The parameterized query @Fname expects a parameter which was not supplied.

EDN Admin · Nov 1, 2012

So many of my questions were answered. Thanks for that!!
I have one more now (hopefully not too many more). Here is my code:

<span style="color:blue private <span style="color:blue void button6_Click(<span style="color:blue object sender,

{

<span style="color:#2B91AF SqlConnection con = <span style="color:blue
new System.Data.SqlClient.
con = <span style="color:blue new System.Data.SqlClient.
con.ConnectionString = <span style="color:#A31515 "Server=excel-pc;Database=Northwind.MDF;Trusted_Connection=True;";

con.Open();

<span style="color:#2B91AF SqlDataAdapter da = <span style="color:blue
new <span style="color:#2B91AF SqlDataAdapter();
<p style="margin-bottom:0in; margin-bottom:.0001pt; line-height:normal; text-autospace:none

<span style="color:blue for (<span style="color:blue int i = 0; i <= dataGridView1.Rows.Count - 1; i++)

{
<p style="margin-bottom:0in; margin-bottom:.0001pt; line-height:normal; text-autospace:none

<span style="color:#2B91AF String insertData = <span style="color:#A31515
"INSERT INTO Import_List(Fname, Lname, Age) VALUES (@Fname, @Lname, @Age)";

<span style="color:#2B91AF SqlCommand cmd = <span style="color:blue
new 
cmd.Parameters.AddWithValue(<span style="color:#A31515 "@Fname", dataGridView1.Rows.Cells[0].Value);

cmd.Parameters.AddWithValue(<span style="color:#A31515 "@Lname", dataGridView1.Rows.Cells[1].Value);

cmd.Parameters.AddWithValue(<span style="color:#A31515 "@Age", dataGridView1.Rows.Cells[2].Value);

da.InsertCommand = cmd;

cmd.ExecuteNonQuery();

}
<p style="margin-bottom:0in; margin-bottom:.0001pt; line-height:normal; text-autospace:none

con.Close();

}
<span style="font-family:Times New Roman,serif
<span style="font-family:Times New Roman,serif Here is the error message:
<span style="font-family:Times New Roman,serif <img alt="" src="http://social.msdn.microsoft.com/Forums/getfile/188174


View the full article

The parameterized query @Fname expects a parameter which was not supplied.

EDN Admin

Well-known member

Similar threads