Текст пишу на русском, если писать на английском - все нормально.
Кодировка - cp1251
Код: Выделить всё
int ransv;
ransv = Convert::ToInt32(rans->Value);
ransv = ransv - 1;
String^ constring = L"datasource='" + this->path + "';port='" + this->port + "';username='" + this->usrname + "';password='" + this->password + "'";
MySqlConnection^ conDataBase = gcnew MySqlConnection(constring);
MySqlCommand^ cmdDataBase = gcnew MySqlCommand("set names cp1251; CREATE TABLE database." + textBox1->Text + " (id INT NOT NULL AUTO_INCREMENT, Vopros VARCHAR(250), Kolvo_Otvetov INT, Otvet1 VARCHAR(250), Otvet2 VARCHAR(250), Otvet3 VARCHAR(250), Otvet4 VARCHAR(250), Otvet5 VARCHAR(250), Otvet6 VARCHAR(250), Verniy_Otvet INT, PRIMARY KEY (id));", conDataBase);
MySqlCommand^ insertdb = gcnew MySqlCommand("insert into database." + textBox1->Text + "(Vopros, Kolvo_Otvetov, Otvet1, Otvet2, Otvet3, Otvet4, Otvet5, Otvet6, Verniy_Otvet) values ('" + this->richTextBox1->Text + "','" + this->ansnum->Value + "','" + this->ans0->Text + "','" + this->ans1->Text + "','" + this->ans2->Text + "','" + this->ans3->Text + "','" + this->ans4->Text + "','" + this->ans5->Text + "','" + ransv + "'); ", conDataBase);
MySqlDataReader^ myReader;
MySqlDataReader^ myReader2;
try{
conDataBase->Open();
//connectDB->ExecuteReader();
myReader = cmdDataBase->ExecuteReader();
myReader->Close();
myReader2 = insertdb->ExecuteReader();
while (myReader2->Read()){
}
richTextBox1->Text = "";
ans0->Text = "";
ans1->Text = "";
ans2->Text = "";
ans3->Text = "";
ans4->Text = "";
ans5->Text = "";
rans->Value = 1;
questionnum = questionnum + 1;
button3->Text = "Далее";
textBox1->Enabled = false;
}
catch (Exception^ex){
MessageBox::Show(ex->Message);
}
}
