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
|
SqlConnection sqlconn = new SqlConnection();
try
{
string connString = String.Format("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\XMLProg2.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");
sqlconn = new SqlConnection(connString);
SqlCommand cmd = new SqlCommand("CREATE TABLE XMLFiles6 (NAME varchar(50) NOT NULL,DESCRIPTION varchar(50) NULL,TYPE varchar(50) NULL,MIN varchar(50) NULL,MAX varchar(50) NULL,FEATURE varchar(50) NULL, STORAGE varchar(50) NULL,FILES varchar(50) NULL,CONSTRAINT PK_XMLFiles2 PRIMARY KEY CLUSTERED (NAME ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY];", sqlconn);
String CommandText = "INSERT INTO XMLFiles6 VALUES ('ACM', 'REAL', '0', '100', 'PROUT', 'CACA', 'RECACA', 'RERECACA');";
DataSet ds = new DataSet("XMLFiles6");
//SqlDataAdapter dacmd;
// ouvrir la connexionsqlConnection1.Open();
sqlconn.Open();
SqlDataAdapter dacmd = new SqlDataAdapter(cmd);
//dacmd.Fill(ds);
cmd.ExecuteNonQuery();
// Fermeture de la connexionsqlConnection1.Close();
SqlDataAdapter dataAdapter = new SqlDataAdapter(CommandText, sqlconn);
dataAdapter.Fill(ds, "XMLFiles6");
//sqlconn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(new Form1());
sqlconn.Close(); |
Partager