do while loop while accessing data from database

Question

0.00/5 (No votes)

See more:

can we two different readers in two nested while loops

the code is below and m use c#.net and ms access

string conn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=ui.mdb";
          OleDbConnection connst = new OleDbConnection(conn);
          connst.Open();
          string str = "select * from Tabs ";




          OleDbCommand cmd = new OleDbCommand(str, connst);

          OleDbDataReader DataReader = cmd.ExecuteReader();
     while (DataReader.Read())
          {

              TabID = Convert.ToInt32(DataReader[0]);
              TabName = DataReader[1].ToString();
              TabCaption = DataReader[2].ToString();
              TabHome = RibbonBar.InsertTab(TabID, TabCaption);
              TabHome.Id = TabID;

              OleDbDataReader ReadGroup;
              do
              {
                  string str1 = "select * from Groups where Tab_ID=" + TabID;
                  OleDbCommand CmdGroup = new OleDbCommand(str1, connst);

                  ReadGroup = CmdGroup.ExecuteReader();
                  ReadGroup.Read();
                  Console.WriteLine(ReadGroup.HasRows);
              }


              while (ReadGroup.Read());
              {
                  GroupID = Convert.ToInt32(ReadGroup[0]);
                  GroupName = ReadGroup[1].ToString();
                  GroupCaption = ReadGroup[2].ToString();
                  Tests = TabHome.Groups.AddGroup(GroupCaption, GroupID);

                  //for (int k = j; k <= i; k++)
                  //{
                  string str2 = "select * from Items where Group_id=0";
                  OleDbCommand CmdControls = new OleDbCommand(str2, connst);
                  OleDbDataReader ReadControl = cmd.ExecuteReader();
                  while (ReadControl.Read())
                  {
                      ControlID = Convert.ToInt32(ReadControl[0]);
                      ControlName = ReadControl[1].ToString();
                      XtremeCommandBars.XTPControlType typ = (XtremeCommandBars.XTPControlType)ControlID;
                      Tests.Add(typ, ControlID, ControlName, false, false);
                      Console.WriteLine(XtremeCommandBars.XTPControlType.xtpControlButton.GetTypeCode());
                      int lm;
                      lm = Convert.ToInt32(typ.GetTypeCode());

                  }
              }
                //}
          }

Posted 7-Feb-10 17:42pm

sharmarun

Updated 7-Feb-10 22:59pm

Christian Graus

v3

Add a Solution

4 solutions

Solution 2

Please format your code properly; use the "code block" button and make sure the entire code block is within the <pre></pre> tags. You can check it after you do this with the "Quick Preview" tab.

Posted 7-Feb-10 22:57pm

Richard MacCutchan

Solution 3

I don't see any reason for this not to work. I assume you think it's not working, so perhaps you need to tell us what doesn't work, what you expect it to do, what you've learned through debugging the code, etc.

The braces around GroupID = Convert.ToInt32(ReadGroup[0]); down to the ReadControl.Read() loop, make the code hard to read, because you have a while statment above them and it takes a second to realise it's attached to a do. The braces add nothing and hurt readability, I'd lose them.

Posted 7-Feb-10 23:01pm

Christian Graus

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Christian Graus · Accepted Answer · 2010-02-07T17:46:00

Solution 1

Sure - knock yourself out.

If you want a more detailed answer, post your code, tell us what language you're using ( is it VBScript or not ? ), and explain what you're trying to do, and where it's going wrong.

Posted 7-Feb-10 17:46pm

Christian Graus

Eddy Vluggen · Accepted Answer · 2010-02-07T23:37:00

cshuhh wrote:
can we two different readers in two nested while loops

That wouldn't be possible according to the documentation;

MSDN states:
While the SqlDataReader is being used, the associated SqlConnection is busy serving the SqlDataReader, and no other operations can be performed on the SqlConnection other than closing it. This is the case until the Close method of the SqlDataReader is called.

.

The alternative would be to replace one of the readers with a DataSet, or to open a second connection.