C#关于SQL数据库连接的相关函数！

最新推荐文章于 2023-03-22 16:33:47 发布

风的期待

最新推荐文章于 2023-03-22 16:33:47 发布

阅读量419

点赞数

本文链接：https://blog.csdn.net/xu646663752/article/details/51596128

版权

ConnectionString constr= “data source = 192.169.0.103; database = repeaterDB; uid = sa  ;  pwd = xu6532591; ”;
SqlConnection  conn = new SqlConnection(constr);
conn.Open();
SqlCommand comd = new Sqlcommand;
comd.Connection = conn;
comd.text= "select * from ";
dataset ds = new dataset();
SqldataAdapt adpt = new SqldataAdpt(comd);
adpt.fill(ds);
return da;

<span style="color: rgb(51, 51, 51); font-family: Arial; font-size: 14px; line-height: 26px;">command.ExecuteNonQuery();</span>

<span style="color: rgb(51, 51, 51); font-family: Arial; font-size: 14px; line-height: 26px;"><span style="color: rgb(51, 51, 51); font-family: Arial; font-size: 14px; line-height: 26px;">ExecuteScalar</span>
</span>

ExecuteReader