insert using checkedlistbox

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.

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

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

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;

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dipankar Biswas12y ago
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 Jain12y ago
Hi!

code for get selected item from checkbox list and save using store procedure...

for (int i = 0; i < chkList1.Items.Count; 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