圣斗士吧 关注：231,358贴子：18,056,673
不感兴趣
开通SVIP免广告
using (SqlConnection sqlconn = new SqlConnection("data source=.; initial catalog=Northwind; uid=sa;pwd="))
{
sqlconn.Open();
SqlCommand cmd = sqlconn.CreateCommand();
cmd.CommandText = " select CompanyName, OrderDate,OrderID from Customers,Orders where Customers.CustomerID=Orders.CustomerID and CompanyName like '%"+name+"%'";
DataTable dt = new DataTable();
dt.Load(cmd.ExecuteReader());
GridView1.DataSource = dt;
GridView1.DataBind();
}
{
sqlconn.Open();
SqlCommand cmd = sqlconn.CreateCommand();
cmd.CommandText = " select CompanyName, OrderDate,OrderID from Customers,Orders where Customers.CustomerID=Orders.CustomerID and CompanyName like '%"+name+"%'";
DataTable dt = new DataTable();
dt.Load(cmd.ExecuteReader());
GridView1.DataSource = dt;
GridView1.DataBind();
}
不感兴趣
开通SVIP免广告
不感兴趣
开通SVIP免广告
扫二维码下载贴吧客户端
下载贴吧APP
看高清直播、视频！
看高清直播、视频！
贴吧热议榜
- 1罗技旧账被扒,狗爪再惹众怒1550190
- 2杰克小天再聚首,TES惨败AL1120589
- 3第五人格八周年送金皮948080
- 4搞心态?罗永浩反向拉黑粉丝744849
- 5Milkway自证:泄露BP是假的736580
- 6穷小子逆袭,张雪机车夺世冠735925
- 7A吧开盾,维护鸣潮斩鬼图594096
- 8洛克贝300w上限,玩家不买账487692
- 9等等党输麻了,ps5大涨近翻倍364650
- 10极客湾自曝横评下架内情313173
