retrieve data in gridview

Question

1.00/5 (1 vote)

See more:

C#

C#4.0

Hi
I want to retrieve data in gridview using Class and I want some columns how i do this
by using C#

Posted 2-Apr-15 22:05pm

Gurpreet Arora Malhotra

Add a Solution

Comments

[no name] 3-Apr-15 4:17am

Please show some example, what you have and what you want ,

if you have class then make a generic collection and bind it to gridview datasource
else provide more information what you want to do :-)

Gurpreet Arora Malhotra 3-Apr-15 4:23am

Hi Thats a method that a .CS File
public void Retrieve_Currency_By_All(ref string Connection_string, out DataTable dt)
{

dt = new DataTable();
SqlConnection con = new SqlConnection(Connection_string);
SqlCommand cmd = new SqlCommand();
SqlDataAdapter da = new SqlDataAdapter();
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.CommandText = "Retrieve_Currency_By_All";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;

da = new SqlDataAdapter(cmd);
da.Fill(dt);

da.Dispose();
con.Close();
con.Dispose();
cmd.Dispose();

}

and On aspx File I take a gridview
<asp:GridView ID="GridView2" runat="server">

Gurpreet Arora Malhotra 3-Apr-15 4:22am

Hi Thats a method that a .CS File
public void Retrieve_Currency_By_All(ref string Connection_string, out DataTable dt)
{

dt = new DataTable();
SqlConnection con = new SqlConnection(Connection_string);
SqlCommand cmd = new SqlCommand();
SqlDataAdapter da = new SqlDataAdapter();
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.CommandText = "Retrieve_Currency_By_All";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;

da = new SqlDataAdapter(cmd);
da.Fill(dt);

da.Dispose();
con.Close();
con.Dispose();
cmd.Dispose();

}

and On aspx File I take a gridview
<asp:GridView ID="GridView2" runat="server">

Thanks7872 3-Apr-15 4:31am

What is the question?

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)

Praveen_Kumar Gupta · Accepted Answer · 2015-04-02T22:29:00

Solution 2

Then You can easily call your method

C#

var Connection_string="con";
DataTable datatable= null;
Retrieve_Currency_By_All(ref Connection_string, out datatable);
GridView2.DataSource=null;
GridView2.DataSource=datatable;
GridView2.DataBind();

and on aspx page you can do column maping.
using eval or bind method.

Posted 2-Apr-15 22:29pm

Praveen_Kumar Gupta

Comments

Gurpreet Arora Malhotra 3-Apr-15 4:32am

How i do Column Mapping Please give me one example

[no name] 3-Apr-15 4:35am

https://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.gridview.autogeneratecolumns%28v=vs.110%29.aspx

check in this link
set autogeneratecolumns="False"
and DataField="CustomerID" for column mapping
CustomerID is datatable column name

Gurpreet Arora Malhotra 3-Apr-15 4:39am

Thank You So Much for the help

[no name] 3-Apr-15 4:40am

Mark Answer as solution if this really help you

Gurpreet Arora Malhotra 3-Apr-15 4:33am

and one more thing i need that at end of every row I need One LinkButton . Is this Possible

[no name] 3-Apr-15 4:38am

https://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.buttonfield%28v=vs.110%29.aspx

Check button field example