Re: problem in displaying money in grid view. - ASP.NET Discussion Boards

Re: Get month name and last date form date time

maltova8-Jun-10 0:29

maltova

8-Jun-10 0:29

following will displat the last date of the present month.

day(DateSerial(Year(datetime.Now), Month(datetime.Now), 0))

Re: Get month name and last date form date time

Refwah8-Jun-10 5:01

Refwah

8-Jun-10 5:01

You can use DateTime.Now.Month to return an int representation of the month. You can pass this to a function to switch on for the month name, IE:

switch(month)
{
case 1:
 return "January";
case 2:
 return "Feburary";
}

problem in displaying money in grid view.

souravghosh186-Jun-10 23:07

souravghosh18

6-Jun-10 23:07

Hi all,
In my application i am displaying Amount field in a grid view. which is money type in data base.my problem is when i m displaying it,it shows 4 numbers after decimal like ('45.0000').but i want to display only 2 places after decimal ('45.00').In sql query analyser it shows correctly.I have already used round function but still it is not working.
Any suggestions?

Re: problem in displaying money in grid view.

michaelschmitt6-Jun-10 23:29

michaelschmitt

6-Jun-10 23:29

Hi there,

is it a bound field? Then you could use the DataFormatString property.

In a custom/template field, you could output your value as string and use string.Format with
a fitting format string (like here).

Re: problem in displaying money in grid view.

souravghosh187-Jun-10 0:21

souravghosh18

7-Jun-10 0:21

i am using Label to diplay it in a ItemTemplate.

Re: problem in displaying money in grid view.

michaelschmitt7-Jun-10 1:56

michaelschmitt

7-Jun-10 1:56

Hi,

then here is an example on how to do it. Just replace the "((double)0.123)" by your variable and modify the rest according to your needs:

<ItemTemplate>
    <asp:Label runat="server" Text='<%# ((double)0.123).ToString("N") %>'></asp:Label>                   
</ItemTemplate>

Re: problem in displaying money in grid view.

Goutam Patra7-Jun-10 2:58

Goutam Patra

7-Jun-10 2:58

it works ,thanx

Re: problem in displaying money in grid view.

The solution7-Jun-10 0:45

The solution

7-Jun-10 0:45

Please try as below

Textbox.Text.ToString("0.00");

Hope this will work for you.

can't see the background-image of a master page

benams6-Jun-10 22:47

benams

6-Jun-10 22:47

I have a div with a background image in my master page, but I can't see this image in the inherited pages.
maybe it happens because the master page and the pages are placed in different directories...
what can I do?

Re: can't see the background-image of a master page

saini arun6-Jun-10 22:58

saini arun

6-Jun-10 22:58

Try to specify the background image path using ResolveURL on master page like this

src="<%=ResolveUrl("~/images/test.png")%>"

Dropdownlist not displaying selectedItem in GridView

meeram3956-Jun-10 22:03

meeram395

6-Jun-10 22:03

I have a Gridview in my form and I use SqlDataSource to fill the Grid. I have an Edit button also in the Gridview to Edit data.

The problem is while clicking on Edit, the dropdownlist in the Gridview
is not displaying the item selected, but going to the first item of the dropdownlist. How should I make the selected item
displayed while click on Edit?

Please find below my code:

<asp:GridView ID="grdDTCCRics" runat="server" AllowPaging="True" AllowSorting="True"
        AutoGenerateColumns="False" 
         DataKeyNames="REDCODE" 
         OnRowDeleted="grdDTCCRics_RowDeleted" 
        OnRowUpdated="grdDTCCRics_RowUpdated" 
        OnRowUpdating="grdDTCCRics_RowUpdating" 
        OnRowEditing="grdDTCCRics_RowEditing"
        OnPageIndexChanged="CmdCancel_Click" 
        DataSourceID="SqlDataSource1">
        <RowStyle Height="20px" HorizontalAlign="Center" VerticalAlign="Middle" />
        <EmptyDataRowStyle Height="20px" HorizontalAlign="Center" VerticalAlign="Middle"  />
        <Columns>
            <asp:BoundField  DataField="REDCODE" HeaderText="REDCODE" ReadOnly="True" SortExpression="REDCODE" />
               <asp:TemplateField HeaderText="RIC" SortExpression="RIC">
                <EditItemTemplate>
                    <asp:TextBox ID="RICTextBox" runat="server" Text='<%# Eval("RIC") %>'></asp:TextBox>
                </EditItemTemplate>
                <ItemTemplate>
                    <asp:Label ID="RICLabel" 
