请问如何在vc2005中用代码实现SQl Server数据库连接，数据查询、添加、删除等操作？急！！！

[hhuifen1721]

各位高手，请问如何在vc2005中用代码实现SQl Server数据库连接，数据查询、添加、删除等操作？

[风骑士之怒]

sqlconnection sqlcommand

[deng_zhi_ping]

public bool Insert(object bean,string tableName)
{
SqlConnection con = null;
try
{
con = new SqlConnection("server=.\\sqlexpress;database=wj;uid=sa;pwd=821123");
con.Open();

string sql = "Insert into " + tableName + "(";

Type t = bean.GetType();

System.Reflection.PropertyInfo[] pt = t.GetProperties();
foreach (System.Reflection.PropertyInfo p in pt)
{
sql += p.Name + ",";
}
sql = sql.Substring(0, sql.Length - 1) + ")values(";

foreach (System.Reflection.PropertyInfo p in pt)
{
sql += "@"+p.Name + ",";
}
sql = sql.Substring(0, sql.Length - 1) + ")";

SqlCommand com = new SqlCommand(sql, con);
foreach (System.Reflection.PropertyInfo p in pt)
{
SqlParameter sp = new SqlParameter("@" + p.Name,p.PropertyType);
sp.Value = p.GetValue(bean, null);
com.Parameters.Add(sp);
}

return Convert.ToBoolean(com.ExecuteNonQuery());

}
catch (Exception ex)
{
Console.Write(ex.Message);
return false;
}
finally
{
if (con != null) con.Close();
}
}

这是通用的添加数据方法

[deng_zhi_ping]

public DataTable select(string sql)
{
string Sql_Connstring = "Data Source=PC-200812201257\SQL2005;Initial Catalog=SBO_PL;User ID=sa;pwd=sasa";
SqlConnection con=new SqlConnection (Sql_Connstring);
//SqlCommand com=new SqlCommand (sql,con);
SqlDataAdapter datApte=new SqlDataAdapter (sql,con);

DataTable dt=new DataTable ();
datApte.Fill(dt);
return dt;

}


这是查询的方法 ok！