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 ?

Asp.Net

Answers (8)