runat="Server" Text='<%# Eval("RIC") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
             <asp:TemplateField HeaderText="REGIONCODE" SortExpression="REGIONCODE">
                <EditItemTemplate>
                    <asp:DropDownList ID="RegionCodeList" runat="Server">
                     <asp:ListItem Text="AM" Value="1"></asp:ListItem>
                    <asp:ListItem Text="US" Value="2"></asp:ListItem>
                    <asp:ListItem Text="EU" Value="3"></asp:ListItem>
                    <asp:ListItem Text="JP" Value="4"></asp:ListItem>
                    <asp:ListItem Text="AS" Value="5"></asp:ListItem>
                    <asp:ListItem Text="OF" Value="6"></asp:ListItem>
                    </asp:DropDownList>
                </EditItemTemplate>
                    <ItemTemplate>            
                        <asp:Label ID="lblcountry" runat="server" Text = '<%# Eval("REGIONCODE") %>'></asp:Label>
                    </ItemTemplate>
            </asp:TemplateField>
          
            <asp:CommandField ShowEditButton="True" ValidationGroup="Upd"   ButtonType="Button" HeaderText="EDIT"  >
              <ControlStyle Height="22px" Width="50px" />
                   </Columns>
</GridView>

When I tried to get the editrowindex, the object lstRegion is coming as null in the rowEditing eventhandler. Any idea how to display it properly? Please help.

Thanks
meeram395.

Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.

Re: Dropdownlist not displaying selectedItem in GridView

michaelschmitt6-Jun-10 23:19

michaelschmitt

6-Jun-10 23:19

Hi,

maybe there is a simpler solution, but you could use the rowdatabound event
of your gridview and set the index of the dropdown there appropriatly (if in edit mode).

Here is an example (which is using c1gridview, just replace it by the microsoft one and
check the if conditions, they may be slightly different)

protected void grdRoomTypes_RowDataBound(object sender, C1.Web.UI.Controls.C1GridView.C1GridViewRowEventArgs e)
{

    if (e.Row.RowType == C1.Web.UI.Controls.C1GridView.C1GridViewRowType.DataRow)
    {
        if ((e.Row.RowState & C1.Web.UI.Controls.C1GridView.C1GridViewRowState.Edit) > 0)
        {
            // here find your dropdownlist by id and set the index
            TimeSchemeEditor editor = (TimeSchemeEditor)e.Row.FindControl("timeSchemeEditor");
            editor.TimeScheme = (ServiceDirectoryRoomTypeItem)e.Row.DataItem;
        }
        else
        {
            // Do nothing here maybe
            TimeSchemeViewer viewer = (TimeSchemeViewer)e.Row.FindControl("timeSchemeViewer");
            viewer.TimeScheme = (ServiceDirectoryRoomTypeItem)e.Row.DataItem;
        }
    }
}

Re: Dropdownlist not displaying selectedItem in GridView

meeram3956-Jun-10 23:52

meeram395

6-Jun-10 23:52

Thanks for the reply. However that code is not working. Following is my RowDataBound Event:

protected void grdTCCRics_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        

        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            
            if ((e.Row.RowState & DataControlRowState.Edit) > 0)
            {
                //grdDTCCRics.EditIndex = e.Row.RowIndex;
                //grdDTCCRics.DataBind();
               
                Label lblRegion = (Label)e.Row.FindControl("lblcountry");

                if (lblRegion != null)
                {
                    DropDownList ddlRegion = (DropDownList)e.Row.FindControl("RegionCodeList");
                    if (ddlRegion != null)
                    {
                        ddlRegion.SelectedItem.Text = lblRegion.Text.Trim();
                    }
                }
            }
        }
    }

