How to get the XML from the SQL Store Procedure

[shilpareddy2787]

Hello,

I am developing an application. In which I have to generate html output using a xml. I am getting the xml from sproc. Now I am not getting how to get that returned xml from store procedure in my c# application. can any one please help me

Thanks

[Frinavale]

What have you tried so far?

[shweta123]

Hi,

You can define the output parameter in your c# code for getting the xml from stored procedure.
e.g.

   //define command object
            OleDbCommand com = new OleDbCommand();
            OleDbParameter p1 = new OleDbParameter();
            p1.DbType = OleDbType.VarChar;
            p1.Name = parameter name;
            p1.Size = 4000;
            //set the direction of the parameter as OUTPUT in order to get the returned xml from stored procedure
            p1.Direction = ParameterDirection.Output;
 
            //set the properties of command object
            com.CommandText = "";
            com.CommandType = CommandType.StoredProcedure;
            com.Connection = con;
            com.Parameters.Add(p1);
 
            //execute the stored procedure
            com.ExecuteNonQuery();
 

Hello,

I am developing an application. In which I have to generate html output using a xml. I am getting the xml from sproc. Now I am not getting how to get that returned xml from store procedure in my c# application. can any one please help me

Thanks

[Plater]

Do you just an XML version of the result table?
DataTable objects have the WriteXML() function you could use.