我现在想把SQL查询出来的数据通过dataset的ds对象来获取,并把我需要的数据显示出来,在下面两句代码后面需要添加什么呢?才能使第三获取数据数据呢?请指教
sSql="select * from news where newsid="+newsid;
DataSet ds=new DataSet();
txttitle.Value=ds.Tables["news"].Columns["newstitle"].ToString();
sSql="select * from news where newsid="+newsid;
DataSet ds=new DataSet();
txttitle.Value=ds.Tables["news"].Columns["newstitle"].ToString();
if(dv.Count != 0)
{
txttitle.Value = dv[0]["newstitle"].ToString();
}
但是读取出来的数据可能不止一条呢
SqlCommand cmd = new SqlCommand("sql语句",con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
DataSet ds=new DataSet(); SqlConnection conn = new SqlConnection(连接数据库字符串);
SqlDataAdapter da = new SqlDataAdapter(sSql,conn);
conn.open();
da.Fill(ds, "USERINFO");
txttitle.Value=ds.Tables["news"].Rows[0]["newstitle"].ToString();
都写
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "SELECT * FROM basic_plan";
cmd.Connection = conn;
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds);
Repeater1.DataSource = ds.Tables[0].DefaultView;
Repeater1.DataBind();
da.Dispose();
SqlCommand cmd = new SqlCommand("sql语句",con);
txttitle.Value=cmd.ExecuteScalar().ToString();
dataReader比fill快,但是只能读