hmariya
شنبه 21 آذر 1388, 12:46 عصر
با سلام. من یک کد نوشتم برای پر کردن نودهای TreeView از طریق بانک اطلاعاتی اما اطلاعات رو درست انتقال نمی ده فکر می کنم اشکال تو حلقه های که ایجاد کردم هست اما نمی دونم کجاش گیر داره... کسی می تونه کمک کنه؟
اینم کد برنامه:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Diagnostics;
using System.Collections;
using System.Data;
namespace SaapStock
{
public partial class frmSlcCode : Form
{
[STAThread]
static void Main2()
{
System.Windows.Forms.Application.Run(new frmSlcCode());
}
#region " Código generado por el Diseñador de Windows Forms "
#endregion
public frmSlcCode()
{
InitializeComponent();
}
private void frmSlcCode_Load(object sender, EventArgs e)
{
//Conect to db & Create Data Source
try
{
string strCon;
SqlConnection con;
strCon = "Data Source=.;Initial Catalog=SaapStock;Integrated Security=True";
con = new SqlConnection(strCon);
con.Open();
string strSql;
string strSqlCode;
strSql = "Select * FROM TreeCode";
DataSet dst = new DataSet();
treeView1.Nodes.Clear();
SqlDataAdapter daSlcCode;
daSlcCode = new SqlDataAdapter(strSql, con);
int i;
int j;
string stCode;
string stDtlCode;
int r;
daSlcCode.Fill(dst, "TreeCode");
r = dst.Tables["TreeCode"].Rows.Count - 1;
for (i = 0; i <= r; i++)
{
stCode = "";
stCode=dst.Tables["TreeCode"].Rows[i]["strCodeName"].ToString();
treeView1.Nodes.Add(stCode);
treeView1.Nodes[i].ImageIndex = 0;
SqlDataAdapter daSlcCode2;
string strSql2;
strSql2 = "";
strSql2="select * from TreeCode where strCodeName=\'" + stCode + "\'";
daSlcCode2 = new SqlDataAdapter(strSql2,con);
dst.Tables["TreeCode"].Clear();
daSlcCode.Fill(dst, "TreeCode");
dst.Tables["TreeCode"].Clear();
daSlcCode2.Fill(dst, "TreeCode");
dataGridView1.DataBindings.Add(new Binding("DataSource", dst, "TreeCode"));
j = 0;
for (j = 0; j <= dst.Tables["TreeCode"].Rows.Count-1; j++)
{
//once we have the records we fill the respective child node in the control
stDtlCode = dst.Tables["TreeCode"].Rows[j]["strCodeValue"].ToString();
TreeNode dtlCNode;
dtlCNode = treeView1.Nodes[i];
dtlCNode.Nodes.Add(stDtlCode);
//asigne a image
//then we expand the nodes so we can show the child nodes
dtlCNode.Expand();
}
}
con.Close();
}
catch
{
// MessageBox.Show("Error");
return;
}
}
private object Err()
{
throw new NotImplementedException();
}
private void button1_Click(object sender, EventArgs e)
{
dataGridView1.DataBindings.Clear();
string strCon;
SqlConnection con;
strCon = "Data Source=.;Initial Catalog=SaapStock;Integrated Security=True";
con = new SqlConnection(strCon);
con.Open();
string strSql;
strSql = "Select * FROM TreeCode";
SqlDataAdapter dat;
DataSet dst = new DataSet();
dat = new SqlDataAdapter(strSql, con);
dat.Fill(dst, "TreeCode");
dataGridView1.DataBindings.Add(new Binding("DataSource", dst, "TreeCode"));
}
private void treeViewP_AfterSelect(object sender, TreeViewEventArgs e)
{
}
private void treeView1_AfterSelect(object sender, TreeViewEventArgs e)
{
}
}
}
اینم کد برنامه:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Diagnostics;
using System.Collections;
using System.Data;
namespace SaapStock
{
public partial class frmSlcCode : Form
{
[STAThread]
static void Main2()
{
System.Windows.Forms.Application.Run(new frmSlcCode());
}
#region " Código generado por el Diseñador de Windows Forms "
#endregion
public frmSlcCode()
{
InitializeComponent();
}
private void frmSlcCode_Load(object sender, EventArgs e)
{
//Conect to db & Create Data Source
try
{
string strCon;
SqlConnection con;
strCon = "Data Source=.;Initial Catalog=SaapStock;Integrated Security=True";
con = new SqlConnection(strCon);
con.Open();
string strSql;
string strSqlCode;
strSql = "Select * FROM TreeCode";
DataSet dst = new DataSet();
treeView1.Nodes.Clear();
SqlDataAdapter daSlcCode;
daSlcCode = new SqlDataAdapter(strSql, con);
int i;
int j;
string stCode;
string stDtlCode;
int r;
daSlcCode.Fill(dst, "TreeCode");
r = dst.Tables["TreeCode"].Rows.Count - 1;
for (i = 0; i <= r; i++)
{
stCode = "";
stCode=dst.Tables["TreeCode"].Rows[i]["strCodeName"].ToString();
treeView1.Nodes.Add(stCode);
treeView1.Nodes[i].ImageIndex = 0;
SqlDataAdapter daSlcCode2;
string strSql2;
strSql2 = "";
strSql2="select * from TreeCode where strCodeName=\'" + stCode + "\'";
daSlcCode2 = new SqlDataAdapter(strSql2,con);
dst.Tables["TreeCode"].Clear();
daSlcCode.Fill(dst, "TreeCode");
dst.Tables["TreeCode"].Clear();
daSlcCode2.Fill(dst, "TreeCode");
dataGridView1.DataBindings.Add(new Binding("DataSource", dst, "TreeCode"));
j = 0;
for (j = 0; j <= dst.Tables["TreeCode"].Rows.Count-1; j++)
{
//once we have the records we fill the respective child node in the control
stDtlCode = dst.Tables["TreeCode"].Rows[j]["strCodeValue"].ToString();
TreeNode dtlCNode;
dtlCNode = treeView1.Nodes[i];
dtlCNode.Nodes.Add(stDtlCode);
//asigne a image
//then we expand the nodes so we can show the child nodes
dtlCNode.Expand();
}
}
con.Close();
}
catch
{
// MessageBox.Show("Error");
return;
}
}
private object Err()
{
throw new NotImplementedException();
}
private void button1_Click(object sender, EventArgs e)
{
dataGridView1.DataBindings.Clear();
string strCon;
SqlConnection con;
strCon = "Data Source=.;Initial Catalog=SaapStock;Integrated Security=True";
con = new SqlConnection(strCon);
con.Open();
string strSql;
strSql = "Select * FROM TreeCode";
SqlDataAdapter dat;
DataSet dst = new DataSet();
dat = new SqlDataAdapter(strSql, con);
dat.Fill(dst, "TreeCode");
dataGridView1.DataBindings.Add(new Binding("DataSource", dst, "TreeCode"));
}
private void treeViewP_AfterSelect(object sender, TreeViewEventArgs e)
{
}
private void treeView1_AfterSelect(object sender, TreeViewEventArgs e)
{
}
}
}