UC知道那位大哥帮我看下
来源：百度知道 编辑：UC知道 时间：2024/09/24 23:45:15
代码:
......
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection mysql = new SqlConnection("data source=localhost;integrated security=true;initial catalog=myexample");
SqlCommand mycmd = new SqlCommand("select * from mytable", mysql);
mysql.Open();
SqlDataReader mydr= mycmd.ExecuteReader();
while (mydr.Read())
{ Response.Write(mydr["username"] + " "+ mydr["password"] + "<br>"); }
mydr.Close();
mysql.Close();
}
protected void mybutton_Click(object sender, EventArgs e)
{ SqlConnection mysql = new SqlConnection("data source=localhost;integrated security=true;initial catalog=myexample");
String mystring="Insert Into mytable(username,[Password],gender,birthplace
......
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection mysql = new SqlConnection("data source=localhost;integrated security=true;initial catalog=myexample");
SqlCommand mycmd = new SqlCommand("select * from mytable", mysql);
mysql.Open();
SqlDataReader mydr= mycmd.ExecuteReader();
while (mydr.Read())
{ Response.Write(mydr["username"] + " "+ mydr["password"] + "<br>"); }
mydr.Close();
mysql.Close();
}
protected void mybutton_Click(object sender, EventArgs e)
{ SqlConnection mysql = new SqlConnection("data source=localhost;integrated security=true;initial catalog=myexample");
String mystring="Insert Into mytable(username,[Password],gender,birthplace
那是因为你把TextBox存到数据库里了，而不是把TextBox.Text存到数据库里了。
你试下TextBox.ToString()就知道了。
——————————
String mystring="Insert Into mytable(username,[Password],gender,birthplace,birth)Values('"+TextBox1+"','"+TextBox2+"','"+TextBox1+"','"+TextBox1+"','"+TextBox1+"')";
这句，TextBox是个控件，你要传的是控件中的值，全部改成：
TextBox1.Text TextBox2.Text……
mydr["username"] 要加.ToString()
后面更新数据库的时候 textbox.text 也没有！！！