how to insert value in sqlserver RSS

• • Reply
  

  atul2430

  Member

  144 Points

  585 Posts

  how to insert value in sqlserver

  Jan 16, 2013 08:11 AM|LINK

  protected void btnSubmit_Click1(object sender, EventArgs e)
      {
  string FSExpiryDate = dt.ToString("yyyy-MM-dd HH:mm:ss");
  }
  
  DateTime dt;
       
      private void CalculateDate(int monthno, int yearno)
      {
         
          monthno=monthno+1;
          if (monthno == 1)
          {
              monthno = 12;
              yearno = yearno+ no - 1;
                         
          }
          else
          {
          monthno = monthno-1;
          yearno = yearno + no;
          }
  
         dt = new DateTime(yearno, monthno, 1);
          if (cb1year.Checked == true || cb2year.Checked == true || cb3year.Checked == true || cballyear.Checked == true)
          {
  
              LblFSmonth.Text = dt.ToString("MMMM-yyyy");
           
          }
         if (Rcb1year.Checked == true || Rcb2year.Checked == true || Rcb3year.Checked == true || Rcballyear.Checked == true)
          {
              lblrsexp.Text = dt.ToString("MMMM-yyyy");
          }
         
      }
   protected void ddlrjmonth_SelectedIndexChanged(object sender, EventArgs e)
      {
          CalculateDate(Convert.ToInt32(ddlrjmonth.SelectedIndex), Convert.ToInt32(ddlrjyear.SelectedValue));
      }
      protected void ddlrjyear_SelectedIndexChanged(object sender, EventArgs e)
      {
          CalculateDate(Convert.ToInt32(ddlrjmonth.SelectedIndex), Convert.ToInt32(ddlrjyear.SelectedValue));
      }

• • Reply
  

  jeevajsb

  Member

  159 Points

  377 Posts

  Re: how to insert value in sqlserver

  Jan 16, 2013 09:37 AM|LINK

  In Your code, you just getting the value from label... 

  Are you asking the Sql query to insert into Database... ?

  Regards
  Jeeva Jsb.
  
  [Mark as Answer on the post that helps you]
• • Reply
  

  atul2430

  Member

  144 Points

  585 Posts

  Re: how to insert value in sqlserver

  Jan 16, 2013 10:25 AM|LINK

  hi,

  
  

  i used label only for display expiry date.

  
  

  in datetime variable dt. i want to insert that value in database.

  i tried

  string expirydate=dt.tostring("yyyy-MM-dd");

  but getting error

• • Reply
  

  kszymaniak

  Member

  205 Points

  112 Posts

  Re: how to insert value in sqlserver

  Jan 16, 2013 09:40 PM|LINK

  I think that you are getting error because you are trying insert date as string into database where ( I suppose) database column format is date. You should convert string expirydate to date format in yr insert command or keep expirydate as DateTime format.

• • Reply
  

  jeevajsb

  Member

  159 Points

  377 Posts

  Re: how to insert value in sqlserver

  Jan 17, 2013 02:43 AM|LINK

  May be you're getting type mismatch..

  If you want to insert date as string, keep your database column as string..

  otherwise send as Date...

  Regards
  Jeeva Jsb.
  
  [Mark as Answer on the post that helps you]
• • Reply
  

  atul2430

  Member

  144 Points

  585 Posts

  Re: how to insert value in sqlserver

  Jan 17, 2013 04:34 AM|LINK

  i did but not able to insert..

• • Reply
  

  atul2430

  Member

  144 Points

  585 Posts

  Re: how to insert value in sqlserver

  Jan 17, 2013 04:34 AM|LINK

  i did but not able to insert.

  may i get code.

• • Reply
  

  prakashslm

  Member

  256 Points

  87 Posts

  Re: how to insert value in sqlserver

  Jan 17, 2013 09:34 AM|LINK

  Hi,

  DateTime dt;
  if ( DateTime.TryParseExact( "01/30/2013", "MM/dd/yyyy", new System.Globalization.CultureInfo( "en-US" ), System.Globalization.DateTimeStyles.None, out dt ) ) {
  	string exp = dt.ToString( "yyyy-MM-dd" );
  }

  
  
  

  be cool ....
  Thanks & Regards,
  Prakash
  
  http://prakash84slm.blogspot.com
  
  Remember to click “Mark as Answer” on the post, if it helps you.