|
Hello
I have written SQL query which returns data in XML form
now i want to catch this data in my C# code
Iam using a dataset
after catching this data i want to upload it in DOM
or an abject of type XmlDocument.
Please tell me the steps
the xml data is of this form
< m attr1="1" attr2="00">< /m>< n attr1="1">< /n>
< m attr1="1" attr2="00">< /m>< n attr1="1">< /n>
< m attr1="1" attr2="00">< /m>< n attr1="1">< /n>
that means there is no root element and tag names
are repeated
Thanks,
Sana
-- modified at 1:49 Friday 11th August, 2006
|
|
|
|
|
Salam
Example:
System.Data.SqlClient.SqlConnection conn = newSystem.Data.SqlClient.SqlConnection("server=pc1;database=northwind;trusted_connection=true");
System.Data.SqlClient.SqlCommand cmd =
new System.Data.SqlClient.SqlCommand("SELECT * FROM Customers For XML Auto", conn);
conn.Open();
System.Xml.XmlReader reader = cmd.ExecuteXmlReader();
while (reader.Read())
{
System.Xml.XmlDocument xmldoc = new System.Xml.XmlDocument();
xmldoc.Load(reader);
}
|
|
|
|
|
Sorry! Previous example was incorrect.
System.Data.SqlClient.SqlConnection conn =
new System.Data.SqlClient.SqlConnection("server=pc1;database=northwind;trusted_connection=true");
System.Data.SqlClient.SqlCommand cmd =
new System.Data.SqlClient.SqlCommand("SELECT * FROM Customers For XML Auto", conn);
conn.Open();
System.Xml.XmlReader reader = cmd.ExecuteXmlReader();
System.Xml.XmlDocument xmldoc =
new System.Xml.XmlDocument();
xmldoc.Load(reader);
conn.Close();
|
|
|
|
|
Hi all,
i am working as a software eng..let know that how to read values from a text file at specified location which the file consists of no of lines of code...moreover i want to code in c#.net
for example..
1
23.34
2
456.33
---
i want to read values below 1 n 2 as x,y values...so plz let me know how to do..
Thanks in advance...
Regards,
cnr..
-- modified at 1:26 Friday 11th August, 2006
|
|
|
|
|
Just discard any lines you don't want, I assume you want to read in the alternate lines. In this case something like which follows should work.
using (StreamReader sr = new StreamReader(filename))
{
while(sr.Peek() != -1)
{
sr.ReadLine();
string line = sr.ReadLine();
}
sr.Close();
}
Formula 1 - Short for "F1 Racing" - named after the standard "help" key in Windows, it's a sport where participants desperately search through software help files trying to find actual documentation. It's tedious and somewhat cruel, most matches ending in a draw as no participant is able to find anything helpful. - Shog9
Ed
|
|
|
|
|
XML or ini files ?
The way you do it is not readable for any other programmer, if anyone want to edit your code or has to take over your project, they will have a hard time to learn what that file stands for ...
In XML or ini you can at least comment (in your code, or in the text file itself).
Don't you also love the code?
|
|
|
|
|
I'm busy with my app installer, so what I did was include the msde with the installer. Now what I need to do is check whether the sql services are running and attach the database to the instance.
So I started creating a console app to help with the command line arguments, but I don't know how to execute commands with the console app.
Any help will be appreciated.
Thanx in advance
He who laughs last is a bit on the slow side
|
|
|
|
|
What do you mean by 'execute commands' ?
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Thanx for the reply, I think I found an answer to my question, only problem is that all the examples I get is in VB, I tried to do my own translation to C# but it doesn't work, I you can maybe have a look a bit up at my last post.
Many thanx
He who laughs last is a bit on the slow side
|
|
|
|
|
Why did you start a new thread when it is obviously a continuation of this?
|
|
|
|
|
I thought it being more with the issue of the translation from vb to c# I'll put it under a new heading.
He who laughs last is a bit on the slow side
|
|
|
|
|
NeroToxic wrote: I don't know how to execute commands with the console app
If you mean "SQL Commands" then you execute them in exactly the same way you would in any other applications. You just cannot use the wizard to write the code for you.
|
|
|
|
|
I want to take the value from one page to another page:
In my maker page i used datagrid and i hv to take that dg's row value (through., DataRowView) i transfered that value to nxt page:
Here in ItemDataBound event i wrote the coding for get the values to the DG's Row..
here i retrieve the value frm the DAtaRowView in a variable in a name as temp.
In ItemCommand Event i wroth that Response.Redirect("Models.aspx")
Now this temp value also transfer to that Models Page.., I tried the QueryString
like: Response.Redirect("Makers1.aspx?val="+temp); but its in Item Command event., but
that value in ItemDataBound Command so., It assigns only null value to that one..,
Here i can't use session also...
How can we solve this one...?
T.Prabu
|
|
|
|
|
You can set the command argument to get the value in itemcommand event.
BTW better you put this into asp.net forum there you will get more responses.
Best Regards,
Apurva Kaushal
|
|
|
|
|
Hi Apurva.,
Thanks for ur suggestion.,
I couldn't get clear with ur answer .,
Anyway thanks for ur effort.,
I vl post this in a ASP.net Forum..
Prabu.T
|
|
|
|
|
I have a windows form that has a bindingnavigator that binds several bound textboxes, datepickers etc. Works great .
What I want to do is display the contents of a text file that is related to each record bound by the above. For example, if record 23 of 50 is currently in view then the contents of 23.txt are displayed in the textbox.
How do I go about that?
Thanks,
Glen Harvy
|
|
|
|
|
private void btnADD_Click(object sender, EventArgs e)
{
DataRow newRow = dataTable.NewRow();
DateTime login = this.timePicLogin.Value;
DateTime logout = this.timePicLogOut.Value;
TimeSpan ts = logout - login;
this.tbTotalLog.Text = ts.ToString();
newRow["LogIn"] = timePicLogin.Text;
newRow["LogOut"] = timePicLogOut.Text;
newRow["TotalLog"] = tbTotalLog.Text;
newRow["Activity"] = rtActivities.Text;
newRow["Date"] = DateTime.Today.ToShortDateString();
dataTable.Rows.Add(newRow);
ShowLB();
try
{
dataAdapter.Update(dataSet, "ActivityReport");
dataSet.AcceptChanges();
Application.DoEvents();
}
catch (OleDbException ex)
{
MessageBox.Show(ex.Message);
dataSet.RejectChanges();
}
FillLB();
}
private void FillLB()
{
string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0; User Id=; Password=; Data Source=C:\\Documents and Settings\\arnold\\My Documents\\db1.mdb";
string strCommand = "Select * from ActivityReport";
dataAdapter = new OleDbDataAdapter(strCommand, strConnection);
dataSet = new DataSet();
dataAdapter.Fill(dataSet, "ActivityReport");
OleDbCommandBuilder bldr = new OleDbCommandBuilder(dataAdapter);
dataAdapter.UpdateCommand = bldr.GetUpdateCommand();
dataAdapter.DeleteCommand = bldr.GetDeleteCommand();
dataAdapter.InsertCommand = bldr.GetInsertCommand();
dataTable = dataSet.Tables[0];
ShowLB();
}
private void ShowLB()
{
lbDate.Items.Clear();
foreach (DataRow dataRow in dataTable.Rows)
{
lbDate.Items.Add(dataRow["Date"]);
}
}
im catching an error: "syntax error INSERT INTO statement"
tnx.
|
|
|
|
|
It's probably stemming from the SELECT statement. It's bad practice to use a * to denote which fields you want from the table. Start be rewriting the SELECT statement to specify which fields you want, including the Primary Key.
SELECT keyfield, field1, field2, field3 FROM ActivityReport
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
is there a label control that can support bold or different color on the same line. by using tags like in HTML?
sample:
This is a test for bold and this for color
i want to implement this without using richtextbox
can anyone please help
-- modified at 5:34 Friday 11th August, 2006
|
|
|
|
|
As far as I know there is not such a control. You could, however, write this yourself fairly easily. One approach is to derive a class from Control. Your Text property would contain the text with any meta tags that you would define. In your OnPaint method you would render your text with colors, fonts, etc. based on any meta tags you may have.
I hope this helps.
-- modified at 22:48 Thursday 10th August, 2006
-- modified at 22:48 Thursday 10th August, 2006
Deus caritas est
|
|
|
|
|
thanks for replying Andy
as i am new to c# i dont have the idea how to do it or where to start
can you please point me to an article how to check for the tags and implement the rendering of text using the OnPaint method.
|
|
|
|
|
There are copious articles at CodeProject and on the web that explain how to draw custom controls in C#. Look at the Graphics class for drawing on a control's surface.
Deus caritas est
|
|
|
|
|
|
Hi I have a few questions to ask,
1. whats the difference between finalize() and dispose() method
2. why below code performs poorly and if i have to write a good code how the below code should be
static string Space (string s)
{
string s2 = "";
foreach (char c in s)
{
s2 += c;
s2 += " ";
}
return s2;
}
3. why following code fails,
int a = 5;
int b = 5;
object oa = a;
object ob = b;
Debug.Assert(oa == ob, "oa is not equal ob");
ans. is that because we cant assign == for an object.
4. The following code is being executed in a highly threaded environment.
1. Why does the Debug.Assert statement sometimes fail?
2. What can be done to stop this from occurring?
public class Warehouse
{
private int stockCount = 0;
public void DecrementStock ()
{
if ( stockCount > 0 )
stockCount--;
Debug.Assert ( stockCount >= 0 )
}
public void IncrementStock()
{
stockCount ++;
}
}
thanks in advance.
|
|
|
|
|
oh I could pass this test! (Wait, I did ACE this test)
A man said to the universe:
"Sir I exist!"
"However," replied the Universe, "The fact has not created in me A sense of obligation."
-- Stephen Crane
|
|
|
|