Im getting below Error While adding childnodes in TreeView and while binding data in DataGridview from database in "Windows application" :
Object reference not set to an instance of an object.
at Line:
treeView1.Nodes.Add(node);
dataGridView1.DataSource = dt;
Full code is below:
MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["ConnectionStr"].ConnectionString);
public Form1()
{
BindGrid();
FillchildNode();
InitializeComponent();
}
private void BindGrid()
{
string query = "SELECT * FROM syncdb.staticstops";
MySqlDataAdapter sda = new MySqlDataAdapter(query, con);
DataTable dt = new DataTable();
sda.Fill(dt);
dataGridView1.DataSource = dt;
}
protected void FillchildNode()
{
string query = "SELECT id FROM syncdb.staticstops";
MySqlDataAdapter adp = new MySqlDataAdapter(query, con);
DataTable dt = new DataTable();
adp.Fill(dt);
foreach (DataRow dr in dt.Rows)
{
TreeNode node = new TreeNode(dr["id"].ToString());
node.Nodes.Add(dr["id"].ToString());
treeView1.Nodes.Add(node);
}
}
I debug my solution and im getting value in it.
Please reply why Im getting this error for both Treeview and DataGridview.