problem with checkbox and arabic when insert to sql server

ÃHmed Élkady

11y1.5kVisual Basic .NET

i had a group of check boxes that insert the checked values in 1 row each time by this code

SqlConnection sqlcon = new SqlConnection();

sqlcon.ConnectionString = @"Data Source=(local);Initial Catalog=cleopatra;Integrated Security=True";

List checks = new List();

foreach (Control cont in this.groupBox1.Controls)

{

if (cont is CheckBox)

{

if (((CheckBox)cont).Checked == true)

{

checks.Add(((CheckBox)cont).Text.ToString() + " , ");

}

sqlcon.Open();

SqlCommand sqlcmd = new SqlCommand("INSERT INTO pateint (mm) VALUES ( '" + string.Join(" ", checks) + "')", sqlcon);

sqlcmd.ExecuteNonQuery();

sqlcon.Close();

MessageBox.Show("ok");

and it insert as ???? marks i make it nchar and collation arabic

26 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajeesh Menoth11y ago
Hi ÃHmed Élkady,

Insert a new arabic value into your table.check the column name datatype as nvarchar.otherwise it's showing like this output ????.

Try again and put break point in your code behind...
Rajeesh Menoth11y ago
Hi ÃHmed Élkady,

It's working,You check and update..

The answer is helpful.Then please accept it..!!!
ÃHmed Élkady11y ago
still same problme
ÃHmed Élkady11y ago
i will try
Rajeesh Menoth11y ago
Hi ÃHmed Élkady,

Change your data type as nchar to nvarchar because nvarchar will take all types of characters.When you are using arabic language then you can use nvarchar as a data type.

Where ever your arabic content inserting into the table that particular column data type use nvarchar...

The answer is helpful.Then accept it because it will help for others...
Raja T11y ago
Please share your tried code and share screen shots design view...
ÃHmed Élkady11y ago
But i dont want it like that way i want to insert the text of the combobox no way to make it like that ??
Raja T11y ago
Hi, check out bellow URLs

http://www.codeproject.com/Questions/810980/Insert-Checkbox-value-in-database-in-asp-net-cshar

http://www.aspsnippets.com/Articles/Save-Insert-CheckBox-value-to-Database-in-ASPNet-using-C-and-VBNet.aspx
ÃHmed Élkady11y ago
can you pls explain this part to m again or give m a sample code
Raja T11y ago
Try and let me know
Raja T11y ago
When checked check box get corresponding value and store in db .

When you retrieving data from db here write logic based on value check the check box.
ÃHmed Élkady11y ago
i will try and see
Raja T11y ago
You can save check box value in db, don't save check box text. It is easy no problem for your requirement it is correct.
ÃHmed Élkady11y ago
I check it and the db accept arabic values and i maje msg box to show me it display me tge checked as arabic everything work but when insert from check box not work
Raja T11y ago
Hi, try like you can check in debug mode get select query and executed query in sqlserver. Don't execute via .net , directly executed

Or

You can check in sqlserver Arabic language insert in db for testing like

Insert into tbltest(arabiclan) values ('&&&&$$$$-&')

Inserted or not please check it
Raja T11y ago
Hi, try like you can check in debug mode get select query and executed query in sqlserver. Don't execute via .net , directly executed

Or

You can check in sqlserver Arabic language insert in db for testing like

Insert into tbltest(arabiclan) values ('&&&&$$$$-&')

Inserted or not please check it
ÃHmed Élkady11y ago
I make it nchar what more to do
Raja T11y ago
Hi, Please check datatype nchar to nvarchar more details checkout bellow url

http://www.c-sharpcorner.com/UploadFile/cda5ba/difference-between-char-nchar-varchar-and-nvarchar-data-ty/
ÃHmed Élkady11y ago
it still insert as ??? marks
Raja T11y ago
Hii,In App.config write bellow code
ÃHmed Élkady11y ago
??????
ÃHmed Élkady11y ago
yes i had an app.config in my project i think i must add something
Raja T11y ago
Hi, Are you created app.cofig file in ur project please check. I think ur not available in ur prjct so getting error like please check and let me know
ÃHmed Élkady11y ago
configurationsettings.appsettings object reference not set
ÃHmed Élkady11y ago
thank bro i will try but there is some errors pls if you can help me in it
Raja T11y ago
Yes, It is inserted into db.

for example check it

public string checkedvals = "";

string constr = ConfigurationSettings.AppSettings["ConnectionString"].ToString();

private void button1_Click(object sender, EventArgs e)
{

if ((!checkBox1.Checked)&&(!checkBox2.Checked)&&(!checkBox3.Checked)&&(!checkBox4.Checked))
{
MessageBox.Show("Please check at least one checkbox");
return;
}
else
{

if (checkBox1.Checked)
{
if (checkedvals != "")
{
checkedvals += checkBox1.Text + ",";
}
else
{
checkedvals = checkBox1.Text + ",";
}
}
if (checkBox2.Checked)
{
if (checkedvals != "")
{
checkedvals += checkBox2.Text + ",";
}
else
{
checkedvals = checkBox2.Text + ",";
}
}
if (checkBox3.Checked)
{
if (checkedvals != "")
{
checkedvals += checkBox3.Text + ",";
}
else
{
checkedvals = checkBox3.Text + ",";
}
}
if (checkBox4.Checked)
{
if (checkedvals != "")
{
checkedvals += checkBox4.Text + ",";
}
else
{
checkedvals = checkBox4.Text + ",";
}
}

string query = "";
query = "insert into tbl_demo (color) values('" + checkedvals.TrimEnd(',') + "')";
SqlConnection con = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Record Inserted Successfully");
checkBox1.Checked = false;
checkBox2.Checked = false;
checkBox3.Checked = false;
checkBox4.Checked = false;
}
}