ASP.NET

Re: bug wit the standard provider???

20-Mar-07 23:57

i notice that the standard provider for the create new user part
the password keep requireing a @ and min 7 chracter

yet the email dont bug? or am i wrong somewhere? lol

szukuro21-Mar-07 0:06

szukuro

21-Mar-07 0:06

The password by default requires at least seven characters of which at least one must be a non-alphanumerical character, for which '@' is satisfactory, though not necessary. Verifying email adresses is quite complicated, therefore no validation is set by default, however you can set the EmailRegularExpression property to a custom regular expression.

Re: bug wit the standard provider???

neodeaths21-Mar-07 15:47

could any convert this to asp.net c#?

21-Mar-07 15:47

omg i now understand!!!
thx!

feel kinda embaress wit my question now lol

must be working too hard =P

anyway thx

neodeaths20-Mar-07 22:42

20-Mar-07 22:42

could anyone roughly convert the below code into c# i am trying to learn thx

Dim strSQL, strConn As String
Dim dbcon As New OleDbConnection

intlevel = 0

strConn = "Provider=Microsoft.Jet.OLEDB.4.0;"
strConn += "Data Source=Computer Store.mdb;User ID=Admin; Password=;"
dbcon.ConnectionString = strConn

strSQL = "Select * from Employee where EmployeeID ='" & txtusername.Text.Trim & "' and EmpPassword ='" & txtpassword.Text.Trim & "'"

Dim cmdselectcommand As New OleDb.OleDbCommand(strSQL, dbcon)
dbcon.Open()

Dim dtlogin As OleDbDataReader = cmdselectcommand.ExecuteReader
If (dtlogin.Read() = True) Then
MsgBox("Login OK")
Dim main As New form1
intlevel = CType(dtlogin.Item("EmpPrivilege"), Integer)
main.Show()
Me.Close()
Else
MsgBox("Login Fail")
Me.txtpassword.Text = ""
Me.txtusername.Text = ""
Me.txtusername.Focus()
End If

dtlogin.Close()
dbcon.Close()

N a v a n e e t h20-Mar-07 22:57

20-Mar-07 22:57

neodeaths wrote:
Dim strSQL, strConn As String
Dim dbcon As New OleDbConnection

string strSQL,strConn = string.empty;
OleDbConnection dbcon = new OleDbConnection();

neodeaths wrote:
strSQL = "Select * from Employee where EmployeeID ='" & txtusername.Text.Trim & "' and EmpPassword ='" & txtpassword.Text.Trim & "'"

In this & should be replaced with + and Trim() should be written like this

txtusername.Text.Trim();

neodeaths wrote:
Dim cmdselectcommand As New OleDb.OleDbCommand(strSQL, dbcon)

OleDb.OleDbCommand cmdselectcommand = new OleDb.OleDbCommand(strSQL,dbcon)

neodeaths wrote:
Dim dtlogin As OleDbDataReader = cmdselectcommand.ExecuteReader

OleDbDataReader dtlogin = cmdselectcommand.ExecuteReader();

neodeaths wrote:
If (dtlogin.Read() = True) Then

if( dtlogin.Read() )
{
    //Write your code
}

neodeaths wrote:
MsgBox("Login OK")

MessageBox.Show("Message")

neodeaths wrote:
Dim main As New form1
intlevel = CType(dtlogin.Item("EmpPrivilege"), Integer)

form1 main = new form1();
intlevel = (int)dtlogin.Item["EmpPrivilege"];

Put semicolumn at the end of each statement. ( Not for If ) D'Oh! | :doh:

printf("Navaneeth!!")

www.w3hearts.com

neodeaths20-Mar-07 23:34

20-Mar-07 23:34

thx i rougly understand wat you are tryign to tell me

but i just cant get it to work >.<

i am just trying to make a simple login function which filter out the username and password from an sql database and lets me login

any pointers,samples or hints would really be appreciated

hard to learn login,logout from books alone >.<

varshavmane20-Mar-07 23:46

varshavmane

20-Mar-07 23:46

Use this whenever u want to convert code in VB or C#

http://www.kamalpatel.net/ConvertCSharp2VB.aspx

AND

http://www.carlosag.net/Tools/CodeTranslator/Default.aspx

Hope this will help u in future.......

databinding to button control

Dave Doknjas21-Mar-07 15:00

Dave Doknjas

21-Mar-07 15:00

