如题 求助

其实这种问题很简单，你应该先找本书看看，因为这种入门问题书上都有

sql server

string constr="Persist Security Info=True;User ID=sa;Password=123;"+
"Data Source=HD-2b25;Initial Catalog=小组1;";
SqlConnection sqlConnection1=new SqlConnection(constr);
sqlConnection1.Open();
————————————————————————————————
insert,delete,update
+++++++++++++++++++++++++++++++++++++
string sqlstr="";//SQL语句
SqlCommand cmd=new SqlCommand(str,sqlConnection1);
cmd.ExecuteNonQuery();
sqlConnection1.Close();
+++++++++++++++++++++++++++++++++++++
———————————————————————————————
select
+++++++++++++++++++++++++++++++++++++++++
string sqlstr = "Select * From ClientInf";
SqlDataAdapter da=new SqlDataAdapter(sqlstr,sqlConnection1);

DataSet ds = new DataSet();
da.Fill(ds,"temp");
this.dataGrid1.SetDataBinding(ds.Tables["temp"].DefaultView,"");
sqlConnection1.Close();
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
——————————————————————————————————————————————————————

看看

1.using System.Data.Sqlclient;
using System.Configuration;
2.建立连接字符串,可以写一个数据库配置文件,app.config
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<appSettings >
<add key="ConnStr" value="Data Source=**;Initial Catalog=数据库;Integrated Security=True" />
</appSettings>
</configuration>
3.主要代码:
string connStr = ConfigurationSettings.AppSettings["ConnStr"];
SqlConnection sqlcn=new SqlConnection();
sqlcn.ConnectionString=connStr;
sqlcn.Open();

SqlCommand sqlcmd=new SqlCommand();
sqlcmd.CommandText ="select * from A";
sqlcmd.Connection=sqlcn;

SqlDataAdapter sqlda=new SqlDataAdapter(sqlcmd.CommandText,sqlcn);
DataSet ds = new DataSet();
sqlda.Fill(ds);
sqlcn.Close();
//操作数据集
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DataRow dr = ds.Tables[0].Rows[i];
if (TextBox1.Text = dr[0].ToString())
{
TextBox2.Text = dr[1].ToString();
}
}