<pre lang="c#">
string cs = ConfigurationManager.ConnectionStrings["DbConnection"].ConnectionString;
SqlConnection con = new SqlConnection(cs);
SqlDataAdapter da = new SqlDataAdapter("spGetAllTables", con);
DataTable dataTable = new DataTable();
da.Fill(dataTable);
List<string> dt = new List<string>();
for (int i = 0; i < dataTable.Rows.Count; i++)
{
dt.Add(dataTable.Rows[i][0].ToString());
}
RES.allTables= dt;
</string></string>
This is how i'm fetching table names. anything now?