数据表有两个字段ShowContent、ShowOrder,我想查询出 ShowContent字段,查询条件按ShowOrder 字段升序排列,我想把从数据库里读出的数据放在ShowConn里,最后ShowConn的形式是ShowConn = "Sno,Sname,...,Ssex" ,(其实这个结果是要显示另一个表select的内容)我该怎么做啊 .请高手指点 string ShowConn = null; GridView1.Visible = true;
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "xxx";
conn.Open();
string strSel = "select * from ShowContent order by ShowOrder asc";
SqlCommand selcom = new SqlCommand(strSel, conn);
//以下是我瞎写的
//SqlDataAdapter da = new SqlDataAdapter();
//da.SelectCommand = selcom;
//DataSet ds = new DataSet();
//da.Fill(ds, "account");
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "xxx";
conn.Open();
string strSel = "select * from ShowContent order by ShowOrder asc";
SqlCommand selcom = new SqlCommand(strSel, conn);
//以下是我瞎写的
//SqlDataAdapter da = new SqlDataAdapter();
//da.SelectCommand = selcom;
//DataSet ds = new DataSet();
//da.Fill(ds, "account");
不知道你是不是这个意思
还是说要两表连接
string ShowConn = null; GridView1.Visible = true;
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "xxx";
conn.Open();
string strSel = "select contentName from ShowContent order by ShowOrder asc";
SqlCommand selcom = new SqlCommand(strSel, conn);
//以下是我瞎写的
//SqlDataAdapter da = new SqlDataAdapter();
//da.SelectCommand = selcom;
//DataSet ds = new DataSet();
//da.Fill(ds, "account");
lz是想两个表连表查询么?
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "xxx";
conn.Open();
string strSel = "select contentName from ShowContent order by ShowOrder asc";
SqlCommand selcom = new SqlCommand(strSel, conn);
SqlDataAdapter da = new SqlDataAdapter(selcom);
DataSet ds = new DataSet();
da.Fill(ds, "table");//table随便起的虚拟表名
DataTable dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
ShowConn = ShowConn + dt.Rows[i][0].ToString() + ",";
}
ShowConn=ShowConn.Substring(0,ShowConn.Length-1)//去掉最后的逗号
是ShowContent表有两个字段contentName、ShowOrder。contentName字段的内容是Sno,Sname,...,Ssex
ShowConn表有Sno,Sname,...,Ssex等字段,
你要显示的是ShowConn表这些字段的内容?