DataGridView Error in Insert Statement

Bineesh Viswanath

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.

9 Replies

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

Upendra Pratap Shahi11y ago
Congrats dear.
0
Bineesh Viswanath11y ago
Finally I succeeded. Here the Code:

Thank you everybody for your valuable suggestions.

0
Jaipal Reddy11y ago
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.
0
Rajeesh Menoth11y ago
Hi,

Check your connection Properly...
0
Upendra Pratap Shahi11y ago
kindly debug your code and check properly whether it is wrong..
0
Bineesh Viswanath11y ago
I already has retrieved data from database which is success. I provided same connection string for this function.
0
Rajeesh Menoth11y ago
Hi,

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

Now the Problem varies. My current error is Object Reference.............

The code where this occures is :-

0
Rajeesh Menoth11y ago
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 );
0