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(query,con); 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

insert using checkedlistbox

Answers (2)