ASP.NET

USE [iLOS]
GO
[dbo].[sp_InsertData] Script Date: SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[sp_InsertData]
(@xmlString VARCHAR(MAX))
AS
BEGIN
/* Initialize a handle for the XmlDocument */ 
DECLARE @xmlHandle INT 
/* 
Create a table variable to store the extract XmlData into Relational 
Database Format. Unlike temporary tables, Table variables are 
automatically removed from memory by SQL Server when the procedure 
has completed. So, there is no need to try and drop them at the 
end of the procedure. 
*/ 
DECLARE @stagingTable TABLE 
( 
[Name] VARCHAR(50), 
[Address] VARCHAR(50), 
[Phone] VARCHAR(50)
) 
/* 
Create the XmlDocument using the handle above and the Xml 
string as parameters. If your stored procedure has an varchar input 
parameter named @xmlString, it would look like this instead: 
EXEC sp_xml_preparedocument @xmlHandle output,@xmlString 
*/ 
EXEC sp_xml_preparedocument @xmlHandle output, @xmlString 
/* 
Use the OPENXML method to query the XmlDocument starting at 
/NewDataSet/SampleDataTable node.
*/ 
INSERT INTO @stagingTable 
SELECT [Name] ,
[Address],
[Phone] 
FROM OPENXML (@xmlHandle, '/NewDataSet/SampleDataTable',1) 
WITH ([Name] varchar(50) '@Name', 
[Address] varchar(50) '@Address', 
[Phone] varchar(50) '@Phone'
)

/*Insert the records into the table variable turning the XML structured 
data into relational data. We are now free to query the table variable 
just as if it were a regular table for use with data manipulation, cursors, etc... 
It could also be used for generated reports and counts in ways that might 
be simpler to code in SQL Server vs XSL.*/ 
INSERT INTO SampleData ([Name], 
[Address], 
[Phone]) 
(SELECT [Name] ,
[Address],
[Phone]
FROM @stagingTable)


/* Remove the document from memory */ 
EXEC sp_xml_removedocument @xmlHandle
END

lbs.allies wrote:

I have two windows forms

sharmilajv wrote:

I have to send mail automatically,mail should have my design

sharmilajv wrote:

and contents change dynamically ?

//Button ClickEvent
//You Can Embe Your Code Like This
 protected void ChangeBackColor(object sender, EventArgs e)
            {
                Literal1.Text = " bgcolor='" + dropStatic.SelectedValue + "'";
                litText.Text = "<div style='background-color:white;color:#000000'>Literl Control is powerful</div>";

//you Can Send Your Email 
            }

sharmilajv wrote:

While Sending mail i

nagendrathecoder wrote:

This is a repost. I already suggested this to him but he didn't replied back.

ksss_maheshece wrote:

.Even though i increase my connection time out

Sujit Mandal wrote:

make pooling="false"