<div>
pass as xml parameter to Sp and use sp_xml_preparedocument sp to insert xml values to Tabel 
(see sample code) 

<pre><code class="code-10 nolinks" id="code-163947">C# code building Xml parameter
---------------
 
System.Xml.XmlDocument objXMLDocument = null;
System.Xml.XmlElement objXMLElement = null;
System.Xml.XmlElement objXMLChildElement = null;
 
//Bulding XML Document for Statistical Ranges
objXMLDocument = new System.Xml.XmlDocument();
objXMLDocument.LoadXml(&quot;&lt;root/&gt;&quot;);
 
objXMLElement = objXMLDocument.DocumentElement;
 
foreach (string sItem in listBox1.SelectedItems)
{
	objXMLChildElement = objXMLDocument.CreateElement(&quot;packagemaster&quot;);
	objXMLChildElement.SetAttribute(&quot;Pkey&quot; , sItem);
	objXMLElement.AppendChild(objXMLChildElement);
}
 
// pass objXMLDocument.OuterXml to Sp parameter
insertcommand.parameters.add(&quot;@vchXMLParms&quot; , sqldbtype.varchar , 8000).value = objXMLDocument.OuterXml;	 
 
 
sample Sp
---------
 
 
ALTER proc InsertSp(@vchXMLParms VARCHAR(MAX))
AS
 
DECLARE @xmldocHandle AS INT
EXEC sp_xml_preparedocument @xmldocHandle OUTPUT, @vchXMLParms
 
 insert into YourTableName(packagemaster)
 SELECT Pkey FROM OPENXML(@xmldocHandle, '/root/packagemaster', 1)WITH(Pkey VARCHAR(MAX))
 
EXEC sp_xml_removedocument @xmldocHandle
</code></pre>
</div>

<div>
im using using sql server 2005 as DB...could u tell me d solution in c# coding
</div>

<div>
<div class="content wysiwyg-content">
insertcommand.parameters.add(&quot;@packagemaster&quot;,sqldbtype.varchar,500).value=selectedlist.items; 
 
here insertcommand is stored procedure,selected list is list box,packagemaster is column name 
 
when i try to insert multiple list items in to pakagemaster column using items property &nbsp;it was not working.....so suggest me &nbsp;to handle this situation
</div>
</div>

insertcommand.parameters.add("@packagemaster",sqldbtype.varchar,500).value=selectedlist.items;

here insertcommand is stored procedure,selected list is list box,packagemaster is column name

when i try to insert multiple list items in to pakagemaster column using items property  it was not working.....so suggest me  to handle this situation

unable to insert multiple listbox items in to database

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications