I made a T9 Dictianary [modified]

[C# Programming]

I made a T9 dictionary please take look I'am waiting your opinions.

Here is the code.

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace T9Sozluk
{
public partial class frmT9 : Form
{
public frmT9()
{
InitializeComponent();
}

SqlConnection Baglanti = new SqlConnection(Properties.Settings.Default.DBYolu.ToString());
SqlCommand Komut;
SqlDataReader dr;
string text = "", sonuc = "";
string[] dizi = new string[1];
int sayi = 0, deger=0, Lstart = 0, Lend = 0;
Point pnt;
bool swich = true;
bool show = true;

private void Form1_Load(object sender, EventArgs e)
{
Baglan(true);
listBox1.Hide();
}

public void Baglan(bool value)
{
if (value)
{
if (Baglanti.State == ConnectionState.Closed)
Baglanti.Open();
}
else if (!value)
{
if (Baglanti.State == ConnectionState.Open)
Baglanti.Close();
}
}

private void MakeSelection()
{
richTextBox1.SelectionStart = richTextBox1.TextLength;
richTextBox1.SelectedText = Convert.ToString(listBox1.SelectedItem);
sonuc = richTextBox1.Text;
sonuc = sonuc.Remove((Lend - sayi), sayi);
richTextBox1.Text = sonuc;
Lstart = richTextBox1.TextLength;
swich = true;
listBox1.Hide();
//richTextBox1.Cursor =
}

private void ShowSelection()
{
if (!show)
{

listBox1.Items.Clear();

Lend = richTextBox1.TextLength;
sayi = Lend - Lstart;
text = richTextBox1.Text;
if (Lstart > 3)
text = text.Remove(0,Lend-sayi);

text = text.TrimStart(Convert.ToChar(" "));
sayi = text.Length;
text = text + "%";

Komut = new SqlCommand("select count(kelimeadi) from kelimeler where " +
"kelimeadi like @KelimeAdi", Baglanti);
Komut.Parameters.Add("@KelimeAdi", SqlDbType.NVarChar).Value = text.ToString();


try
{
dr = Komut.ExecuteReader(CommandBehavior.SingleResult);
if (dr.Read())
deger = dr.GetInt32(0);
}
catch (Exception hata)
{
MessageBox.Show(hata.ToString());
}
dr.Close();
dr.Dispose();

if (deger>0)
{
Komut = new SqlCommand("Select Kelimeadi From Kelimeler Where" +
" KelimeAdi like @KelimeAdi", Baglanti);
Komut.Parameters.Add("@KelimeAdi", SqlDbType.NVarChar).Value = text;
dr = Komut.ExecuteReader();

if (dr.Read())
{
for (int i = 0; i < deger; i++)
{
dizi[0] = dr.GetString(0);
listBox1.Items.Add(dizi[0]);
dr.Read();
}
}
dr.Close();
dr.Dispose();
}

if (deger>0)
{
pnt = richTextBox1.GetPositionFromCharIndex(richTextBox1.TextLength);
pnt.X = pnt.X + 15;
pnt.Y = pnt.Y + 20;
listBox1.******** = pnt;
listBox1.Show();
}
}
}

private void Form1_KeyPress(object sender, KeyPressEventArgs e)
{
if ((e.KeyChar == 17))
{
show = false;
swich = false;
}
else
show = true;

if (!swich)
{
if (e.KeyChar == 13)
MakeSelection();
else
ShowSelection();
}
}

private void tsItemEkle_Click(object sender, EventArgs e)
{
Komut = new SqlCommand("Insert into Kelimeler(KelimeAdi) values(@KelimeAdi)", Baglanti);
Komut.Parameters.Add("@KelimeAdi", SqlDbType.NVarChar).Value = text.Remove(sayi);

try
{
Komut.ExecuteNonQuery();
MessageBox.Show("Kelime Listeye Eklendi...");
}
catch (Exception hata)
{
MessageBox.Show(Convert.ToString(hata));
}
return;
}
}
}


modified on Wednesday, May 6, 2009 4:46 PM