连接数据库的代码就不放了。
string str1 = "select * from tableName where name= 'xxx' ";
string s= db.Query(str1,0,"id");int i= int.Parse(s);
public string Query(string SQLString, int row, string columnName)
{
try
{
SqlDataAdapter sda = new SqlDataAdapter(SQLString, conn);
DataSet ds = new DataSet();
sda.Fill(ds);
string val = ds.Tables[0].Rows[row][columnName].ToString();
return val;
}
catch (Exception e)
{
throw e;
}
finally
{
conn.Close();
}
}