C# Data Grid View Issue

Question

0.00/5 (No votes)

See more:

C#

SqlCommand cmd = new SqlCommand("SLECT subCode,supName FROM SUPPLIER", sqlCon);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(dSetTEMP.ITEM_SEARCH_COLTWO);
gvSearch.DataSource = dSetTEMP.ITEM_SEARCH_COLTWO;

above is my code

this dSetTemp Is a dataset and the ITEM_SEARCH_COLTWO is a data table

this code fill the grid view with rows with empty rows
if the sql select 10 record grid fill with 10 record

how to sort this issue
thanks

Posted 20-Nov-14 23:25pm

anushikaroshan

Updated 20-Nov-14 23:52pm

Herman<T>.Instance

v2

Add a Solution

Comments

Vinay Mistry 21-Nov-14 5:52am

If you have added boundfield then check DataTextField property of the column

1 solution

Add a Solution

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

/\jmot · Answer 1 · 2014-11-20T23:56:00

Try..

C#

gvSearch.DataSource = dSetTEMP.ITEM_SEARCH_COLTWO;
gvSearch.DataBind();

And Set..
ShowHeaderWhenEmpty and EmptyDataText propery in gridview. like this

C#

<asp:gridview id="gvSearch" runat="server" allowpaging="false" autogeneratecolumns="False" emptydatatext="No Records Found" showheaderwhenempty="True" width="100%" xmlns:asp="#unknown">
</asp:gridview>

C# Data Grid View Issue

1 solution

Solution 1

Add your solution here

Preview 0

C# Data Grid View Issue

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us