change odbc to oledb

Question

i'm using odbc for all my connection in all forms..the problem is i'm going to list all my tables from database in a form and most of the examples given use the oledbconnection. can i use the oledbconnection only for the form that i use to list all the tables?only that form use oledb.where else other forms use the odbcconnection. if not what should i do if i still wants to use the odbcconnection

Answer 1

Hi, To retrevie infromation from a usercontrol form from the save button which is in another user control what we can do is When the save button is clicked find the parent control of the save button, then using the parent control instance find out the form user control instance from that u can get the information. For example Let me have 2 user control the first user control the as an input as Name textbox and age textbox and another user control has an display button in another usercontrol To retervie the information and display when the display button is clicked private void btnDisplay_Click(object sender, System.EventArgs e) { //Finds out the panel control since the usercontrol is placed in a panel System.Web.UI.Control ct = this.Parent.FindControl("p1"); if(ct != null) { //Find out entry(form control) control System.Web.UI.Control ef = ct.FindControl("entry1"); if(ef != null) { //Find out the textbox control which is in form in turn which is place in a panel System.Web.UI.Control tb = ef.FindControl("txtName"); Response.Write(((TextBox)tb).Text); } else Response.Write("Entry form Box not found"); } else Response.Write("Control not found"); } If you want the entire program give me ur email id. Thanks edward prakash