C# Discussion Boards - CodeProject

Sathesh Sakthivel6-Jun-07 20:56

Sathesh Sakthivel

6-Jun-07 20:56

Why are you creating the new thread for the same question.

pls correct it in the prevoius post itself.

Regards,

Satips. Rose | [Rose]

Pankaj - Joshi6-Jun-07 21:09

6-Jun-07 21:09

System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand();
cmd.Parameters.AddWithValue("@id", 1);
cmd.CommandText = "Select * from Emp Where EmpId=@id";

Regards
Pankaj Joshi

Tauseef A6-Jun-07 21:12

Tauseef A

6-Jun-07 21:12

but i am using dot net frame work 1.1 and there is not add with value

hello

blackjack21506-Jun-07 21:19

6-Jun-07 21:19

Use this pattern:

OleDbParameter param = new OleDbParameter();<br />
            param.DbType = DbType.Int32;<br />
            param.Value = 15;<br />
<br />
            command.Parameters.Add(param);

blackjack21506-Jun-07 21:16

6-Jun-07 21:16

Those are MySql named parameters.
He uses Access I think.

Tauseef A6-Jun-07 21:26

Tauseef A

6-Jun-07 21:26

private const string ConString ="Provider=MSDAORA;Data Source=ESPCS;User ID=espcs_users;Password=jtechusers;Persist Security Info=True";
private const string GetEmployeeByName= "select empno,name,grade,desgn,section from espcs.emp where status='T' and " +
" empno = @empno";

when i run this code it gives an exception "some error occured during processing of command"
public DataSet GetEmpByName(int name)
{

try
{
using (OleDbConnection con = new OleDbConnection (ConString))
{
con.Open ();
OleDbCommand com = new OleDbCommand (GetEmployeeByName ,con);

OleDbParameter par = new OleDbParameter ();
par.DbType = System .Data.DbType.Int32;
par.Value = name;

com.Parameters.Add(par);
OleDbDataAdapter dr = new OleDbDataAdapter (com);
DataSet ds = new DataSet ();
dr.Fill (ds);

return ds;

hello

Pankaj - Joshi6-Jun-07 21:41

6-Jun-07 21:41

Hi,
I don't why it giving error but I use same code as you use except I use the MSACCESS
as database and it is running successfully

public DataSet GetEmpByName(int empId)
{
string ConString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\test.mdb";
string GetEmployeeByName = "select * from Emp where Empid = @empno";
DataSet ds = new DataSet();
try
{
OleDbConnection con = new OleDbConnection(ConString);
con.Open();
OleDbCommand com = new OleDbCommand(GetEmployeeByName, con);

OleDbParameter par = new OleDbParameter();
par.DbType = System.Data.DbType.Int32;
par.Value = empId;

com.Parameters.Add(par);
OleDbDataAdapter dr = new OleDbDataAdapter(com);

dr.Fill(ds);

}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
return ds;
}
Rose | [Rose]

Regards
Pankaj Joshi

Pankaj - Joshi6-Jun-07 21:43

6-Jun-07 21:43

You Can also add the parameter name to like

par.ParameterName = "@empno"; Big Grin | :-D

Regards
Pankaj Joshi

blackjack21506-Jun-07 21:53

6-Jun-07 21:53

Yes, I think that's the problem. When using the @param form you soulb also specify the parameter name. But if you use unnamed parameters: ?, then there's no need for that. You just have to add them in the right order.

Button down issue

Soleil couchant6-Jun-07 20:48

Soleil couchant

6-Jun-07 20:48

I am designing a PDA application using the .NET CF, but I guess this issue would be the same irrespective of it being .NET Framework or .NET Compact Framework..

I have a button and I want to make it have like a button-down event. For example, a form has a mousedown and when the mouse button is down, there is an eventhandler mousedown for it.

I want my button to do the same. Note that the mousedown event doesn't exist for a button. Even setting a mousedown event on the form which contains the button doesn't do the trick (clicking the button does not fire the mousedown event of the form)..

what I want to do is have a facility in my application like while the button is being pressed (for example it can remain pressed for 5 seconds), keep changing the value of another control..

Any help would be highly appreciated.

Cheers,

David

blackjack21506-Jun-07 23:18

6-Jun-07 23:18

What if you use the mouse down event and check for the position of the cursor to be inside your button. Wouldn't that have the same outcome?

Soleil couchant6-Jun-07 23:20

Soleil couchant

6-Jun-07 23:20

I thought of that too.. But it doesn't help.. because when you click the button, the mousedown event of the form doesn't get fired

mav.northwind6-Jun-07 23:23

mav.northwind

6-Jun-07 23:23

What makes you think the MouseDown event doesn't exist for a Button?

According to the documentation, the MouseUp and MouseDown events are part of the Control class and supported in CF 1.0 and 2.0 as well.
Since Button inherits from Control, these events do exist.

Regards,
mav

--
Black holes are the places where God divided by 0...

Soleil couchant6-Jun-07 23:25

Soleil couchant

6-Jun-07 23:25

Well.. I can't find them in the property window of the button. I have KeyDown, KeyUp and a bunch of other events but not MouseDown and MouseUp.

Numer Problem

Pankaj - Joshi6-Jun-07 20:46

Re: You just missed an 'm'

6-Jun-07 20:46

Sir,
I am writing a program that return the current file size in MB
my file size in bytes is 4,412,471 and windows shows it 4.20 MB.

for that I write following code

System.IO.FileInfo objNew = new System.IO.FileInfo("C:\\\\test.rar");
decimal val=objNew.Length / 1048576;
string str = String.Format("{0:F2}", val);

but when i print the str it shows 4.00 what is the problem ...?

I think when (objNew.Length / 1048576) execute it give 4 not 4.2 please give me solution
Sigh | :sigh:

Regards
Pankaj Joshi

You just missed an 'm'

CPallini6-Jun-07 21:07

CPallini

6-Jun-07 21:07

pankaj.indore wrote:
decimal val=objNew.Length / 1048576;

change the above to:

decimal val=objNew.Length / 1048576m;

Try to discover why the avove solves Big Grin | :-D

If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.

Pankaj - Joshi6-Jun-07 21:47