The Label control lblRegion is coming as null. So how will I get the value? Please help.

Thanks
meeram395.

Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.

Re: Dropdownlist not displaying selectedItem in GridView

michaelschmitt7-Jun-10 0:06

michaelschmitt

7-Jun-10 0:06

I guess in your markup, you have an edititemtemplate and an itemtemplate, is that right?

In your rowdatabound event, it depends on the current rowstate, which controls exist and which not. For example, if you have a label in your itemtemplate and a dropdown in your
edititemtemplate, then the label will be null if rowstate == edit and the other way around.

So first check if RowState == Edit and then find your dropdown. you will not find the
controls shown during "view" rowstate (dont read viewstate:P).

GL

Re: Dropdownlist not displaying selectedItem in GridView

meeram3957-Jun-10 0:31

meeram395

7-Jun-10 0:31

Ok. Thanks a lot Michael. I have EditItemTemplate and ItemTemplate. As you said, I checked now only the dropdownlist and I'm getting the object. But how will I fix the selected value. Still it is displaying only the first value.

<asp:TemplateField HeaderText="REGIONCODE" SortExpression="REGIONCODE">
                <EditItemTemplate>
                    <asp:DropDownList ID="RegionCodeList" runat="Server" AppendDataBoundItems="true" >
                     <asp:ListItem Text="AM" ></asp:ListItem>
                    <asp:ListItem Text="US" ></asp:ListItem>
                    <asp:ListItem Text="EU"></asp:ListItem>
                    <asp:ListItem Text="JP" ></asp:ListItem>
                    <asp:ListItem Text="AS" ></asp:ListItem>
                    <asp:ListItem Text="OF" ></asp:ListItem>
                    </asp:DropDownList>
                </EditItemTemplate>
                    <ItemTemplate>            
                        <asp:Label ID="lblcountry" runat="server" Text = '<%# Eval("REGIONCODE") %>'></asp:Label>
                    </ItemTemplate>
            </asp:TemplateField>

As per the above, it always show the selected value as 'AM' rather than 'EU' which is the actual value selected. Following is my RowDataBoundEvent.

protected void grdTCCRics_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        

        if (e.Row.RowType == DataControlRowType.DataRow)
        {  
            
            if ((e.Row.RowState & DataControlRowState.Edit) > 0)
            {
                DropDownList ddlRegion = (DropDownList)e.Row.FindControl("RegionCodeList");
                if (ddlRegion != null)
                {
                    string strregion = ddlRegion.SelectedItem.Text;
                } 
                
            }
        }

Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.

Re: Dropdownlist not displaying selectedItem in GridView

michaelschmitt7-Jun-10 1:43

michaelschmitt

7-Jun-10 1:43

Hi,

you have to set the SelectedIndex of your DropDownList in this event (according
to the value of your DataItem)

Try something like this:

protected void grdTCCRics_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                if ((e.Row.RowState & DataControlRowState.Edit) > 0)
                {
                    DropDownList ddlRegion = (DropDownList)e.Row.FindControl("RegionCodeList");
                    if (ddlRegion != null)
                    {
                        // You have to replace VALUEFROMDATAITEM by the current region
                        // value of your DataItem (look in e.Row.DataItem, i dont know it)
                        ListItem item = ddlRegion.Items.FindByValue("VALUEFROMDATAITEM");
                        ddlRegion.SelectedIndex = ddlRegion.Items.IndexOf(item);

                        //string strregion = ddlRegion.SelectedItem.Text;
                        // You dont retrieve the value of the dropdown here, you set it
                    }
                }
            }
        }

I hope this helps

Re: Dropdownlist not displaying selectedItem in GridView - Resolved

meeram3957-Jun-10 1:41

meeram395

7-Jun-10 1:41

I got the solution. Below is the solution. It will be nice if it helps somebody else.

I have added the following along with the dropdownlist:

SelectedValue='<%# Bind("REGIONCODE") %>'

So the code will be:

