About GetXml() function in C#.Net

[manivelk]

Hi to all

I am developing a C# Dot new application. Now i got a problem i dont kow how to pass my GetXml() function value to my stored procedure. If any one know the answer please help me out.

Thanks in advance.

Regards,
Manivel. K

[rrocket]

Hi to all

I am developing a C# Dot new application. Now i got a problem i dont kow how to pass my GetXml() function value to my stored procedure. If any one know the answer please help me out.

Thanks in advance.

Regards,
Manivel. K

Send what you have so far as it will give me a better idea of what you are trying to do. You should be able to return a value from the GetXML() function, store it in a variable, and pass it like anything else to your SP.

[manivelk]

Hi,

Thanks for your reply. Here i nave attached my code behind statements. i call the GetXml() fumection in this.. Now i want to know how to pass this to my SP. How to convert this dataset to a SP parameter..

DataSet dataSet = new DataSet("dataSe t");
DataTable table = dataSet.Tables. Add("Searching" );
table.Columns.A dd("ProjectPhas e", typeof(string)) ;
table.Columns.A dd("LessonsLear nt", typeof(string)) ;
table.Columns.A dd("ProjectName ", typeof(string)) ;
table.Columns.A dd("Technology" , typeof(string)) ;
table.Columns.A dd("ProjectLead er", typeof(string)) ;

DataRow row;
for (int i = 0; i < 30; i++)
{
row = table.NewRow();
row["ProjectPha se"] = "ProjectPha se";
row["LessonsLea rnt"] = "LessonsLearnt" ;
row["ProjectNam e"] = "ProjectNam e";
row["Technology "] = "Technology ";
row["ProjectLea der"] = "ProjectLeader" ;
table.Rows.Add( row);
}

dataSet.GetXml( );


Please inform me.. and how to handle this xml function inside my SP. Plzmhelp me out..