(via Instant C#):

string strSQL = null;
string strConn = null;
OleDbConnection dbcon = new OleDbConnection();

intlevel = 0;

strConn = "Provider=Microsoft.Jet.OLEDB.4.0;";
strConn += "Data Source=Computer Store.mdb;User ID=Admin; Password=;";
dbcon.ConnectionString = strConn;

strSQL = "Select * from Employee where EmployeeID ='" + txtusername.Text.Trim() + "' and EmpPassword ='" + txtpassword.Text.Trim() + "'";

OleDb.OleDbCommand cmdselectcommand = new OleDb.OleDbCommand(strSQL, dbcon);
dbcon.Open();

OleDbDataReader dtlogin = cmdselectcommand.ExecuteReader();
if (dtlogin.Read() == true)
{
MessageBox.Show("Login OK");
form1 main = new form1();
intlevel = System.Convert.ToInt32(dtlogin["EmpPrivilege"]);
main.Show();
this.Close();
}
else
{
MessageBox.Show("Login Fail");
this.txtpassword.Text = "";
this.txtusername.Text = "";
this.txtusername.Focus();
}

dtlogin.Close();
dbcon.Close();

David Anton
www.tangiblesoftwaresolutions.com
Instant C#: VB to C# converter
Instant VB: C# to VB converter
Instant C++: C# to C++ converter, VB to C++ converter
Instant Python: C# to Python converter, VB to Python converter

kallileo20-Mar-07 22:41

kallileo

20-Mar-07 22:41

Hi,
I have only one record in my sql server express table and I need to update(toggle) a boolean value every time I press a button on my asp.net page.
Any help would be appreciated....

Re: databinding to button control

N a v a n e e t h20-Mar-07 23:04

Re: databinding to button control

20-Mar-07 23:04

Update the flag each time. Check database value. If it is true then update it to false.? what's the Confused | :confused:

confusion ?

printf("Navaneeth!!")

www.w3hearts.com

kallileo20-Mar-07 23:21

kallileo

20-Mar-07 23:21

The confusion is that I have just started programming...and I'm not very experienced.
I created a web site were I presenting data from a database with gridviews and datalists. The only update command I need is this botton.

My thought:
I need an event lets say "OnClick" and a Sub that corresponds to onclick event has the db connection, "checking code" and the SQL code to update the record.

Am I right?

Thank you for your reply...

Authentication

nclauder20-Mar-07 22:40

nclauder

20-Mar-07 22:40

Hi,
I have this datagrid that inserts data and I want to know who ever has inserted data through his login name when starting computer. How could I do this? I have tried Windows Authentication but it does not work?
I've added Authentication Mode="windows", identity impersonate="true", and The IIS I've Unchecked: Anonymous access and Checked: Intergrated Windows authentication. But no change is being made.
Thanks.

Re: Authentication

N a v a n e e t h20-Mar-07 23:05

20-Mar-07 23:05

nclauder wrote:
I have this datagrid

Which ?

printf("Navaneeth!!")

www.w3hearts.com

Re: Authentication

nclauder21-Mar-07 1:50

nclauder

21-Mar-07 1:50

A datagrid that inserts data. I mean using edit,Update and cancel. It actually inserts data into SQlserver. But the inserting code is not the problem, my problem is I want to know Which ever user has inserted data. Like when some one login his computer and uses the datagrid I want the user name to be automatically in datagrid.
Thanks

sql server error

saravanan0520-Mar-07 22:23

saravanan05

20-Mar-07 22:23

hi friends

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'NEW\ASPNET'.

i got above error on when i run the my ASP.NET applicaion.

plz give me the solution

regards
saravanan

Re: sql server error

Guffa20-Mar-07 22:36

Guffa

20-Mar-07 22:36

It looks like you are trying to use integrated security, but haven't added the ASPNET user as a user in the database.

---
single minded; short sighted; long gone;

Re: sql server error

N a v a n e e t h20-Mar-07 22:58

how to move folder and files from a folder tree in ASP.NET

20-Mar-07 22:58

saravanan05 wrote:
Login failed for user 'NEW\ASPNET'.

Show me your connection string

printf("Navaneeth!!")

www.w3hearts.com

rajnish_haldiya20-Mar-07 21:58

rajnish_haldiya

20-Mar-07 21:58

Hi all,

I have a problem as follow.
I have a file/folder tree in my CMS - web site. this tree shows all the name of file and folder existing for a web site in tree view.
The list of names in this tree view list is coming from a XML file, and the real location of every file is saved in database.

So what i need to do is to make such functionality , that i could move the folders and files in this tree anywhere.

For this i need to first make changes in xml file from where the filename list is coming in tree view. and also i need to update the location for related file in database.

Could any one help me to develop such functionality.

address of button

vengaqua20-Mar-07 21:17

vengaqua

20-Mar-07 21:17

I am adding three buttons for every new question. suppose i have two questions then i have two pairs of three buttons all having different ids.
If i click the first button then i want the id of this button and if i click the second button i want his id.And i have this function which i am calling in the form load event.In this function i am adding controls at runtime.Is this ok.It is very urgent.

Mohinder Singh

Re: address of button

N a v a n e e t h20-Mar-07 23:02