Re: Fill DataSet with two tables - C# Discussion Boards

stancrm30-Jul-09 3:07

30-Jul-09 3:07

DataTable table1 = new DataTable();
DataTable table2 = new DataTable();

DataSet dataSet = new DataSet();
dataSet.Tables.Add(table1);
dataSet.Tables.Add(table2);

Re: Fill DataSet with two tables

Rahul DSG30-Jul-09 3:16

Rahul DSG

30-Jul-09 3:16

the code is like this..
SqlCommand cmd;
SqlConnection conn;
SqlDataAdapter sda;
conn = new SqlConnection("server=Sai2; database=Inventory; uid=sa; pwd=123456;");
cmd = conn.CreateCommand();
cmd.CommandText = "select * from stock";
sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
DataS.Stock ds = new SisInventorySystem.DataS.Stock();
sda.Fill(ds, "stock");
Crystal_Reports.TotalStockRpt TtlStkRpt = new SisInventorySystem.Crystal_Reports.TotalStockRpt();
TtlStkRpt.SetDataSource(ds);
crystalReportViewer1.ReportSource = TtlStkRpt;
crystalReportViewer1.DisplayToolbar = true;

Now i have to run one more Query "select * from Company" having nothing in common between table company and stock.

Re: Fill DataSet with two tables

Robin_Roy30-Jul-09 17:11

Robin_Roy

30-Jul-09 17:11

You can write a stored procedure that returns multiple recordset and get the resultset directly mapped with a dataset, it will create the same number of datatables in your dataset as the count of resultset in your procedure...

Re: Fill DataSet with two tables

Mike Ellison30-Jul-09 3:12

Mike Ellison

30-Jul-09 3:12

DataAdapter.Fill perhaps? If you're using SQL Server for your database, you can call a stored procedure that returns two result sets - each will be filled in the dataset as a separate DataTable. The stored procedure is simple:

CREATE PROCEDURE Sample
AS
BEGIN
  select * from table1;
  select * from table2;
END

MishaInTheCloud.blogspot.com

Re: Fill DataSet with two tables

Rahul DSG30-Jul-09 19:24

Rahul DSG

30-Jul-09 19:24

ok...
and after what to write...
da.fill(ds,"whichtable");
can i write the both table....

Re: Fill DataSet with two tables

Mike Ellison3-Aug-09 6:44

Mike Ellison

3-Aug-09 6:44

Access the tables through the DataSet's Tables collection:

DataTable dt0 = ds.Tables[0]; // first result set from the batch queries
DataTable dt1 = ds.Tables[1];  // second result set from the batch queries

MishaInTheCloud.blogspot.com

Re: Fill DataSet with two tables

Rahul DSG3-Aug-09 20:09

Rahul DSG

3-Aug-09 20:09

Done All the things but can not Solved ...
sda.fill(ds,"Table name Is Must.")
Is there any Solution...

Re: Fill DataSet with two tables

Mike Ellison4-Aug-09 2:44

Mike Ellison

4-Aug-09 2:44

Why is the table name a must upon filling? You can always change the table name (if you really need to) after filling the set like this:

sda.Fill(ds);
ds.Tables[0].TableName = "tableNameIsAMust.";
ds.Tables[1].TableName = "somethingElse";

Or is it that you are looking to execute two queries separately (instead of together in one batch)? In that case, you could supply separate table names upon filling:

da1.Fill(ds, "Table1");
da2.Fill(ds, "Table2");

I'm having difficulty understanding exactly why this is problematic for you. Can you explain?

www.MishaInTheCloud.com

Re: Fill DataSet with two tables

Rahul DSG6-Aug-09 18:14

Rahul DSG

6-Aug-09 18:14

Actually I have to make a crystal report which needs two table nothing is common in between these two tables.i tried all these suggestion in this section but not working...i already posted my code...

Re: Fill DataSet with two tables

PIEBALDconsult30-Jul-09 4:23

PIEBALDconsult

30-Jul-09 4:23

With SQL Server:

