小弟刚学ASP.NET问一个简单的连接数据库与删除修改等问题！送分200

小弟不解：
当我连接数据库后，ASP.net 改怎么写
SqlConnection Conn = new SqlConnection("Data Source=localhost; database=data2;uid=;pwd=;");
Conn.open();
下面添加数据库怎么写？修改怎么写？删除怎么写，请大哥们帮忙，送分，最好有个相关源码可下，
我的E-MAIL:[email protected]
QQ：86470130 在线等。
给相关源码的兄弟在多送100分
-----------
源码最好有，登陆注册验证/修改删除/添加，不需要写在类里，写在窗体里就可以。数据库是SQL

解决方案 »

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

你好,朴素论坛现在已经更新.,加强了论坛的安全性.朴素论坛版本:1.0开发语言:C#+asp.net数据库：Access网址:http://uin.edzh.com源码下载:http://uin.haokoo.net
在你的机器上装上SQL SERVER2000数据库，然后参考
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %><html>
<script language="C#" runat="server">    SqlConnection myConnection;    protected void Page_Load(Object sender, EventArgs e)
    {
        myConnection = new SqlConnection("server=(local)\\NetSDK;database=pubs;uid=sa;pwd=xxxx");        if (!IsPostBack)
            BindGrid();
    }    public void MyDataGrid_Delete(Object sender, DataGridCommandEventArgs e)
    {
        String deleteCmd = "DELETE from Employee where emp_id = @Id";        SqlCommand myCommand = new SqlCommand(deleteCmd, myConnection);
        myCommand.Parameters.Add(new SqlParameter("@Id", SqlDbType.NVarChar, 11));
        myCommand.Parameters["@Id"].Value = MyDataGrid.DataKeys[(int)e.Item.ItemIndex];        myCommand.Connection.Open();        try
        {
            myCommand.ExecuteNonQuery();
            Message.InnerHtml = "<b>已删除记录</b><br>" + deleteCmd;
        }
        catch (SqlException)
        {
            Message.InnerHtml = "错误：未能删除记录";
            Message.Style["颜色"] = "红色";
        }        myCommand.Connection.Close();        BindGrid();
    }    public void BindGrid()
    {
        SqlDataAdapter myCommand = new SqlDataAdapter("select * from Employee", myConnection);        DataSet ds = new DataSet();
        myCommand.Fill(ds, "员工");        MyDataGrid.DataSource=ds.Tables["员工"].DefaultView;
        MyDataGrid.DataBind();
    }</script><body style="font: 10.5pt 宋体">  <form runat="server">    <h3><font face="宋体">删除数据行</font></h3>    <span id="Message" EnableViewState="false" style="font: arial 11pt;" runat="server"/><p>    <ASP:DataGrid id="MyDataGrid" runat="server"
      Width="800"
      BackColor="#ccccff"
      BorderColor="black"
      ShowFooter="false"
      CellPadding=3
      CellSpacing="0"
      Font-Name="Verdana"
      Font-Size="8pt"
      HeaderStyle-BackColor="#aaaadd"
      DataKeyField="emp_id"
      OnDeleteCommand="MyDataGrid_Delete"
    >      <Columns>
         <asp:ButtonColumn Text="删除员工" CommandName="Delete"/>
      </Columns>    </ASP:DataGrid>  </form></body>
</html>
_strConn ="Server=localhost;uid=/"/";pwd=/"/";database=/"data2/"";
SqlConnection conn=new SqlConnection(_strConn);
conn.Open();
建议你找本书看看，最基本的东西一定要搞清楚哦！可以看看MS的QuickStart
最简单的更新/删除数据库:
_strConn ="Server=localhost;uid=/"/";pwd=/"/";database=/"data2/"";
SqlConnection conn=new SqlConnection(_strConn);
conn.Open();
SqlCommand _cmd=new SqlCommand("更新语句/删除语句",conn);
_cmd.ExecuteNonQuery();
conn.Close();最简单的查询数据库：
_strConn ="Server=localhost;uid=/"/";pwd=/"/";database=/"data2/"";
SqlConnection conn=new SqlConnection(_strConn);
conn.Open();
SqlCommand _cmd=new SqlCommand("更新语句/删除语句",conn);
SqlDataReader rs=_cmd.ExecuteReader();while(rs.Read())
{
   Response.Write(rs["字段名1"].ToString());
   Response.Write(rs["字段名3"].ToString());
   Response.Write(rs["字段名2"].ToString());
   ...
}
rs.Close();
conn.Close();
要源码？www.asp.net网站上面的starterkit系列咯！还有中文的gotdotnet你多看看
里面有相关的操作
<%@ Page Language="VB" AutoEventWireup="True" Debug="true"%>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SQLClient" %>
<script runat="server">
      Dim MyConnection as SQLConnection
      Dim MyCommand As SQLDataAdapter      Sub Page_Load(sender As Object, e As EventArgs)
  MyConnection = New SqlConnection("server=localhost;Initial Catalog=pubs;uid=sa;pwd=")
          If Not IsPostBack Then
             BindGrid()
          End If
      End Sub      Sub BindGrid()
      Dim MyCommand As SQLDataAdapter = new SQLDataAdapter("SELECT * FROM authors", MyConnection)
          Dim DS As DataSet = new DataSet()
          MyCommand.Fill(DS,"min")
          MyDataGrid.DataSource = DS.Tables("min").DefaultView
          MyDataGrid.DataBind()
      End Sub
