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(nameclasssectionsubject) 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();