Comments by PriyaRajavelu (Top 4 by date)

yes i have used the datatable concept.

var dataTable = new DataTable();
dataTable.Columns.Add("itmes");

for (int i = 0; i < listBox1.Items.Count; i++)
{
dataTable.Rows.Add(listBox1.Items[i].ToString());
}


using (SqlConnection ocon = new SqlConnection("Data Source=172.19.44.21;Initial Catalog=sample;Persist Security Info=True;User ID=sa;Password=saa"))
{
SqlCommand cmd = new SqlCommand("InsertItems", ocon);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter tvparam = cmd.Parameters.AddWithValue("@dt", dataTable);
tvparam.SqlDbType = SqlDbType.Structured;
ocon.Open();
cmd.ExecuteNonQuery();
ocon.Close();
}

i created userdefined table type:

CREATE TYPE [dbo].[MYDATATABLE12] AS TABLE(
[Items] [varchar](10) NULL
)
GO

and used sp like:

Create PROCEDURE [dbo].[InsertItems]
@dt AS dbo.MYDATATABLE READONLY
AS
BEGIN
SET NOCOUNT ON;

INSERT dbo.Items(Item) SELECT Items FROM @dt;
END

NOTE:
but i go for sql server 2005 this is not possible(Datatable)