incomplete data showing

[rameshjha]

Hi all,

I am new in this forum,

I have some trouble in Microsoft visual c# 2003 and Oracle 8i.

I have made a program in visual c# to read content from Oracle 8i database and show it in datagrid on the webpage.

But whenever i read content from the database and there is any repeatation of data is coming then it makes repeated data incomplete or garbage,

below is the code which i am using in it.

Code:

DataGrid on aspx file --



<asp:datagrid id="DataGrid1" runat="server" Width="100%" AutoGenerateColumns="False" AllowPaging="True" CellPadding="3">


<ItemStyle Font-Size="12px" Font-Names="Arial" ForeColor="#4E4421" BackColor="#DCE9FB"></ItemStyle>



<HeaderStyle Font-Size="12px" Font-Names="Arial" Font-Bold="True" ForeColor="#FFFFFF" BorderColor="#D0C7B3" BackColor="#708EBA"></HeaderStyle>



<Columns>


<asp:HyperLinkColumn DataNavigateUrlField="Quotation Number" DataNavigateUrlFormatString="QuoteDetails.aspx?{0}"

DataTextField="Quotation Number" SortExpression="Quotation Number" HeaderText="Quotation Number">



<ItemStyle Width="150px"></ItemStyle>



</asp:HyperLinkColumn>


<asp:BoundColumn DataField="Date" SortExpression="Date" HeaderText="Date">



<ItemStyle Width="150px"></ItemStyle>

</asp:BoundColumn>


<asp:BoundColumn DataField="City of Delivery" SortExpression="City of Delivery" HeaderText="City of Delivery">

<ItemStyle Width="175px"></ItemStyle>

</asp:BoundColumn>

<asp:BoundColumn DataField="status" SortExpression="status" HeaderText="Status">
<ItemStyle Width="225px"></ItemStyle>


</asp:BoundColumn>



</Columns>


<PagerStyle HorizontalAlign="Center" Mode="NumericPages"></PagerStyle>



</asp:datagrid>





Function to fill DataGrid in cs (code behind) file --



public void fillDg()

{

DataSet ds=new DataSet();

Cache["DataTable"]="";

ds=objClientInfo.GetQuotes(Session["Email"].ToString());

Cache["DataTable"]=ds.Tables[0];

DataGrid1.DataSource=ds;

DataGrid1.DataBind();

ds.Dispose();



}



Please help me to sort this error.

Regards
Ramesh Jha