Voici le code que j'ai testé :
private void buttonTest_Click(object sender, RoutedEventArgs e)
{
Create();
System.Windows.Forms.MessageBox.Show("Créée");
test();
test2();
Drop();
System.Windows.Forms.MessageBox.Show("Supprimée");
}
private void Create()
{
string req = @"CREATE TABLE #t1
(
tn nvarchar(64),
qname nvarchar(150),
ttname nvarchar(150)
)";
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = req;
cmd.ExecuteNonQuery();
req = @"CREATE TABLE #t2
(
tn nvarchar(64),
body nvarchar(max)
)";
cmd = con.CreateCommand();
cmd.CommandText = req;
cmd.ExecuteNonQuery();
}
private void Drop()
{
string req = @"DROP table #t1";
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = req;
cmd.ExecuteNonQuery();
req = @"DROP table #t2";
cmd = con.CreateCommand();
cmd.CommandText = req;
cmd.ExecuteNonQuery();
}
private void test()
{
string req = CreateRequest();
SqlDataAdapter da = new SqlDataAdapter();
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = req;
cmd.Parameters.AddWithValue("@date1", Convert.ToDateTime(datePicker1.Text));
cmd.Parameters.AddWithValue("@date2", Convert.ToDateTime(datePicker2.Text).AddDays(1));
cmd.Parameters.AddWithValue("@nom1", Convert.ToString(comboBoxClient1.SelectedValue));
cmd.Parameters.AddWithValue("@nom2", Convert.ToString(comboBoxClient2.SelectedValue));
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds);
foreach (DataRow dr in ds.Tables[0].Rows)
{
req = @"INSERT INTO #t1 (tn, qname, ttname) values ('" + Convert.ToString(dr["tn"]) + "', '" + Convert.ToString(dr["qname"]) + "', '" + Convert.ToString(dr["ttname"]) + "')";
cmd.CommandText = req;
cmd.ExecuteNonQuery();
}
}
private void test2()
{
string req2 = CreateRequestBodyOpen();
SqlDataAdapter da2 = new SqlDataAdapter();
SqlCommand cmd2 = con.CreateCommand();
cmd2.CommandText = req2;
cmd2.Parameters.AddWithValue("@date1", Convert.ToDateTime(datePicker1.Text));
cmd2.Parameters.AddWithValue("@date2", Convert.ToDateTime(datePicker2.Text).AddDays(1));
cmd2.Parameters.AddWithValue("@nom1", Convert.ToString(comboBoxClient1.SelectedValue));
cmd2.Parameters.AddWithValue("@nom2", Convert.ToString(comboBoxClient2.SelectedValue));
da2.SelectCommand = cmd2;
DataSet ds2 = new DataSet();
da2.Fill(ds2);
foreach (DataRow dr in ds2.Tables[0].Rows)
{
req2 = @"INSERT INTO #t2 (tn, body) values (@tn, @bodyOpen)";
cmd2.CommandText = req2;
cmd2.Parameters.AddWithValue("@tn", Convert.ToString(dr["tn"]));
cmd2.Parameters.AddWithValue("@bodyOpen", Convert.ToString(dr["bodyOpen"]));
cmd2.ExecuteNonQuery();
}
}
J'obtiens une erreur lors des insert que je fais dans la table2 :
The variable name '@bodyOpen' has already been declared. Variable names must be unique within a query batch or stored procedure.
Je n'utilise mon @bodyOpen a un seul endroit.
Avez vous une idée?
Merci
