c#_数据库连接和操作大全+经典SQL语句大全+SQL语句学习手册实例.pdf

文档介绍：c# wxh zt
一:数据库连接代码:
SqlConnection objSqlConnection = new SqlConnection ("server = ;uid = sa;
pwd =;database =test");
();
二:数据库的添加记录代码:
int i = 0;
string s1 = "", s2 = "";
i = ();
s1 = ;
s2 = ;
SqlConnection objSqlConnection = new SqlConnection("server = .
1;uid = sa; pwd =;database =test");
();
("数据库连接成功", "好");
try
{
mand = new mand("insert into info(id,name,sex)
values( " + i + ",'" + s1 + "','" + s2 + "')", objSqlConnection);
.ExecuteNonQuery();
("添加成功!", "啊");
}
catch (Exception a)
{
(());
}
("添加成功!", "啊");
1
}
三:数据库的修改代码:
int i = 0;
string s1 = "", s2 = "";
s1 = ;
s2 = ;
if ( == 0)
i = 0;
else
i = ();
SqlConnection objSqlConnection = new SqlConnection("server = .
1;uid = sa; pwd =;database =test");
();
("数据库连接成功", "好");
try
{
mand = new mand("update info set name='"+s1+"',
sex='"+s2+"'"+"where id=" + i, objSqlConnection);
.ExecuteNonQuery();
("修改成功!", "啊");
();
}
catch (Exception a)
{
(());
}
四:数据库的删除代码:
int i = 0;
string s1 = "", s2 = "";
s1 = ;
s2 = ;
if(==0)
i=0;
else
i = ();
2
SqlConnection objSqlConnection = new SqlConnection("server = .
1;uid = sa; pwd =;database =test");
();
("数据库连接成功", "好");
try
{
mand = new mand("delete from info where id="+i,
objSqlConnection);
.ExecuteNonQuery();
("删除成功!", "啊");
();
}
catch (Exception a)
{
(());
}
五:数据库的查询代码:
:
DataTa