|
Christian Graus wrote: that's hungarian notation
Not really used anymore.
Christian Graus wrote: P in front of method names was more bizarre
That got me scratching my head. Wondering what the hell that was.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
v: express variable of method
l: local in method.
vStrSQL = "select * from User where user = 'aaa' and passwd = 'bb';
I tested vStrSQL on MS Access. It is true.
It used folow:
vStrSQL = "select * from User where User = '" + txtUser.Text + "' and Passwd = '" + txtPassword.Text + "'";
DataTable lTbl = mUti.PGetDataTable(mConnectString, mStrSQL, "tbl");
////
Error ...
System.Data.OleDb.OleDbException: Syntax error in FROM clause.
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
|
|
|
|
|
Sorry! It is not contain mUti.
It correct:
DataTable lTbl = PGetDataTable(mConnectString, mStrSQL, "tbl");
|
|
|
|
|
Why do your methods start with a P ?
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Got me on that one 
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
May be, P = procedure.
But wait do we have procedures in C#. Atleast I am not aware.
Loading signature. Please wait...
|
|
|
|
|
thuyphuongid wrote: v: express variable of method
l: local in method.
Can I suggest you do this with casing instead ? In any case, why does it matter, if a variable was passed in, unless it's a class ?
You realise that your code means I can erase your database during the login process if I feel like it ? Research SQL Injection attacks.
Could it be that you're calling a method that requires only a single result, but you're doing a select * ? What if you do a select Top 1 * ?
Or could it be because your table name and a column name are the same ?
The SQL itself looks fine, you are right there.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Ok. Thank you for your help. See u later.
|
|
|
|
|
In your code, as Christian has said, you are open to sql injection attacks with the string concatenation. Read this fine article preventing sql injection attacks[^]. It is a very good reading and worth bookmarking.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
Christian Graus wrote: Research SQL Injection attacks
I noticed that with the wonderful string concatenation going on there.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
I have created this wallapaper in Fireworks. Please give me the comments. To view full goto: Click Here
Software Development & Web Development is my addiction. I am a Visual C# 2.0 and ASP.NET 2.0 Developer and working in Visual Studio 2005 using Dot Net Framework 2.0.
Email: bottomless.wisdom@hotmail.com
Web: http://bottomless-wisdom.spaces.live.com
|
|
|
|
|
|
|
Pretty stupid IMO.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
[Homer Simpson voice over] Lame [/Homer Simpson voice over]
Thanks for wasting 5 seconds of my afternoon 
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
YOU ARE AN IDIOT.
Blog link to be reinstated at a later date.
|
|
|
|
|
Not nearly innovative or witty enough to make it to my desktop. If there is a war, you missed it being new by about eight years. Also, the image doesn't reflect on any of the aspects of either programming language, any of their differences, or the people involved in the "war".
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
I have expresses the difference between C# and VB in this wallpaper. C# is shown more powerful than VB in this wallpaper. 
Software Development & Web Development is my addiction. I am a Visual C# 2.0 and ASP.NET 2.0 Developer and working in Visual Studio 2005 using Dot Net Framework 2.0.
Email: bottomless.wisdom@hotmail.com
Web: http://bottomless-wisdom.spaces.live.com
|
|
|
|
|
Whats a wallapaper? Some kind of new toilet paper?
xacc.ide - now with TabsToSpaces support IronScheme - 1.0 beta 1 - out now! ((lambda (x) `((lambda (x) ,x) ',x)) '`((lambda (x) ,x) ',x))
|
|
|
|
|
Hi
i have a BindingList<listitem> and i want to check if the list contains an object of ListItem. But the Contains method of the BindingList<> always returns false. can anyone tell me why? and what should i do?
BindingList<listItem> normalExtItems = new BindingList<listItem>();
extItem = new listItem(Number,Name,Id));
if(normalExtItems.Contains(extItem))
{
}
modified on Sunday, November 30, 2008 5:54 PM
|
|
|
|
|
Hi,
I don't see any line of code adding something to normalExtItems, so it seems obvious Contains() returns false no matter what.
|
|
|
|
|
Since this is obviously partial code, do you insert extItem into the bindinglist somewhere. The code you posted cannot find extItem in the list because it's not added to it.
|
|
|
|
|
yes, sure bindinglist has ListItems. Because it was in a long loop, i didn't add it to the code here. sorry it was not clear
|
|
|
|
|
Just a simple test case. Didn't know what your listitem type was, but it doesn't matter. The following works as expected:
System.Web.UI.WebControls.ListItem extItem;
System.ComponentModel.BindingList<System.Web.UI.WebControls.ListItem> normalExtItems
= new System.ComponentModel.BindingList<System.Web.UI.WebControls.ListItem>();
extItem = new System.Web.UI.WebControls.ListItem("A","1", true);
normalExtItems.Add(extItem);
if(normalExtItems.Contains(extItem)) {
}
Have you checked (using debugger) that the list actually contains the item you're interested in.
|
|
|
|
|
yes, no matter the list has the item or not, it always returns false, i have checked that so many times 
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
