Asp.Net

i see your insert code is in page_load event. please move it to Submit_button click event -

1. go to projectadd.aspx -->double click on the submit button -->

then in projectadd.aspx.cs page

protected void Submit_Button_Click(object sender, EventArgs e)

{

int userId = 0;

string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;

using (SqlConnection con = new SqlConnection(constr))

{

using (SqlCommand cmd = new SqlCommand("Employee"))

{

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@Name", N_TB.Text.Trim());

cmd.Parameters.AddWithValue("@Description", D_TB.Text.Trim());

cmd.Parameters.AddWithValue("@Subject", S_TB.Text.Trim());

cmd.Parameters.AddWithValue("@Topic", TP_TB.Text.Trim());

cmd.Parameters.AddWithValue("@TotalPages", TotalPages_TB.Text.Trim());

cmd.Parameters.AddWithValue("@CostPerPage", CostPerPage_TB.Text.Trim());

cmd.Parameters.AddWithValue("@TotalCost", TotalCost_TB.Text.Trim());

cmd.Parameters.AddWithValue("@StartDate", StartDate_TB.Text.Trim());

cmd.Parameters.AddWithValue("@Deadline", Deadline_TB.Text.Trim());

cmd.Parameters.AddWithValue("@Reference", Reference_TB.Text.Trim());

cmd.Parameters.AddWithValue("@ProjectStyleId", ProjectStyleId_TB.Text.Trim());

cmd.Parameters.AddWithValue("@CustomerId", CustomerId_TB.Text.Trim());

cmd.Parameters.AddWithValue("@IsActive", IsActive_TB.Text.Trim());

cmd.Parameters.AddWithValue("@CreatedOn", CreatedBy_TB.Text.Trim());

cmd.Parameters.AddWithValue("CreatedBy", CreatedBy_TB.Text.Trim());

cmd.Parameters.AddWithValue("UpdatedOn", UpdatedOn_TB.Text.Trim());

cmd.Parameters.AddWithValue("UpdatedBy", UpdatedBy_TB.Text.Trim());

cmd.Connection = con;

con.Open();

userId = Convert.ToInt32(cmd.ExecuteScalar());

con.Close();

}

}

also i didnot find any connectionstring in web.config
please add your databse connection string in web.config with key name as "constr"

8 Replies

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

ram zy12y ago

connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\celebral.mdf;User Instance=true"
providerName="System.Data.SqlClient" />

0
Lakshmanan Sethu Sankaranarayan12y ago
Hi, We are not able to see the connection string.Please post it again.
0
ram zy12y ago
i have pasted in the above dilog
0
Biswa Pujarini Mohapatra12y ago
can you paste your connection string here if possible and put your code in try catch
0
ram zy12y ago
this the connection string ... but not working
0
Biswa Pujarini Mohapatra12y ago
i see your insert code is in page_load event. please move it to Submit_button click event -

1. go to projectadd.aspx -->double click on the submit button -->

then in projectadd.aspx.cs page
protected void Submit_Button_Click(object sender, EventArgs e)
{
int userId = 0;
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("Employee"))
{

cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Name", N_TB.Text.Trim());
cmd.Parameters.AddWithValue("@Description", D_TB.Text.Trim());
cmd.Parameters.AddWithValue("@Subject", S_TB.Text.Trim());
cmd.Parameters.AddWithValue("@Topic", TP_TB.Text.Trim());
cmd.Parameters.AddWithValue("@TotalPages", TotalPages_TB.Text.Trim());
cmd.Parameters.AddWithValue("@CostPerPage", CostPerPage_TB.Text.Trim());
cmd.Parameters.AddWithValue("@TotalCost", TotalCost_TB.Text.Trim());
cmd.Parameters.AddWithValue("@StartDate", StartDate_TB.Text.Trim());
cmd.Parameters.AddWithValue("@Deadline", Deadline_TB.Text.Trim());
cmd.Parameters.AddWithValue("@Reference", Reference_TB.Text.Trim());
cmd.Parameters.AddWithValue("@ProjectStyleId", ProjectStyleId_TB.Text.Trim());
cmd.Parameters.AddWithValue("@CustomerId", CustomerId_TB.Text.Trim());
cmd.Parameters.AddWithValue("@IsActive", IsActive_TB.Text.Trim());
cmd.Parameters.AddWithValue("@CreatedOn", CreatedBy_TB.Text.Trim());
cmd.Parameters.AddWithValue("CreatedBy", CreatedBy_TB.Text.Trim());
cmd.Parameters.AddWithValue("UpdatedOn", UpdatedOn_TB.Text.Trim());
cmd.Parameters.AddWithValue("UpdatedBy", UpdatedBy_TB.Text.Trim());

cmd.Connection = con;
con.Open();
userId = Convert.ToInt32(cmd.ExecuteScalar());
con.Close();

}
}
}

also i didnot find any connectionstring in web.config
please add your databse connection string in web.config with key name as "constr"
0
ram zy12y ago
i have uploaded my codeactually its not shwoing any error
0
Shweta Lodha12y ago
what error are you getting ?
Can you paste your code here ?
0