miiiti
پنج شنبه 15 خرداد 1393, 20:58 عصر
سلام دوستان من میخوام اطلاعت فرمم در دیتا بیس درج بشه ولی همش ارور cmd.ExecuteNonQuery(); میگیره
اینا کد رویداد دکمه ثبت اطلاعات هستش
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class adminpanel_users_insert : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button2_Click(object sender, EventArgs e)
{
System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection();
con.ConnectionString = System.Configuration.ConfigurationManager.Connecti onStrings["DatabaseConnectionString1"].ConnectionString;
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
cmd.CommandType= System.Data.CommandType.Text;
cmd.CommandText="insert into to tblmembers values (N'"+txtname.Text+"',N'"+txtfamily.Text+"',N'"+txtemail.Text+"',N'"+txtpass1.Text+"',N'"+txtpass2.Text+"',N'"+DropDownList1.SelectedValue+"')";
cmd.Connection=con;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
Response.Redirect("deafult.aspx");
}
}
چیکار کنم؟//:ناراحت:
اینا کد رویداد دکمه ثبت اطلاعات هستش
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class adminpanel_users_insert : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button2_Click(object sender, EventArgs e)
{
System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection();
con.ConnectionString = System.Configuration.ConfigurationManager.Connecti onStrings["DatabaseConnectionString1"].ConnectionString;
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
cmd.CommandType= System.Data.CommandType.Text;
cmd.CommandText="insert into to tblmembers values (N'"+txtname.Text+"',N'"+txtfamily.Text+"',N'"+txtemail.Text+"',N'"+txtpass1.Text+"',N'"+txtpass2.Text+"',N'"+DropDownList1.SelectedValue+"')";
cmd.Connection=con;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
Response.Redirect("deafult.aspx");
}
}
چیکار کنم؟//:ناراحت: