|
Anyone any experience of outputting a nested set model (to an XML
structure using Microsoft SQL Server? Would like to read in as a stream using ExecuteXmlReader.
For details on Nested Set Model, see the chapter in JOE CELKO'S SQL FOR SMARTIES (Morgan-Kaufmann, 1999, second edition)
http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci537290,00.html
http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci801943,00.html
> For example using the following table and TSQL I can extract an
> employee and their subordinates.
>
> Personnel
> emp lft rgt
> ======================
> 'Albert' 1 12
> 'Bert' 2 3
> 'Chuck' 4 11
> 'Donna' 5 6
> 'Eddie' 7 8
> 'Fred' 9 10
Example XML output:
<root>
<node emp="Albert">
<node emp="Bert"/>
<node emp="Chuck">
<node emp="Donna"/>
<node emp="Eddie"/>
<node emp="Fred"/>
</node>
</node>
</root>
This works, but isnt an XML stream:
SELECT xml1.xmltext
FROM
(SELECT lft, xmltext = '<node emp="' + emp + '">' FROM Personnel
UNION ALL SELECT rgt, xmltext = '</node>' FROM Personnel) AS xml1
ORDER BY xml1.lft
-- Ingram Leedy
|
|
|
|
|
Hi,
I am using the following code to read a exel file from a AS.NET page , but its not working.
Pls help...
string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=D:\\Documents\\EServer\\ProjectCodes.xls;"
+"Extended Properties=Excel 8.0;";
//You must use the $ after the object you reference in the spreadsheet
OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn);
DataSet myDataSet = new DataSet();
myCommand.Fill(myDataSet, "ProjectCodes");// This line is giving the error !
DataGrid1.DataSource = myDataSet.Tables"ProjectCodes"].DefaultView;
DataGrid1.DataBind();
|
|
|
|
|
What is the error message? Also, you have an extra bracket in the second to last line (DataGrid1.DataSource). Is that a problem?
|
|
|
|
|
I Use the following from VC++, I hope that will be the same:
strConnection = _T("Driver={Microsoft Excel Driver (*.xls)};DriverId=790;"
"Dbq=C:\\DatabasePath\\DBSpreadSheet.xls;DefaultDir=c:\\databasepath;");
If you prefer to use Ole DB you connection srting is correct...
Where you recibe an error?
Regards
Carlos Antollini.
Sonork ID 100.10529 cantollini
|
|
|
|
|
Hi,
I am using the following code to read a exel file from a AS.NET page , but its not working.
Pls help...
string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=D:\\Documents\\EServer\\ProjectCodes.xls;"
+"Extended Properties=Excel 8.0;";
//You must use the $ after the object you reference in the spreadsheet
OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn);
DataSet myDataSet = new DataSet();
myCommand.Fill(myDataSet, "ProjectCodes");// This line is giving the error !
DataGrid1.DataSource = myDataSet.Tables"ProjectCodes"].DefaultView;
DataGrid1.DataBind();
|
|
|
|
|
Well I am in need of a MDX function parser and do not want to reinvent the wheel.
anyone know where I can find one?
|
|
|
|
|
HI all....
Can u help me in this,
I have MS Office 2000 installed with all options. I want to setup a database using the MS-Access, to access the database for my ASP applications. What should I do?
Mine is Windows 2000 professional.
Thanks in advance,
SPS
|
|
|
|
|
1. Look at some articles right here on codeproject
2. read a book
3. search the web.
Signature space for rent. Apply by email to....
|
|
|
|
|
Great help and good idea. Wont forget this forever.
Happy day.....
|
|
|
|
|
SPS wrote:
What should I do?
I agree with what Jon wrote as you will only understand more as you read, so I thought this article[^] will show you an example to go off of.
HTH
Nick Parker
The goal of Computer Science is to build something that will last at least until we've finished building it. - Unknown
|
|
|
|
|
Thanks a lot. But I am need need to configure my ODBC driver. I guess, I know what to do after getting the ODBC connected.
Anyway, thanks for the help indeed.
|
|
|
|
|
Nick Parker wrote:
so I thought this article[^] will show you an example to go off of.
Thats the exact same article that got me started with using databases from ASP
James
Sig code stolen from David Wulff
|
|
|
|
|
Will give a try at that.... Thanks.........
|
|
|
|
|
James T. Johnson wrote:
"So, if you are interested in watching the rate of hair loss, are you going to hook up a callback to each follicle?
Personally, I'd rather just hook up the comb, and let it tell me when a hair gets stuck in there. Any interesting information I need about why the little deserter abandoned post I can get from the hair itself as a member of the HairLossEventArg type.
Interestingly, my hair loss is a result of inheritance, which I can also use to extend my hair... What's up with that?"
Ed Stegman on event granularity
Ed sounds like he read a little too much into Chris Sells .NET Delegates: A C# Bedtime Story[^] article.
Nick Parker
The goal of Computer Science is to build something that will last at least until we've finished building it. - Unknown
|
|
|
|
|
|
I've seen it's simple enough to write ADO.NET applications in .NET.
But, how do I write them in ADO with plain Win32 API???
NO MFC!!!!!!
NO MFC!!!!!!
NO MFC!!!!!!
NO MFC!!!!!!
Tell me a good book or tutorial about ADO programming with C++ in plain Win32 API
Bye!
Rickard Andersson@Suza Computing
C# and C++ programmer from SWEDEN!
UIN: 50302279
E-Mail: nikado@pc.nu
Speciality: I love C#, ASP.NET and C++!
|
|
|
|
|
Rickard,
I know you don't want to use MFC, but you could take a look at Carlos Antollini's article[^] on ADO access.
Nick Parker
The goal of Computer Science is to build something that will last at least until we've finished building it. - Unknown
|
|
|
|
|
|
Hi,
First I would like to complement you on your exellant to tutorials and articles, I'm new at database programing and they are a great resource!! However, I do have a small problem, I'm attempting to use your datacontainer and dbio to make a web based program that will enter marketing info into a database. However, It wouldn't work, so I steped throught the code and found the error was my sql statement. However, the statement looks fine to me and I was hoping you could share some insite.
Thanks,
John
Code:
private void Summit_Click(object sender, System.EventArgs e)
{
RegisterUser(TextBox2.Text,TextBox1.Text,TextBox3.Text,TextBox4.Text,TextBox5.Text);
Response.Redirect("Thanks.aspx");
}
private void RegisterUser(string Name, string Where, string Os,string Occ,string Air)
{
DataContainer dc=new DataContainer(); dc.Set("Name", Name);
dc.Set("Where", Where);
dc.Set("Os", Os); dc.Set("Occ",Occ);
dc.Set("Air",Air);
DBIO dbio=new DBIO(dc); dbio.Execute("sql_SurveyAddEntry");
}
SQL Statement:
<add key="sql_SurveyAddEntry" value="insert into SURVEY (AIR,NAME,OCC,OS,WHERE) values ('{Air}','{Name}','{Occ}','{Os}','{Where}')">
|
|
|
|
|
I must say, seeing my name at the top of the "question time" section REALLY got my attention. Anyways, the SQL statement got chopped off in your message post. Why don't you send me an email directly to:
webmaster@knowledgeautomation.com
Thanks!
Marc
|
|
|
|
|
Not sure if I should reply, since i'm not Marc Clifton.
But,
insert into SURVEY (AIR,NAME,OCC,OS,WHERE) values ('{Air}','{Name}','{Occ}','{Os}','{Where}')
NAME and WHERE are reserved keyword in most SQL implementations. You should avoid using them for column names.
However,
insert into SURVEY ([AIR],[NAME],[OCC],[OS],[WHERE]) values ('{Air}','{Name}','{Occ}','{Os}','{Where}')
ought to do the trick.
Signature space for rent. Apply by email to....
|
|
|
|
|
Thanks for the reply, I tried and I still had no luck any other ideas??
|
|
|
|
|
Can Anyone tell me how to call Stored Procedures in DAO
Samir Sood
|
|
|
|
|
|
I am writing SQL statements for MS Access 2000 and SQL server 7.0. In MS Access 2000, Dates have to be enclosed with #, like WHERE (datefield=#10/3/2002#). But SQL Server doesn't like that. I have to use WHERE (datefield=10/3/2002). Is there any way to write the queries so they work in both programs?
BTW. I am using ADO, but not ADO.NET.
|
|
|
|
|