Interested to Buy Any Domain ? << Click Here >> for more details...
1)Declare array with five elements
a[]={8,4,6,2,1,10}
Print minimum and maximum no from array.
2)Accept values from Textbox and add into Listbox on click
ok button.
2)Accept these values store them in cookie collection and
show them in next form.
Assignment 3 20Marks
1) Display EmpId ,EmpName ,EmpSal usind datagrid view
(use sqlerver 2005)
2) Insert Item Id, Item Name, Qty, Rate using ado.net(use
sqlerver 2005)
- 5 Answers
- 9459 Views
- I also Faced
- E-Mail Answers
Answer Posted / sangram singh thakur(t.y.b.c.a
assignment 3-2
<%@ Page Language=VB Debug=true %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SQLClient" %>
<script runat=server>
Sub SubmitBtn_Click(Sender As Object, E As EventArgs)
Dim DBConn as SQLConnection
Dim DBAdd As New SQLCommand
' DBConn = New SQLConnection("server=localhost;" _
' & "Initial Catalog=TT;" _
' & "User Id=sa;" _
' & "Password=yourpassword;")
DBConn = New SQLConnection("Data Source=whsql-
v08.prod.mesa1.secureserver.net;Initial
Catalog=DB_49907;User ID=java2suser;Password='password';")
DBAdd.CommandText = "Insert Into Employee (" _
& "LastName, FirstName, Salary " _
& ") values ('" & txtLastName.Text & "'," _
& "'" & txtFirstName.Text _
& "'," & txtSalary.Text & ")"
DBAdd.Connection = DBConn
DBAdd.Connection.Open
DBAdd.ExecuteNonQuery()
End Sub
</SCRIPT>
<HTML>
<HEAD>
<TITLE>Adding SQL Server Data</TITLE>
</HEAD>
<Body LEFTMARGIN="40">
<form runat="server">
<BR>
Last Name:
<BR>
<asp:textbox id="txtLastName" runat="Server"/>
<BR>
First Name:
<BR>
<asp:textbox id="txtFirstName" runat="Server"/>
<BR>
Salary:
<BR>
<asp:textbox id="txtSalary" runat="Server"/>
<BR><BR>
<asp:button id="butOK" text="OK" onclick="SubmitBtn_Click"
runat="server"/>
</form>
</BODY>
</HTML>
| Is This Answer Correct ? | 11 Yes | 2 No |
Post New Answer View All Answers
How could u display all of the cookies/cookie values for a user through a Web page in ASP?
What are asp controls?
how can we create a webpage in .Net
hello,please can any one tell me who is best faculty for asp.net in naresh it....i heard that mr.nagaraju and mr.rakesh sing both are best..so i am confused to take one particular faculty. classes ...so please if any attend classes just give me clarity of teaching style..i mean ..who is best...
What are the components of asp?
Define response object?
What does asp mean in business?
Name the methods by which output stream is controlled?
What inheritance is and an example of when you might use it?
Explain the difference between server.transfer and response.redirect?
How to convert a string into an integer in .net?
Define managed code?
Define .asp file?
Define global.asa file?
How can you disable the browser to view the code?
