62,047
社区成员
发帖
与我相关
我的任务
分享
protected void Bind()
{
sqlcon.Open();//打开数据库连接
string sqlCmdText = "select * from tb_Card where 帖子编号=@id";
SqlCommand sqlcmd = new SqlCommand(sqlCmdText, sqlcon);
SqlParameter id = new SqlParameter("@id", SqlDbType.Int);
id.Value = int.Parse(_id);
sqlcmd.Parameters.Add(id);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = sqlcmd;
DataSet ds = new DataSet();
da.Fill(ds);
FormView1.DataSource = ds;
FormView1.DataBind();
string sqlCmdText2 = "select * from tb_Reply where 帖子编号=@id";
SqlCommand sqlcmd2 = new SqlCommand(sqlCmdText2, sqlcon);
SqlParameter id2 = new SqlParameter("@id", SqlDbType.Int);
id2.Value = int.Parse(_id);
sqlcmd2.Parameters.Add(id2);
SqlDataAdapter da2 = new SqlDataAdapter();
da2.SelectCommand = sqlcmd2;
DataSet ds2 = new DataSet();
da2.Fill(ds2, "tb_Reply");
DataList1.DataSource = ds2.Tables["tb_Reply"];
DataList1.DataBind();
}
string sqlCmdText = "select * from tb_Reply where 帖子编号=@id union all select * from tb_Card where 帖子编号=@id";
protected void Bind()
{
sqlcon.Open();//打开数据库连接
string sqlCmdText = "select * from tb_Card where 帖子编号=@id";
SqlCommand sqlcmd = new SqlCommand(sqlCmdText, sqlcon);
SqlParameter id = new SqlParameter("@id", SqlDbType.Int);
id.Value = int.Parse(_id);
sqlcmd.Parameters.Add(id);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = sqlcmd;
DataSet ds = new DataSet();
da.Fill(ds);
FormView1.DataSource = ds;
FormView1.DataBind();
string sqlCmdText2 = "select * from tb_Reply where 帖子编号=@id";
SqlCommand sqlcmd2 = new SqlCommand(sqlCmdText2, sqlcon);
SqlParameter id2 = new SqlParameter("@id", SqlDbType.Int);
id2.Value = int.Parse(_id);
sqlcmd2.Parameters.Add(id2);
SqlDataAdapter da2 = new SqlDataAdapter();
da2.SelectCommand = sqlcmd2;
DataSet ds2 = new DataSet();
da2.Fill(ds2, "tb_Reply");
DataList1.DataSource = ds2.Tables["tb_Reply"];
DataList1.DataBind();
}