Question

VS2005中，使用C#语言连接SQL数据库，然后实现插入数据的方法。

希望哪位可以给我一个实例，让本人详细的参考一下；因为我是个新手，所以还望各位伸出友情之手多多帮助啊，您的帮助，将使我再一次进步，谢谢啊！！！

Answer 1

try
{
String commandText="select count(*) from users";
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=(local);Initial Catalog=classmate;User Id=sa;Password=sa";

SqlCommand cmd = new SqlCommand(commandText,conn);
conn.Open();
string count = cmd.ExecuteScalar().ToString();
if (conn.State == ConnectionState.Open)
{
Response.Write(count);
Response.Write("数据库连接成功！<br>");
Response.Write("<script>alert('连接已打开')</script>");
}
conn.Close();
if (conn.State == ConnectionState.Closed)
{
Response.Write("连接已关闭");
Response.Write("<script>alert('连接已关闭')</script>");
}
}
catch(Exception ex)
{
Response.Write("数据库连接失败"+ex.Message);
}
}

Answer 2

try
{
string cnnStr="server=(local);uidsa;pwd=sa;database= database";//设置连接字符串
con.ConnectionString=cnnStr;
if(con.State==System.Data.ConnectionState.Open)
{
con.Close();//如果连接已打开，先关闭
}
con.Open();//打开连接
string sql="insert into yourTable (字段1，字段2..) value (数据1，数据2...)";//sql语句
SqlCommand cmd=new SqlCommand();实例化command对象
cmd.CommandType=CommandType.Text;//执行类型为sql语句
cmd.Connection=con;//连接对象con
cmd.CommandText=sql;//执行语句为sql
cmd.ExecuteNonQuery();//执行插入语句
con.close();//关闭连接
}
catch(Exception ex)
{
Response.Write("操作失败！");
}

Answer 3

新建一个class类文件，取名为DBSql
private SqlConnection sqlCon;
private SqlCommand sqlCmd;

public DBSql()
{
try
{
string strCon="Data Source=.;Initial Catalog="你自己的数据库名称";Trusted_Connection=yes";
sqlCon=new SqlConnection(strCon);
}
catch(sqlException on)
{
throw on;
}
//对数据库进行增删改查的方法，返回受影响的行数,将SQL语句作为参数传进来
public int OperatorDTable( string strSql)
{
int rows;
try
{
if(sqlCon!=null)
{
if(sqlcon.State!=ConnectionState.Open)
{
sqlcon.open();
}
sqlCmd=new SqlCommand(strSql,sqlCon);
rows=sqlCmd.ExecuteNonQuery();
sqlcon.close();
}

}
catch(SqlException on)
{
throw on;
return 0;
}
return rows;
}
}

需要注意的是，我上面的代码连接的是SQLSERVER2000
如果连接的是2005那么 string strCon="Data Source=你的SQLSERVER2005的服务器名称;Initial Catalog="你自己的数据库名称";Trusted_Connection=yes";

最好是把把它写在Web.Config中

Answer 4

try
{
String
commandText="select
count(*)
from
users";
SqlConnection
conn
=
new
SqlConnection();
conn.ConnectionString
=
"Data
Source=(local);Initial
Catalog=classmate;User
Id=sa;Password=sa";
SqlCommand
cmd
=
new
SqlCommand(commandText,conn);
conn.Open();
string
count
=
cmd.ExecuteScalar().ToString();
if
(conn.State
==
ConnectionState.Open)
{
Response.Write(count);
Response.Write("数据库连接成功！<br>");
Response.Write("<script>alert('连接已打开')</script>");
}
conn.Close();
if
(conn.State
==
ConnectionState.Closed)
{
Response.Write("连接已关闭");
Response.Write("<script>alert('连接已关闭')</script>");
}
}
catch(Exception
ex)
{
Response.Write("数据库连接失败"+ex.Message);
}
}