inserting values are not storing into database?

hello,
you have just entered insert query but i am unable to find where you have executed that...(you have created s1 variable to store your insert query but never used)

Tejamanimala, if this helps please login to Mark As Answer. | Alert Moderator

Hi,I don't know how to execute it can you please tell me how to execute it?

manimala

Tejamanimala, if this helps please login to Mark As Answer. | Alert Moderator

Yu have to bring like this

SqlCommand cmd = new SqlCommand(con);
cmd ="insert into Registration(UserID,FirstName,LastName,Address,ContactNo,DOB,Gender,EmailID) values('" + Label17 + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "','" + TextBox6.Text + "','" + RadioButtonList1.SelectedItem.Text + "','" + TextBox7.Text + "')";
cmd.ExecuteNonquery();

Tejamanimala, if this helps please login to Mark As Answer. | Alert Moderator

write this below your insert query

SqlCommand cmd = new SqlCommand(s1, con);

cmd.ExecuteNonQuery();

and remove this SqlCommand cmd = new SqlCommand(); object creation from the top

Tejamanimala, if this helps please login to Mark As Answer. | Alert Moderator

hi,still the values are not storing into database,can you please tell me how it is possible?

manimala

Tejamanimala, if this helps please login to Mark As Answer. | Alert Moderator

try this
SqlCommand cmd = new SqlCommand("insert into Registration(UserID,FirstName,LastName,Address,ContactNo,DOB,Gender,EmailID) values('" + Label17.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "','" + TextBox6.Text + "','" + RadioButtonList1.SelectedItem.Text + "','" + TextBox7.Text + "')", con);
cmd.ExecuteNonquery();

Tejamanimala, if this helps please login to Mark As Answer. | Alert Moderator

hi

change this line label like lable17.text

string s1 = "insert into Registration(UserID,FirstName,LastName,Address,ContactNo,DOB,Gender,EmailID) values('" + Label17.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "','" + TextBox6.Text + "','" + RadioButtonList1.SelectedItem.Text + "','" + TextBox7.Text + "')";

Mark as Answer if its helpful to you

Kumaraspcode2009@gmail.com

Tejamanimala, if this helps please login to Mark As Answer. | Alert Moderator

actualy what is your requirements when username not exists then that information should have to insert, if yes so write this

SqlCommand cmd = new SqlCommand("insert into Registration(UserID,FirstName,LastName,Address,ContactNo,DOB,Gender,EmailID) values('" + Label17.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "','" + TextBox6.Text + "','" + RadioButtonList1.SelectedItem.Text + "','" + TextBox7.Text + "')", con);

cmd.ExecuteNonquery();

under your if block below this Label17.Text = rn.Next(1000).ToString();

Tejamanimala, if this helps please login to Mark As Answer. | Alert Moderator

hi

try this code working


con.Open();
//Session["User ID"] = TextBox4.Text;
string s1 = "insert into Registration(UserID,FirstName,LastName,Address,ContactNo,DOB,Gender,EmailID) values('" + Label17.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "','" + TextBox6.Text + "','" + RadioButtonList1.SelectedItem.Text + "','" + TextBox7.Text + "')";
cmd.Connection = con;
//cmd.CommandText = "select count(*) from Registration where FirstName='" + TextBox2.Text + "'";
cmd.CommandText = s1;
int i = int.Parse(cmd.ExecuteNonQuery().ToString());
//int j = int.Parse(cmd.ExecuteScalar().ToString());
if (i == 0)
{
Session["id"] = Label17.Text;
Session["FirstName"] = TextBox2.Text;

TextBox2.Text = "";
TextBox3.Text = "";
TextBox4.Text = "";
TextBox5.Text = "";
TextBox6.Text = "";
TextBox7.Text = "";
RadioButtonList1.Items[0].Selected = false;
RadioButtonList1.Items[1].Selected = false;
Label17.Text = rn.Next(1000).ToString();
Response.Redirect("RegAck.aspx");
}
else
{
Label1.Text = "Username already exists...";
}
con.Close();

Mark as Answer if its helpful to you

Kumaraspcode2009@gmail.com

Tejamanimala, if this helps please login to Mark As Answer. | Alert Moderator

Hi
Ankitsrist ,and
Jayakumars,
i tried both of your code but still the data is not storing into database

manimala

