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
- 8364 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
Name the asp objects?
Can .net framework components be used from a com program?
Define unmanaged code?
Juxtapose the HTTP verbs GET and POST. What is HEAD?
What are the advantages of asp?
What options are available to deploy my .net applications?
What is asp what can asp do for you?
How do I add aspx page to visual studio?
Explain what are the attributes of the tags? What are their functions?
Explain the advantages of using asp?
i learnt .net and would like to know if there is any institute in hyderabad that gives real time knowledge.i worked on testing and planning to move on to .net putting same amount of experience in .net.kindly suggest me the institute and other details.
Define a variable in asp?
Explain the difference between inline and code behind.
Whats the implicit name and type of the parameter that gets passed into the class set method?
Explain the difference between a namespace and an assembly name?
