For Each s As String In TextBox1.Text
s = Regex.Replace(s, "[أإآا]", "[أإآا]")
s = Regex.Replace(s, "[هة]", "[هة]")
s = Regex.Replace(s, "[ىي]", "[ىي]")
s = Regex.Replace(s, "[وؤ]", "[وؤ]")
txt &= s
SQL = "select * from tpl1 where Description like '%" & txt & "%'"
Next(07-05-19, 08:16 PM)%Eman% كتب : [ -> ]ممكن الكود بالسى شارب
foreach (string s in TextBox1.Text)
{
s = Regex.Replace(s, "[أإآا]", "[أإآا]");
s = Regex.Replace(s, "[هة]", "[هة]");
s = Regex.Replace(s, "[ىي]", "[ىي]");
s = Regex.Replace(s, "[وؤ]", "[وؤ]");
txt += s;
SQL = "select * from tpl1 where Description like '%" + txt + "%'";
}
string[] hamazat = new[] {"إ", "أ", "آ", "ؤ"};
var textString = textBox1.Text;
foreach (var Rp in hamazat.ToArray())
{
if (Rp == "ؤ")
textString = textString.Replace(Rp, "و");
else
textString = textString.Replace(Rp, "ا");
}
MessageBox.Show(textString); MessageBox.Show(textString);textString
textBox1.Text