UC知道DataSet中的DataRow
来源：百度知道 编辑：UC知道 时间：2024/09/28 17:50:11
string strCon = "Data Source=FHQUITD;Initial Catalog=db_11;Persist Security Info=True;User ID=sa;Password=46098915";
string sqlstr = "select money from yinhang where id ='" + this.TextBox1.Text.Trim() + " '";
SqlConnection sqlcon = new SqlConnection(strCon);
SqlCommand com = new SqlCommand(sqlstr, sqlcon);
sqlcon.Open();
SqlDataAdapter da = new SqlDataAdapter(sqlstr, sqlcon);
DataSet ds = new DataSet();
da.Fill(ds);
sqlcon.Close();
DataRow[] row1 = ds.Tables[0].Select(); //请问这句话是什么意思!
foreach (DataRow dr in row1)
{
sum1 = decimal.Parse(dr["money"].ToString().Trim());//这句什么意思!
}
//谢谢
string sqlstr = "select money from yinhang where id ='" + this.TextBox1.Text.Trim() + " '";
SqlConnection sqlcon = new SqlConnection(strCon);
SqlCommand com = new SqlCommand(sqlstr, sqlcon);
sqlcon.Open();
SqlDataAdapter da = new SqlDataAdapter(sqlstr, sqlcon);
DataSet ds = new DataSet();
da.Fill(ds);
sqlcon.Close();
DataRow[] row1 = ds.Tables[0].Select(); //请问这句话是什么意思!
foreach (DataRow dr in row1)
{
sum1 = decimal.Parse(dr["money"].ToString().Trim());//这句什么意思!
}
//谢谢
DataRow[] row1 = ds.Tables[0].Select(); //在数据集ds的Table[0]中进行条件查询。例如：ds.Tables[0].Select("id = 5"); 该方法的返回对象为DataRow数组。
sum1 = decimal.Parse(dr["money"].ToString().Trim()); //是将money字段的值传换为decimal类型。