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