Monday 28 May 2012

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}">
      <ItemStyle HorizontalAlign="Right"></ItemStyle>        </asp:BoundField>

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>

or

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

C#

<%# 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">
                       <ItemTemplate>
                           <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">
<ItemTemplate>
<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>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" />
</asp:TemplateField>


div_compdetails.Visible =true;LinkButton lnk = (LinkButton)sender; string comp_code = lnk.CommandArgument.ToString();