// this the code of the linked database with page
protected void Page_Load(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(Request.QueryString["IDContent"]))
{
Response.Redirect("ContentList.aspx");
}
if (!String.IsNullOrEmpty(Request.QueryString["IDContent"]))
{
if (!IsPostBack)
//这是connectionString
{
SqlConnection Cn = new SqlConnection("Data Source = Lenovo;Initial Catalog = Web_Data; Integrated Security = True");
Cn.Open();
string Sql = "Select * From Content_Table Where IDContent = @IDContent";
DataTable Dt = new DataTabel();
SqlDataAdapter Da = new SqlDataAdapter(Sql, Cn);
Da.SelectCommand.Parameters.AddWithValue("IDContent", Request.QueryString["IDContent"]);
Da.Fill(Dt);
Cn.Close();
//从Sql server导入数据的代码
if (Dt.Rows.Count > 0)
{
TxtCategory2.SelectedValue = Dt.Rows[0]["FIDContent"].ToString();
TxtTitel2.Text = Dt.Rows[0]["ContentTitel"].ToString();
TxtDateTime2.Text = Dt.Rows[0]["ContentDateTime"].ToString();
TxtSummary2.Text = Dt.Rows[0]["ContentSummary"].ToString();
TextImage.Text = Dt.Rows[0]["ContentImage"].ToString();
TxtText2.Text = Dt.Rows[0]["ContentText"].ToString();
Image1.ImageUrl = TextImage.Text;
}
else
{
LbMsg2.Text = " The Content is not exist!";
}
}
}
}
我发现“ IDContent”的拼写有误,我将其更改为“ ContentID”,就像SQL Server表上的同名一样,这是可行的!,这只是键入erorr。
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句