how to fill data in sql server??

vinod jangir

11y1.1kVisual Basic .NET

i add Test_Result column in table and i fill data from client side but i confuse

help me

for (int r = 0; r < dataGridView1.RowCount; r++)

{

if (con.State == ConnectionState.Closed)

con.Open();

SqlCommand cmd1 = new SqlCommand ("Insert Into Admission(Test_Result) Values (" + Row[Test_Result].ToString() +")");

//cmd1.Parameters.AddWithValue("Test_Result", dataGridView1.Rows[e.RowIndex].Cells[3].Value);

com.ExecuteNonQuery();

con.Close();

FrmTest fc = new FrmTest();

MessageBox.Show("Inserted sucessfully");

this.Close();

}

9 Replies

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

Vipan Sharma11y ago
Accepted answer
As per screen shot you provide me . I think you are looking to update the result of record you are showing in grid.

string Query2 = "Update Admission set Test_Result = " + Convert.ToInt32(dataGridView1.Rows[r].Cells[3].Value) + " where Admission_ID =@Admission_ID ";
Vipan Sharma11y ago
Is Admission_ID is Primary key ?
vinod jangir11y ago
following error found.

Cannot insert the value NULL into column 'Admission_ID', table 'Shreesankalpclass.dbo.Admission'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Vipan Sharma11y ago
Hello Vinod,

Thanks for information sharing.

I have checked the code you have shared with us and found the query of MSSQL you are using have syntax error.

string Query2 = "Insert Test_Result Into Admission Values(" + Test_Result + "," + Convert.ToInt32(dataGridView1.Rows[r].Cells[3].Value) + ")";

I have done some changes in query.

string Query2 = "Insert Into Admission (Test_Result) Values("+Convert.ToInt32(dataGridView1.Rows[r].Cells[3].Value) + ")";

and also need to call

cmd.ExecuteNonquery()

and if you facing any error during insertion. Kindly share your error. Because I'm not able to run your code due to no database in attached file.

P.S Changes AS PER CODE SEND BY YOU.

Revert me if any issue
vinod jangir11y ago
attach below file???
help me please...
Vipan Sharma11y ago
Hello Vinod,

The question you have posted is not clear . You need to explain your problem in more detail for get best solution. It also save time of other author for solving your problem.

have a nice day

Vipan
vinod jangir11y ago
if i fill data from client side Test_Result column data???
but it fill data in admission for first column ???
why can do ???

for (int r = 0; r < dataGridView1.RowCount; r++)
{
if (dataGridView1.Rows[r].Cells[0].Value != null)
{
string Query2 = "Insert Test_Result Into Admission Values(" + Test_Result + "," + Convert.ToInt32(dataGridView1.Rows[r].Cells[3].Value) + ")";
SqlCommand com3 = new SqlCommand(Query2, con);
com3.Connection = con;
con.Close();
FrmTest fc = new FrmTest();
MessageBox.Show("Inserted sucessfully");
this.Close();
}
else
{
MessageBox.Show("Invalid Operation");
}
}
Abhay Shanker11y ago
What the exactly you want to show in grid from client side. Share Details
Manas Mohapatra11y ago
Please describe your problem. Because you are writing form open,close and showing alert box inside a for loop which is not good. Means if your gridview contains 10 rows then think 10 time it will show messagebox and open the window form. Please elaborate.