Combobox and Database

Question

Hi!!!!!
I am making a window application in Visual Studio2008 using MS Access database .
On form i am having 3 combos for class,section,subject respectively. And there is a textbox and button by which we could add student for any particular class-section-subject combination selected from combos.
Kindly help me in this....................

Kirtan Patel · Answer

Here is Answer to your problem check "Do you like this answer" check box if it helps you :) private void btnAddToDatabase_Click( object sender, EventArgs e) { OleDbConnection con = new OleDbConnection ( "Connection String Here" ); con.Open(); OleDbCommand comm = new OleDbCommand ( "insert into Students(name,class,section,subject) v alues(@name,@class,@section,@subject)" , con); comm.Parameters.AddWithValue( "@name" , txtName.Text); comm.Parameters.AddWithValue( "@class" , ClasscomboBox.SelectedItem.ToString()); comm.Parameters.AddWithValue( "@section" , SectioncomboBox.SelectedItem.ToString()); comm.Parameters.AddWithValue( "@subject" , SubjectcomboBox.SelectedItem.ToString()); con.Close(); }

Srinivas Kotra · Answer

hi, use like this OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\db1.mdb"); string stroledb="insert into Student_Registration values('"+ cmbClass.Text+"','"+cmbSection.Text+"')"; OleDbCommand aCommand = new OleDbCommand(stroledb, con); aCommand.Connection.Open(); aCommand.ExecuteNonQuery(); aCommand.Connection.Close();