public static void GetStudentById(int studentID) { using (OleDbConnection connection = new OleDbConnection (@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Students.mdb;Persist Security Info=True")) { connection.Open(); using (OleDbCommand command = connection.CreateCommand()) { command.CommandType = CommandType.StoredProcedure; command.CommandText = "GetStudentById"; command.Parameters.AddWithValue("@studentID", studentID); OleDbDataAdapter adapter = new OleDbDataAdapter(command); adapter.TableMappings.Add("Table", "Students"); StudentsDataSet dataset = new StudentsDataSet(); adapter.Fill(dataset); DataSetDump.ShowDSInOutputWindow(dataset); } }
Wednesday, May 1, 2013
sql command
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment