envoyer les données vers la base

Bonjour tous le monde,

j'ai un formulaire de réclamation, et je veux envoyer les données vers ma base, mais ça ne marche pas!
après l'exécution, il n'y a aucun message d'erreur, mais quand je vérifie ma base je ne trouve aucune insertion dans ma table !

Quelqu'un pourrait m'aider s'il vous plait! c'est très urgent!

ma table:

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
CREATE TABLE Incident(
Id_Incident NUMERIC(18) Identity(1,1),
Login_Creation varchar(50),
Login_Assigned varchar(50),
Id_Type int,
Id_Priorite int,
Objet varchar(20),
Description varchar(200),
CONSTRAINT pkIncident primary key (Id_Incident), 
CONSTRAINT fkType foreign key (Id_Type) REFERENCES TI_Type(Id_Type),
CONSTRAINT fkPriorite foreign key (Id_Priorite) REFERENCES TI_Priorite(Id_Priorite),
CONSTRAINT fkLogin_creation foreign key (Login_Creation) REFERENCES Utilisateur(Login),
CONSTRAINT fkLogin_assigned foreign key (Login_Assigned) REFERENCES Utilisateur(Login));

voilà le code de ma procédure stockée:

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
Create Procedure Insert_Incident(@Login_Creation varchar(50),
 								@Login_Assigned varchar(50),
								@Id_Type int,
								@Id_Priorite int,
								@Objet varchar(50),
								@Description varchar(50),
								@Date_Etat date
								)
 
as
 
BEGIN
 
Insert into Incident (Login_Creation, Login_Assigned,Id_Type,Id_Priorite,Objet,Description) 
 
values(@Login_Creation,@Login_Assigned,@Id_Type,@Id_Priorite,@Objet,@Description)	
 
END

le code C#

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
using System;
using System.Collections.Generic;
using System.Web.UI.WebControls;
using System.ComponentModel;
using System.Data.SqlClient;
using System.Drawing;
using System.Web.UI;
using System.Data;
using System.Text;
using System.Linq;
using System.Web;
using System.Net;
using System.Configuration;
 
namespace AddUser
{
    public partial class NewIncident : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
 
        }
 
        public static DataSet AjoutIncident(String Login_Creation,String Login_Assigned,int Id_Type,int Id_Priorite,String Objet,String Description)
        {
            SqlParameter[] AttributTab = new SqlParameter[] 
		    {
                new SqlParameter("@Login_Creation",Login_Creation),
 				new SqlParameter("@Login_Assigned",Login_Assigned),
				new SqlParameter("@Type",Id_Type),
                new SqlParameter("@Priorite",Id_Priorite),
				new SqlParameter("@Objet",Objet),
				new SqlParameter("@Description",Description),
				//new SqlParameter("@Date_Etat",Date_Etat)
            };
 
            DataSet ds = new DataSet();
            SqlConnection connexion;
            try
            {
                connexion = new SqlConnection("Server=.\\SQLExpress;Database=test1008;Trusted_Connection = True;");
                connexion.Open();
 
                SqlCommand cmd = new SqlCommand("Insert_Incident", connexion);
                //verifier la procedure stockée!
 
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.AddRange(AttributTab);
                cmd.CommandTimeout = 3600;
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                da.Fill(ds);
            }
            catch (Exception x)
            {
                string ex = x.Message;
            }
            return ds;
        }
 
 
 
        protected void Button1_Click(object sender, EventArgs e)
        {
            AjoutIncident("admin1","admin1",int.Parse(DropDownList1.SelectedValue),int.Parse(DropDownList2.SelectedValue),TextBox1.Text,TextBox2.Text);
        }
    }
}

et ceci le code de mon formulaire :

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
<%@ Page Title="" Language="C#" MasterPageFile="~/master.Master" AutoEventWireup="true" CodeBehind="NewIncident.aspx.cs" Inherits="AddUser.NewIncident" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
<H2>&nbsp;</H2>
    <H2><u>Nouveau Incident</u></H2>
<FORM  NAME="Nouveau_Incident" style="width: 564px">
<br />
<br />
Type : 
&nbsp;&nbsp;<asp:DropDownList ID="DropDownList1" runat="server">
    <asp:ListItem Value="1">Bug</asp:ListItem>
    <asp:ListItem Value="2">Probleme General</asp:ListItem>
</asp:DropDownList>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Priorité : 
<asp:DropDownList ID="DropDownList2" runat="server">
    <asp:ListItem Value="1">Basse</asp:ListItem>
    <asp:ListItem Value="2">Normale</asp:ListItem>
    <asp:ListItem Value="3">Haute</asp:ListItem>
    <asp:ListItem Value="4">Urgent</asp:ListItem>
    <asp:ListItem Value="5">Immediate</asp:ListItem>
</asp:DropDownList>
<br />
<br />
Objet :&nbsp;
<asp:TextBox ID="TextBox1" runat="server" Width="378px"></asp:TextBox>
    <P>
 
        Description : <br>
&nbsp;<asp:TextBox ID="TextBox2" runat="server" Height="197px" TextMode="MultiLine" 
        Width="422px"></asp:TextBox>
<P>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    <asp:Button ID="Button1" runat="server" onclick="Button1_Click" 
        Text="Valider" />
<P>
        &nbsp;<p>
</FORM >
</asp:Content>