<asp:TemplateField HeaderText="REGIONCODE" SortExpression="REGIONCODE">
               <EditItemTemplate>
                   <asp:DropDownList ID="RegionCodeList" runat="Server" AppendDataBoundItems="true" SelectedValue='<%# Bind("REGIONCODE") %>'  >
                   <asp:ListItem Text=""></asp:ListItem>
                    <asp:ListItem Text="AM" ></asp:ListItem>
                   <asp:ListItem Text="US" ></asp:ListItem>
                   <asp:ListItem Text="EU"></asp:ListItem>
                   <asp:ListItem Text="JP" ></asp:ListItem>
                   <asp:ListItem Text="AS" ></asp:ListItem>
                   <asp:ListItem Text="OF" ></asp:ListItem>
                   </asp:DropDownList>
               </EditItemTemplate>
                   <ItemTemplate>
                       <asp:Label ID="lblcountry" runat="server" Text = '<%# Eval("REGIONCODE") %>'></asp:Label>
                   </ItemTemplate>
           </asp:TemplateField>

That's it. I have tested so many times. It didn't give any issues.

Thanks
meeram395.

Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.

Re: Dropdownlist not displaying selectedItem in GridView - Resolved

michaelschmitt7-Jun-10 1:45

michaelschmitt

7-Jun-10 1:45

oh dear god, now THAT is simpler=). Thanks

DateFormat Problem in ASP.NET

sharad Pyakurel6-Jun-10 21:57

sharad Pyakurel

6-Jun-10 21:57

I have needed to insert and update DateTime Field in MSSQL Database Table. I am using Text Querry. My input Control is TextBox where the format of Date is "dd/MM/yyyy". In Database it should be save as "yyyy-MM-dd". I have used a Function to convert Date Format as:

public static string ConvertToDate(string pstr)
{
string result=string.empty;
try
{
result = "'" + Convert.ToDateTime(str).ToString("yyyy/MM/dd") + "'";
}
catch
{
result = System.Data.SqlTypes.SqlDateTime.Null.ToString();
}
}

The string Data Returned after conversion is used for insertion.

I I execute Application Visual studio by compiling it works well. but when i make virtual Directory of this application and run this through browser it doesn't work.

How can i solve this issue.

Re: DateFormat Problem in ASP.NET

saini arun6-Jun-10 22:06

saini arun

6-Jun-10 22:06

As far as I know there should not be any case for not working the same code from virtual directory if it works from visual studio.

Are you sure you set the correct path while configuring the virtual directory?

Re: DateFormat Problem in ASP.NET

walterhevedeich6-Jun-10 22:47

walterhevedeich

6-Jun-10 22:47

Perhaps providing us some error messages from your application can help us to figure out what the problem is.

Re: DateFormat Problem in ASP.NET

sharad Pyakurel7-Jun-10 1:38

sharad Pyakurel

7-Jun-10 1:38

Error when using virtual Directory is:
Exception Details: System.FormatException: String was not recognized as a valid DateTime.

Source Error:

Line 298: if (str.ToString().Trim().Length > 0)
Line 299: {
Line 300: result = "'" + Convert.ToDateTime(str).ToString("MM/dd/yyyy") + "'";
Line 301: }
Line 302: else

But it is ok from Visual Studio.

Re: DateFormat Problem in ASP.NET

walterhevedeich7-Jun-10 2:28

walterhevedeich

7-Jun-10 2:28

It will never be catched during compile time since its a runtime error. Try using DateTime.TryParse method. http://msdn.microsoft.com/en-us/library/system.datetime.tryparse.aspx[^]

Re: DateFormat Problem in ASP.NET [modified]

kupps7-Jun-10 21:09

kupps

7-Jun-10 21:09

Are you sure the current culture is the same between IIS and Visual Studio...?

Try outputting System.Globalization.CultureInfo.CurrentCulture.ToString() on both sites and see if there are any differences.

If this is different, then Convert.ToDateTime(str) will complain.

modified on Tuesday, June 8, 2010 4:16 AM

Re: DateFormat Problem in ASP.NET

sharad Pyakurel8-Jun-10 18:08

sharad Pyakurel

8-Jun-10 18:08

This problem is solved after changing Globalization setting in Web.Config File. Previously i had used en_US culture, Now it is changed to en_GB then problem is solved.

Thank you all for yours remarkable helps.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.