Skip to content
Loading
How to convert int month into string month of date type input: year i
  • Muhammad Imran Ansari

    Can you share the parameters list of UIPKGREPORTING_spFetchMonthlyAttendanceReport?

    +1
  •  

     @inFromDateTime is Year Form = dtp_FromDate
    @inToDateTime is Month Format = dtp_toDate

    0
  • Muhammad Imran Ansari
    What is the datatype of parameter @inToDateTime? It seems datatype is Integer and you are passing string value that why getting this exception.
    0
  •   Line Number 13 System.FormatException: 'String was not recognized as a valid DateTime.' 
    1. int Month = dtp_FromDate.Value.Month;  
    2.             int Year = dtp_FromDate.Value.Year;  
    3.   
    4.             string MonthNameWithMonth = CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(Month);  
    5.             string MonthNameWithYear = new DateTime(Year, Month, 1).ToString("yyyy-MM-dd");  
    6.   
    7.             SqlCommand cmd = new SqlCommand("UIPKGREPORTING_spFetchMonthlyAttendanceReport", connection);  
    8.             cmd.CommandType = CommandType.StoredProcedure;  
    9.             cmd.Parameters.Add("@inVolunteerID", SqlDbType.Int).Value = drp_Volunteer.SelectedValue;  
    10.             cmd.Parameters.AddWithValue("@inType", SqlDbType.VarChar).Value = drp_Type.Text;  
    11.             cmd.Parameters.AddWithValue("@inShift", SqlDbType.VarChar).Value = drp_Shift.Text;  
    12.             cmd.Parameters.AddWithValue("@inFromDateTime", Convert.ToDateTime(MonthNameWithYear).AddMonths(-1));  
    13.             cmd.Parameters.AddWithValue("@inToDateTime", DateTime.Parse(MonthNameWithMonth));
    14.   
    15.             MessageBox.Show(DateTime.Parse(MonthNameWithYear).AddMonths(-1).ToString() + "-" + MonthNameWithMonth);  
    16.   
    17.             cmd.Parameters.Add("@inPoints", SqlDbType.Int).Value = -1;  
    18.             SqlDataAdapter sda = new SqlDataAdapter(cmd);  
    19.             DataSet dt = new DataSet();  
    20.   
    21.             sda.Fill(dt, "abc");  
    22.             dataGridView1.DataSource = dt.Tables["abc"].DefaultView;  
    23.             labeltc.Text = dt.Tables["abc"].Rows.Count.ToString();  
    24.   
    25.             return dt.Tables["abc"];  
    0
  • Muhammad Imran Ansari
    You can use any way from below code:
    1. int Month = dtp_Year.Value.Month;  
    2. int Year = dtp_Year.Value.Year;  
    3.   
    4. string monthNameWithMonth = CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(Month);  
    5. string monthNameWithMonthYear = new DateTime(Year, Month, 1).ToString("MMM");  
     
    0