i need a response to my q..:-)
i have made a form to insert data into sql server and here is the code :
Sub doInsert(Source as Object, E as EventArgs)
Dim MySQL as string = "Insert into user_data (user_id,[timestamp],non_availability,cause_of_non_availability) values (@ppid,@tst,@noava,@cnoava)"
Dim myConn As SqlConnection = New SqlConnection("data source=tstsrv;uid=;pwd=;database=user")
Dim Cmd as New SQLCommand(MySQL, MyConn)
cmd.Parameters.Add(New SQLParameter("@ppid", pumpi.text))
cmd.Parameters.Add(New SQLParameter("@tst", tmstm.text))
cmd.Parameters.Add(New SQLParameter("@noava", navl.text))
cmd.Parameters.Add(New SQLParameter("@cnoava", cnaval.text))
MyConn.Open()
cmd.ExecuteNonQuery
label1.visible="true"
BindData()
MyConn.Close()
label1.text = "Your data has been received!"
End Sub
--------------------------------------------------------------
and i have a function to view the data:
Sub BindData()
'Dim MySQL as string = "Select * from user_data where [timestamp] = @tmstm" Dim myConn As SqlConnection = New SqlConnection( "data source=tstsrv;uid=;pwd=;database=user")
Dim MySQL as string
MySQL= "Select * from user_data "& _
"Where [timestamp] = @tst "
Dim Cmd1 as New SQLCommand(MySQL, MyConn)
cmd1.Parameters.Add(New SQLParameter("@tst", tmstm.text))
Dim ds as DataSet=New DataSet()
Dim Cmd as New SQLDataAdapter(MySQL,MyConn)
Cmd.Fill(ds,"user_data")
MyDataGrid.Datasource=ds.Tables("user_data").Defau ltView
MyDataGrid.DataBind()
End Sub
---------------------------------------------------------------
but the problem is that i want to view the data that is recently inserted or lets say according to the time stamp field in the form as i high lighted above,would you plz help me
|