How To Add New Items In Treeview From The Database?
By Goniey N (Mr. G)
At Runtime It Will Add New Items In Treeview From The Database...
private void button1_Click(object sender, EventArgs e)
{
OleDbConnection Conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=<<Your Database Path>>");
try
{
Conn.Open();
OleDbDataReader dr;
string str = "SELECT Name FROM Student";
OleDbCommand cmd = new OleDbCommand(str, Conn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
//Here "Node[0]" Means It Will Add Nodes In Root Node...
MyNameTreeView.Nodes[0].Nodes.Add(dr.GetValue(0).ToString());
}
Conn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
How To Add New Items In Treeview From The Database? (964 Views)