Question

asp.net 如何连接数据库并且将注册信息插入数据库？要代码

Answer 1

一样的啊！
添加命名空间：using System.Data.SqlClient;
//增删查改
//string sql = "";
//SqlConnection cn=new SqlConnection("连接字符串");
//sql = "insert into table (字段1，字段2) values ('xx','aa')";//增
//sql = "delete from table where table_id ='" + ID + "'";//删
//sql = "select 字段1,字段2 from table where 条件";//查
//sql = "update table set 字段1='',字段2='' where table_id='" + ID + "' ";//改
//SqlDataAdapter da = new SqlDataAdapter(sql, cn);
//DataSet ds = new DataSet();
//da.Fill(ds);// 这样就执行了

你注册就是插入那些注册信息到你数据库的自定义的注册用的表不就得了？ 用上面的“增”语句解决

Answer 2

public static int ExecuteSql(string SQLString)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlCommand cmd = new SqlCommand(SQLString, connection))
{
try
{
connection.Open();
int rows = cmd.ExecuteNonQuery();
return rows;
}
catch (System.Data.SqlClient.SqlException e)
{
connection.Close();
throw e;
}
}
}
}

string zhuce="insert into userinfo(name,sex) values('张三','111')";
int i=ExecuteSql(zhuce);

追问

不好意思，我想要的插入代码不是这样的