Hi

Hi,

 

I have a winform application that gets data from an excel file and places it in a datatable. I then need to insert those values into my database by calling a stored procedure.

 I have the following code but it gives me an error:
Procedure or function insExcelTest has too many arguments specified.

The first set of records from the excel file is entered into the database. This error occurs the second time it enters the loop. When i run SQL Profiler I see that it tries to insert the 1st record again and therefore there are more arguments passed then in the sp. 
I am not sure how to modify my code to insert into the database as it should.

Any help will be greatly appreciated. 
Thanks
 

myDataTable contains the information from the excel file.

 
3    public static void DisplayDataTable(
4    
5       DataTable myDataTable
6    )
7            {
8                SqlConnection mySqlConnection = new SqlConnection(connectionString);
9                 
10                 DataSet myDataSet = new DataSet();
11                 // formulate a SELECT statement to retrieve the
12                       string selectString =
13                   "SELECT ID, firstname, lastname " +
14                   "FROM excelTest " ;
15               // use the Clear() method of the DataSet object
16               // to remove all the rows in the DataSet
17   
18                 // create a SqlCommand object to hold the SELECT statement
19                 SqlCommand mySqlCommand = mySqlConnection.CreateCommand();
20   
21                 // set the CommandText property of the SqlCommand object to
22                 // the SELECT string
23                 mySqlCommand.CommandText = selectString;
24   
25                 // create a SqlDataAdapter object
26                 SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter();
27                
28                 // set the SelectCommand property of the SqlAdapter object
29                 // to the SqlCommand object
30                 mySqlDataAdapter.SelectCommand = mySqlCommand;
31   
32              myDataSet.Clear();
33   
34               // use the Fill() method of the SqlDataAdapter object
35               // to synchronize any changes made to the database
36               // with the DataSet object
37               mySqlDataAdapter.Fill(myDataSet, "ExcelTable");
38   
39             
40               // display the columns for each row in the DataTable,
41               // using a DataRow object to access each row in the DataTable
42               foreach (DataRow myDataRow in myDataTable.Rows)
43               {
44   
45                   mySqlCommand.CommandType = CommandType.StoredProcedure;
46                   mySqlCommand.CommandText = "insExcelTest";
47                   mySqlCommand.Connection = mySqlConnection;
48   
49                   mySqlCommand.Parameters.Add("@candidate_id", SqlDbType.Int, 4);
50                   mySqlCommand.Parameters.Add("@firstname", SqlDbType.NVarChar, 50);
51                   mySqlCommand.Parameters.Add("@lastname", SqlDbType.NVarChar, 50);
52   
53   
54                   mySqlCommand.Parameters["@candidate_id"].Value = myDataRow["ID"];
55                   mySqlCommand.Parameters["@firstname"].Value = myDataRow["firstname"];
56                   mySqlCommand.Parameters["@lastname"].Value = myDataRow["lastname"];
57   
58   
59   
60                   mySqlConnection.Open();
61                    mySqlCommand.ExecuteNonQuery();
62   
63                   mySqlConnection.Close();
64                   
65                  
66           }
67   
68   
69   
70