</script>
<form runat="server">
    <asp:DataGrid id="MyDataGrid"
           runat="server"
   AutoGenerateColumns="true"
   Width="200">
         <HeaderStyle BackColor="Navy"
                      ForeColor="White"
                      Font-Bold="True"
  HorizontalAlign="Center"/>
         <PagerStyle Mode="NextPrev"
                     HorizontalAlign="Right"
NextPageText="ÏÂÒ»Ò³"
                     PrevPageText="ÉÏÒ»Ò³"/>
      </asp:DataGrid>
</form>
private string Constr;
private SqlConnection Conn;
public UserDataAccess()
{
//
// TODO: 在此处添加构造函数逻辑^_^
//
Constr=ConfigurationSettings.AppSettings["ConStr"];
Conn=new SqlConnection(Constr);
}
//打开数据库连接^_^
public void OpenConn()
{
if(Conn.State==ConnectionState.Closed)
{
Conn.Open();
}
}
//关闭数据库连接^_^
public void CloseConn()
{
if(Conn.State!=ConnectionState.Closed)
{
Conn.Close();
//Conn.Dispose();
}
}
//更新用户信息操作
public int AddUser(string uname,string upassword)
{
SqlCommand cmd=new SqlCommand();
cmd.CommandType=CommandType.StoredProcedure;
cmd.Connection=this.Conn;
cmd.CommandText = "dbo.AddUserInfo"; SqlParameter param=new SqlParameter("@uname",SqlDbType.NVarChar,50);
param.Value=uname;
cmd.Parameters.Add(param); param=new SqlParameter("@upass",SqlDbType.NVarChar,50);
param.Value=upassword;
cmd.Parameters.Add(param);
param.Value=uinfoclass;
cmd.Parameters.Add(param);

//开始执行
//SqlDataReader rd;
try
{
OpenConn();
object o=cmd.ExecuteScalar();
return int.Parse(o.ToString());
}
catch(SqlException ex)
{
throw(new Exception("执行存储过程时发生错误："+ex.Message));
//return 0;
}
finally
{
CloseConn();
}
}
//更新用户信息操作^_^
public void UpdateUser(string uid, string uname,string upass)
{
string sqlstr;
object[] fields=new object[19];
fields[0]=uname;
fields[1]=upass;
System.Text.StringBuilder sb=new System.Text.StringBuilder("update userinfo ");

sb.Append(" set uname='{0}',upass='{1}',"); sqlstr=string.Format(sb.ToString(),fields);
//执行更新
SqlCommand cmd=new SqlCommand(sqlstr,this.Conn);
try
{
this.OpenConn();
cmd.ExecuteNonQuery();
}
catch(SqlException ex)
{
throw(new Exception("更新失败，原因:"+ex.Message));
}
finally
{
this.CloseConn();
} }
//删除用户^_^
public void DeleteUser(string uid)
{
string deleteSql="Delete from userinfo where uid='"+uid+"'";
SqlCommand cmd=new SqlCommand(deleteSql,this.Conn);
try
{
this.OpenConn();
cmd.ExecuteNonQuery();
}
catch(SqlException ex)
{
throw(new Exception("删除信息失败！原因:"+ex.Message));
}
finally
{
this.CloseConn();
} }
//执行查询并返回结果 param:sql^_^
public  DataTable Select(string sql)
{
sql=sql.Trim();
this.CloseConn();
SqlDataAdapter cmd=new SqlDataAdapter(sql,this.Conn);
DataSet ds=new DataSet();
cmd.Fill(ds,"userinfo");
this.CloseConn();
return ds.Tables[0]; }
}
我還初學者。還暫時看不懂。。搞不懂。哪個是C#寫的哪個是VB寫的。難道是一樣的嗎﹖
给command对象的text属性赋值就可以了。