本文介绍了如何复制我必须存储在节点中的列表以便稍后构建Treenode的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧! 问题描述 我有从excel导入的数据列表,我想将它存储在节点中,例如 Pro_ID [0] duration [0] pressodesor [0]在一个节点我怎么能这样做任何人请帮助 我不知道从哪里开始......我有一个存储数据的列表。我得到了4个列表。 所有列表都链接为例如索引0处的列表是第一个链接的所有信息。 ........................................... ....................................... 这是我将数据存储在Excel中的代码列表 ................. .................................................. ............... private void button1_Click(object sender,EventArgs e) { 试试 { { openFileDialog1.Filter =Excel Sheet(*。xlsx)| * .xlsx |所有文件(*。* )| *。*; if(openFileDialog1.ShowDialog()== DialogResult.OK) { string FileName = openFileDialog1。文件名; //เอาทั้งชื่อและนามสกุลpath.GetFileName // string path = // Application.StartupPath + @\ Myycel.xlsx; // Server.MapPath(File / MyExcel.xlsx); string connstr =Provider = Microsoft.ACE.OLEDB.12.0; Data Source =+ FileName; connstr + =;扩展属性= Excel 12.0;; string strSQL =SELECT * FROM [Sheet1 $]; OleDbConnection con = new OleDbConnection(connstr); con.Open(); OleDbCommand com; com = new OleDbCommand(strSQL ,con); OleDbDataReader odr; com.Parameters.Clear(); odr = com.ExecuteReader(); DataTable dt = new DataTable(); if(odr.HasRows) { dt.Load(odr) ; //dataGridView1.Columns[3].Visible = false; //dataGridView1.Columns[2].Visible = false; //dataGridView1.Columns [1] .Visible = false; //dataGridView1.Columns[0].Visible = false; dataGridView1.DataSource = dt; } else { dataGridView1.DataSource = null; ath.GetFileName // string path = // Application .StartupPath + @\ Myycel.xlsx; / } odr.Close(); string FileName2 = openFileDialog1.FileName; Server.MapPath(File / MyExcel.xlsx); string connstr2 =Provider = Microsoft.ACE.OLEDB.12.0; Data Source =+ FileName2; connstr2 + =;扩展属性= Excel 12.0;; string strSQL2 =SELECT * FROM [Sheet2 $]; OleDbConnection con2 = new OleDbConnection(connstr2); con2.Open(); OleDbCommand com2; com2 = new OleDbCommand(strSQL2,con2 ); OleDbDataReader odr2; com2.Parameters.Clear(); odr2 = com2.ExecuteReader(); DataTable dt2 = new DataTable(); if(odr2.HasRows) { dt2.Load(odr2); //dataGridView1.Columns[3].Visible = false; //dataGridView1.Columns[2].Visible = false; //dataGridView1.Columns [1] .Visible = false; //dataGridView1.Columns[0].Visible = false; dataGridView2.DataSource = dt2; } else { dataGridView2.DataSource = null; } odr2。关闭(); } for(int X = 0; X< = dataGridView1.RowCount - 1; X ++) { Proj_name = Convert.ToString(dataGridView1.Rows [X] .Cells [0] .Value); Proj_name_Values.Add(Convert.ToString(Proj_name)); } for(int X = 0; X< = dataGridView1.RowCount - 1; X ++) { 持续时间= Convert.ToInt32(dataGridView1.Rows [X]。单元格[1] .Value); Duration_Values.Add(Convert.ToInt32(Duration)); } for(int X = 0; X< = dataGridView1.RowCount - 1; X ++){ Predecessor = Convert .ToString(dataGridView1.Rows [X] .Cells [2] .Value); String [] Word = Predecessor.Split(''); Predecessor_Number.Add(Convert.ToString(Word.Length)); Predecessor_Values.Add(Convert.ToString(Predecessor)); Predecessor_Value_FindLF.Add(Convert.ToString(Predecessor)); } } i got lists of data that import from excel and i want to store it in node for example Pro_ID[0] duration[0] pressodesor[0] in a node how can i do it anyone please helpwell i didn't know where to start ...... i got an lists that store data. i got like 4 lists.all list is linked for example list at index 0 are all the information to the first link...................................................................................here is my code to store the data in excel to list.................................................................................. private void button1_Click(object sender, EventArgs e) { try { { openFileDialog1.Filter = "Excel Sheet(*.xlsx)|*.xlsx|All Files(*.*)|*.*"; if (openFileDialog1.ShowDialog() == DialogResult.OK) { string FileName = openFileDialog1.FileName; // เอาทั้งชื่อและนามสกุล path.GetFileName //string path = // Application.StartupPath + @"\MyExcel.xlsx"; // Server.MapPath("File/MyExcel.xlsx"); string connstr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + FileName; connstr += ";Extended Properties=Excel 12.0;"; string strSQL = "SELECT * FROM [Sheet1$]"; OleDbConnection con = new OleDbConnection(connstr); con.Open(); OleDbCommand com; com = new OleDbCommand(strSQL, con); OleDbDataReader odr; com.Parameters.Clear(); odr = com.ExecuteReader(); DataTable dt = new DataTable(); if (odr.HasRows) { dt.Load(odr); //dataGridView1.Columns[3].Visible = false; //dataGridView1.Columns[2].Visible = false; //dataGridView1.Columns[1].Visible = false; //dataGridView1.Columns[0].Visible = false; dataGridView1.DataSource = dt; } else { dataGridView1.DataSource = null;ath.GetFileName //string path = // Application.StartupPath + @"\MyExcel.xlsx"; / } odr.Close(); string FileName2 = openFileDialog1.FileName; Server.MapPath("File/MyExcel.xlsx"); string connstr2 = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + FileName2; connstr2 += ";Extended Properties=Excel 12.0;"; string strSQL2 = "SELECT * FROM [Sheet2$]"; OleDbConnection con2 = new OleDbConnection(connstr2); con2.Open(); OleDbCommand com2; com2 = new OleDbCommand(strSQL2, con2); OleDbDataReader odr2; com2.Parameters.Clear(); odr2 = com2.ExecuteReader(); DataTable dt2 = new DataTable(); if (odr2.HasRows) { dt2.Load(odr2); //dataGridView1.Columns[3].Visible = false; //dataGridView1.Columns[2].Visible = false; //dataGridView1.Columns[1].Visible = false; //dataGridView1.Columns[0].Visible = false; dataGridView2.DataSource = dt2; } else { dataGridView2.DataSource = null; } odr2.Close(); } for (int X = 0; X <= dataGridView1.RowCount - 1; X++) { Proj_name = Convert.ToString(dataGridView1.Rows[X].Cells[0].Value); Proj_name_Values.Add(Convert.ToString(Proj_name)); } for (int X = 0; X <= dataGridView1.RowCount - 1; X++) { Duration = Convert.ToInt32(dataGridView1.Rows[X].Cells[1].Value); Duration_Values.Add(Convert.ToInt32(Duration)); } for (int X = 0; X <= dataGridView1.RowCount - 1; X++) { Predecessor = Convert.ToString(dataGridView1.Rows[X].Cells[2].Value); String[] Word = Predecessor.Split(' '); Predecessor_Number.Add(Convert.ToString(Word.Length)); Predecessor_Values.Add(Convert.ToString(Predecessor)); Predecessor_Value_FindLF.Add(Convert.ToString(Predecessor)); } }推荐答案 这篇关于如何复制我必须存储在节点中的列表以便稍后构建Treenode的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!
10-27 13:44