C#

int index = 2;
Console.WriteLine(myarr[index]);

string[] myarr = new[] { "a", "b", "c" };

string s = string.Join( "", myarr);

for ( int i = 1; i <= s.length; i++ ) {
   Console.Writeline( s.Substring( 0, i ) );
}

byte[] data = File.ReadAllBytes(@"D:\Temp\MyImage.bmp");
MemoryStream ms = new MemoryStream(data);
Image im = Image.FromStream(ms);

byte[] data = File.ReadAllBytes(@".\MyImage.bmp");
MemoryStream ms = new MemoryStream(data);
Image im = Image.FromStream(ms);

Image im = Properties.Resources.MyImage;

Dioxazine wrote:

If you came to me for guitar lessons I too could slice you to ribbons for all that you don't know.

Dioxazine wrote:

But that is a very poor way of teaching guitar.

Alex Dunlop wrote:

'There was an error parsing the query. [ Token line number = 1,Token line offset = 92,Token in error = End ]'

myCommand.CommandText = @"INSERT into [PMinfo] (Number, CostCenter, pType, ServiceType, Receiver, WorkCenter, Start, [End], Remaining, Status, ReceiveDate) values(@Number, @CostCenter, @pType, @ServiceType, @Receiver, @WorkCenter, @Start, @End, @Remaining, @Status, @ReceiveDate)";

System.NullReferenceException: 'Object reference not set to an instance of an object.'

System.NullReferenceException: 'Object reference not set to an instance of an object.'

Quote:

C#

dataGridView1.Rows[i].Cells[10].Value.ToString()

myCommand.Parameters.AddWithValue("@Number", dataGridView1.Rows[i].Cells[0].Value);
myCommand.Parameters.AddWithValue("@CostCenter", dataGridView1.Rows[i].Cells[1].Value);
myCommand.Parameters.AddWithValue("@pType", dataGridView1.Rows[i].Cells[2].Value);
myCommand.Parameters.AddWithValue("@ServiceType", dataGridView1.Rows[i].Cells[3].Value);
myCommand.Parameters.AddWithValue("@Receiver", dataGridView1.Rows[i].Cells[4].Value);
myCommand.Parameters.AddWithValue("@WorkCenter", dataGridView1.Rows[i].Cells[5].Value);
myCommand.Parameters.AddWithValue("@Start", dataGridView1.Rows[i].Cells[6].Value);
myCommand.Parameters.AddWithValue("@End", dataGridView1.Rows[i].Cells[7].Value);
myCommand.Parameters.AddWithValue("@Remaining", dataGridView1.Rows[i].Cells[8].Value);
myCommand.Parameters.AddWithValue("@Status", dataGridView1.Rows[i].Cells[9].Value);
myCommand.Parameters.AddWithValue("@ReceiveDate", dataGridView1.Rows[i].Cells[10].Value);

myCommand.Parameters.AddWithValue("@ReceiveDate", dataGridView1.Rows[i].Cells[10].Value.ToString());

myCommand.Parameters.AddWithValue("@ReceiveDate", dataGridView1.Rows[i].Cells[10].Value?.ToString());

private void btnSave_Click(object sender, EventArgs e)
      {
          update.PerformClick();
          SqlCeConnection connection = new SqlCeConnection();
          connection.ConnectionString = @"Data Source=C:\Users\Dell\Desktop\DataGridView\PMinfo.sdf";
          SqlCeCommand myCommand = new SqlCeCommand();
          myCommand.Connection = connection;

          connection.Open();
          //Clearing data table
          myCommand.CommandText = "DELETE FROM PMinfo";
          connection.Close();

          myCommand.CommandText = @"INSERT into [PMinfo] (Number, CostCenter, pType, ServiceType, Receiver, WorkCenter, Start, [End], Remaining, Status, ReceiveDate) values(@Number, @CostCenter, @pType, @ServiceType, @Receiver, @WorkCenter, @Start, @End, @Remaining, @Status, @ReceiveDate)";
          connection.Open();
          for (int i = 0; i < dataGridView1.Rows.Count; i++)
          {
              myCommand.Parameters.AddWithValue("@Number", dataGridView1.Rows[i].Cells[0].Value);
              myCommand.Parameters.AddWithValue("@CostCenter", dataGridView1.Rows[i].Cells[1].Value);
              myCommand.Parameters.AddWithValue("@pType", dataGridView1.Rows[i].Cells[2].Value);
              myCommand.Parameters.AddWithValue("@ServiceType", dataGridView1.Rows[i].Cells[3].Value);
              myCommand.Parameters.AddWithValue("@Receiver", dataGridView1.Rows[i].Cells[4].Value);
              myCommand.Parameters.AddWithValue("@WorkCenter", dataGridView1.Rows[i].Cells[5].Value);
              myCommand.Parameters.AddWithValue("@Start", dataGridView1.Rows[i].Cells[6].Value);
              myCommand.Parameters.AddWithValue("@End", dataGridView1.Rows[i].Cells[7].Value);
              myCommand.Parameters.AddWithValue("@Remaining", dataGridView1.Rows[i].Cells[8].Value);
              myCommand.Parameters.AddWithValue("@Status", dataGridView1.Rows[i].Cells[9].Value);
              myCommand.Parameters.AddWithValue("@ReceiveDate", dataGridView1.Rows[i].Cells[10].Value);


              myCommand.ExecuteNonQuery();
          }
          connection.Close();
      }

System.ArgumentException: 'The SqlCeParameter with this name is already contained by this SqlCeParameterCollection.'