|
Hi,
As suggested by other other fellows, have a counter in authentication procedure/routine, count for invalid tries, and if the count reaches 3, change the ULock to 0. You can even add a column for the total number of times the account ws locked in the same column. Just an idea! 
Regards,
Adeel
Do rate the reply, if it helps or even if it doesnot, because it helps the members to know, what solved the issue. Thanks.
|
|
|
|
|
I wil just tell u the Procedure to be done.
1.Initailly the default value of ULock will be 1.
2. Declare a variable WrongPwdCount=0;
3.Check the status of the ULock
if ULock==0
Display the Message as " Your account is locked"
else
WrongPwdCount++;
4. if WrongPwdCount==3
Change the ULock=0
else
Do a successful login
Let me know if this works....
Otherwise Let me send a code for the same
Regards
Basavarajayya
|
|
|
|
|
Try This.
SqlConnection con = new SqlConnection("Data Source=;Database=;User Id=;Password=");
SqlCommand cmd;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
hfCounter.Value = "1";
}
}
protected void btLogin_Click(object sender, EventArgs e)
{
try
{
con.Open();
string xSql="select * from <trackuser> where userid='" + txtUser.Text + "' and pswd='" + txtPswd.Text + "'";
cmd = new SqlCommand(xSql,con);
SqlDataReader rd = cmd.ExecuteReader();
int x = Convert.ToInt32(hfCounter.Value);
if (x == 3)
{
lblMsg.Text = "User Locked....!";
// write your process here. to change the Lock Status from 0 to 1 OR 1 to 0 etc...
}
else
{
if (rd.HasRows != true)
{
x++;
hfCounter.Value = x.ToString();
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
con.Close();
}
}
I hope Helps you out. I used Two TextBox, Label, Button, HiddenField 
" Good Things Goes with Good People "
|
|
|
|
|
I would like to know how we can determine whether a function call is resolved at runtime or compile time.
Thanks in Advance
Anand
Not everything that can be counted counts, and not everything that counts can be counted
|
|
|
|
|
How about using Reflection?
|
|
|
|
|
Thanks.
But I would like to find when is the reference resolved really at runtime or compile time. We say a simple function call is resolved at compile time and something complex with inheritance is resolved at run time. How can I really see it or make sure that how its done. Is there any way to find it with reflection libraries. If yes give me some examples.
Thanks a lot
Anand
Not everything that can be counted counts, and not everything that counts can be counted
|
|
|
|
|
I have a class, ImageLoad which receives a stringPath where I have stored the encrypted images. I would like to know if it is possible to know if the file has been modified before decrypting it? I'm trying to void getting the exception bad data just because someone added a .crip file [file extension I'm using], to the working folder or modified any file extension to .crip and if it happens I get the exception how can I close the application without getting another exception?
Thanks beforehand !
Luis E Tineo S
|
|
|
|
|
hi there,
i want to detach my database but it always gives an error that it currently in use.
here is written what im doing :
SqlConnection dataConnection = new SqlConnection();
SqlCommand dataCommand = new SqlCommand();
dataConnection.ConnectionString = "Data Source= MYSERVER; Integrated Security=true; Initial Catalog= MYDATABASE";
dataConnection.Open();
dataCommand.Connection = dataConnection;
dataConnection.Close();
dataConnection.ConnectionString = "Data Source= MYSERVER; Integrated Security=true; Initial Catalog= master";
dataConnection.Open();
dataCommand.CommandText = "sp_detach_db 'MYDATABASE', 'true'";
dataCommand.ExecuteScalar();
dataConnection.Close();
the error occured when 'ExecuteScalar()' called
i also use dipose() but problem persist
can someone tell how to solve it?
Becoming Programmer...
|
|
|
|
|
The way I detach databases is by going to sql server, selecting the database I want to detach, left click on it and select task and then detach. If VS2005, the one I use, is open and it is connected to the database I want to detach I close VS2005 and the detach the database.
Hope it help!
Luis E Tineo S
|
|
|
|
|
oh wow...!! what the way you are using... Keep it up
Becoming Programmer...
|
|
|
|
|
Hello,
Good to see you! 
Here is the process of doing that in a simple and easy to understand way, originally it is at:
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22761995.html[^]
i just tried to make it bit easy to understand. Hope this helps!
Use this to check if the database is in use by any process:
SELECT * FROM sysprocesses WHERE dbid = db_id('" + Put_Database_Name_Here + "');
If it returned zero rows, you are set to detach it, if not then use:
string spid;
foreach (DataRow xyz in datatable.Rows)
{
spid = dr["spid"].ToString();
execute: "KILL " + spid;
}
after that, execute
EXEC sp_detach_db @dbname='" + Put_Database_Name_Here + "';
Use (preferably)
ExecuteNonQuery();
Then close the connection.
Regards,
Adeel
Do rate the reply, if it helps or even if it doesnot, because it helps the members to know, what solved the issue. Thanks.
|
|
|
|
|
thanks again man... you are great
but may i know why ExecuteNonQuery() is preferable?
rated 5
Becoming Programmer...
|
|
|
|
|
|
i dont think its useful for me but anyway thanks for your helpful replies
a ![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif) from me
Becoming Programmer...
|
|
|
|
|
Welcome my friend , i am here to share the little bit of knowledge i possess.
Regards,
Adeel
Do rate the reply, if it helps or even if it doesnot, because it helps the members to know, what solved the issue. Thanks.
|
|
|
|
|
hi
i had date in he form of ddmmyy and it is dispalyed as 141107 but i want it to be in the form of 14-11-07
Regards
padma
padma
|
|
|
|
|
So change the display format. How are you rendering it now ? DateTime never renders like that, AFAIK.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
are you using DateTimePicker? if yes
then change it "Format" property to 'Custom'
and in "CustomFormat" property enter your format like "dd-MM-yy"
hope this will help
Becoming Programmer...
|
|
|
|
|
U r fetching from db or selecting date from datepicker?
Cheers
Bino
www.codepal.co.nr
|
|
|
|
|
Hi Padma,
Just test using DateTime.Now.ToString("d"); there are formats avaibale just check by .ToString("m");("y") like that...
|
|
|
|
|
I am attempting to write my own flood fill algorithm, but it is proving to be pretty slow. I am wondering if anyone has an idea on how I can improve performance. Currently, I am using the 4-way non-recursive scanline algorithm, based on a Queue<Point>. I am using the WinAPI methods CreateCompatibleDC, GetPixel, SetPixel, and BitBlt. I have a feeling that if I can copy the bitmap to a byte array, then modify that array directly, then return the array to the bitmap, I can get better performance. Does anyone know how to do this, or have any other ideas as to how I can improve the following code? I copied my code below for examination (note that all the colors I am filling are gray, so R=G=B all the time, if it is a valid fill). Thanks,
private static int ToRGB(Color col) {
return (col.B << 16 | col.G << 8 | col.R);
}
private static bool AreEqual(ref int known, int other) {
if (known == other)
return true;
if ((other & 0xFF) != (other >> 8 & 0xFF) ||
(other & 0xFF) != (other >> 16 & 0xFF) ||
(other & 0xFF) < (known & 0xFF) - 2 ||
(other & 0xFF) > (known & 0xFF) + 2)
return false;
known = other;
return true;
}
private static bool FloodFill(Bitmap img, Point loc, Color fillColor) {
Graphics g = null;
IntPtr hdc1 = IntPtr.Zero, hdc2 = IntPtr.Zero;
try {
g = Graphics.FromImage(img);
hdc1 = g.GetHdc();
Color temp = ((Bitmap)img).GetPixel(loc.X, loc.Y);
hdc2 = WinAPI.CreateCompatibleDC(hdc1);
WinAPI.SelectObject(hdc2, img.GetHbitmap());
int oldColor = WinAPI.GetPixel(hdc2, loc.X, loc.Y);
if ((oldColor & 0xFF) != (oldColor >> 8 & 0xFF) ||
(oldColor & 0xFF) != (oldColor >> 16 & 0xFF))
return false;
Queue<Point> pixels = new Queue<Point>(128);
pixels.Enqueue(loc);
int x, y, newColor = ToRGB(fillColor);
bool spanL, spanR;
do {
loc = pixels.Dequeue();
x = loc.X;
y = loc.Y;
oldColor = WinAPI.GetPixel(hdc2, x, y);
while (y > 0) {
if (!AreEqual(ref oldColor, WinAPI.GetPixel(hdc2, x, --y))) {
++y;
break;
}
}
spanL = spanR = false;
do {
int res = WinAPI.SetPixel(hdc2, x, y, newColor);
if (!spanL) {
if (x > 0 && AreEqual(ref oldColor, WinAPI.GetPixel(hdc2, x - 1, y))) {
pixels.Enqueue(new Point(x - 1, y));
spanL = true;
}
} else if (!AreEqual(ref oldColor, WinAPI.GetPixel(hdc2, x - 1, y))) {
spanL = false;
}
if (!spanR) {
if (x < img.Width - 1 && AreEqual(ref oldColor, WinAPI.GetPixel(hdc2, x + 1, y))) {
pixels.Enqueue(new Point(x + 1, y));
spanR = true;
}
} else if (!AreEqual(ref oldColor, WinAPI.GetPixel(hdc2, x + 1, y))) {
spanR = false;
}
} while (++y < img.Height && AreEqual(ref oldColor, WinAPI.GetPixel(hdc2, x, y)));
} while (pixels.Count > 0);
WinAPI.BitBlockTransfer(hdc2, hdc1, 0, 0, 0, 0, img.Width, img.Height, WinAPI.TRO.SRCCOPY);
} catch {
return false;
} finally {
if (hdc2 != IntPtr.Zero)
WinAPI.DeleteDC(hdc2);
if (g != null) {
if (hdc1 != IntPtr.Zero)
g.ReleaseHdc(hdc1);
g.Dispose();
}
}
return true;
}
Jeff
|
|
|
|
|
Read my image processing articles.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Yep, that pointer implementation worked nicely. I now have four working implementations... One is with the built in GetPixel and SetPixel methods (excruciatingly slow), the second uses Win API GetPixel and SetPixel methods (as in the first post of this thread) (pretty slow), the third uses the LockBits method on the Bitmap, then I use Marshal.ReadInt32 and Marshal.WriteInt32 to modify the bitmap directly without using pointers (pretty fast), and the final way is to use int pointers and the LockBits method (blazingly fast!) The most unbeleivable part is that the pointer method is faster than the Win API ExtFloodFill method, and I even have WAY more control over how the fill is done (allowing near-matches in addition to exact matches). Thanks for the input!
Jeff
|
|
|
|
|
Hi Jeff,
for this I would stay clear from images if at all possible; a simple array should do,
you only need empty, border, and one or a few fill values.
As always, I prefer one-dimensional arrays over two-dimensional ones
(typically less code, more speed).
On the other hand, there are some CP articles on similar things such as this one.[^]
Luc Pattyn [Forum Guidelines] [My Articles]
this months tips:
- use PRE tags to preserve formatting when showing multi-line code snippets
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
Hi,
I have some problems with the updating of database. I will need to update 2 tables in one sql query and I am not too sure how to write a stored procedure with sql server. Need some guidance.
Thanks.
Regards,
Jo
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
