C#

string query = "insert into Data(Product,discription) values('" + textBox1.Text + "','" + textBox2.Text + "''&& ''" + textBox3.Text + "')";

neodeaths wrote:

i am having trouble saving the edited file back into the same file which i open from.

//41 digit number string
string originalNumberString = "3454587632090873454498766009893432389887";

char[] numberValues = originalNumberString.ToCharArray();
int numberLength = numberValues.Length;
int originalLength = numberValues.Length;
string binaryNumber = string.Empty;

do
{
   char[] newNumberString = new char[numberLength];
   double remainderValue = 0.00;

   //Divide the string number by 2
   foreach (char numberValue in numberValues)
   {
      double valueNumber = (double.Parse(numberValue.ToString()) / 2) + remainderValue;
      remainderValue = (valueNumber % 1) * 10;

      newNumberString[originalLength - numberLength] = (valueNumber - (valueNumber % 1)).ToString().ToCharArray()[0];

      --numberLength;
   }

   //If there is a remainder the bit value is 1 else 0
   binaryNumber +=  (remainderValue > 0 ? 1 : 0);
   int offSetValue = (newNumberString[0] == '0' ? 1 : 0);

   numberValues = new char[numberValues.Length - offSetValue];
   Array.Copy(newNumberString, offSetValue, numberValues, 0, numberValues.Length);
   numberLength = numberValues.Length;
   originalLength = numberValues.Length;
} while (originalLength > 0);

//Add extra zeros to fit 8bits to a byte exactly
while (((binaryNumber.Length / 8.0) % 1) > 0)
{
   binaryNumber += "0";
}

//Reverse the order of the bits in the string so it is MSB to LSB.
char[] charArray = binaryNumber.ToCharArray();
Array.Reverse(charArray);
binaryNumber = new string(charArray);

//Convert the binaryString value to a byte array index 0 will be the MSB value to to the array reverse code above.
//If you want index 0 to be the LSB then omit the array reversing code above.
byte[] numberArray = new byte[binaryNumber.Length / 8];
System.Collections.BitArray bitArray = new System.Collections.BitArray(binaryNumber.Length);
for (int bitIndex = 0; bitIndex < binaryNumber.Length; ++bitIndex)
{
   bitArray[bitIndex] = (binaryNumber[bitIndex] == '1' ? true : false);
}
bitArray.CopyTo(numberArray, 0);