C# Discussion Boards - CodeProject

6-Jul-09 11:31

Hi there:
Am making a login page using xml to get username and possword i want before dataview rowfilter to make column case sensitive which is the password and the other field in sensitive which is the username. I Tried to make the column in dataview case sensitive but i did know how? Could any one help me with this.

Manas Bhardwaj6-Jul-09 11:44

Manas Bhardwaj

6-Jul-09 11:44

I am not sure what exactly you want?
Could you post your code what you have done so far, so that some one can helpt you better.

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

kKamel6-Jul-09 11:47

6-Jul-09 11:47

DataSet ds = new DataSet();
DataTable dt = new DataTable();
string xmlPath=Server.MapPath("/Database/Credential.xml");
ds.ReadXml(xmlPath);
dt=ds.Tables[0];
DataView dv = new DataView();
dt=ds.Tables[0];
dv = dt.DefaultView;
//dv.Table.Columns["password"].
//dv.Table.Columns["username"].Table.CaseSensitive = false;

string rowFilter = "username = '"+this.txtUsername.Text+"' And password = '"+txtPassword.Text+"'";
dv.RowFilter=rowFilter;
//dt=(DataTable)dv;
if(dv.ToTable().Rows.Count==1)
Response.Write("<script>alert('Meche el 7al');</script>");

I want to check for case sensitive password column only

Manas Bhardwaj6-Jul-09 12:02

Manas Bhardwaj

6-Jul-09 12:02

khalil.kamel wrote:
string rowFilter = "username = '"+this.txtUsername.Text+"' And password = '"+txtPassword.Text+"'";
dv.RowFilter=rowFilter;

Well, .Net expression has a very limited capabitlites and it does not do all the things which can be done by SQL(for eg distinct, case expressions etc). So, the answer is you can not do this with RowFilter.

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

kKamel6-Jul-09 12:06

6-Jul-09 12:06

Ok thanx anyways i found another way to do it:
and i would like to share it:
First in the XML file he usernames should be in upper case:
and since the data view is case sensitive i would check for the upper case of the username and check the password as it is
here is the code

DataSet ds = new DataSet();
DataTable dt = new DataTable();
string xmlPath=Server.MapPath("/Database/Credential.xml");
ds.ReadXml(xmlPath);
dt=ds.Tables[0];
DataView dv = new DataView();
dt=ds.Tables[0];
dv = dt.DefaultView;
//dv.Table.Columns["password"].
dv.Table.Columns["username"].Table.CaseSensitive = true;

string rowFilter = "username = '"+this.txtUsername.Text.ToUpper()+"' And password = '"+txtPassword.Text+"'";
dv.RowFilter=rowFilter;
//dt=(DataTable)dv;
if(dv.ToTable().Rows.Count==1)
{
Response.Write("<script language='javascript' > alert('Meche el 7al'); </script>");
}

kKamel6-Jul-09 12:36

6-Jul-09 12:36

And Sorry to tell you it can be done but it is inefficient regarding the performance issues.
How it could be done:
DataSet ds = new DataSet();
DataTable dt = new DataTable();
string xmlPath=Server.MapPath("/Database/Credential.xml");
ds.ReadXml(xmlPath);
dt=ds.Tables[0];
DataView dv = new DataView();
dt=ds.Tables[0];
dv = dt.DefaultView;
dv.Table.CaseSensitive = false;//Set dv to case insensitive
dv.RowFilter="username ='"+txtUsername.Text+"'";//check for username
if (dv.ToTable().Rows.Count==1)//Valid Username
{
dt=dv.ToTable();//here i get the row that has the valid username and with its password and put it in DT
dv=dt.DefaultView;//then i reset the dv to the new dt
dv.Table.CaseSensitive=true;then i change the dv table to case sensitive
dv.RowFilter="password ='"+txtPassword.Text+"'";then i check for the password
if(dv.ToTable().Rows.Count==1)//if it retireved a record this means a valid password
{
//Code todo when login
}

}

PS: You might refine the code for better performance but the code i did above is better regarding performance

Please Rate If It helped and same thing for the code above

Design Ideas / nested DataGridView??

Ennis Ray Lynch, Jr.6-Jul-09 12:42

Ennis Ray Lynch, Jr.

6-Jul-09 12:42

Usually passwords are stored as binary data and not strings. This will fix your problem. Furthermore, if you store them in binary form you can just as easily store the hash plus a salt for security reasons instead of storing the password.

Need custom software developed? I do C# development and consulting all over the United States.

A man said to the universe:
"Sir I exist!"
"However," replied the universe,
"The fact has not created in me
A sense of obligation."
--Stephen Crane

Muammar©6-Jul-09 10:46

Muammar©

6-Jul-09 10:46

Hey everyone,
I have this simple financial budget-lines screen on which some budget line items may be branched to unknown levels, what control(s) would you use to design such screen??

I'm thinking maybe nested DataGridView?? If so then how can I do such a thing and still maintain good design.

Please advise.

All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)

Mycroft Holmes6-Jul-09 19:13

6-Jul-09 19:13

Look into the infragistics treeview in outlook express mode.

Or the objectlistview right here on CP will give you a tree on the left column with nomal cells in the rest of the control

Never underestimate the power of human stupidity
RAH

kKamel6-Jul-09 22:36

6-Jul-09 22:36

You better Use nested repeater and the first cell in a repeater item row put a button that would view the repeater within

Mycroft Holmes6-Jul-09 23:09

6-Jul-09 23:09

And a repeater is.

Never underestimate the power of human stupidity
RAH

Mohammad Mahdipour20-Oct-09 19:26

Mohammad Mahdipour

20-Oct-09 19:26

see Advanced TreeView for .NET in cp

----------
Eric(M.M)

Mycroft Holmes21-Oct-09 0:23

Re: Retrieve the PK after an add into an in memory DataTable

21-Oct-09 0:23

Now that looks like a cool control, pity the author does not seem to be supporting it!

Never underestimate the power of human stupidity
RAH

Message Removed

6-Jul-09 10:40

N_tro_P

6-Jul-09 10:40

Message Removed

Ennis Ray Lynch, Jr.6-Jul-09 12:44

Ennis Ray Lynch, Jr.

6-Jul-09 12:44

I'm not going to give you the answer but only because you put regions inside of methods.

Re: Retrieve the PK after an add into an in memory DataTable

Mycroft Holmes6-Jul-09 19:16