Question

C#中连接到数据库后怎么执行Sql语句？

Answer 1

C#中执行SQL语句
//SQL查询语句
public DataTable query(string sql)
{
//server=127.0.0.1;
DataTable dt=new DataTable();
//DataRow dr;
string connString = "server=127.0.0.1;uid=sa;pwd=;database=TJPTTC";
SqlConnection conn = new SqlConnection(connString);
SqlDataAdapter adapter = new SqlDataAdapter(sql,conn);
adapter.Fill(dt);
return dt;
}
//SQL非查询语句
public void noQuery(string sql)
{
//server=127.0.0.1;
string connString = "server=GLASSESONION;uid=sa;pwd=;database=TJPTTC";
SqlConnection conn = new SqlConnection(connString);
SqlCommand cmd = new SqlCommand(sql,conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}

Answer 2

SqlCommand cmd = sqlConnection.CreateCommand();
cmd.CommandText = string.Format(
"SELECT xPos, yPos FROM Position WHERE username = 1 AND panelname= 2"
);