求对sql server做数据读取、更新的讲解和例子

数据库连接
<%@ Import Namespace="System.Data.SqlClient" %><Script Runat="Server">Sub Page_Load
Dim conPubs As SqlConnection conPubs = New SqlConnection( "server=localhost;uid=webuser;pwd=secret;database=pubs" )
conPubs.Open()
End Sub</Script>Connection Opened!

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

数据读取并显示<%@ Import Namespace="System.Data.SqlClient" %>
<%
Dim conPubs As SqlConnection
Dim cmdSelectAuthors As SqlCommand
Dim dtrAuthors As SqlDataReaderconPubs = New SqlConnection( "Server=localhost;uid=sa;pwd=secret;database=pubs" )
conPubs.Open()
cmdSelectAuthors = New SqlCommand( "Select au_lname From Authors", conPubs )
dtrAuthors = cmdSelectAuthors.ExecuteReader()
While dtrAuthors.Read()
  Response.Write( "<li>" )
  Response.Write( dtrAuthors( "au_lname" ) )
End While
dtrAuthors.Close()
conPubs.Close()
%>
通过表单对数据库中某个表进行更新<%@ Import Namespace="System.Data.SqlClient" %>
<Script Runat="Server">Sub Button_Click( s As Object, e As EventArgs )
  Dim conPubs As SqlConnection
  Dim strUpdate As String
  Dim cmdUpdate As SqlCommand
  Dim intUpdateCount As Integer  conPubs = New SqlConnection( "Server=localhost;UID=sa;PWD=secret;database=Pubs" )
  strUpdate = "Update Authors Set phone=@phone Where au_fname=@firstname And au_lname=@lastname"
  cmdUpdate = New SqlCommand( strUpdate, conPubs )
  cmdUpdate.Parameters.Add( "@phone", txtPhone.Text )
  cmdUpdate.Parameters.Add( "@firstname", txtFirstName.Text )
  cmdUpdate.Parameters.Add( "@lastname", txtLastName.Text )
  conPubs.Open()
  intUpdateCount = cmdUpdate.ExecuteNonQuery()
  conPubs.Close()
  lblResults.Text = intUpdateCount & " records updated!"
End Sub
</Script><html>
<head><title>SqlFormUpdate.aspx</title></head>
<body>
<form Runat="Server"><h2>Update Phone Number</h2><b>First Name:</b>
<br>
<asp:TextBox
  ID="txtFirstName"
  Runat="Server" />
<p>
<b>Last Name:</b>
<br>
<asp:TextBox
  ID="txtLastName"
  Runat="Server" />
<p>
<b>New Phone:</b>
<br>
<asp:TextBox
  ID="txtPhone"
  Runat="Server" />
<p>
<asp:Button
  Text="Update Phone Number!"
  OnClick="Button_Click"
  Runat="Server" />
<p>
<asp:Label
  ID="lblResults"
  Runat="Server" /></form>
