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
- 9302 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 many global.asa files can an application have in asp?
How do I save asp file in notepad?
What is a form collection in asp?
Hi, i am looking for join learn real time project on dotnet please tell me which is the best institute now i am staying in a ameerpet. thank u for advance.
How do I create an aspx page?
Explain the difference between the value-type variables and reference-type variables?
What does active server pages look like?
Juxtapose the HTTP verbs GET and POST. What is HEAD?
Explain the tags necessary to be present within the tag ?
What are the different types of html?
Define clientcertificate collection?
Name the control which would you use if you needed to make sure the values in two different controls matched?
Write code for the following in ASP a)Display attributes of a file b) File copy c) get disk capacity.
Define common language specification (cls)?
How can I break Search
