string sql="select ComID,ComName from tablename"; ComID,ComName是一一对应的
SqlConnection conn = new SqlConnection(...); SqlCommand cmd = new SqlCommand("SELECT ComName FROM tablename WHERE ComID=12", conn); conn.Open(); string comName = cmd.ExecuteScalar() as string; conn.close();
ComID,ComName是一一对应的
SqlCommand cmd = new SqlCommand("SELECT ComName FROM tablename WHERE ComID=12", conn);
conn.Open();
string comName = cmd.ExecuteScalar() as string;
conn.close();