Click here to Skip to main content
15,881,803 members
Home / Discussions / XML / XSL
   

XML / XSL

 
Generallink in xsl Pin
x-trate10-Jan-05 6:04
x-trate10-Jan-05 6:04 
GeneralRe: link in xsl Pin
DavidNohejl10-Jan-05 8:22
DavidNohejl10-Jan-05 8:22 
GeneralHelp with XML Pin
dotnetquery9-Jan-05 18:07
dotnetquery9-Jan-05 18:07 
GeneralWebservices Pin
rgoyal7-Jan-05 18:21
rgoyal7-Jan-05 18:21 
GeneralUsing XML to develop portal. Pin
ruthra30-Dec-04 21:22
ruthra30-Dec-04 21:22 
GeneralRe: Using XML to develop portal. Pin
DavidNohejl31-Dec-04 0:48
DavidNohejl31-Dec-04 0:48 
Generala little OT: SVGViewer and WinXP SP2 Pin
fuel2run29-Dec-04 22:04
fuel2run29-Dec-04 22:04 
GeneralWebservice question Pin
steve_rm29-Dec-04 5:12
steve_rm29-Dec-04 5:12 
Hello,

I am trying to create a webservice that will enable me to retrieve rows from a database in sql. I would like the service to return the datatable filled with the records. So that the consumer can display in a datagrid. But l am not sure if l am going about it correctly.

This is my code below.

[WebMethod (Description="This will get retrieve customers' orders")]<br />
		public DataTable RetrieveOrders()<br />
		{<br />
			SqlConnection cnn = new SqlConnection("Server = Steves-pc; Database = northwind; Integrated Security = yes");<br />
			cnn.Open();<br />
			SqlDataAdapter da = new SqlDataAdapter();<br />
			SqlCommand cmd = new SqlCommand();<br />
			DataTable dt = new DataTable("Orders");<br />
		<br />
			string getOrders = "SELECT OrderID,CustomerID,ShipName,ShipCountry FROM Orders";<br />
			cmd = cnn.CreateCommand();<br />
			cmd.CommandType = CommandType.Text;<br />
			cmd.CommandText = getOrders;<br />
			da.SelectCommand = cmd;<br />
<br />
			dt.Clear();<br />
			da.Fill(dt);<br />
<br />
			cnn.Close();<br />
<br />
			return dt;				<br />
		}

Many thanks in advance,

Steve
GeneralRe: Webservice question Pin
Javier Lozano1-Jan-05 13:57
Javier Lozano1-Jan-05 13:57 
GeneralRead any Xml schema file and write it on a xml file with data's automatically written according to their appropriate datatypes using c# Pin
dhol28-Dec-04 23:53
dhol28-Dec-04 23:53 
GeneralXML to develop portal. Pin
ruthra28-Dec-04 15:30
ruthra28-Dec-04 15:30 
GeneralXPath navigation with namespaces Pin
Steven Campbell28-Dec-04 9:32
Steven Campbell28-Dec-04 9:32 
GeneralRe: XPath navigation with namespaces Pin
DavidNohejl28-Dec-04 10:16
DavidNohejl28-Dec-04 10:16 
GeneralRe: XPath navigation with namespaces Pin
Steven Campbell28-Dec-04 12:33
Steven Campbell28-Dec-04 12:33 
GeneralRe: XPath navigation with namespaces Pin
DavidNohejl28-Dec-04 13:04
DavidNohejl28-Dec-04 13:04 
GeneralRe: XPath navigation with namespaces Pin
DavidNohejl28-Dec-04 13:15
DavidNohejl28-Dec-04 13:15 
GeneralRe: XPath navigation with namespaces Pin
Steven Campbell30-Dec-04 4:44
Steven Campbell30-Dec-04 4:44 
GeneralXML validation through XSD Pin
Het210927-Dec-04 23:00
Het210927-Dec-04 23:00 
GeneralRe: XML validation through XSD Pin
DavidNohejl28-Dec-04 9:05
DavidNohejl28-Dec-04 9:05 
GeneralRe: XML validation through XSD Pin
Het210931-Dec-04 21:48
Het210931-Dec-04 21:48 
GeneralW3C XML standards Pin
Nosheen Iqbal21-Dec-04 16:20
Nosheen Iqbal21-Dec-04 16:20 
GeneralI want XML to draw the network topology Pin
Mohammed Aijaz Mohiuddin21-Dec-04 6:00
Mohammed Aijaz Mohiuddin21-Dec-04 6:00 
GeneralRe: I want XML to draw the network topology Pin
DavidNohejl21-Dec-04 8:29
DavidNohejl21-Dec-04 8:29 
GeneralSkip blocks of nodes with XSL Pin
Milby00720-Dec-04 0:22
Milby00720-Dec-04 0:22 
GeneralRe: Skip blocks of nodes with XSL Pin
Milby00720-Dec-04 3:13
Milby00720-Dec-04 3:13 

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.