Tejamanimala, if this helps please login to Mark As Answer. | Alert Moderator

giving any error??

Tejamanimala, if this helps please login to Mark As Answer. | Alert Moderator

No,it's not showing any error

manimala

Tejamanimala, if this helps please login to Mark As Answer. | Alert Moderator

can you please check my code...
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;
namespace newonlineexam
{
public partial class Register1 : System.Web.UI.Page
{
SqlConnection con = new SqlConnection("user id=sa;password=Ektha@2013;Data Source=EKTHA-3D34;Initial Catalog=OnlineExam");
Random rn = new Random();
// SqlCommand cmd = new SqlCommand();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Label17.Text = rn.Next(1000).ToString();
}
}

protected void Button1_Click1(object sender, EventArgs e)
{
con.Open();
//Session["User ID"] = TextBox4.Text;
SqlCommand cmd = new SqlCommand("insert into Registration(UserID,FirstName,LastName,Address,ContactNo,DOB,Gender,EmailID) values('" + Label17.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "','" + TextBox6.Text + "','" + RadioButtonList1.SelectedItem.Text + "','" + TextBox7.Text + "')", con);
cmd.ExecuteNonQuery();
//string s1 = "insert into Registration(UserID,FirstName,LastName,Address,ContactNo,DOB,Gender,EmailID) values('" + Label17 + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "','" + TextBox6.Text + "','" + RadioButtonList1.SelectedItem.Text + "','" + TextBox7.Text + "')";

//SqlCommand cmd = new SqlCommand(s1, con);

cmd.ExecuteNonQuery(); cmd.Connection = con;
cmd.CommandText = "select count(*) from Registration where FirstName='" + TextBox2.Text + "'";
int i = int.Parse(cmd.ExecuteScalar().ToString());
if (i == 0)
{
Session["id"] = Label17.Text;
Session["FirstName"] = TextBox2.Text;

TextBox2.Text = "";
TextBox3.Text = "";
TextBox4.Text = "";
TextBox5.Text = "";
TextBox6.Text = "";
TextBox7.Text = "";
RadioButtonList1.Items[0].Selected = false;
RadioButtonList1.Items[1].Selected = false;
Label17.Text = rn.Next(1000).ToString();
Response.Redirect("RegAck.aspx");
}
else
{
Label1.Text = "UserName already exists...";
}
con.Close();
}

protected void Button2_Click1(object sender, EventArgs e)
{
TextBox2.Text = "";
TextBox4.Text = "";
TextBox5.Text = "";
TextBox6.Text = "";
TextBox7.Text = "";
RadioButtonList1.Items[0].Selected = false;
RadioButtonList1.Items[1].Selected = false;
}

}

}

manimala

Tejamanimala, if this helps please login to Mark As Answer. | Alert Moderator

as i said above:- actualy what is your requirements when username not exists then that information should have to insert, if yes so write this
under your if block below this Label17.Text = rn.Next(1000).ToString();

SqlCommand cmd = new SqlCommand("insert into Registration(UserID,FirstName,LastName,Address,ContactNo,DOB,Gender,EmailID) values('" + Label17.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "','" + TextBox6.Text + "','" + RadioButtonList1.SelectedItem.Text + "','" + TextBox7.Text + "')", con);



cmd.ExecuteNonquery();

Tejamanimala, if this helps please login to Mark As Answer. | Alert Moderator

Are yu entering Textbox values and then proceeding with Submit???

Or
simply going with blank Textbox values and Procedding with submit?

Tejamanimala, if this helps please login to Mark As Answer. | Alert Moderator

no,am entering the values

manimala

Tejamanimala, if this helps please login to Mark As Answer. | Alert Moderator

Just keep ur breakpoint on insert query line and check whether all values are holded in Textbox

Tejamanimala, if this helps please login to Mark As Answer. | Alert Moderator

hi,i entered all the values,but still am not getting the data into database

manimala

Tejamanimala, if this helps please login to Mark As Answer. | Alert Moderator

have u add connection string in web.config file

Tejamanimala, if this helps please login to Mark As Answer. | Alert Moderator

and try to write your insert query in if block

Tejamanimala, if this helps please login to Mark As Answer. | Alert Moderator

hi
Tejamanimala
what is ur issue? working this code in my machine otherwise send me full source code zip format.


