AspdotnetCodes.com
Voted 'Best ASP.NET Host' for 2008 – DiscountASP.NET
 
Articles Subscribe for our Articles Updates
Books
Resources
Downloads
Free Tech Magazines
Archives
Softwares
Newsletter
Suggest Us
Link to Us
  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 Answer Post New Question

 
 Viewer's Answers
hi this is raju from rjy
Posted By boda.raju on 5/13/2008 2:04:56 PM
Description:
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();
 
Sponsored by