Bandita Codes

Amount (Point) Added in the Gridview & DataList:

Amount (Point) Added in the Gridview & DataList:

<asp:BoundField HeaderText="Unit Price"

DataField="UnitPrice" SortExpression="UnitPrice DataFormatString="{0:c}">

Datalist :

<%#String.Format("{0:c}", (DataBinder.Eval(Container.DataItem, "totalprice")))%>

Null Date Field Assigned NA in DataLst

C#:

dob:

<asp:Label ID="dobLabel" runat="server" Text='<%# Eval("dob")==DBNull.Value ? "N/A": Eval("dob","{0:d}") %>'></asp:Label>

<asp:Label ID="Label3" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "dob")==DBNull.Value ? "N/A": DataBinder.Eval(Container.DataItem, "dob","{0:d}") %>'></asp:Label><br />

VB.NET:

dob:

<asp:Label ID="dobLabel" runat="server" Text='<%# IIF(Eval("dob") IS DBNull.Value,"N/A", Eval("dob","{0:d}")) %>'></asp:Label>

<asp:Label ID="Label3" runat="server" Text='<%# IIF(DataBinder.Eval(Container.DataItem, "dob") IS DBNull.Value, "N/A", DataBinder.Eval(Container.DataItem, "dob","{0:d}")) %>'></asp:Label><br />

<%# DataBinder.Eval(Container.DataItem, "RecentDate") == "{1/1/0001 12:00:00 AM}" ? "n/a" : DataBinder.Eval(Container.DataItem, "RecentDate", "{0:d}")%>
Text='<%# Eval("RecentDate") == DBNull.Value ? "n/a": Eval("RecentDate","{0:d}") %>'
Text='<%# Convert.ToString(Eval("myDatetime")) =="1/1/0001 12:00:00 AM" ? "N/A" : Eval("myDatetime", "{0:d}")%>'

Tender show Three Days :

SqlDataAdapter da5 = new SqlDataAdapter("select * from idco_tender where sale_date > getdate() and sale_date < DATEADD(day, 3, sale_date) ", con);

DataSet dt5 = new DataSet();

da5.Fill(dt5);

if (dt5.Tables[0].Rows.Count > 0)

{

GridView3.Visible = true;

Label1.Visible = false;

GridView3.DataSource = dt5;

GridView3.DataBind();

}

else

{

Label1.Visible = true;

GridView3.Visible = false;

Label1.Text = "Active Tender not Found";

}

Popup

Freez Pane in Dynamic Table

Gridview Count INput

<asp:TemplateField HeaderText="Organization">

<asp:Label ID="Label1" runat="server" Text='<%#GetORGName(Convert.ToString(DataBinder.Eval(Container.DataItem, "org_id", ""))) %>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

public String GetORGName(string org_id)
   {
       if (org_id == null || org_id == "")
       {
           return "No Organization";
       }
       else
       {

           int org = Convert.ToInt32(org_id);
           string sql = "SELECT * FROM p2p_v2_registration WHERE org_id=" + org + "";
           SqlDataAdapter ad = new SqlDataAdapter(sql, con);
           DataTable dt = new DataTable();
           ad.Fill(dt);

return dt.Rows[0]["organization"].ToString().Trim();
}

Gridview LinkButton

Gridview LinkButton

<asp:TemplateField HeaderText="Order ID">

<asp:LinkButton ID="lnk_orderid" runat="server" ForeColor="Blue"

CommandArgument='<%#Eval("compl_id") %>'

Text='<%#Eval("compl_id") %>' Font-Bold="False" onclick="lnk_orderid_Click"

></asp:LinkButton>