split function in textbox and compare it to database

[ishtine18]

hello ! my thesis is all about language translation and im having a problem with the concatenation of strings in the textbox...because for example i input city kiss and it will display the ilocano(dialect) ili agek but when i input kiss city it still display ili agek

[ddanbe]

Hi ishtine18, welcome on Daniweb!
Could you post some code?
Without it it is hard to solve your problem.

[ishtine18]

public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

static string str_conn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Administrator\Desktop\thesis(data).mdb";
private OleDbConnection conn;
private OleDbDataAdapter da;
private DataSet ds;
private OleDbCommand Dictionary;
private OleDbDataReader dr;
string[] strSplit;
string strOne;

private void button1_Click(object sender, EventArgs e)
{
//strOne = textBox1.Text;
if (textBox1.Text == "")
{
MessageBox.Show("Please Enter Text in the Textbox!");
label5.Text = "";
}

if (comboBox2.SelectedItem == "Ilocano" && comboBox1.SelectedItem == "English")
{
strOne = textBox1.Text;
string seperator = "";
strSplit = textBox1.Text.Split(seperator.ToCharArray());
string complete = "";

foreach (string x in strSplit)
{
complete = complete + "'" + x.ToString() + "',";
}

Dictionary = new OleDbCommand("Select Ilokano FROM Dictionary where English IN ("+ complete + "'')", conn);
Dictionary.CommandType = CommandType.Text;
Dictionary.Connection = conn;
dr = Dictionary.ExecuteReader();
while (dr.Read())
{
label5.Text = label5.Text + " " + dr["Ilokano"].ToString();
}

}
else if (comboBox1.SelectedItem == "Ilocano" && comboBox2.SelectedItem == "English")
{
//strOne = textBox1.Text;
//string seperator = "";
//strSplit = textBox1.Text.Split(seperator.ToCharArray());
//string complete = "";
//foreach (string x in strSplit)
//{
// complete = complete + "'" + x.ToString() + "',";
//}

Dictionary = new OleDbCommand("Select English FROM Dictionary where Ilokano like" + "'%" + textBox1.Text + "%'", conn);
Dictionary.CommandType = CommandType.Text;
Dictionary.Connection = conn;
dr = Dictionary.ExecuteReader();
dr.Read();
//while (dr.Read())
//{
label5.Text = dr["English"].ToString();
//}
}

}

[ddanbe]

Please use code tags when you send some code.
Isn't it a problem you use both "llocano" and "llokano"?

[ishtine18]

Please use code tags when you send some code. Isn't it a problem you use both "llocano" and "llokano"?

okay sorry..im just new here :)

Ilocano is the name in the combobox..and Ilokano is the name of a column in the database...
and as i see its like the first data in the database is the one will be displayed first..hmm

[finito]

int LastSep=0;
for (int i=0; i< textBox1.Text.Length;i++)
{
  if (textBox1.Text[i] == ' ')
  {
    label5.Text += new OleDbCommand("Select English FROM Dictionary where Ilokano like" + "'%" +  textBox1.Text.SubString(LastSep,i-LastSep) + "%'", conn).ExecuteScaler().toString() + " ";
    LastSep=i;
  }
  if (i == textBox1.Text.Length-1 && textBox1.Text[textBox1.Text.Length-1] != ' ')
  {
        label5.Text += new OleDbCommand("Select English FROM Dictionary where Ilokano like" + "'%" +  textBox1.Text.SubString(LastSep,i-LastSep) + "%'", conn).ExecuteScaler().toString();
  }
}

Try this
I didn't have a compiler so there maybe syntax errors

Please let me know if you need clarification

I don't see where you opened the Connection

[Iswariya]

string s = txtValue.Text;
char[] delimeter={',','@','$',' ','#','%','*','\t'};
string[] word = s.Split(delimeter);
txtFName.Text = word[0];
txtLName.Text = word[1];
txtAge.Text = word[2];
txtDOB.Text = word[3];