代码:
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class save : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string conn = ConfigurationManager.AppSettings["ConnectionString"].ToString();
SqlConnection myConn = new SqlConnection(conn);
myConn.Open();
string Sql = "update db2 set db3='" + v[i] + "</div>" + "', where id='" + nu + "'";
SqlCommand com = new SqlCommand(Sql, myConn);
com.ExecuteNonQuery(); myConn.Close();
}protected void btnSubmit_Click(object sender, EventArgs e)
{
if (Request["action"].ToString() == "save")
{
string[] v = Request["content1"].ToString().Replace("</DIV>", "ac").Split(char.Parse("ac"));
{
string[] tmparray;
for (int i = 0; i < v.Length; i++)
{
tmparray = v[i].Split(char.Parse(">"));
string nu = tmparray[1];
conn.execute(sql);
}
}
}
}
}
最后用conn.execute(sql);
可以吗?
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class save : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string conn = ConfigurationManager.AppSettings["ConnectionString"].ToString();
SqlConnection myConn = new SqlConnection(conn);
myConn.Open();
string Sql = "update db2 set db3='" + v[i] + "</div>" + "', where id='" + nu + "'";
SqlCommand com = new SqlCommand(Sql, myConn);
com.ExecuteNonQuery(); myConn.Close();
}protected void btnSubmit_Click(object sender, EventArgs e)
{
if (Request["action"].ToString() == "save")
{
string[] v = Request["content1"].ToString().Replace("</DIV>", "ac").Split(char.Parse("ac"));
{
string[] tmparray;
for (int i = 0; i < v.Length; i++)
{
tmparray = v[i].Split(char.Parse(">"));
string nu = tmparray[1];
conn.execute(sql);
}
}
}
}
}
最后用conn.execute(sql);
可以吗?
那应该怎么把conn变成全局变量呢
写到db2的db3中····· 不过nu=id···我就整不明白了··哎
private string conn;
protected void Page_Load(object sender, EventArgs e)
{
conn = ConfigurationManager.AppSettings["ConnectionString"].ToString();
SqlConnection myConn = new SqlConnection(conn);
myConn.Open();
string Sql = "update db2 set db3='" + v[i] + " </div>" + "', where id='" + nu + "'";
SqlCommand com = new SqlCommand(Sql, myConn);
com.ExecuteNonQuery(); myConn.Close();
} protected void btnSubmit_Click(object sender, EventArgs e)
{
if (Request["action"].ToString() == "save")
{
string[] v = Request["content1"].ToString().Replace(" </DIV>", "ac").Split(char.Parse("ac"));
{
string[] tmparray;
for (int i = 0; i < v.Length; i++)
{
tmparray = v[i].Split(char.Parse(">"));
string nu = tmparray[1];
conn.execute(sql);
}
}
}
}
有这种写法???