table retrieval from sqlserver 2008 to web page

Question

0.00/5 (No votes)

See more:

currently i'm designing application to retrieve the table and show it in my webpage from the sql server 2008 by getting table name from the user.. how can i do it... help me

Posted 5-Mar-13 0:21am

Ramkumar K

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

choudhary.sumit · Answer 1 · 2013-03-05T00:25:00

Solution 1

Good example for beginners:
datagridview-tutorial[^]

Posted 5-Mar-13 0:25am

choudhary.sumit

Comments

Ramkumar K 5-Mar-13 6:33am

Thanks,,.choudhary.sumit .. but i know about it.. my doubt is, i want to get table name from user and display it accordingly... i dont want to display particular table alone... table must be chosed by user only

choudhary.sumit 5-Mar-13 6:38am

USe parameterized query in that case. if u r passing table name with the textbox1, then replace the "animal" with the "+textbox1.text+" in the above example.

Ramkumar K 5-Mar-13 6:43am

what about the columns...? some table contains 3 columns and others may have different number of column?.. :(

Ramkumar K 5-Mar-13 6:45am

consider that in my grid if i included 3 columns only... then if user choses 4 column table means..how can i fit that in grid...

choudhary.sumit 5-Mar-13 6:45am

ok. post your code here in which you are binding your datasource.

Ramkumar K 5-Mar-13 6:58am

my aspx file:


<div id="tb" runat="server">
<table id="mytb" runat="server">
<tr>
<td>
Enter the table u wished to display here:
</td>
<td>
<asp:TextBox ID="gettbname" runat="server">
</td>
</tr>
<tr>
<td>
<asp:Button ID="sbt" Text="submit" runat="server"/>
</td>
</tr>
</table>
</div>

<div id="gridacc" class="gridacc" runat="server">
<asp:GridView ID="GridView1" DataKeyNames="UserId"
AutoGenerateColumns="false" BackColor="white"
BorderColor="#333300" runat="server"
Style="left: 239px; position: absolute;top: 40px"
AlternatingRowStyle-BackColor="#D8D8C5">
<columns> <asp:BoundField HeaderText="Id" DataField="UserId" />
<asp:BoundField HeaderText="Name" DataField="Fullname" />
<asp:BoundField HeaderText="Email" DataField="Email" />

</div>


My ASPX.CS FILE:
protected void sbt_Click(object sender, EventArgs e)
{
SqlConnection con1 = new SqlConnection(connection);
con1.Open();
SqlCommand cmd = new SqlCommand("Select * from " + gettbname.Text + "", con1);
SqlDataAdapter data = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
data.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
con1.Close();
}

Ramkumar K 5-Mar-13 7:10am

how can i bring the name of the columns of the user requested table into '
Asp:datafield '

Ramkumar K 5-Mar-13 7:11am

i think i should get the name of the table and columns from user .. via textbox.. is that the only way huh???