Dim strConnString AsString =
System.Configuration.ConfigurationManager.ConnectionStrings.Item("ConnectionString").ToString()
Dim con AsNew
SqlConnection(strConnString)
Dim sqlda As SqlDataAdapter
Dim com As SqlCommand
Dim ds As
DataSet
Dim str AsString
Dim s AsString
ProtectedSub Page_Load(ByVal
sender AsObject,
ByVal e As
System.EventArgs) HandlesMe.Load
IfNot
IsPostBack Then
bindgrid()
EndIf
EndSub
Sub bindgrid()
Try
con.Open()
str = "select * from
student"
com = New
SqlCommand(str, con)
Dim reader As SqlDataReader = com.ExecuteReader
DataGrid1.DataSource = reader
DataGrid1.DataBind()
reader.Close()
con.Close()
Catch ex As Exception
Response.Write(ex.Message)
EndTry
EndSub
ProtectedSub datagrid1_editcommand(ByVal
source AsObject,
ByVal e As
System.Web.UI.WebControls.DataGridCommandEventArgs) Handles
DataGrid1.EditCommand
DataGrid1.EditItemIndex = e.Item.ItemIndex
bindgrid()
EndSub
ProtectedSub datagrid1_updatecommand(ByVal
source AsObject,
ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs)
Handles DataGrid1.UpdateCommand
ProtectedSub datagrid1_cancelcommand(ByVal
source AsObject,
ByVal e As
System.Web.UI.WebControls.DataGridCommandEventArgs) Handles
DataGrid1.CancelCommand
Join the conversation! Your thoughts help the community grow.