Click here to Skip to main content
15,898,222 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: how to encrypt a query string value Pin
keyur satyadev26-Feb-09 22:30
keyur satyadev26-Feb-09 22:30 
QuestionCrystal Report problem Pin
Mogaambo26-Feb-09 19:12
Mogaambo26-Feb-09 19:12 
AnswerRe: Crystal Report problem Pin
Abhishek Sur26-Feb-09 21:35
professionalAbhishek Sur26-Feb-09 21:35 
QuestionInsert Runtime Row in Gridview Control Pin
Vishal0926-Feb-09 18:35
Vishal0926-Feb-09 18:35 
AnswerRe: Insert Runtime Row in Gridview Control Pin
N a v a n e e t h26-Feb-09 18:51
N a v a n e e t h26-Feb-09 18:51 
Questiontest Pin
Member 464259126-Feb-09 17:31
Member 464259126-Feb-09 17:31 
AnswerRe: test Pin
Christian Graus26-Feb-09 17:55
protectorChristian Graus26-Feb-09 17:55 
Questionhow insert datatable to storedprocedure Pin
amit sahu2026-Feb-09 17:30
amit sahu2026-Feb-09 17:30 
hi..
i have a DataTable dt width data
Id Price
1 250
2 200
3 300

DataSet ds = new DataSet();
ds.Tables.Add(dt);
XmlDataDocument x = new XmlDataDocument(ds); 


and a procedure in sql server 2005
create procedure Sproc_Select_Xml(@x xml) 
AS
BEGIN
DECLARE @data TABLE(Id bigint,Price numeric)
INSERT INTO @data(Id,Price)
SELECT xmlVals.rowvals.query('Id').value('.','bigint'),
       xmlVals.rowvals.query('Price').value('.','numeric')
FROM   @x.nodes('/ds/dt') as xmlVals(rowvals)
SELECT * FROM @data  
END


when i pass xml document to proc
i get the error

System.ArgumentException: No mapping exists from object type System.Xml.XmlDataDocument to a known managed provider native type.
AnswerRe: how insert datatable to storedprocedure Pin
Christian Graus26-Feb-09 17:57
protectorChristian Graus26-Feb-09 17:57 
GeneralRe: how insert datatable to storedprocedure Pin
amit sahu2026-Feb-09 18:41
amit sahu2026-Feb-09 18:41 
QuestionGridview in UpdatePanel (AJAX) Pin
Lash2026-Feb-09 13:19
Lash2026-Feb-09 13:19 
AnswerRe: Gridview in UpdatePanel (AJAX) Pin
sarang_k26-Feb-09 16:38
sarang_k26-Feb-09 16:38 
GeneralRe: Gridview in UpdatePanel (AJAX) Pin
Lash2027-Feb-09 3:39
Lash2027-Feb-09 3:39 
GeneralRe: Gridview in UpdatePanel (AJAX) Pin
Lash2027-Feb-09 5:28
Lash2027-Feb-09 5:28 
Questionprojects that is developed using microsoft office sharepoint Pin
valli rajya lakshmi26-Feb-09 9:58
valli rajya lakshmi26-Feb-09 9:58 
AnswerRe: projects that is developed using microsoft office sharepoint Pin
led mike26-Feb-09 10:07
led mike26-Feb-09 10:07 
GeneralRe: projects that is developed using microsoft office sharepoint Pin
Jim Crafton26-Feb-09 11:07
Jim Crafton26-Feb-09 11:07 
QuestionLooking for ASP.NET web toolkit databind to image sqlserver Pin
John Schuster26-Feb-09 8:32
John Schuster26-Feb-09 8:32 
AnswerRe: Looking for ASP.NET web toolkit databind to image sqlserver Pin
Christian Graus26-Feb-09 8:46
protectorChristian Graus26-Feb-09 8:46 
QuestionDataKey from a gridview Pin
Malayil alex26-Feb-09 8:04
Malayil alex26-Feb-09 8:04 
AnswerRe: DataKey from a gridview Pin
ToddHileHoffer26-Feb-09 9:16
ToddHileHoffer26-Feb-09 9:16 
GeneralRe: DataKey from a gridview Pin
Malayil alex26-Feb-09 9:46
Malayil alex26-Feb-09 9:46 
GeneralRe: DataKey from a gridview Pin
ToddHileHoffer26-Feb-09 10:17
ToddHileHoffer26-Feb-09 10:17 
GeneralRe: DataKey from a gridview Pin
Malayil alex26-Feb-09 12:21
Malayil alex26-Feb-09 12:21 
GeneralRe: DataKey from a gridview Pin
ToddHileHoffer26-Feb-09 13:17
ToddHileHoffer26-Feb-09 13:17 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.