database using asp.net

Originally posted by : shika (shika_3in@yahoo.com)hi, i want to know how to add , delete, modify, search a database in sqlserver using asp.net and sqlserver using the ado connectionthanx

Originally posted by : masoom (masoom_w@hotmail.com)This Example is for Access!!change the connection to SQL SERVER!!Sub Page_Load(Source As Object, E As EventArgs)Dim oConnection As ADOConnectionDim oCommand As ADODataSetCommand Dim oDS As New DataSet Dim sConnString As String Dim sSQL As String Dim nCount As Integer'Define connection string DSN less connection string.... change it withrespect to your server 'and database name sConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; " & "DBQ=" & Server.MapPath("ashoknetdbempdb.mdb")'Define SQL statement sSQL = "SELECT * FROM emp"'Create the connectionoConnection = New ADOConnection(sConnString) 'Execute this SQL statement with this Connection StringoCommand = New ADODataSetCommand(sSQL, sConnString) 'Fill the DataSet and name the table oCommand.FillDataSet(oDS, "TestTable") DataGrid1.DataSource = oDS.Tables("TestTable").DefaultView DataGrid1.DataBind() End Sub