<p><%@ Import Namespace="System.Data" %></p>
<p> <%@ Import Namespace="System.Data.SQL" %> </p>
<p><html> </p>
<p><script language="C#" runat="server"> public DataSet dsCustomers; protected
void Page_Load(Object Src, EventArgs E ) </p>
<p>{</p>
<p> // 创建数据库联结</p>
<p>SQLConnection myConnection = newSQLConnection("server=sql2.bitsonthewire.com;uid=joeuser;pwd=joeuser;database=northwind");
</p>
<p>SQLDataSetCommand myDSC = new SQLDataSetCommand("Select * from Region", myConnection);
</p>
<p>SQLParameter workParam = null; </p>
<p>//增加数据到数据库中</p>
<p>myDSC.InsertCommand = new SQLCommand("Insert into Region (RegionID, RegionDescription)
VALUES (@RegionID, @RegionDescription)", myConnection);</p>
<p> workParam = myDSC.InsertCommand.Parameters.Add(new SQLParameter("@RegionID",
SQLDataType.Int)); <br>
workParam.SourceColumn = "RegionID"; workParam.SourceVersion = DataRowVersion.Current;
<br>
workParam = myDSC.InsertCommand.Parameters.Add(new SQLParameter("@RegionDescription",
SQLDataType.NChar, 50));<br>
workParam.SourceVersion = DataRowVersion.Current;<br>
workParam.SourceColumn = "RegionDescription"; </p>
<p>//更新数据库中的数据<br>
myDSC.UpdateCommand = new SQLCommand("Update Region Set RegionDescription =
@RegionDescription WHERE RegionID = @RegionID" , myConnection);</p>
<p> workParam = myDSC.UpdateCommand.Parameters.Add(new SQLParameter("@RegionID",
SQLDataType.Int)); <br>
workParam.SourceColumn = "RegionID";<br>
workParam.SourceVersion = DataRowVersion.Original; </p>
<p>workParam = myDSC.UpdateCommand.Parameters.Add(new SQLParameter("@RegionDescription",
SQLDataType.NChar, 50));<br>
workParam.SourceVersion = DataRowVersion.Current; <br>
workParam.SourceColumn = "RegionDescription";</p>
<p> DataSet myDataSet = new DataSet(); <br>
myDSC.FillDataSet(myDataSet, "Region"); <br>
DataRow changeRow = myDataSet.Tables["Region"].Rows.Find(2);<br>
changeRow[1] = "Changed this region desc";<br>
DataRow newRow = myDataSet.Tables["Region"].NewRow(); <br>
newRow[0] = 901;<br>
newRow[1] = "A new region";<br>
myDataSet.Tables["Region"].Rows.Add(newRow); <br>
try { myConnection.Open(); <br>
myConnection.BeginTransaction();<br>
myDSC.Update(myDataSet, "Region");<br>
myConnection.CommitTransaction(); <br>
Response.Write("DataSet transaction succeeded!"); <br>
} </p>
<p>catch(Exception e) <br>
{<br>
myConnection.RollbackTransaction();<br>
Response.Write(e.ToString());<br>
}<br>
finally </p>
<p>{<br>
myConnection.Close();<br>
} } <br>
</script></p>
<p> <body></p>
<p> </body></p>
<p> </html> </p>
<p></td> </tr> </table> <p></p>
</body>
</html>
相关C#对数据库的操作