代码部分:Dim sql As [String] = ""
Dim strCnn As [String] = "Data Source=.;Initial Catalog=aa;User Id=sa;Password=;"'create a datasource function
Public Function CreateDataSource() As ICollection
Dim conn As New SqlConnection(strCnn)
Dim db_sqladaptor As New SqlDataAdapter(sql, conn)
Dim ds As New DataSet()
db_sqladaptor.Fill(ds, "MyDataResult")
Dim myView As DataView = ds.Tables("MyDataResult").DefaultView
Return myView
End Function 'CreateDataSource'do page load
Public Sub Page_Load(sender As [Object], e As EventArgs)
strCnn = "Data Source=.;Initial Catalog=aa;User Id=sa;Password=;"
If Not IsPostBack Then
sql = "Select * FROM People"
People.DataSource = CreateDataSource()
People.DataBind()
End If
End Sub 'Page_Load
Public Sub Page_Grid(sender As [Object], e As DataGridPageChangedEventArgs)
sql = "Select * FROM People"
' Set CurrentPageIndex to the page the user clicked.
People.CurrentPageIndex = e.NewPageIndex
' Rebind the data.
People.DataSource = CreateDataSource()
People.DataBind()
End Sub 'Page_Grid
Public Sub People_Edit(sender As [Object], e As DataGridCommandEventArgs)
sql = "Select * FROM People"
People.EditItemIndex = e.Item.ItemIndex
People.DataSource = CreateDataSource()
People.DataBind()
End Sub 'People_Edit
Public Sub People_Cancel(sender As [Object], e As DataGridCommandEventArgs)
sql = "Select * FROM People"
People.EditItemIndex = - 1
People.DataSource = CreateDataSource()
People.DataBind()
End Sub 'People_Cancel
Public Sub People_Update(sender As [Object], e As DataGridCommandEventArgs)
Dim FirstName As String = CType(e.Item.Cells(1).Controls(1), TextBox).Text
Dim LastName As String = CType(e.Item.Cells(2).Controls(1), TextBox).Text
Dim connUpdate As New SqlConnection(strCnn)
connUpdate.Open()
Dim sql_edit As [String] = "UPDATE People " + "SET FirstName = '" + FirstName.Replace("'", "''") + "'," + "LastName = '" + LastName.Replace("'", "''") + "'" + " WHERE pkID = " + e.Item.Cells(0).Text
Dim sqlCommandUpdate As New SqlCommand(sql_edit, connUpdate)
sqlCommandUpdate.ExecuteNonQuery()
connUpdate.Close()
sql = "Select * FROM People"
People.EditItemIndex = - 1
People.DataSource = CreateDataSource()
People.DataBind()
End Sub 'People_Update
Public Sub People_Delete(sender As [Object], e As DataGridCommandEventArgs)
Dim connDel As New SqlConnection(strCnn)
connDel.Open()
Dim sql_Del As [String] = "DELETE FROM People " + " WHERE pkID = " + e.Item.Cells(0).Text
Dim sqlCommandDel As New SqlCommand(sql_Del, connDel)
sqlCommandDel.ExecuteNonQuery()
connDel.Close()
sql = "Select * FROM People"
People.EditItemIndex = - 1
People.DataSource = CreateDataSource()
People.DataBind()
End Sub 'People_Delete
Dim strCnn As [String] = "Data Source=.;Initial Catalog=aa;User Id=sa;Password=;"'create a datasource function
Public Function CreateDataSource() As ICollection
Dim conn As New SqlConnection(strCnn)
Dim db_sqladaptor As New SqlDataAdapter(sql, conn)
Dim ds As New DataSet()
db_sqladaptor.Fill(ds, "MyDataResult")
Dim myView As DataView = ds.Tables("MyDataResult").DefaultView
Return myView
End Function 'CreateDataSource'do page load
Public Sub Page_Load(sender As [Object], e As EventArgs)
strCnn = "Data Source=.;Initial Catalog=aa;User Id=sa;Password=;"
If Not IsPostBack Then
sql = "Select * FROM People"
People.DataSource = CreateDataSource()
People.DataBind()
End If
End Sub 'Page_Load
Public Sub Page_Grid(sender As [Object], e As DataGridPageChangedEventArgs)
sql = "Select * FROM People"
' Set CurrentPageIndex to the page the user clicked.
People.CurrentPageIndex = e.NewPageIndex
' Rebind the data.
People.DataSource = CreateDataSource()
People.DataBind()
End Sub 'Page_Grid
Public Sub People_Edit(sender As [Object], e As DataGridCommandEventArgs)
sql = "Select * FROM People"
People.EditItemIndex = e.Item.ItemIndex
People.DataSource = CreateDataSource()
People.DataBind()
End Sub 'People_Edit
Public Sub People_Cancel(sender As [Object], e As DataGridCommandEventArgs)
sql = "Select * FROM People"
People.EditItemIndex = - 1
People.DataSource = CreateDataSource()
People.DataBind()
End Sub 'People_Cancel
Public Sub People_Update(sender As [Object], e As DataGridCommandEventArgs)
Dim FirstName As String = CType(e.Item.Cells(1).Controls(1), TextBox).Text
Dim LastName As String = CType(e.Item.Cells(2).Controls(1), TextBox).Text
Dim connUpdate As New SqlConnection(strCnn)
connUpdate.Open()
Dim sql_edit As [String] = "UPDATE People " + "SET FirstName = '" + FirstName.Replace("'", "''") + "'," + "LastName = '" + LastName.Replace("'", "''") + "'" + " WHERE pkID = " + e.Item.Cells(0).Text
Dim sqlCommandUpdate As New SqlCommand(sql_edit, connUpdate)
sqlCommandUpdate.ExecuteNonQuery()
connUpdate.Close()
sql = "Select * FROM People"
People.EditItemIndex = - 1
People.DataSource = CreateDataSource()
People.DataBind()
End Sub 'People_Update
Public Sub People_Delete(sender As [Object], e As DataGridCommandEventArgs)
Dim connDel As New SqlConnection(strCnn)
connDel.Open()
Dim sql_Del As [String] = "DELETE FROM People " + " WHERE pkID = " + e.Item.Cells(0).Text
Dim sqlCommandDel As New SqlCommand(sql_Del, connDel)
sqlCommandDel.ExecuteNonQuery()
connDel.Close()
sql = "Select * FROM People"
People.EditItemIndex = - 1
People.DataSource = CreateDataSource()
People.DataBind()
End Sub 'People_Delete
解决方案 »
- 求一正则表达式,从html中取出指定网址
- MSChart图表控件有时候图片不显示的问题
- 关于RadioButtonList绑定的问题
- 在ASP.NET中如何实现上传文件?
- 为什么从数据库动态生成的Xml在vs2005打开的时候都是乱码?
- .net组件在ie浏览器端嵌入,javascript如何调用.net公共属性和事件。
- 有关Session丢失的问题,不知您们是如何用sqlserver来实现存储session值的,您能否将设计思路说一下呢?谢谢!!1
- 大家帮助:VS.NET在调试时出现的错误!-未能将临时文件复制到输出目录中....
- 请问这儿有没有作CRM系统的?进来就有分噢。快!快!快!
- <<ASP.NET 入门经典>>这本书中例程Synchronize.asp为什么编译错误?
- 请问有人使用微软的StoreCSVS程序吗
- 急:问web叶面上的treeview怎么跟数据库绑定?
还有vb没有每句结束都用;
另外都是一些基本的语法,很容易的。