Comments by Manzoor Ahmed P (Top 10 by date)

Sorry, I am totally new... Can u tell me where to put this ? in head section or in the body section of content page or master page?

thank u VeeraAnnapureddy...

I did something similar like this

CREATE TABLE dbo.tblCompany
(ID INT IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED,
CompanyID AS 'X-' + RIGHT('00000' + CAST(ID AS VARCHAR(5)), 5) PERSISTED,
.... your other columns here....
)

Thanks Everybody!...
Sorry for late reply, actually i wa on holiday
The problem was My master page's EnableViewState property was false !

Sorry i m late i was out for lunch...

this is how i m filling Grid

public void BindGridNewPOReq()
{
using (SqlConnection conn = new SqlConnection())
{
try
{
conn.ConnectionString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlCommand cmd = new SqlCommand())
{
DataTable dt = new DataTable();
string cmdText = "select * from PLNGPRItemDet where(type = 'Purchase Order' and POStatus = 'pending @ purchase') ORDER BY JobNo ASC ";
cmd.CommandText = cmdText;
cmd.Connection = conn;
SqlDataAdapter da = new SqlDataAdapter(cmd);
conn.Open();
da.Fill(dt);

GrvNewPORequests.DataSource = dt;
GrvNewPORequests.DataBind();
GrvNewPORequests.Columns[1].Visible = false;
conn.Close();
}
}
catch (Exception ex)
{

}
}
if (GrvNewPORequests.Rows.Count < 1)
{
lblNoNewReq.Visible = true;
panelTop.Visible = false;
}
}

<asp:GridView ID="GrvNewPORequests" runat="server" Width="98%"
AutoGenerateColumns="false" GridLines="Both">

<footerstyle backcolor="#E7E7FF" forecolor="#4A3C8C">
<%--<rowstyle backcolor="#E7E7FF" forecolor="#4A3C8C">--%>
<columns>
<asp:TemplateField HeaderText="" ShowHeader="false">
<itemtemplate>
<asp:CheckBox ID="cbApprove" runat="server" />



<asp:TemplateField HeaderText="PriceUID" ShowHeader="false">
<itemtemplate>
<asp:Label ID="lblPriceUID" runat="server" Text='<%#Eval("PriceUID") %>'>



<asp:TemplateField HeaderText="Item Name" ShowHeader="true">
<%--<controlstyle width="auto">--%>
<itemtemplate>
<asp:Label ID="lblIT_Name" runat="server" Text='<%#Eval("IT_Name") %>'>


<asp:TemplateField HeaderText="Description" ShowHeader="true">
<itemtemplate>
<asp:Label ID="lblDRGDesc" runat="server" Text='<%#Eval("DRGDesc") %>'>



<asp:TemplateField HeaderText="Quantity" ShowHeader="true">
<itemtemplate>
<asp:Label ID="lblQty" runat="server" Text='<%#Eval("Qty") %>'>



<asp:TemplateField HeaderText="Req Date" ShowHeader="true">
<itemtemplate>
<asp:Label ID="lblReqDate" runat="server" Text='<%#Eval("ReqDate", "{0:dd-MMM-yyyy}") %>'>



<asp:TemplateField HeaderText="Instructions" ShowHeader="true">
<itemtemplate>
<asp:Label ID="lblInstruction" runat="server" Text='<%#Eval("instructions") %>'>



<asp:TemplateField HeaderText="JobNo" ShowHeader="true">
<itemtemplate>
<asp:Label ID="lblJobNo" runat="server" Text='<%#Eval("JobNo") %>'>


<%--<asp:TemplateField HeaderText="Delete" ShowHeader="false">
<itemtemplate>
<asp:ImageButton ID="ImageDelete" runat="server" ImageUrl="~/Images/icon-delete.gif" CommandName="delete"
OnClientClick="return ConfirmOnDelete();" />

--%>


<HeaderStyle CssClass="GridviewScrollHeader" />
<rowstyle cssclass="GridviewScrollItem">
<PagerStyle CssClass="GridviewScrollPager" />