assignment 3-2 <%@ Page Language=VB Debug=true %> <%@ Import

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)

Question Posted / sangram singh thakur(t.y.b.c.a

5 Answers
9274 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

Please Help Members By Posting Answers For Below Questions

What are the tasks performed by <> tags?

939

Explain the post & get method or explain the difference between them in asp?

944

What is asp and how it works?

1013

Can I use the win32 api from a .net framework program?

884

Explain the difference between cookies collection and form/querystring collection?

1016

Describe ways to present an arbitrary endpoint (URL) and route requests to that endpoint to ASP.NET.

4311

What is asp cookies?

918

Define a variable?

1053

Is classic asp still supported?

986

What is the maximum size of an array?

996

Why .Net Does not Support multiple inheritance?

2155

how u can use asp.net for making website?

2068

Explain the difference between server-side validation and client-side validation?

931

What does aspx stand for?

915

what is execute dataset for sp

2509