★Asp.net如何连接SQL Server2000数据库★ <br />     <br />     大家好,以下是有关ASP.net连接SQL Server2000数据库的例程， <br />     在这里和大家分享一下： <br />     <br />     Asp.net连接SQL Server2000数据库例程详解: <br />     &lt;%@ Import Namespace=&quot;System.Data&quot; %&gt; <br />     &lt;%@ Import NameSpace=&quot;System.Data.SqlClient&quot; %&gt; <br />     &#60;script laguage=&quot;VB&quot; runat=&quot;server&quot;&gt; <br />     sub page_load(sender as Object,e as EventArgs) <br />     Dim myConnection As SqlConnection <br />     Dim myCommand As SqlCommand <br />     Dim ds as DataSet <br />     &#39;1.connect to sql server <br />     myConnection = New SqlConnection( &quot;server=localhost;database=Pubs;uid=ueytjdf;pwd=doekdf&quot; ) <br />     myConnection.Open() <br />     la1.text=&quot;Connection Opened&#33;&quot; <br />     <br />     &#39;2.Create a table <br />     myCommand = New SqlCommand( &quot;CREATE TABLE [test] ([id] [int] IDENTITY (1, 1) NOT NULL ,[name] <br />     <br />     [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,[sex] [char] (10) COLLATE Chinese_PRC_CI_AS NULL <br />     <br />     )&quot;, myConnection ) <br />     myCommand.ExecuteNonQuery() <br />     la2.text=&quot;New table created&#33;&quot; <br />     <br />     &#39;2 添加纪录 <br />     myCommand = New SqlCommand( &quot;Insert into [test] (name,sex) values( &#39;黄志文&#39;,&#39;男&#39; )&quot;, <br />     <br />     myConnection ) <br />     myCommand.ExecuteNonQuery() <br />     la3.text=&quot;New Record Inserted&#33;&quot; <br />     <br />     &#39;3 更新数据 <br />     myCommand = New SqlCommand( &quot;UPDATE [test] SET name=&#39;Smith&#39; where name=&#39;李明&#39;&quot;, myConnection ) <br />     myCommand.ExecuteNonQuery() <br />     la4.text=&quot;Record Updated&#33;&quot; <br />     <br />     &#39;4 删除数据 <br />     myCommand = New SqlCommand( &quot;delete from [test] where name=&#39;Smith&#39;&quot;, myConnection ) <br />     myCommand.ExecuteNonQuery() <br />     la5.text=&quot;Record Deleted&#33;&quot; <br />     <br />     &#39;5 用DataGrid显示数据 <br />     myCommand = New SqlCommand( &quot;select * from [test]&quot;, myConnection ) <br />     MyDataGrid.DataSource=myCommand.ExecuteReader() <br />     MyDataGrid.DataBind() <br />     end sub <br />     &lt;/script&gt; <br />     &lt;html&gt; <br />     &lt;body&gt; <br />     &lt;asp:label id=&quot;la1&quot; runat=&quot;server&quot; /&gt;&lt;br&gt; <br />     &lt;asp:label id=&quot;la2&quot; runat=&quot;server&quot; /&gt;&lt;br&gt; <br />     &lt;asp:label id=&quot;la3&quot; runat=&quot;server&quot; /&gt;&lt;br&gt; <br />     &lt;asp:label id=&quot;la4&quot; runat=&quot;server&quot; /&gt;&lt;br&gt; <br />     &lt;asp:label id=&quot;la5&quot; runat=&quot;server&quot; /&gt;&lt;br&gt; <br />     &lt;ASP:DataGrid id=&quot;MyDataGrid&quot; runat=&quot;server&quot; <br />     BorderColor=&quot;black&quot; <br />     BorderWidth=&quot;1&quot; <br />     GridLines=&quot;Both&quot; <br />     CellPadding=&quot;3&quot; <br />     CellSpacing=&quot;0&quot; <br />     Font-Name=&quot;Verdana&quot; <br />     Font-Size=&quot;10pt&quot; <br />     HeaderStyle-BackColor=&quot;#aaaadd&quot; <br />     AlternatingItemStyle-BackColor=&quot;#eeeeee&quot; <br />     &gt; <br />     &lt;/asp:DataGrid&gt; <br />     <br />     &lt;/body&gt; <br />     &lt;/html&gt;