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
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