Hi,
I am working on a project in that I want to dispaly the avablible quantity from database. I have write some code for that code is working. but It display entier data from frist row to last. I want to display only particular item avaliable quantity. can any one help me to slove the problem please....
Here is my code:
string val = textBox2.Text;
string contr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\praj\\sports shop\\database.mdb";
OleDbConnection cn = new OleDbConnection();
cn.ConnectionString = contr;
cn.Open();
string str = "select avbqut from ava where itnm=?val ";
OleDbCommand cmd = new OleDbCommand(str, cn);
cmd.CommandType = CommandType.Text;
OleDbParameter sql;
sql = cmd.Parameters.Add("?val",OleDbType.VarChar, 15);
sql.Value = val;
Please help me....