C#

BobJanova wrote:

using myDateTimePicker.Value.ToString("yyyy-MM-dd") to get them in database
format

m_insert_cmd2.Parameters.Add("@DateStart", MySqlDbType.DateTime).Value = this.dateTimePicker1.Text;
m_insert_cmd2.Parameters.Add("@DateEnd", MySqlDbType.DateTime).Value = this.dateTimePicker2.Text;

m_insert_cmd2.Parameters.Add("@DateStart", MySqlDbType.DateTime).Value = this.dateTimePicker1.Text.ToString();
m_insert_cmd2.Parameters.Add("@DateEnd", MySqlDbType.DateTime).Value = this.dateTimePicker2.Text.ToString();

String was not recognized as a valid DateTime.

m_insert_cmd2 = new MySqlCommand("INSERT INTO tb_rezerwacja (kwota, ilosc_osob, w_tym_ilosc_dzieci, data_od, data_do, FK_pokoj_id, FK_zamowienie_id) VALUES (' 345', '3', '3', @DateStart, @DateEnd,  @pokoj_id,  @zamowienie_id)", m_conn);

string value="abc";
string result=string.Empty;

for(int i=0;i<=value.Length-1;i++)
{
   result+=value[i].ToString()+"\n";
}

for(int i=0;i<=value.Length-1;i++)
{
   if(i<value.Length-1)
   {
        result+=value[i].ToString()+value[i+1].ToString()+"\n";
   }
   else
   {
      result+=value[0].ToString()+value[value.Length-1].ToString()+"\n"+value;
   } 
}

string str = "anystring";

for (int x = 1; x <= str.Length; x++) // x = substring length
{
    for (int y = 0; y <= str.Length - x; y++) // y = start position
    {
        Console.WriteLine(str.Substring(y, x));
    }
}

Estys wrote:

input is "ABCD"?

Blue_Boy wrote:

Same question I asked