Click here to Skip to main content
14,977,673 members
Home / Discussions / C#
   

C#

 
GeneralRe: How to create a tree node with menu, submenu, child, item Pin
Samiul0710-Jun-19 3:35
MemberSamiul0710-Jun-19 3:35 
GeneralRe: How to create a tree node with menu, submenu, child, item Pin
OriginalGriff10-Jun-19 3:50
mveOriginalGriff10-Jun-19 3:50 
GeneralRe: How to create a tree node with menu, submenu, child, item Pin
#realJSOP10-Jun-19 5:00
mva#realJSOP10-Jun-19 5:00 
GeneralRe: How to create a tree node with menu, submenu, child, item Pin
Gerry Schmitz10-Jun-19 5:47
mveGerry Schmitz10-Jun-19 5:47 
AnswerRe: How to create a tree node with menu, submenu, child, item Pin
BillWoodruff9-Jun-19 15:22
mveBillWoodruff9-Jun-19 15:22 
GeneralRe: How to create a tree node with menu, submenu, child, item Pin
Samiul0710-Jun-19 0:21
MemberSamiul0710-Jun-19 0:21 
GeneralRe: How to create a tree node with menu, submenu, child, item Pin
BillWoodruff10-Jun-19 1:27
mveBillWoodruff10-Jun-19 1:27 
GeneralRe: How to create a tree node with menu, submenu, child, item Pin
Samiul0710-Jun-19 3:19
MemberSamiul0710-Jun-19 3:19 
I imported from excel using OleDb. now I can't be shorting data. this code now I'm trying..

string stringconn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + tbxSelect.Text + ";Extended Properties=\"Excel 8.0;HDR=Yes;\";";
            OleDbConnection conn = new OleDbConnection(stringconn);
            if (tbxSelect.Text != "")
            {
                OleDbDataAdapter da = new OleDbDataAdapter("Select * from [" + tbxChoice.Text + "$]", conn);
                DataTable dt = new DataTable();
                //DataSet dt = new DataSet();
                dt.Clear();
                da.Fill(dt);
                //dataGridView1.DataSource = dt;

                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    string firstRow = dt.Rows[i]["A"].ToString();
                    if (firstRow != "")
                    {
                        cmbRow1.Items.Add(firstRow);

                        if (!firstRow.Equals(Row1))
                        {
                            //essageBox.Show(firstRow);
                            RowIndex_1++;
                            //Menu{ firstRow, RowIndex_1 };
                        }
                        Row1 = firstRow;
                    }
                    MessageBox.Show(i.ToString(),RowIndex_1.ToString());
                }


                for (int j = 0; j < dt.Rows.Count; j++)
                {
                    string secondRow = dt.Rows[j]["B"].ToString();

                    if (secondRow != "")
                    {
                        cmbRow2.Items.Add(secondRow);
                        if (!secondRow.Equals(Row2))
                        {
                            //essageBox.Show(firstRow);
                            RowIndex_2++;

                            //Menu{ firstRow, RowIndex_1 };
                        }
                        Row2 = secondRow;
                    }
                    MessageBox.Show(j.ToString(), RowIndex_2.ToString());
                }

                for (int k = 0; k < dt.Rows.Count; k++)
                {
                    string secondRow = dt.Rows[k]["C"].ToString();

                    if (secondRow != "")
                        cmbRow3.Items.Add(secondRow);
                }

                for (int l = 0; l < dt.Rows.Count; l++)
                {
                    string secondRow = dt.Rows[l]["D"].ToString();

                    if (secondRow != "")
                        cmbRow4.Items.Add(secondRow);
                }

                for (int m = 0; m < dt.Rows.Count; m++)
                {
                    string secondRow = dt.Rows[m]["E"].ToString();

                    if (secondRow != "") ;
                        //cmbRow5.Items.Add(secondRow);
                }

                MessageBox.Show((dt.Rows.Count).ToString());
                conn.Close();
            }
            else
                MessageBox.Show("Er");

GeneralRe: How to create a tree node with menu, submenu, child, item Pin
OriginalGriff10-Jun-19 3:45
mveOriginalGriff10-Jun-19 3:45 
GeneralRe: How to create a tree node with menu, submenu, child, item Pin
BillWoodruff10-Jun-19 6:59
mveBillWoodruff10-Jun-19 6:59 
GeneralRe: How to create a tree node with menu, submenu, child, item Pin
Samiul0710-Jun-19 12:27
MemberSamiul0710-Jun-19 12:27 
GeneralRe: How to create a tree node with menu, submenu, child, item Pin
Samiul0710-Jun-19 12:44
MemberSamiul0710-Jun-19 12:44 
GeneralRe: How to create a tree node with menu, submenu, child, item Pin
BillWoodruff10-Jun-19 17:05
mveBillWoodruff10-Jun-19 17:05 
GeneralRe: How to create a tree node with menu, submenu, child, item Pin
BillWoodruff11-Jun-19 0:53
mveBillWoodruff11-Jun-19 0:53 
GeneralRe: How to create a tree node with menu, submenu, child, item Pin
Samiul0711-Jun-19 5:31
MemberSamiul0711-Jun-19 5:31 
AnswerRe: How to create a tree node with menu, submenu, child, item Pin
#realJSOP10-Jun-19 4:37
mva#realJSOP10-Jun-19 4:37 
GeneralRe: How to create a tree node with menu, submenu, child, item Pin
Richard MacCutchan10-Jun-19 4:49
mveRichard MacCutchan10-Jun-19 4:49 
GeneralRe: How to create a tree node with menu, submenu, child, item Pin
#realJSOP10-Jun-19 4:57
mva#realJSOP10-Jun-19 4:57 
GeneralRe: How to create a tree node with menu, submenu, child, item Pin
Gerry Schmitz10-Jun-19 5:40
mveGerry Schmitz10-Jun-19 5:40 
GeneralRe: How to create a tree node with menu, submenu, child, item Pin
#realJSOP10-Jun-19 9:17
mva#realJSOP10-Jun-19 9:17 
GeneralRe: How to create a tree node with menu, submenu, child, item Pin
Gerry Schmitz10-Jun-19 10:04
mveGerry Schmitz10-Jun-19 10:04 
QuestionHow to clean all the installers? Pin
_Q12_7-Jun-19 3:55
Member_Q12_7-Jun-19 3:55 
AnswerRe: How to clean all the installers? Pin
OriginalGriff7-Jun-19 4:05
mveOriginalGriff7-Jun-19 4:05 
PraiseRe: How to clean all the installers? Pin
Richard Deeming7-Jun-19 4:56
mveRichard Deeming7-Jun-19 4:56 
GeneralRe: How to clean all the installers? Pin
OriginalGriff7-Jun-19 5:06
mveOriginalGriff7-Jun-19 5:06 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

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