Notes:
1.You Put Multiple ExecuteNonQuery Remove One.
2.Then when execute the Record return value 1 so check i=1 like this

con.Open();
//Session["User ID"] = TextBox4.Text;
SqlCommand cmd = new SqlCommand("insert into Registration(UserID,FirstName,LastName,Address,ContactNo,DOB,Gender,EmailID) values('" + Label17.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "','" + TextBox6.Text + "','" + RadioButtonList1.SelectedItem.Text + "','" + TextBox7.Text + "')", con);
cmd.ExecuteNonQuery();
//string s1 = "insert into Registration(UserID,FirstName,LastName,Address,ContactNo,DOB,Gender,EmailID) values('" + Label17 + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "','" + TextBox6.Text + "','" + RadioButtonList1.SelectedItem.Text + "','" + TextBox7.Text + "')";

//SqlCommand cmd = new SqlCommand(s1, con);

//cmd.ExecuteNonQuery();
cmd.Connection = con;
cmd.CommandText = "select count(*) from Registration where FirstName='" + TextBox2.Text + "'";
int i = int.Parse(cmd.ExecuteScalar().ToString());



if (i == 1)
{
Session["id"] = Label17.Text;
Session["FirstName"] = TextBox2.Text;

TextBox2.Text = "";
TextBox3.Text = "";
TextBox4.Text = "";
TextBox5.Text = "";
TextBox6.Text = "";
TextBox7.Text = "";
RadioButtonList1.Items[0].Selected = false;
RadioButtonList1.Items[1].Selected = false;
Label17.Text = rn.Next(1000).ToString();
Response.Redirect("RegAck.aspx");
}
else
{
Label1.Text = "Username already exists...";
}
con.Close();

Mark as Answer if its helpful to you

Kumaraspcode2009@gmail.com

Tejamanimala, if this helps please login to Mark As Answer. | Alert Moderator

what is the connectionstring,need to write in web.config,please tell me

manimala

Tejamanimala, if this helps please login to Mark As Answer. | Alert Moderator

hi


This WebConfig File
=====================
<add name="ConnectionString" connectionString="Data Source=PCNAME;Initial Catalog=YourDbNAme;User ID=YourSqlserverID;Password=Your Password"
providerName="System.Data.SqlClient" />



server Side C# Code.
=========================

string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
string str;
SqlCommand com;
SqlDataAdapter sqlda;
DataSet ds;


protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
bindgrid("Select * from Tbl_Emp");
}
}


void bindgrid(string Qry)
{
SqlConnection con = new SqlConnection(strConnString);
con.Open();
str = Qry;

com = new SqlCommand(str, con);
sqlda = new SqlDataAdapter(com);
ds = new DataSet();
sqlda.Fill(ds, "student");
Grd1.DataSource = ds;
Grd1.DataBind();

con.Close();

}


mark as answer if it is helpful for u.

Mark as Answer if its helpful to you

Kumaraspcode2009@gmail.com

Tejamanimala, if this helps please login to Mark As Answer. | Alert Moderator

hi ,please tell me,where is the mistake,the values are not storing into database,please help me

my source code is...........
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;
namespace newonlineexam
{
public partial class Register1 : System.Web.UI.Page
{
SqlConnection con = new SqlConnection("user id=sa;password=Ektha@2013;Data Source=EKTHA-3D34;Initial Catalog=OnlineExam");
Random rn = new Random();
// SqlCommand cmd = new SqlCommand();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Label17.Text = rn.Next(1000).ToString();


}
}