"SELECT * FROM Table1 ; SELECT * FROM Table2"

(Other database engines don't allow multiple statements in a command.)

closin a form in application hangs the application or closes the applcn

Vivek Vijayan30-Jul-09 2:48

Vivek Vijayan

30-Jul-09 2:48

closin a form in application hangs the application or closes the applcn
i m doin a mobile application how can i close the form in the middle of running when a condition is met
i want to navigate to another form when a condition is met
this.close() and this.dispose is not working.

if (str.Equals("stop"))

{

//form shud be closed and navigate to another form

}

This code was posted by me...

a performance problem

reilak30-Jul-09 2:37

reilak

30-Jul-09 2:37

Hi all...
I'm writing a program that passes on an XML file and present it on a treeView.
For some reason the application preform the task vary slow: for a 440K XML file the application needs a full minute and a half to present the tree!!, now I have a good computer and other XML readers I use read the 440K file in a second, so it's probably something I do wrong, I just don't know what.

here is the function that passes on the XML file and adds tree nodes.

private void AddNodesToTree(XmlNode currentXMLNode, TreeNode currentTreeNode)
{

    // Loop through the XML nodes until the leaf is reached.
    // Add the nodes to the TreeView during the looping process.
    if (currentXMLNode.HasChildNodes == true)
    {
        XmlNodeList XMLChildNodeList = currentXMLNode.ChildNodes;
        XmlNode XMLChildNode;
        TreeNode TreeChildNode;
        int NodeIndex = 0;

        for (int i = 0; i < XMLChildNodeList.Count; i++)
        {
            if ((XMLChildNodeList.Item(i).GetType().ToString() != "System.Xml.XmlComment") && 
                (XMLChildNodeList.Item(i).GetType().ToString() != "System.Xml.XmlText"))
            {
                XMLChildNode = currentXMLNode.ChildNodes[i];

                if (XMLChildNode.Attributes.Count != 0)
                {
                   currentTreeNode.Nodes.Add(XMLChildNode.Attributes.Item(0).InnerText);
                }
                else
                {
                   currentTreeNode.Nodes.Add(XMLChildNode.Name);
                }

                TreeChildNode = currentTreeNode.Nodes[NodeIndex];
                NodeIndex++;
                AddNodesToTree(XMLChildNode, TreeChildNode);
            }
        }
    }
    else
    {
        // Here you need to pull the data from the XmlNode based on the
        // type of node, whether attribute values are required, and so forth.
        currentTreeNode.Text = (currentXMLNode.OuterXml).Trim();
    }
}

Thanks, Jimmy

Re: a performance problem

Nagy Vilmos30-Jul-09 4:07

Nagy Vilmos

30-Jul-09 4:07

Suspend updating the display, that is your big cost. Use SuspendLayout() before you start adding nodes and then ResumeLayout(true) at the end.

Panic, Chaos, Destruction.
My work here is done.

Re: a performance problem

reilak30-Jul-09 4:27

reilak

30-Jul-09 4:27

): doesn't work... still it takes a lot of time.
I've added SuspendLayout() just before I call the AddNodesToTree() for the first time, ResumeLayout(true) after that.

maybe it is the treeView?
I'm using XmlDocument to read the file and XmlNode/List.

Re: a performance problem

Nagy Vilmos30-Jul-09 4:32

Nagy Vilmos

30-Jul-09 4:32

Check Piebald's comments and also move the SuspendLayout() and ResumeLayout(true) outside the loop. You are still refreshing the display for EVERY node you add.

Panic, Chaos, Destruction.
My work here is done.

Re: a performance problem

reilak30-Jul-09 4:37

reilak

30-Jul-09 4:37

<code>SuspendLayout()</code> and ResumeLayout(true) are out of the loop.

Re: a performance problem

PIEBALDconsult30-Jul-09 4:26

PIEBALDconsult

30-Jul-09 4:26

Also, don't use XMLChildNodeList.Item(i).GetType().ToString() != "System.Xml.XmlComment"; look into the is operator.

