Comments by MeftahDAKHEEL (Top 51 by date)

Great, thanks now its working perfect, so i have to write the parameters twice

It's showing only the first Stock ID, even if i select the row 6

1 1 Bridgestone TC10 B 175/70R13
2 1 Bridgestone MY02 B 185/65R14
3 1 Bridgestone TC10 B 185/70R14
4 1 Bridgestone AR20 B 215/60R16
5 1 Bridgestone AR20 B 225/55R16
6 1 Bridgestone TG90 B 235/60R16
7 1 Bridgestone TC10 B185/65R15

for example:
StockID ProductID ProName ProType ProSize
1 1 Bridgestone TC10 B 175/70R13
2 1 Bridgestone MY02 B 185/65R14
3 1 Bridgestone TC10 B 185/70R14
4 1 Bridgestone AR20 B 215/60R16
5 1 Bridgestone AR20 B 225/55R16
6 1 Bridgestone TG90 B 235/60R16
7 1 Bridgestone TC10 B185/65R15
8 4 GoodYear GY101 GY 205/60R16


As per the data in Table (Store), but the result is always StockID = 1, the first catch, until i change product name from comboBox "combProdName", then it change with the first StockID related to the chosen productName.

const string ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|StoreSys.mdb";
const string Query = "SELECT TOP 1 StockID FROM Store WHERE ProductID = ? OR ProName = ? OR ProType = ? OR ProSize = ?";

using (var connection = new OleDbConnection(ConnectionString))
using (var command = new OleDbCommand(Query, connection))
{
// OleDb doesn't use named parameters, so only the order matters here:
command.Parameters.AddWithValue("p0", textProdID.Text);
command.Parameters.AddWithValue("p1", combProdName.Text);
command.Parameters.AddWithValue("p2", combProdSize.Text);
command.Parameters.AddWithValue("p3", combProdType.Text);

connection.Open();
txtStockID.Text = Convert.ToString(command.ExecuteScalar());
}


the result is the first StockID, and is not always the same

i really appreciate you kind help, thanks a lot, also your advice about the controls...

:) sure, i have forgotten, thanks a lot @Suvendu

I'm so sorry, i do know sir, and for what to shout, i learning so always kind, and an other thing English is not my tong language, anyway i am glad i have learned a lot from this website, i hope one day i could give a lot back to the CodeProject family, however i am facing this problem and its killing my time to solve it.

thanks a lot, SA

It's windo applications

It's windows application not ASP

load error, how to load it in designer??

Error 11 The name 'Server' does not exist in the current context D:\Graduation System\Graduation System\Form1.cs 58 29 Graduation System

in my PC

sorry i could not understand!

but the server is not exists i face an error

I HAVE INSTALLED THE X64, the one it should be

i have solved it myself, thanks a lot to every body

I have added all of them, after i searched on Google, but i still have the same problem

How can i add it? please let me know

CRYSTAL REPORTS® FOR VISUAL STUDIO 2010

Crystal Reports for Visual Studio 2010 is a free download for adding presentation quality reports to WPF, WinForms, and ASP.Net Web Sites.

Major new features include:

64-bit runtime
WPF viewer
Enhanced embedded report designer
Support for exporting to XLSX
sap.jpg Learn more and download Crystal Reports for Visual Studio 2010 today.

using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.ReportSource;
using CrystalDecisions.Shared;
using CrystalDecisions.Windows.Forms;

when i use those classes i face errors as following:

Error 2 The type or namespace name 'CrystalDecisions' could not be found (are you missing a using directive or an assembly reference?) D:\Graduation System\Graduation System\Form1.cs 10 7 Graduation System

using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.ReportSource;
using CrystalDecisions.Shared;
using CrystalDecisions.Windows.Forms;


when i use those classes i face the errors as following:

Error 2 The type or namespace name 'CrystalDecisions' could not be found (are you missing a using directive or an assembly reference?) D:\Graduation System\Graduation System\Form1.cs 10 7 Graduation System

Error 1 The type or namespace name 'CrystalDecisions' could not be found (are you missing a using directive or an assembly reference?) D:\Graduation System\Graduation System\Form1.cs 9 7 Graduation System

i could not use CrystalReportViewer, always errorrs, i use also using CrystalDecisions.CrystalReports.Engine;
& using CrystalDecisions.Shared; ... but show errors on name spaces

NO, i meant that the same error as when it was without SAP crystal insstalled

i made the above letter on on text, but i put another text to indicate the name, the ID, so on... what i need to link those texts with specific fields from my data-source, but it does not work!

i could not put values on the text in crystalreports

i wish you great morning Peter, thanks a lot, i am new to C# this is my graduation project Information System Diploma

@peter, thanks for your kind solution, but when made a numeric class, i face this error as follow:
Error 1 The type or namespace name 'NumberFormatInfo' could not be found (are you missing a using directive or an assembly reference?) C:\Users\Bisan\Documents\Visual Studio 2010\Projects\Graduation System\Graduation System\NumericTextBox.cs 21 9 Graduation System

i have the same problem, i tried to use your code, but told me Match not exists also Reges

thanks its corrict

@Arkadeep, it is good, thanks a lot

i need to check my code and update my mistaks please

i need to have a help with my code, i need to check if value exists in database and show a message...
=============================
my code
=============
private void btnSearch_Click(object sender, EventArgs e)
{


if (searchtext.Text == "")
{
MessageBox.Show("Plese Inter Employee's ID you are searching for");
searchtext.Focus();
}
else
{

OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\Employees.mdb");
OleDbDataAdapter ad = new OleDbDataAdapter("select * from Employee where EmpID=@EmpID", con);
ad.SelectCommand.Parameters.Add("@EmpID", OleDbType.Integer);
ad.SelectCommand.Parameters["@EmpID"].Value = int.Parse(searchtext.Text);


DataSet ds = new DataSet();
ad.Fill(ds, "Emp");
DGV1.DataSource = ds.Tables["Emp"];


if (ds == null)
{

MessageBox.Show("not found!!");

}
else
{
MessageBox.Show("The Employee you are searching for is listed down, if you want to update the data click the arrow sign on the lift side of the record");
}
}

i update the code, it working now, but i need to show a message if EmpID not found Please!!

When i find the EmpID it is ok and i got what i need, but in the case the EmpID not found nothing done, i need to check with IF condition,

Thanks @Sacha Lefevre, i appreciate, i will try...

thanks a lot, its almost done, only this

if (Information.IsNumeric(TextBox15.Text))

if you check it please.

Would you please if you know change it for me

if (Information.IsNumeric(TextBox3.Text))



also this please

if (Conversion.Val(TextBox18.Text) <= 74)


thanks a lot

@manchanx, i wanna tell you that the search code wont show me the resullt i need, would you please correct my code to speedup my programming skills

i really appreciate your advice, would you please check my updated code, i did what you ask to do, put the all employee class, and i tried to work with parameters!

i have updated my code, but when i search nothing appears