62,074
社区成员
发帖
与我相关
我的任务
分享
SqlConnection conn = new SqlConnection(sqlbusiness);
string i = ddl.SelectedValue;
string display = "select content from business where category=" + "'" + i + "'";
SqlDataAdapter sda= new SqlDataAdapter(display, conn);
DataSet ds = new DataSet();
sda.Fill(ds);
sda.UpdateCommand = new SqlCommand("update business set content=" + "'" + Editor1.Text + "'" + "where category=" + "'" + i + "'",conn);
ds.Tables[0].Rows[0][0] = Editor1.Text;
protected void ddl_SelectedIndexChanged(object sender, EventArgs e)
{
}
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(sqlbusiness);
string i = ddl.SelectedValue;
string display = "select content from business where category=" + "'" + i + "'";
SqlDataAdapter sda = new SqlDataAdapter(display, conn);
DataSet ds = new DataSet();
sda.Fill(ds);
DataTable tableSource = ds.Tables[0];
Editor1.Text = ds.Tables[0].Rows[0][0].ToString();
}
sda.UpdateCommand = new SqlCommand("update business set content=" + "'" + Editor1.Text + "'" + " where category=" + "'" + ddl.SelectedValue + "'", conn);
sda.UpdateCommand.Parameters.Add(Editor1.Text, SqlDbType.NText, 15, "content");
SqlParameter parameter = sda.UpdateCommand.Parameters.Add(i, SqlDbType.NVarChar,15,"category");
parameter.SourceColumn = i;
parameter.SourceVersion = DataRowVersion.Original;
DataSet dataset = new DataSet();
sda.Fill(dataset, "business");
DataRow row = dataset.Tables["business"].Rows[0];
row["content"] = Editor1.Text;
sda.Update(dataset, "business");
conn.Close();
sda.UpdateCommand = new SqlCommand("update business set content=@content where category=@category ", conn);
sda.UpdateCommand.Parameters.Add("@content", SqlDbType.NText, 15, "content");
SqlParameter parameter = sda.UpdateCommand.Parameters.Add("@category", SqlDbType.NVarChar,15,"category");
parameter.SourceColumn = "category";
parameter.SourceVersion = DataRowVersion.Original;
DataSet dataset = new DataSet();
sda.Fill(dataset, "business");
DataRow row = dataset.Tables["business"].Rows[0];
row["content"] = Editor1.Text;
sda.Update(dataset, "business");
conn.Close();
SqlConnection conn = new SqlConnection(sqlbusiness);
conn.Open();
string i = ddl.SelectedValue;
string display = "select * from business where category=" + "'" + i + "'";
SqlDataAdapter sda= new SqlDataAdapter(display, conn);
sda.UpdateCommand = new SqlCommand("update business set content=" + "'" + Editor1.Text + "'" + " where category=" + "'" + ddl.SelectedValue + "'", conn);
sda.UpdateCommand.Parameters.Add(Editor1.Text, SqlDbType.NText, 15, "content");
SqlParameter parameter = sda.UpdateCommand.Parameters.Add(i, SqlDbType.NVarChar,15,"category");
parameter.SourceColumn = i;
parameter.SourceVersion = DataRowVersion.Original;
DataSet dataset = new DataSet();
sda.Fill(dataset, "business");
DataRow row = dataset.Tables["business"].Rows[0];
row["content"] = Editor1.Text;
sda.Update(dataset, "business");
conn.Close();
dataAdpater.UpdateCommand = new SqlCommand(
"UPDATE Categories SET CategoryName = @CategoryName " +
"WHERE CategoryID = @CategoryID", connection);
dataAdpater.UpdateCommand.Parameters.Add(
"@CategoryName", SqlDbType.NVarChar, 15, "CategoryName");
dataAdpater.UpdateCommand.Parameters.Add(
"@CategoryName", SqlDbType.NVarChar, 15, "CategoryName");
SqlParameter parameter = dataAdpater.UpdateCommand.Parameters.Add(
"@CategoryID", SqlDbType.Int);
parameter.SourceColumn = "CategoryID";
parameter.SourceVersion = DataRowVersion.Original;
dataAdpater.Update(dataSet, "Categories");
SqlParameter parameter = dataAdpater.UpdateCommand.Parameters.Add(
"@CategoryID", SqlDbType.Int);
parameter.SourceColumn = "CategoryID";
parameter.SourceVersion = DataRowVersion.Original;
dataAdpater.Update(dataSet, "Categories");