How do i use select for xml?
strSQL = "SELECT id, fname,lname FROM tbl1 FOR XML path('')"
Comm = New SqlCommand(strSQL, Con)
Comm.CommandType = CommandType.Text
Comm.ExecuteNonQuery()
Hello gus,
I have a database (sql server 2005) .
Data are store on table in binary data (doc, pdf, xls files)
How do i restore thoes files from SQL Server?
Hello,
How to get the null value from the xml node.
Pls. modify the following code to get null value.
Imports System.Xml
Module Module1
Sub Main()
Dim reader As XmlTextReader = New XmlTextReader("bb.xml")
Do While (reader.Read())
Select Case reader.NodeType...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.