</body>
</html>
各位大哥，我要的是C#的，而且数据库连接我会，还会用dataread
你装了vs.net没有
里面带了一个例子Duwamish 7.0
这里是它的介绍
ms-help://MS.VSCC/MS.MSDNVS.2052/dwamish7/html/vtoriDuwamish70Overview.htm另外，你的vs.net的安装目录下有它的原文件
在你的vs.net的安装目录
\Enterprise Samples\Duwamish 7.0 CS
下进行安装就好
我的盘没在这里……怎么办？给个Duwamish 7.0 CS的下载好吗？
SqlConnection conn = new SqlConnection("数据库连接字符串");
SqlCommand cmd = "select id,username,userpassword from user_info";
SqlAdapter sa = new SqlAdapter(cmd,conn);
DataSet ds = new DataSet();
sa.Fill(ds);
if(ds.Table[0].Rows.count != 0)
{
    for(int i = 0;i < ds.Table[0].Rows.count;i++)
    {
            if(ds.Table[0].Rows[i]["username"].toString() == "rain")
            {
                break;
                MessageBox.Show("该用户存在");
            }
    }
}
else
{
}
C#里面如何向SQL SERVER里INSTER的语句呀？
SqlConnection conn = new SqlConnection("连接字符串");
string sql = "Insert into ... value ..."
SqlCommand cmd = new SqlCommand(sql,conn);
cmd.ExecuteNoQuery();
SqlCommand("INSERT INTO bbs3(AnnounceID,ParentID) Values(@AnnounceID,@ParentID)",DataBaseObj2);
老提示叫我先声明变量@AnnounceID
可我声明了int AnnounceID='111';了的呀
怎么办啊，大哥们，帮帮我啊~~~
<%@ Import Namespace="System.Data.SqlClient" %><Script runat=server>

  Dim conNorthwidn As SqlConnection
  Dim cmdSql As SqlCommand
  Dim As String

  Sub Page_Load
    conNorthwind = New SqlConnection( "Server=localhost;UID=sa;PWD=;Databade=Northwind")
    If Not IsPostBack Then
    BindDataGrid
    End IF
  End Sub  Sub BindDataGrid
    cmdSql = New SqlCommand( "Select * From Product", conNorthwind )
    conNorthwind.Open()
    dgrdProducts.DataSource = cmdSql.ExecuteReader()
    dgrdProducts.DataBidn()
    conNorthwind.Close()
  End Sub  Sub dgrdProducts_EditCommand( s As Object, e As DataGridCommandEventArgs )
    dgrdProducts.EditItemInex = e.Item.ItemIndex
    BindDataGrid
  End Sub  Sub dgrdProducts_UpdateCommand( s As Object, e As DataGridCommandEventAgrs )
    Dim intProductID As Integer
    Dim txtUnitPrice As TextBox
    Dim decUnitPrice As Decimal    If IsValid Then
      intProductID = dgrdProducts.DataKeys( e.Item.ItemIndex )
      txtUnitPrice = e.Item.FindControl( "txtUnitPrice" )
      decUnitPrice = txtUnitPrice.Text
      strSql = "Update Products Set UnitPrice=@UnitPrice Where ProductID=@ProductID"
      cmdSql = New SqlCommand( strSql, conNorthwind )
      cmdSql.Parameters.Add( "@UnitPrice", decUnitPrice )
      cmdSql.Parameters.Add( "@ProductID", intProductID )
      conNorthwind.Open()
      cmdSql.ExecuteNonQuery()
      conNorthwind.Close()
      dgrdProducts.EditItemIndex = -1
      BindDataGrid
    End If
  End Sub  Sub dgrdProducts_CancelCommand( s As Object, e As DataGridCommandEventArgs )
    dgrdProducts.EditItemIndex = -1
    BindDataGrid
  End Sub</Script><html>
<head><title>DataGridEditTemplate.aspx</title></head>
<body>
  <form runat=server>
    <asp:DataGrid id="dgrdProducts"
        OnEditCommand="dgrdProducts_EditCommand"
OnUpdateCommand="dgrdProducts_UpdateCommand"
OnCancelCommand="dgrdProducts_CancelCommand"
DataKeyField="ProductID" AutoGenerateColumns="False"
CellPadding="10" HeaderStyle-BackColor="Salmon" runat="server">
      <Columms>
        <asp:BoundColumn HeaderText="Product Name" DataField="ProductName" ReadOnly="True" />
<asp:TemplateColumn>
  <asp:HeaderTemplate>Price</asp:HeaderTemplate>
  <ItemTemplate><%# Container.DataItem( "UnitPrice" )%></ItemTemplate>
  <EditTemplate>
    <asp:TextBox id="txtUnitPrice" Text='<%# Container.DataItem( "UnitPrice" ) %>' runat=server />
    <asp:RequiredFieldValidator controltovalidate="txtUnitPrice" dispaly="Dynamic" text="Required!" runat=server/>
    <asp:CompareValidator controltovalidate="txtUnitPrice" display="Dynamic" text="Must be currency"operator="DataTypeCheck" Type="Currency" runat=server />
  </EditTemplate>
</asp:TemplateColumn>
<asp:EditCommandColumn>
  EidtText="Edit!"
  UpdateText="Update!"
  CancelText="Cancel!"
</asp:EditCommandColumn>
      </Columns>
    </asp:DataGrid>
  </form>
</body>
</html
kill
你使用的不过是SQL语句，而不是存储过程。用不着加上@.直接用声明的变量就可以了。
public class DataBase
{
public DataSet DataTable(string DataBaseCon,string RunSql,string DataTableName)
{
SqlConnection Connection=new SqlConnection( DataBaseCon );
SqlDataAdapter DataAdapter=new SqlDataAdapter(RunSql,Connection);
DataSet DataTable=new DataSet();
DataAdapter.Fill(DataTable,DataTableName);
Connection.Close();
return DataTable;
} public SqlDataReader DataRead(string DataBaseCon,string RunSql)
{
SqlConnection myconn=new SqlConnection(DataBaseCon);
SqlCommand mycmd=new SqlCommand(RunSql,myconn);
myconn.Open();
return mycmd.ExecuteReader(CommandBehavior.CloseConnection);
} public int SqlDataExec(string DataCon,string RunSql)
{
SqlConnection myconn=new SqlConnection(DataCon);
myconn.Open();
SqlCommand mycmd=new SqlCommand(RunSql,myconn);
int ReturnData=mycmd.ExecuteNonQuery();
myconn.Close();
return ReturnData;
}
}