get month from date string in c#.net

Question

3.00/5 (2 votes)

See more:

Hello,
I am working on C#,

code for .aspx
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="id"
OnPageIndexChanging="GridView1_PageIndexChanging"
OnRowCommand="GridView1_RowCommand" PageSize="10"
class="table table-striped table-bordered datatables"
AllowPaging="True" >
<columns> <asp:TemplateField HeaderText="Employee Name">
<itemtemplate>
<asp:Label ID="lblempname" runat="server" Text='<%#Eval("empname") %>' />

<asp:TemplateField HeaderText="Work Type">
<itemtemplate>
<asp:Label ID="lblworktype" runat="server" Text='<%#Eval("worktype") %>' />

<asp:TemplateField HeaderText="Company Name">
<itemtemplate>
<asp:Label ID="lblcompanyname" runat="server" Text='<%#Eval("companyname") %>' />

<asp:TemplateField HeaderText="Date">
<itemtemplate>
<asp:TextBox ID="txtdate" runat="server" class="form-control"> <asp:CalendarExtender ID="txtdate_CalendarExtender" runat="server" Enabled="True" TargetControlID="txtdate" Format="dd/MM/yyyy">

<asp:TemplateField HeaderText="Start Time">
<itemtemplate>
<asp:TextBox ID="txtstime" class="timepicker form-control" runat="server">

<asp:TemplateField HeaderText="End Time">
<itemtemplate>
<asp:TextBox ID="txtetime" class="timepicker form-control" runat="server" >

<asp:TemplateField HeaderText="Attendance Symbol">
<itemtemplate>
<asp:DropDownList ID="ddlattsysmbol" runat="server" class="form-control" DataSourceID="SqlDataSource1"
DataTextField="shortname" DataValueField="id" AppendDataBoundItems="true">
<asp:ListItem Value="">Select Any One

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:HRMConnectionString %>"
SelectCommand="SELECT DISTINCT * FROM [sysmbol_attend] WHERE ([cid] = @cid)">
<SelectParameters>
<asp:SessionParameter Name="cid" SessionField="CompanyID" Type="Int32" />
</SelectParameters>

<asp:TemplateField>
<itemtemplate>
<asp:ImageButton ID="imgbtnAdd" runat="server" ImageUrl="~/images/AddNewitem.jpg"
CommandName="AddNew" Width="30px" Height="30px" ToolTip="Add new User" ValidationGroup="a" />

<pagersettings mode="NextPreviousFirstLast" pagebuttoncount="4" previouspagetext="Previous">
NextPageText="Next" FirstPageText="First" LastPageText="Last" />

.cs
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "AddNew")
{
GridViewRow row = (GridViewRow)((ImageButton)e.CommandSource).NamingContainer;
String curdate = (row.FindControl("txtdate") as TextBox).Text;
}

In curdate string i am getting the output is '29/07/2014' , I want to also get month from my curdate string output like '07'.

Posted 1-Aug-14 19:24pm

Pratham4950

Add a Solution

3 solutions

Solution 1

You could simply use string.SubString - that's trivial - but don't.
Instead, parse the date input using DateTime.TryParse and the user culture to get a DateTime, and get the month from that.

Posted 1-Aug-14 20:06pm

OriginalGriff

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Nirav Prabtani** · Accepted Answer · 2014-08-01T20:28:00

Solution 3

First read solution of Sergey Alexandrovich Kryukov (Solution 2) and than if you still go woth string than try my solution.. :)

C#

string curdate = "29/07/2014";

string Month = curdate.Split('/')[1].ToString();

Posted 1-Aug-14 20:28pm

Nirav Prabtani

Sergey Alexandrovich Kryukov · Accepted Answer · 2014-08-01T20:07:00

Don't work with sheer strings in .NET. Instead, parse a string into System.DataTime, it will give you the pure data. Then manipulate it and use ToString to get string representation of data. Please see all the methods called Parse, TryParse, ParseExact and TryParseExact, and also ToString here:
http://msdn.microsoft.com/en-us/library/system.datetime%28v=vs.110%29.aspx[^],
see also http://msdn.microsoft.com/en-us/library/system.datetime.month(v=vs.110).aspx[^] :-).

—SA