|
hi
i have access db and it has one table as "user" and 2 fields as "username" and "pass" and in user login Form in my app when input user and pass and click in enter_button the following message was shown :
Syntax error in FROM clause
my enter_button_click code is :
string str_com = "SELECT * FROM user WHERE username = '" + txt_user.Text + "' AND password = '" + txt_pass.Text + "'";
OleDbCommand command = new OleDbCommand(str_com, oleDbConnection1);
OleDbDataReader dr;
try
{
oleDbConnection1.Open();
dr = command.ExecuteReader();
if (dr.HasRows)
{
this.Hide();
Form_Main frm1 = new Form_Main();
frm1.Show();
}
else
{
MessageBox.Show("error"); }
}
finally
{
dr.Close();
oleDbConnection1.Close();
}
how to slove problem ??
thanks ..
|
|
|
|
|
"user" is a reserved word. Change the name of the table.
---
b { font-weight: normal; }
|
|
|
|
|
What does str_com expand to? Is user a reserved word in Access? Enclose the table name in square brakets like this [user]
What happens if the user types, as their user name, the following?
' OR 1=1; --
What is the code flow in that situation? What will be returned from the database if the user types that as a user name?
Your major problems are not syntax errors (because while you have syntax errors your application won't run and thus your data will be safe.) Your major problem is that your code is highly susceptable to a SQL Injection Attack (as I demonstrated above). You will likely wish to read about SQL Injection Attacks and how to prevent them.[^]
|
|
|
|
|
|
I have a Customize class that inherits a TreeView. This class has some extra properties, other than those from the TreeView. Is there a way to make this properties visible in the Properties box during design time?
|
|
|
|
|
Yes, you should insert:
[Browsable(true),
Description("..."),
Category("Design"),
DefaultValue("No Title")]
public String OwnTitle {
...
}
------------------------------
PROST Roleplaying Game
War doesn't determine who's right. War determines who's left.
|
|
|
|
|
I'm looking for a way to send a message from a desktop pc to a mobile device.
What's the easiest way to do that?
|
|
|
|
|
If you have a TCP/IP connection, then use TcpListener and TcpClient.
|
|
|
|
|
excuse me
first thanks for help
i want to set the DataBindings property for datagrid by dataview
but it send me an exception here is the code i wrote
DataView custadd=new DataView(customer.Tables["address"],"","",DataViewRowState.CurrentRows );
custadd.AllowEdit=true;
custadd.AllowNew=true;
custadd.AllowDelete=true;
custadd.Table =customer.Tables["address"];
custadd.RowFilter="cust_ID='"+txid.Text+"'";
dataGrid1.DataBindings.Add("DataSource",custadd, );
the databindings takes three arguments but i do not know the 3 argument
thanks
fatma
|
|
|
|
|
third argument is datamember where u have to specify table name
but i do not think it is possible to do databinding with dataview
u will still get the exception
so u can use datagrid.datasource = cusadd;
rahul
|
|
|
|
|
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties=Excel 8.0;HDR=Yes;IMEX=1"
Does it work with Excel 2003 or doen't ?
please help me
MD_NADA
|
|
|
|
|
"Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + Server.MapPath("../ExcelData.xls") + ";" +
"Extended Properties=Excel 8.0;";
|
|
|
|
|
How to read .xls file by giving the cell value and write the cellvalue in another .xls file at the same position using C#.net
Could u pls help me?
chandra999777
|
|
|
|
|
http://www.codeproject.com/csharp/excel_using_oledb.asp
|
|
|
|
|
Hi,
please help me out to check the CheckedListbox only one item at click, rest of the items should be unchecked.
|
|
|
|
|
It's easy :
Use the event CheckedChanged then write this kind of code :
Go to each item, checked whether the item is the item you just selected.
If yes, then set the property "Checked" to true, otherwise false;
|
|
|
|
|
i found the solution ,
CheckedIndex is previously selected item index.
private void chkProperties_ItemCheck(object sender, ItemCheckEventArgs e)
{
chkProperties.ItemCheck-=new ItemCheckEventHandler(chkProperties_ItemCheck);
chkProperties.SetItemChecked(CheckedIndex,false);
chkProperties.ItemCheck+=new ItemCheckEventHandler(chkProperties_ItemCheck);
CheckedIndex=e.Index;
}
|
|
|
|
|
hi,
maybe it's a stupid question, but i really need to know: is there a possibility to find out the amount of free space on a ftp server for an axisting account..? thanks
|
|
|
|
|
How many space you have - How many space you used = How many space is free
haha~
|
|
|
|
|
Thanks for the piece of code that u gave me yesterday, but I still have a problem. I need to create a USER INTERFACE PROGRAM that can LOAD,DISPLAY AND SAVE a bitmap file and I'm not really good in c# now so I can't really do it. Please if anybody can help me with that for now,I would be grateful. I need that for a project.
Please guys, help me out. 
tony-yeyo
|
|
|
|
|
You should look at the System.Drawing.Image class. There you find routines to Load and Save an Image. To Display one, you can use a panel or picturebox.
So try it and when you have a specific question or problem with the classes or functions ask again.
Regards,
Ingo
------------------------------
PROST Roleplaying Game
War doesn't determine who's right. War determines who's left.
|
|
|
|
|
Hi,
I´ve a designproblem how I shall compare values from two lists of data and finally store in a output. But the output is not the problem it is the mapping, comparing. For sure I can use a several of techniques for comparing data but Im looking for a optimal method in C# 2.0. Maybe I can use the generics List, Comparer etc...?
Ok, first I recieve a xml file via a webservice. I validate and transform it for prepering the mapping, see <sou<<<rcedatalist>. Second I get the mappingvalues from the database and bind to a List<>, xml!?!
It is the "SourceId" attribute I want to compare with a equal value from the second list. The SourceId is a generic attribute and e.g. "16481788" means street and "16481791" city, ok!?!
Below shows the sourcelist of data, the list of mapping values and a outputlist.
<br />
<br />
<SourceDataList><br />
<DataRow SourceId="16481788" value="21st street" dbType="string" /><br />
<DataRow SourceId="16481789" value="Manhattan" dbType="string" /><br />
<DataRow SourceId="16481790" value="2345" dbType="int" /><br />
<DataRow SourceId="16481791" value="New York" dbType="string" /><br />
</SourceDataList><br />
<br />
<MappingDataList><br />
<DataRow SourceId="16481788" DestId="21" /><br />
<DataRow SourceId="16481789" DestId="22" /><br />
<DataRow SourceId="16481790" DestId="23" /><br />
<DataRow SourceId="16481791" DestId="24" /><br />
</MappingDataList><br />
<br />
<OutputDataList><br />
<DataRow DestId="21" value="21st street" /><br />
<DataRow DestId="22" value="Manhattan" /><br />
<DataRow DestId="23" value="2345" /><br />
<DataRow DestId="24" value="New York" /><br />
</OutputDataList><br />
<br />
These three list only show the structure. I can treat them in any suitable format, e.g. generic lists etc. Maybe in performance purpose I want to make i xml batch insert into the database.
List1 List2 = XmlStream > Database
I hope you have good tips out there
Best regards
//Albin Malmgren
|
|
|
|
|
I'm sorry if this has been asked before - I have spent some time searching and not found an answer...
My question is this : I have developed a Usercontrol in C# / Winforms that is intended to be a child control of certain other controls, not developed by me. Is there any way that my control can 'listen' to it's parents events (specifically mouse events) and respond to them?? This seems like it should be trivial but I'm drawing a blank (too much PHP probably 
Thanks in advance
Ian Roberts
|
|
|
|
|
Control does have a Parent property. Did you try accessing that property and subscribing to its events?
|
|
|
|
|
Hi,
I have created a control, and added event handling capabilty throught delegates.
Now the problem here is, i want to use this control as a ActiveX control and i am unable to find a way to handle the events on the web page???
P.S. i have tried my control in windows application, it works fine! Also i have used delegates to expose my control's events for outside world, if you have a better( rather another) way i would love to see that.
Thanks in anticipation
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
