Asp.Net

Question

I suppose to create a web form which insert data into db on button clicks ... but unfotunately it is not inseting to database

ram zy · Answer

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

Lakshmanan Sethu · Answer

Hi We are not able to see the connection string.Please post it again.

ram zy · Answer

i have pasted in the above dilog

Biswa Pujarini Mohapatra · Answer

can you paste your connection string here if possible and put your code in try catch

ram zy · Answer

this the connection string ... but not working

Biswa Pujarini Mohapatra · Answer

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

ram zy · Answer

i have uploaded my codeactually its not shwoing any error

Shweta Lodha · Answer

what error are you getting ? Can you paste your code here ?