Comments by jihad anwar (Top 12 by date)

thanks for every think
at last please the correct code for update option send to me again for here .
((* regards *))

thanks a lot for help me.
but i have same error in my code till now
and this code bellow to for "select" option is true
but for "update" has same problems

cod to select option :

OleDbCommand command = new OleDbCommand();
command.Connection = connect;
connect.Open();
string cmdstr = "select Count(key) from Table2 where key='" + richTextBox2.Text + "'";
OleDbCommand che1 = new OleDbCommand(cmdstr, connect);
int ku1 = Convert.ToInt32(che1.ExecuteScalar().ToString());
connect.Close();

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

namespace qamus
{
public partial class Form3 : Form
{
public Form3()
{
InitializeComponent();
}
OleDbConnection connect = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;DataSource=E:\qamus.mdb");

private void button1_Click(object sender, EventArgs e)
{

OleDbCommand cmd = new OleDbCommand();

cmd.CommandType = CommandType.Text;
cmd.CommandText = "UPDATE Table2 set check='2' where key='"+richTextBox2.Text+"' ";
cmd.Connection = connect;
connect.Open();
cmd.ExecuteNonQuery();
connect.Close();


}

private void richTextBox2_TextChanged(object sender, EventArgs e)
{

}
}
}

thanks

i checked it but i did not get correct answer.
please help me again

thanks
but not solved
please help me as son as possible to answer me
because i need it so mach .

please help me

thanks
but not solved