Comments by Mohammed Ahmed Gouda (Top 50 by date)

okay but when i check if reader.read()==true it gives false and execute else statement

i changed it to sql2 do i have to make it cmd2 or not and it always gives me reader.read() false not true

??

same result

okay :)

i dont understand

no i am just trying to improve myself

* * * * *
* * * *
* * *
* *
*

thx a lot original and i am not storing password in database i am just trin ideas :)

sql = "select amount from data where password='" + txtpassword.Text + "'";
cmd = new SqlCommand(sql, con);
if (rdbAdd.Checked == true)
{

if (txtpassword.Text.Length == 7)
{
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
try
{
reader.Read();
amount=(int)reader["Amount"];

this is the error : Invalid attempt to read when no data is present.

i know i changed it :)

it gives me error cause there is no data in table how can i avoid this error ?

how?

it didnt work also may be i wrote the code in wrong place

the cursor remains after the string

the code :

private void textBox1_TextChanged(object sender, EventArgs e)
{
string sql = "insert into items values('" + textBox1.Text + "')";
cmd = new SqlCommand(sql, con);
if (textBox1.Text.Length > 7)
{
textBox1.Text=textBox1.Text.Remove(0, 7);
if (textBox1.Text.Length == 7)
{
try
{
con.Open();
cmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
MessageBox.Show(ex.ToString());
}
con.Close();
textBox1.SelectionStart = 0;
textBox1.ScrollToCaret();
}
}

the curosr didnt return to the start of textbox

it didnt work

it didnt work

no i want when the 8th char enter the text box i will take the first 7 char into DB

no i didnt delete any of my questions

I WANT TO MAKE BOOLEAN IF TEXT CHANGED BOOLEAN WILL BE TRUE IF NOT IT WILL REMAIN FALSE THIS WHAT I MEAN

okay and am sorry my english is bad :)

text box are not empty , no exception appears , data types are (nvarchar(50),nvarchar(50)and int)

i used ExecuteNonQuery but nothing happens

when i am running the sql server management studio i have to run it as administrator

i used it but nothing happens also :D

thx a lot

but i doesnt send a special character after reading barcode

scanner is motorola ds4208

how can i configure it using code or it is within its configuration

yeah it works put how can i make it lose focus automatically not manual.sorry i know am annoying but i am using this textbox with scanner so i want it after reading each string to put it in DB.

how ? sorry i am an amatuer

i am sorry

what about make a delay between each event ??

sorry for the late this is the link http://www.motorola.com/Business/US-EN/Business+Product+and+Services/Bar+Code+Scanning/Bar+Code+Scanners/General+Purpose+Scanners/DS4208

no it doesnt send an EOL

it is like u r writing in text box each time u write a new letter u want the old one to be deleted but this time with barcodes . sorry i konw i am annoying

i want if i scanned more than one item with different barcode barcodes appears in textbox and dont want to add them together

i just click scanner button and the barcode appears in the text box

it work but it just take the first number from the barcode and add it to DB

sorry but can u help me with the code coz i am an amatuer with programming ?

i want to extract data from barcode and show it on a richtext