Re: a performance problem (UPDATE)

reilak30-Jul-09 4:33

reilak

30-Jul-09 4:33

I commented the lines where I build the tree in the function, so now the function only travels in the file. Also when the function ends (completely) I pop up a Message Box, and it took exactly a second for the application to pop up the message, so it's probably the way I build the tree.

Re: a performance problem (UPDATE)

Luc Pattyn30-Jul-09 13:50

Luc Pattyn

30-Jul-09 13:50

that is the way to go: split it up in smaller pieces, so you can see which one takes too much time.
alternatively, add logging code, where each message shows time in milliseconds, as with DateTime.Now.ToString("HH:mm:ss.fff")

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

Re: a performance problem, (check this out)

reilak1-Aug-09 22:16

reilak

1-Aug-09 22:16

Hi all, still haven't find the downer...
but I encourage you all to try this tutorial, which is actually the base of my source code: How to populate a TreeView control with XML data
This is a Microsoft tutorial, really short and simple - just copy and paste. Try loading a large XML file (440K and above), if anyone has insights I would love to hear!

Converting HTML File to Excel File and XML File using c# Code

shavil30-Jul-09 2:35

shavil

30-Jul-09 2:35

Hi,

Can any one suggest me how to convert HTML file to Excel and Pdf .

In C# Code only

I have html file i want 2 generate that file to Excel and PDF

Re: Converting HTML File to Excel File and XML File using c# Code

Mike Ellison30-Jul-09 2:57

Mike Ellison

30-Jul-09 2:57

There's a lot of different approaches.

You could use an XSLT transformation, assuming the HTML is well-formed. (example: http://ewbi.blogs.com/develops/2005/01/create_excels_s.html[^]). For pdf's, you'd probably be converting to XSL-FO, then using a converter to pdf (example and information: http://html2fo.sourceforge.net/[^]; http://www.ibm.com/developerworks/library/x-xslfo2app/[^])

You could use 3rd party components to do the creation/conversion.
(XL example: http://www.gemboxsoftware.com/GBSpreadsheetFree.htm[^]; pdf example: 100% .NET component for rendering PDF documents[^])

You could try a more targeted programmatic approach to create the output directly, if you didn't need a full-featured 3rd party component. Try a Google search for something like "html to excel c#" for a bunch of examples.

You could also, at least for the XL side, use interop. (example: http://support.microsoft.com/kb/302084[^])

I think the approach you use ultimately depends on the specifics of your situation, and how much complexity in the excel/pdf document you need to support.

MishaInTheCloud.blogspot.com

Double click custom controls

Jon Henry30-Jul-09 2:27

Jon Henry

30-Jul-09 2:27

Im writing a simple control to use in my app. It consists of a button with two labels on it, each displaying different data.

Heres my problem:

When I use the control in my app, I have to click twice on the labels to trigger the click event of the control while clicking on a part of the button with no label on it works correctly. I assume the way to handle this is to tie the labels click events to the controls click event. I have managed to setup properties correctly to alter label text and color and what not but how do I go about linking the click events"

Thanks,
Jon

Re: Double click custom controls

Mike Ellison30-Jul-09 2:36

Mike Ellison

30-Jul-09 2:36

I'm guessing then that the purpose of the two labels are to display some kind of relevant data that is refreshed upon clicking the button?

If that is the case, it might be considered a better UI strategy to have the two labels above the button rather than on it, and the button labeled "Refresh".

But if you are intent on keeping other controls on top of your button, then yes, you could simply have the label click handler and the button click handler each call the same code method.

MishaInTheCloud.blogspot.com

Re: Double click custom controls

Jon Henry30-Jul-09 12:20

Jon Henry

30-Jul-09 12:20

Actually no, the data on the labels doesnt change once it is set. The button is for music, the top label is the song title and the bottom is the album name. When the user clicks anywhere on the button(including on the labels), the song should loaded into the queue to be played.

Problem is when the user clicks on a part of the button with a label, they have to click twice in order to trigger the load.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.