AspdotnetCodes.com
Search
Articles
Books
Resources
Asp.Net News
Downloads
Free Tech Magazines
Asp.Net Web Hosting
Archives
Softwares
Newsletter
Suggest Us
Link to Us
Feeds Subscription
Articles
Questions & Answers
Tips & Tricks
  for Gridview
Posted by RAVI KHARVI on  5/9/2008 6:45:17 AM Category: Asp.Net 2.0
Add to my favorites
Email to friend
my intention is i want to fill the data set with different tables from a database using different adapters. the tablenames filled in dataset has to be added into dropdownlist items.
when ever a tablename selected from dropdownlist the correspondin information should display in gridview.if there is any modifications the table has to update the changes made by user n need to bind gridview. please anyone could help me .plzzz its urgent

Post Your Reply Post New Question

 Viewer's Reply
hi this is raju from rjy
Answered By boda.raju on 5/13/2008 2:04:56 PM
hi , first ur selected tables in dropdownlist dynamically(ie, through properties) then write
code under dropdownlist

string tab = DropDownList1.SelectedItem .ToString();
SqlConnection cn = new SqlConnection("Data Source=AMSOL-601;Initial Catalog=bn.raju;User ID=sa");
SqlDataAdapter da = new SqlDataAdapter("select *from " + tab + "", cn);
DataSet ds = new DataSet();
da.Fill(ds, "exa");
GridView1.DataSource = ds;
GridView1.DataBind();
 
Post Your Reply If you still have problem, post it again under this reply for better response.

 
Sponsored by
Oracle Magazine
Take Advantage of Oracle's 2 Day DBA Course
When Good HTML Goes Bad: How You Can Protect Your Web Applications