DataGridView Error in Insert Statement

Question

Hi, I am in a project of doing Purchase System. During insert statement, I getting an error. Here the screenshot:- I didn't getting a hint that how it occures. So please help me on this issue.

Upendra Pratap Shahi · Answer

Congrats dear.

Bineesh Viswanath · Answer

Finally I succeeded. Here the Code: Thank you everybody for your valuable suggestions.

Jaipal Reddy · Answer

Debug your code once again and check whether you pass any string as null or empty. null and empty string are different in stored procedure.

Rajeesh Menoth · Answer

Hi, Check your connection Properly...

Upendra Pratap Shahi · Answer

kindly debug your code and check properly whether it is wrong..

Bineesh Viswanath · Answer

I already has retrieved data from database which is success. I provided same connection string for this function.

Rajeesh Menoth · Answer

Hi, I think some null values or check you have entered the database name,column name ,connection name are correct or not ?

Bineesh Viswanath · Answer

Hi Rajeesh, Now the Problem varies. My current error is Object Reference............. The code where this occures is :-

Rajeesh Menoth · Answer

Hi, In your code SavePurchaseMasterDetails is a name,u just check the below code. Write like this.. string Connection = ConfigurationManager.ConnectionStrings["ConReg"].ConnectionString; SqlConnection con = new SqlConnection(Connection); string sqlCmd = "SELECT * from table_name"; SqlCommand cmd = new SqlCommand(sqlCmd, con );

DataGridView Error in Insert Statement

Answers (9)