insert using checkedlistbox

Question

i need to insert multiple items using checkedlistbox in c# and sql 2005.please give code and insert sp

Dipankar Biswas · Answer

example of with out sp.... Sqlconnection con=new Sqlconnection(); con.open(); con.Connectionstring=Data Source=PHANNY-PC\PHANNY; Initial Catalog=db_stuRegisterPay; Integrated Security=SSPI; string query=insert into Persons_info(perID latinName gender dob pob phone passport curAdd status) values(' + txtID.Text + '' + txtLatinName.Text + '' + cbGender.Text + ' + dTPdob.Text + txtPob.Text + '' + txtPhone.Text + '' + txtPassport.Text + ' + txtCurAdd.Text + ' + cbStatus.Text +  ); SqlCommand cmd=new SqlCommand(querycon); cmd.ExecuteNonQuery(); MessageBox.show(Saving is done!); Now your sp in sql..example. GO CREATE PROCEDURE dbo.sp_Students_INS_byPK @student_id INT  @password VARCHAR(15) = NULL  @active_flg TINYINT  @lastname VARCHAR(30) = NULL  @birth_dttm DATETIME = NULL  @gpa INT = NULL  @is_on_staff TINYINT AS BEGIN SET NOCOUNT ON INSERT INTO dbo.Students ( student_id  password  active_flg  lastname  birth_dttm  gpa  is_on_staff ) VALUES ( @student_id  @password  @active_flg  @lastname  @birth_dttm  @gpa  @is_on_staff ) END GO C# Code.........example.. try { sqlConnection = new SqlConnection(dbConnectionString); SqlCommand command = new SqlCommand(sp_Test sqlConnection); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(@Id SqlDbType.VarChar).Value = txtId.Text; command.Parameters.Add(@Name SqlDbType.DateTime).Value = txtName.Text; sqlConnection.Open(); return command.ExecuteNonQuery(); sqlConnection.Close(); } catch (SqlException ex) { Console.WriteLine(SQL Error + ex.Message.ToString()); return 0; } you are use checkbox.... so only change... command.Parameters.Add(@Id SqlDbType.VarChar).Value = checkbox1.Text;

Ankur Jain · Answer

Hi! code for get selected item from checkbox list and save using store procedure... for (int i = 0; i { if (chkList1.Items[i].Selected == true) { rightSelectedItems = rightSelectedItems + chkList1.Items[i].Value + ; } } now you can pass rightSelectedItems as parameter in your procedure... create procedure sp_insertCheckboxItem @Item nvarchar(250)=null as begin transcation insert into tablename (columnname) values(@item) commit; end please don't forget to mark it as answer if it's helpful