|
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
DECLARE @xmlHandle INT
DECLARE @stagingTable TABLE
(
[Name] VARCHAR(50),
[Address] VARCHAR(50),
[Phone] VARCHAR(50)
)
EXEC sp_xml_preparedocument @xmlHandle output, @xmlString
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 INTO SampleData ([Name],
[Address],
[Phone])
(SELECT [Name] ,
[Address],
[Phone]
FROM @stagingTable)
EXEC sp_xml_removedocument @xmlHandle
END
hi first insert all records in som xml file and thn use above sp i think it might work in your case..
modified on Monday, October 12, 2009 4:38 AM
|
|
|
|
|
While You Are Replying Use Code Block So It will be more clear..!
|
|
|
|
|
I have two windows forms and I need to get the changing mouse position at the same time in the next form. I am using a function in the mouse move event ,so how should i properly do that..pls help me
|
|
|
|
|
Wrong forum.
You can have a public event handler for mouse move in your first form which you can handle in the second form to get the mouse positions.
It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD
|
|
|
|
|
lbs.allies wrote: I have two windows forms
Then why are you asking this question in ASP.NET Forum ?
|
|
|
|
|
I have to send mail automatically,mail should have my design and contents change dynamically ?
|
|
|
|
|
sharmilajv wrote: I have to send mail automatically,mail should have my design
Try to search in Google You Will find Toms of examples for seneding mail..!
sharmilajv wrote: and contents change dynamically ?
Wat Abt This..!What are the contents You Want to change dynamically..!You want to chance it By Code or Web.config file Please be more clear..!
|
|
|
|
|
|
Then Wat Is The Problem In That..!
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>";
}
|
|
|
|
|
While Sending mail i want to give (body)content from five Different Literal controls how to do that?
|
|
|
|
|
Really I didnt Get Your Question..!
I am Confused ..!
Plz Read the General Guideline Before Posting a question...!
sharmilajv wrote: While Sending mail i
Is It After Sending Mail..!
Be More Clear ..!
Then Group May Help..!
First
http://www.w3schools.com/ASPNET/control_literal.asp[^]
|
|
|
|
|
Hi friends,
I'm facing SqlTime out error in My web Application.Even though i increase my connection time out,it still showing error.
I've restarted my Sql services but it's working for 1 hr then time out Repeated.
I checked each connection I've used.it was closed properly.
What may be the error?
Thanks&Regards,
Mahez
Confused
|
|
|
|
|
Did you tried by debug your code ? Set breakpoint and try to debug. check there is any black spot in your code or not.
|
|
|
|
|
I bet he is not going to do that.
This is a repost. I already suggested this to him but he didn't replied back.
|
|
|
|
|
nagendrathecoder wrote: This is a repost. I already suggested this to him but he didn't replied back.
Ohh..Sorry ! I didn't noticed that.
Yes, rather than starting a new thread for same question it always helpful if he replied on the earlier post. But I don't know why.....
|
|
|
|
|
I've replied that Q but it's went back,therefore ive created a new thread.
Here I need to run a job.
This job has procedure to execute.This taking too much of time.
Now only it's happening but not before.
Thanks
Mahesh
|
|
|
|
|
I've tried to debug my code(Sql prcocedure).it replies the same even after the Timeout error.
|
|
|
|
|
ksss_maheshece wrote: .Even though i increase my connection time out
First things first Check You Connection string..!
SomeTime Connection String MAy be the problem..!
Clear Your Application pool..!Or If it is local Restart Your IIS..!
|
|
|
|
|
make pooling="false"
it will solve the prb.
Thanks and Regards
Sujit Kr. Mandal
|
|
|
|
|
Sujit Mandal wrote: make pooling="false"
IMO May Be Thts a Bad Idea..!
|
|
|
|
|
|
I am still learning about ASP.NET.
I have read many articles on the Internet about how ASP.NET creates hidden field __EVENTARGUMENT and __EVENTTARGET. I am using VS2005, ASP.NET 2005 (I suspect w/VS2005) and C#.
I create the simplest test web site with one Button as a server control and an OnClick handler. I examine the source it generates in Internet Explorer. I see NO __EVENTARGUMENT and __EVENTTARGET fields in the HTML source. Where are they?
There is an __EVENTVALIDATION field. If I use the EnableEventValidtion="false" then it disappears. But never do I see the __EVENTARGUMENT and __EVENTTARGET in the HTML.
What is going on?
Thanks!
Mark
|
|
|
|
|
You're asking the wrong questions. If all you've done is create a page with a button then you need to spend time learning stuff like the page lifecycle, and how to use viewstate, etc. You don't need to worry about if a hidden field you read about is there or not, who cares ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
I find this response very curious.
I have read many, many articles about viewstate and page lifecycle. About init phase, page load phase etc. I am writing a fairly involved application in which I am creating some dynamic controls. It works well to a point and then some simple OnClicks just stop working.
I have struggled for quite a while trying to explain this. At this point, I was wondering why I see no _EVENTTARGET and __EVENTARGUMENT fields, like some many articles tell me to expect. Maybe this is a symptom of a large problem??
It amazes me how so many times respondees on this forum must point out how little the poster knows.
Sorry to imply I know so little about ASP.NET. I guess I actually know more than I implied.
Could somebody be kind enough to address my original question?
Thanks,
Mark
|
|
|
|
|
MarkMokris wrote: It amazes me how so many times respondees on this forum must point out how little the poster knows.
As you say, you told me you were new to ASP.NET. I just believed you.
MarkMokris wrote: . I am writing a fairly involved application in which I am creating some dynamic controls. It works well to a point and then some simple OnClicks just stop working.
OK, so THIS is the real question ? Your original post said 'I made a page with a button and cannot see a field in the page that I read about online'. Your original post and this one, are basically unrelated.
How are you creating dynamic controls ? The reason for an event to not work, is that your controls are created too late OR your control tree changes, both of which will mean that viewstate is not restored because the control tree is not identical before page_load.
FWIW CP uses ASP.NET and I just searched the source of this page for the fields you mention. Instead of looking for random things based on your online reading, you should focus on your actual problem, which is viewstate not being restored, from the sound of it.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|