how to select record show in gridview in asp.net

Jyoti Jodha

9y1.2kVisual Basic .NET

private void DisplayData()

{

dataGridView1.AutoGenerateColumns = false;

con.Open();

DataTable dt = new DataTable();

adapt = new SqlDataAdapter("select Tax_ID,Tax,percentage from Tax", con);

cmd.Parameters.AddWithValue("@Tax", this.txt_tax.Text.Trim());

cmd.Parameters.AddWithValue("@percentage", this.txt_per.Text.Trim());

cmd.ExecuteNonQuery();

adapt.Fill(dt);

dataGridView1.DataSource = dt;

con.Close();

}

Tax_Id Don't show in grid view.....???

18 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jitendra Shekhawat9y ago
Accepted answer
dataGridView1.Columns[0].HeaderText = "name";
dataGridView1.Columns[0].DataPropertyName = "name";
9y ago
which column display in Gridview?

if tax_id is not get then display in gridview so error arise..

please upload both server side and page code.
Karthi Keyan9y ago
Hi,
if you already define the column names in Gridview, then the retriving columns (Tax and Percentage) will add like follow. Because of using this line. dataGridView1.DataSource = dt;

In grid it will show,

        Tax_ID, Tax, percentage,Tax,Percentage // the values should be in under Yellow Marked Tax and Percentage

        For that u should remove your Tax_ID, Tax, percentage columns from gridview. then there will be no Tax-Id.

while you use datasource no need of column creation in Gridview. because datasource is directly binding the data to grid.

Another method for load the data to datagrid.
we can use foreach. without datasource. for this method you Should create columns to the Gridview. then select the neccessary data from database and load that in datatable.
then use the follow code.

foreach(DataRow dr in dt.Rows) // In this dt is my Datatable
           {
               grid.Rows.Add(dr["Tax"]..ToString(),dr["Percentage"].ToString());
           }

           // For the above code i created Tax and Percentage columns in my gridview.
           // the above code is doing the simple task, that get the value from datatable (dt) and add that to the grid.

Thank You.
Jyoti Jodha9y ago
Thanks
Karthi Keyan Sir

IT Done
Jyoti Jodha9y ago
Your code is right
but
in Gridview iam deffin the columns name
Tax_ID, Tax, percentage

And Tax_ID is hide
now tell me what to do....??/
Karthi Keyan9y ago
you did well. see your code. that green line.

Select * From Tax; // * means all columns in table. Replace Your * By Tax,percentage like this.

adapt = new SqlDataAdapter("select Tax,percentage from Tax", con);

con.Open();
DataTable dt = new DataTable();
adapt = new SqlDataAdapter("select * from Tax", con);
adapt.Fill(dt);
dataGridView1.DataSource = dt;
con.Close();
Jyoti Jodha9y ago
Hello sir
my this code in Running

con.Open();
DataTable dt = new DataTable();
adapt = new SqlDataAdapter("select * from Tax", con);
adapt.Fill(dt);
dataGridView1.DataSource = dt;
con.Close();

But Iam want to show records in selected columns in gridview

Not show all Tables records in gridview....??
Karthi Keyan9y ago
i have seen you image. your code was wrong. Executenonquery will not retrun the value. we can't use that for select. in your code, you were fill the datatable by adapt (SqlDataAdapter). but you never pass that adapt in your SqlCommand. do you understand now what mistake you did.

SqlCommand cmd = new SqlCommand("select Tax,percentage from Tax",con);
SqlDataAdapter da = new SqlDataAdapter(cmd)

these two lines not in your code. kindly check your code and my code. and finaly replace your code with mine.

Any doubts replay me.
Jyoti Jodha9y ago
iam send you a image
an you see this

an error are show in this image
Karthi Keyan9y ago
Hi Jhoda.

I already sent this code. it will work fine.

private void DisplayData()
{
con.Open();
DataTable dt = new DataTable();
SqlCommand cmd = new SqlCommand("select Tax,percentage from Tax",con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
dataGridView1.DataSource = dt;
con.Close();
}
Jyoti Jodha9y ago
see Error
Karthi Keyan9y ago
where you get this error. kindly send your code.
Jyoti Jodha9y ago
Error Show

Object reference not set to an instance of an object.
Karthi Keyan9y ago
In Select Query Only select Tax and Percentage. simple.

SqlCommand cmd = new SqlCommand("select Tax,percentage from Tax",con);
Jyoti Jodha9y ago
Hello sir
iam want to show gridview record only " Tax, & Percentage"
And Tax_ID is hide hi Gridview

Please Tell me now how to show two records in gridview....???
Karthi Keyan9y ago
In my previous post i written the code for select the data from Grid. not from database.

private void DisplayData()
{
con.Open();
DataTable dt = new DataTable();
SqlCommand cmd = new SqlCommand("select Tax_ID,Tax,percentage from Tax",con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
dataGridView1.DataSource = dt;
con.Close();
}

try this.
Jyoti Jodha9y ago
Use in Windows application c#
Jyoti Jodha9y ago
How to use in DisplayData()

how to select record show in gridview in asp.net

Karthi Keyan Sir