|
Could you tell us what your problem is?
|
|
|
|
|
here is my source code whn login button clicked..
can you check for me..
private void Button1_Click(object sender, System.EventArgs e)
{
switch (UserLogin(usertxtname.Text, usertxtpass.Text))
{
case 1:
Session.Abandon();
Login();
break;
case 2:
Label4.Text = "Incorrect Password";
break;
case 3:
Label4.Text = "Incorrect Username";
break;
}
}
public void Login()
{
FormsAuthenticationTicket objTicket = null;
HttpCookie objCookie = null;
string strReturnURL = null;
objTicket = new FormsAuthenticationTicket(1, usertxtname.Text, System.DateTime.Now, DateTime.Now.AddMinutes(60), false, Session.SessionID);
objCookie = new HttpCookie(".ASPXAUTH");
objCookie.Value = FormsAuthentication.Encrypt(objTicket);
Response.Cookies.Add(objCookie);
strReturnURL = Request.QueryString["ULogin.aspx"];
if (strReturnURL != null)
Response.Redirect("ULogin.aspx");
else
Response.Redirect("registration.aspx", false);
}
public int UserLogin(string strUsername, string strPassword)
{
int iReturnValue = 0;
string sql;
OdbcConnection myconn;
OdbcDataReader MyReader = null;
sql="Select count(*) as expr1 From login Where (pword='"+usertxtpass.Text+"')And(uname='"+usertxtname.Text+"')";
myconn= new OdbcConnection ("DSN=myodbc2;SERVER=localhost;DATABASE=misdb;UID=root;PORT=3306");
OdbcCommand cmd = new OdbcCommand(sql, myconn);
cmd.Parameters.Add("@username", strUsername);
cmd.Parameters.Add("@password", strPassword);
cmd.Parameters.Add("@ReturnValue", OdbcType.Int).Direction = ParameterDirection.ReturnValue;
myconn.Open();
MyReader=cmd.ExecuteReader();
MyReader.Read();
iReturnValue = System.Convert.ToInt32(cmd.Parameters["@ReturnValue"].Value.ToString());myconn.Close();
return iReturnValue;
}
%#&kmpYrlHSGYG5@#($_+!@!(*JASnjshdk,cm_0ashjhdbn@#$!48mkhfbchsh))^%#W%&@YW7wsdfjw789';'][]\`~JKJQ4$!@#~)-HSKS^&*1)JK12@#@$~!1`DFGkqp][]\]?Zas;EWRG%!@~)(^&BVAG
|
|
|
|
|
Eduard asked what your PROBLEM is not for a code dump. 
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
|
hi
I want to create a website for seaching some details through websites using some particular keywords.Can you give me an idea for creating this.
Thanks in advance
Rasma
|
|
|
|
|
Member 4124915 wrote: Can you give me an idea for creating this.
Yes, ask it here[^]
While (true) { Human.isLearnable = true; }
|
|
|
|
|
I understand you can't just set the database to '' or null, but how can you do this when you dynamically generate the sql? Here is a example which I know does not work
SqlDateTime sqldatenull;<br />
<br />
if (tmpDate == "")<br />
tmpDate = sqldatenull;<br />
<br />
sqlQuery = "INSERT INTO Event (";<br />
sqlQuery += "Event_ID";<br />
sqlQuery += ", Event_Date";<br />
sqlQuery += ") VALUES (";<br />
sqlQuery += "'" + tmpID + "'";<br />
sqlQuery += ", '" + tmpDate + "')";
|
|
|
|
|
1st) Write your query this way:
sqlQuery = string.Format("INSERT INTO Event (Event_ID, Event_Date) VALUES ('{0}', '{1}')", tmpID, tmpDate);
2nd) Use System.Data.SqlTypes.SqlDateTime.Null;
While (true) { Human.isLearnable = true; }
|
|
|
|
|
Just don't insert the value...
sqlQuery = "INSERT INTO Event (";
sqlQuery += "Event_ID";
sqlQuery += ") VALUES (";
sqlQuery += "'" + tmpID + "'";
sqlQuery += ")";
Also, it would be neat to use a StringBuilder..
|
|
|
|
|
Why are you generating this SQL? This is a really, really, really bad idea. I can't stress enough, how bad this idea really is. By doing this, you've left your database open to SQL Injection Attacks.
|
|
|
|
|
Can you give me a example of the best way to stop sql injections? I am using SQL Server 2005 (Express) which the best option would be to use Stored Procedures?
|
|
|
|
|
Please read this[^] article.
|
|
|
|
|
Hi,
I have created a Webpage, and on the click of a certain link i want to run a unicast stream from VLC giving an output of RTSP.
Please help.
Regards
|
|
|
|
|
Head off to the ASP.NET forum.
xacc.ide - now with TabsToSpaces support IronScheme - 1.0 beta 1 - coming soon ((lambda (x) `((lambda (x) ,x) ',x)) '`((lambda (x) ,x) ',x))
|
|
|
|
|
In my C# editor space and Tab are filled by dots. How can I change this?
Can any one help me?
thanks to all.
|
|
|
|
|
Use Ctrl + R, Ctrl + W
"If you had to identify, in one word, the reason why the human race has not achieved, and never will achieve, its full potential, that word would be 'meetings'." - Dave Barry
|
|
|
|
|
|
Cool. I never knew this. Wonder what the point of it is 
Simon
|
|
|
|
|
It might help to get lines aligned. I have never used it though.
"If you had to identify, in one word, the reason why the human race has not achieved, and never will achieve, its full potential, that word would be 'meetings'." - Dave Barry
|
|
|
|
|
Go to the 'Edit' menu, select 'Advanced' and then 'View white space'. This enables and disables the dots.
|
|
|
|
|
Hi all,
I have created one windows services in C#. In OnStart method i want to start external exe at particular given time by user.
For that i need to keep comparing time of system and user given time.
But OnStart method calls only one time when starting that service.
Is there any other event or methods which will call continuosly when service in Started condition.
I feel happy when will get alternative solution for the problem.
Thanks guys......
|
|
|
|
|
Create a global Timer instance like System.Timers.Timer or System.Threading.Timer in your service class that you enable and start in your OnStart() event. Then every time the timer event fires you can perform your logic you need to. And you can set it to fire as often as you like.
Hope this helps.
|
|
|
|
|
Hi,
You could place a timer control on your service and do your programming logic in timer elapse event. Set the timer elapse time say 10 seconds or what ever you want and launch your exe.
cheers
|
|
|
|
|
Use a BackgroundWorker object. Timers are okay, but they send the lowest priority message Windows has, and it's not guaranteed to be handled in a busy system. So, to avoid the issue, use a BackgroundWorker.
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001
|
|
|
|
|
Hi All,
I have developed a formbased application.
In which I need to use another dll which contains some callback.
For using the callback inside the DLL from C# application what should be done??
In dll there is a struct which stores the callback pointers and one function uses to register this callback.
Please help
Regards
San
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
