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
- 9127 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
What is difference between aspx and razor?
how can we delete cookies by coding part . so pls help me
What is asp full form?
What is a request body?
what is database deployment?
How to display images using response object?
Explain how to refresh an asp page on a single click of a button?
how to add master page in aspx page that is design before master page....
What is the order of precedence for logical operators.
I am not doing well in my oracle class and desparetly need some help. My main problem is the join chapter. I am very frustrated right now because I got my first zero in my in school lastweek. I excell in every other subject except oracle. I really would like to learn the program, but it looks dim for me right now and it is too late to drop the class without getting 'F'. Can someone pleae help me. with this one because I only have a few days before my assignment is due. If you leave your email I will get intouch with you immediately. Thanks
How do I convert an aspx file to pdf?
Is asp still supported by microsoft?
textbox has viewstate property,but it does not depend on its property to retain their data across page,Explain.
Resource Files: How to use the resource files, how to know which language to use?
how to update text box value in c#.net project?
