Hi Morris,
Thanks for your update. I've made a sample that demonstrates how to do
this. The database I used is the Northwind database. If you have no that
database you can change the NorthwindConnectionString1 setting in the
web.config:
<connectionStrings>
<add name="NorthwindConnectionString1" connectionString="Your Connection
String" providerName="System.Data.SqlClient"/>
</connectionStrings>
Here's the code.
Aspx:
<asp:TextBox ID="TextBox1" runat="server" Text="Orders"></asp:TextBox>
<asp:Label ID="Label1" runat="server" Text=""></asp:Label>
<asp:Button ID="Button1"
runat="server" Text="Check" onclick="Button1_Click" />
<asp:GridView ID="GridView1" runat="server">
<Columns>
<asp:TemplateField>
<ItemTemplate>
<asp:LinkButton ID="LinkButton1" runat="server">Yes the table
is in the database!</asp:LinkButton>
</ItemTemplate></asp:TemplateField></Columns>
</asp:GridView>
Aspx.cs:
protected void Button1_Click(object sender, EventArgs e)
{
using (SqlConnection sc = new
SqlConnection(ConfigurationManager.ConnectionStrin gs["NorthwindConnectionStr
ing1"].ToString()))
{
SqlCommand command = new SqlCommand(@"SELECT
TABLE_NAME, TABLE_TYPE
FROM INFORMATION_SCHEMA.TABLES", sc);
SqlDataAdapter sa = new SqlDataAdapter(command);
DataTable dt = new DataTable();
sa.Fill(dt);
//The following code just shows the table on the page,
which can provide a direct vision of the data retrieved.
this.GridView1.DataSource = dt;
this.GridView1.DataBind();
///////////////////////////
//The key here, to see if the table exists in the database
if you also want to check the views, please check dr[0] only.
string tablename = this.TextBox1.Text;
bool hasfound = false;
foreach (DataRow dr in dt.Rows)
{
if (dr[1].ToString() == "BASE TABLE" &&
dr[0].ToString() == tablename)
{
Label1.Text = "The table " + tablename + " is in
the database";
this.GridView1.Columns[0].Visible = true;
hasfound = true;
break;
}
}
if (!hasfound)
{
Label1.Text = "The table " + tablename + " is NOT in
the database";
this.GridView1.Columns[0].Visible = false;
}
}
}
To test, you can enter an arbitary table name in the TextBox and click the
"Check" button. You'll see the Lable shows if the table exists in the
database and a hyperlink column in the GridView will also be
visible/invisible according to the result.
As to Access database we don't use:
SELECT TABLE_NAME, TABLE_TYPE
FROM INFORMATION_SCHEMA.TABLES
We use this query instead:
Select Name from MSysObjects
If there's anything unclear please feel free to let me know. I'll do my
best to provide a clearer explanation.
Regards,
Allen Chen
Microsoft Online Support
Similar Threads