protected void Button1_Click1(object sender, EventArgs e)
{
con.Open();
//Session["User ID"] = TextBox4.Text;
SqlCommand cmd = new SqlCommand("insert into Registration(UserID,FirstName,LastName,Address,ContactNo,DOB,Gender,EmailID) values('" + Label17.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "','" + TextBox6.Text + "','" + RadioButtonList1.SelectedItem.Text + "','" + TextBox7.Text + "')", con);
cmd.ExecuteNonQuery();
//string s1 = "insert into Registration(UserID,FirstName,LastName,Address,ContactNo,DOB,Gender,EmailID) values('" + Label17 + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "','" + TextBox6.Text + "','" + RadioButtonList1.SelectedItem.Text + "','" + TextBox7.Text + "')";

//SqlCommand cmd = new SqlCommand(s1, con);

//cmd.ExecuteNonQuery();
cmd.Connection = con;
cmd.CommandText = "select count(*) from Registration where FirstName='" + TextBox2.Text + "'";
int i = int.Parse(cmd.ExecuteScalar().ToString());
if (i == 1)
{

Session["id"] = Label17.Text;
Session["FirstName"] = TextBox2.Text;

TextBox2.Text = "";
TextBox3.Text = "";
TextBox4.Text = "";
TextBox5.Text = "";
TextBox6.Text = "";
TextBox7.Text = "";
RadioButtonList1.Items[0].Selected = false;
RadioButtonList1.Items[1].Selected = false;
Label17.Text = rn.Next(1000).ToString();
Response.Redirect("RegAck.aspx");
}
else
{
Label1.Text = "UserName already exists...";
}
con.Close();
}

protected void Button2_Click1(object sender, EventArgs e)
{
TextBox2.Text = "";
TextBox4.Text = "";
TextBox5.Text = "";
TextBox6.Text = "";
TextBox7.Text = "";
RadioButtonList1.Items[0].Selected = false;
RadioButtonList1.Items[1].Selected = false;
}

}

}


my c# code is....
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;
namespace newonlineexam
{
public partial class Home : System.Web.UI.Page
{
SqlConnection con = new SqlConnection("user id=sa;password=Ektha@2013;Data Source=EKTHA-3D34;Initial Catalog=OES");
protected void Page_Load(object sender, EventArgs e)
{

}

protected void Button1_Click(object sender, EventArgs e)
{
con.Open();
String s1 = "Select * from Registration where UserType='" + DropDownList1.SelectedItem.Text + "' and UserID'" + TextBox1.Text + "' and Password='" + TextBox2 + "'";
SqlCommand cmd= new SqlCommand(s1,con);
cmd.ExecuteScalar();
if(DropDownList1.SelectedItem.Text =="Student")
{
Response.Redirect("Student.aspx");
}
else if(DropDownList1.SelectedItem.Text=="Admin")
{
Response.Redirect("Admin.aspx");
}
else
{
Response.Redirect("InstructorHome.aspx");
}
}
// if (DropDownList1.SelectedItem.Text == "Student")
//{
// Session["uid"] = TextBox1.Text;
// }


//SqlDataReader da;
// da = cmd.ExecuteReader();
//if (da.Read())
//Response.Redirect("Toproceed.aspx");
// //else
// //Response.Write("not authenticated");
protected void LinkButton1_Click(object sender, EventArgs e)
{

Response.Redirect("Register1.aspx");
}
}

}

manimala

Tejamanimala, if this helps please login to Mark As Answer. | Alert Moderator

i didn't use ant connestionstring in my code na,then why i use it?

manimala

Tejamanimala, if this helps please login to Mark As Answer. | Alert Moderator

hi
atttached full source code zip format thats useful solve them

Mark as Answer if its helpful to you

Kumaraspcode2009@gmail.com

Tejamanimala, if this helps please login to Mark As Answer. | Alert Moderator

do one thing, comment all ur below code and then run insert values and lets see wat will happen

cmd.Connection = con;

cmd.CommandText = "select count(*) from Registration where FirstName='" + TextBox2.Text + "'";

int i = int.Parse(cmd.ExecuteScalar().ToString());

if (i == 1)

{



Session["id"] = Label17.Text;

Session["FirstName"] = TextBox2.Text;



TextBox2.Text = "";

TextBox3.Text = "";

TextBox4.Text = "";

TextBox5.Text = "";

TextBox6.Text = "";

TextBox7.Text = "";

RadioButtonList1.Items[0].Selected = false;

RadioButtonList1.Items[1].Selected = false;

Label17.Text = rn.Next(1000).ToString();

Response.Redirect("RegAck.aspx");

}

else

{

Label1.Text = "UserName already exists...";

}

con.Close();

}



protected void Button2_Click1(object sender, EventArgs e)

{

TextBox2.Text = "";

TextBox4.Text = "";

TextBox5.Text = "";

TextBox6.Text = "";

TextBox7.Text = "";

RadioButtonList1.Items[0].Selected = false;

RadioButtonList1.Items[1].Selected = false;

}



}

Tejamanimala, if this helps please login to Mark As Answer. | Alert Moderator