1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
| public DataTable ListTarifs(Int64 id_appel)
{
SqlConnection conn = null;
SqlCommand command = new SqlCommand();
DataTable dt = new DataTable();
conn = new SqlConnection();
String strConnection = @"Data Source=.\SQLEXPRESS;Initial Catalog=Taxation;Persist Security Info=True;User Id=sa;Password=root";
conn.ConnectionString = strConnection;
conn.Open();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "TarifsAppel";
command.Connection = conn;
SqlParameter num = null;
num = new SqlParameter("@appel", SqlDbType.BigInt, 8);
num.Direction = ParameterDirection.Input;
num.Value = id_appel;
command.Parameters.Add(num);
SqlDataAdapter da = new SqlDataAdapter(command);
da.FillSchema(dt, SchemaType.Source);
da.Fill(dt);
conn.Close();
return dt;
} |
