|
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.
|
|
|
|
|
omg i now understand!!!
thx!
feel kinda embaress wit my question now lol
must be working too hard =P
anyway thx
|
|
|
|
|
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()
|
|
|
|
|
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() )
{
}
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 )
|
|
|
|
|
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 >.<
|
|
|
|
|
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.......
|
|
|
|
|
(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
|
|
|
|
|
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....
|
|
|
|
|
Update the flag each time. Check database value. If it is true then update it to false.? what's the confusion ?
|
|
|
|
|
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...
|
|
|
|
|
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.
|
|
|
|
|
nclauder wrote: I have this datagrid
Which ?
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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;
|
|
|
|
|
saravanan05 wrote: Login failed for user 'NEW\ASPNET'.
Show me your connection string
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
vengaqua wrote: f i click the first button then i want the id of this button and if i click the second button i want his id
You can use button.clientId
vengaqua wrote: And i have this function which i am calling in the form load event
Which function ? I m not seeing anything
|
|
|
|
|
i have a function that adds the controls at runtime and i generate their ids at that time.And i am calling this function in the form load event. outside that function i dont have access to the buttons. Now tell me how to do it.i want the id of the button i click.I need this thing very urgently.Please hel me dear.
Mohinder Singh
|
|
|
|
|
Hi everybody. Anyone help me.
I have a table in SQL 2000 with one of the colume is image data. But when I load this column to my Datagrid (in VB.Net, ASP.Net), I don't know how my Datagrid show the picture i inserted.
If someone know how to do this, Please help me. Thanks too much.
My email is: aeriscute@yahoo.com
Hanh Aeriscute
|
|
|
|
|
take new page page called image.aspx and write below code in its codebehind page.
protected void Page_Load(object sender, EventArgs e)<br />
{<br />
MemoryStream stream = new MemoryStream();<br />
SqlConnection connection = new<br />
SqlConnection(@"server=servername;database=DBname;uid=sa;pwd=ccc");<br />
try<br />
{<br />
connection.Open();<br />
SqlCommand command = new<br />
SqlCommand("select image_name from image", connection);<br />
byte[] image = (byte[])command.ExecuteScalar();<br />
stream.Write(image, 0, image.Length);<br />
Bitmap bitmap = new Bitmap(stream);<br />
Response.ContentType = "image/gif";<br />
bitmap.Save(Response.OutputStream, ImageFormat.Gif);<br />
bitmaps.Dispose();<br />
}<br />
finally<br />
{<br />
connection.Close();<br />
stream.Close();<br />
}<br />
}
Now in ur datagrid page just set src or imageurl of this page like this.
<datagrid id="" ...........="">
<columns>
<asp:templatefield>
<itemtemplate>
Best regards
Pathan
GOD HELP THOSE WHO HELP THEMSELF
|
|
|
|
|
try this:
http://aspalliance.com/articleViewer.aspx?aId=141&pId=
|
|
|
|
|
Here is this: http://www.codeproject.com/aspnet/CPImageGallery.asp[^]
It doesn't show the part about dumping it into a datagrid but I believe that is the easier of the tasks involved. It's a fully functioning application and you should readily be able to customize it.
|
|
|
|
|
Respected Gurus
I want to make a calendar through javascript.
it should not be any third party control because it may create problem when i will upload my project on the server.
It should not be machine dependent.
plz give me some code......
or any link where i can get some code....
Any solution
Ajay
|
|
|
|