buttons don't work in asp.net c#

Jyoti Jodha

9y1.1k.NET

I am Using bootstrap templates

and i am want to save data in data base

don't show any Error or don't save data in database

protected void Button1_Click(object sender, EventArgs e)

{

SqlConnection con;

con = new SqlConnection(ConfigurationManager.AppSettings["connect"]);

con.Open();

SqlCommand cmd;

cmd = new SqlCommand("Insert into registration (name,class) values('" + TextBox1.Text + "','" + TextBox2.Text + "')", con);

try

{

con.Open();

cmd.ExecuteNonQuery();

Label14.Text = "Data inserted successfully";

con.Close();

refress();

}

catch (Exception ex)

{

Label14.Text = ex.Message;

}

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ramesh Palanivel9y ago
Accepted answer
Hi Jyothi,

You are tying to open two connection string same time. May be the reason it may occur any error.

Please try the below code,
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con;
con = new SqlConnection(ConfigurationManager.ConnectionString["connect"]);

SqlCommand cmd;
cmd = new SqlCommand("Insert into registration (name,class) values('" + TextBox1.Text + "','" + TextBox2.Text + "')", con);
try
{
con.Open();
cmd.ExecuteNonQuery();
Label14.Text = "Data inserted successfully";
con.Close();
refress();
}
catch (Exception ex)
{
Label14.Text = ex.Message;
}
}
Ramesh Palanivel9y ago
Hi Jyothi,

set break point and check your code, whether it comes catch or not.

Change this code try again,

Lable4.Text=ex.toString();
Jyoti Jodha9y ago
Don't Show Any Error Message.......
Ramesh Palanivel9y ago
Hi Jyothi,

Initially you are hiding your lable4 visible false, set it true before assigning exception msg for lable 4,

please change this code and try again,
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con;
con = new SqlConnection(ConfigurationManager.ConnectionString["connect"]);

SqlCommand cmd;
cmd = new SqlCommand("Insert into registration (name,class) values('" + TextBox1.Text + "','" + TextBox2.Text + "')", con);
try
{
con.Open();
cmd.ExecuteNonQuery();
Label14.Text = "Data inserted successfully";
con.Close();
refress();
}
catch (Exception ex)
{
Label14.Visible=true;
Label14.Text = ex.Message;
}
}
Sundaram Subramanian9y ago
1) Check your are using the correct database

2) Breakpoint the Button event and figure what error is getting, May be try .. catch ... catches the error. See the Error there and let me to know, or else you can fix if you are aware of error.

thanks in advance
Jyoti Jodha9y ago
Html code

<%@ Page Title="" Language="C#" MasterPageFile="~/Web_Homepages.Master" AutoEventWireup="true" CodeBehind="Post_Add.aspx.cs" Inherits="user_Details.Post_Add" %>
Ramesh Palanivel9y ago
Hi Jyothi,

please share your html page code also.
Jyoti Jodha9y ago
doing try this code

Problem same....??
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con;
con = new SqlConnection(ConfigurationManager.ConnectionString["connect"]);
SqlCommand cmd;
cmd = new SqlCommand("Insert into registration (name,class) values('" + TextBox1.Text + "','" + TextBox2.Text + "')", con);
try
{
con.Open();
cmd.ExecuteNonQuery();
Label14.Text = "Data inserted successfully";
con.Close();
refress();
}
catch (Exception ex)
{
Label14.Text = ex.Message;
}
}