Web开发中数据库操作.doc

Web开发中的数据库操作 Vs2010提供的控件简化了web页面数据库应用开发，几乎不用编写脚本语句，直接将控件拉到页面上，对控件属性进行编辑即可完成任务。 Sqldatasource控件直接实现了页面与sql数据库绑定但是要在其中定义SelectCommand、updateCommand、deleteCommand、insertCommand等语句才能进行数据操作（缺省只有selectcommand语句被定义了）！！ Gridview完成了数据库表的显示、编辑更新、删除功能 但是gridview控件不直接支持插入功能，需要与datalistview控件配合使用 Datalistview控件直接支持编辑更新、删除、插入 %@ Page Language=VB AutoEventWireup=true CodeFile=Default2.aspx.vb Inherits=Default2 % %@ Import Namespace=System.Data.SqlClient % %@ Import Namespace=System.Data % script runat=server Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Create a connection Dim strConn As String = server=localhost;database=qj;Integrated Security=SSPI Dim conn As SqlConnection = New SqlConnection(strConn) Create the DataAdapter Dim cmdsele As SqlDataAdapter = New SqlDataAdapter(select * from ynyjusers, conn) Create and populate the DataSet Dim ds As DataSet ds = New DataSet() cmdsele.Fill(ds, ynyjusers) Dim dv As DataView dv = ds.Tables(ynyjusers).DefaultView GridView1.DataSource = ds GridView1.DataMember = ynyjusers GridView1.DataBind() If Not Page.IsPostBack Then Label4.Text = The date and time is now() End If End Sub /script !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN /TR/xhtml1/DTD/xhtml1-transitional.dtd html xmlns=/1999/xhtml head runat=server title/title /head body form id=form1 runat=server div nbsp;/div nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; asp:Label ID=Label2 runat=server Font-Names=华a文?行D楷? Font-Size=32pt Font-Underline=True ForeColor=#FF3300 hirezontalAlign=Center Text=云?南?医°?疗￠?器??械|ì检¨?验¨|研D究