Posts by dickersonka

You need to set the server to be in mixed mode authentication.

Go to properties for server, then click security and change it to mixed mode.

Then restart sql server.

If that doesn't allow you in, make sure the username is valid.

You can use either the repeater control or something along those lines, or use the System.Web.UI.HtmlControls namespace with class Table();

One more thing, you need to terminate it with a semicolon

store the query in $sql
and echo it out before you run it

and by the way, only one row will be returned, not multiples

html table to hold the images

Check out this link.
http://www.csharp-station.com/Articles/Thumbnails.aspx

Then you can create 5 images in a table, or however you choose to do it, and set each to have a url of this thumbnailpage with a query string of file, and pass 'file' into it, with the file path.

Separate out the classes, and create a singleton

public class Server
{
private bool _stopped;
public bool Stopped
{
get
{
return _stopped;
}
set
{
_stopped = value;
}
}
    private static Server _instance = new Server();

public static Server instance
{
return _instance;
}
}



//from your notify icon class
Server.instance.Stopped = true;

A good way to think about top level objects, is what ways you 'access' this object.

You interact with the top level objects, for the top level objects to interact with low-level objects.

An example is you can use the door on it, but regardless of the door, you have no clue how it works on the inside.

Once again depending on how the instructor is presenting things here are a few possibilities.

Keypad, Timer Display, Electrical cord

You could use the bottom statement only and get the avatar id, then issue this query to get the pic

select * from avatar where avatar_id ='{$avatar_id}'

here is the consolidated one, where you need ONLY this select statement

select
        ma.user_id,
        ma.memberfname,
        ma.memberlname,
        ma.avatar_id,
        a.pic
from
(
select
members.user_id,
members.memberfname,
members.memberlname,
coalesce(avatar_id, 1) as avatar_id
from members
left join avatars on members.user_id=avatars.user_id
) ma
inner join avatar a
on a.avatar_id = ma.avatar_id
where ma.user_id='{$user_id}';

You can either get the avatar_id from this query

Then run an additional query to get the pic, or if you want to consolidate everything in a single let me know, and i'll post one more to consolidate everything.

you get the avatar_id from this query

do you have an pic for avatar_id of 1?

It won't show the avatar with grabbing the pic column.

Assuming this is either a byte array or file path to their picture, you need to grab this column as well.

Is that what you are meaning?

Whenever you just run this piece

select 
						members.user_id, 
						members.memberfname,
						members.memberlname,
					coalesce(avatar_id, 1) as avatar_id
					from members
					left join avatars on members.user_id=avatars.user_id

What do you see?
You should see all the members, with their avatar_id's unless they don't have one, with an id of 1

Is this the result you see?

i'll stick with the coalesce

make sure your join is on the column that will be in both tables, use a left join, and make sure to use an alias on your coalesced column

[B]left join [/B]avatars
on [B]members.user_id = avatars.user_id[/B]

No need for a physical server. For the database server change the security to use mixed mode authentication (sql server and windows authentication). Next, create the user(s) for your database. You might want to create a read only account, and an admin account. Then set security for your user. And set the connection string for your application to use a username and password rather than trusted or integrated.

ConfigurationManager did not exist until .net 2.0, use visual studio 2005 to be able to use it.

I don't think its DataTableConnection. TableName and DataMember are both string types, make sure you have '.TableName' at the end

LizR is correct. Run a query on your columns to check if it exists, from the database side, you can also add a unique constraint on those columns to ensure that a sqlexception will be thrown if you try to do a insert on an already existing record with the specified columns.

Maintain the balance in a private variable inside deposit class.

you are trying to assign a double a value of void here
double newBalance = accounts.get(j).deposit(deposit);

when you withdraw or deposit, have that update a private variable of balance

private double balance = 0.0;

public double getBalance(){
   return balance;
}
public void withdraw(double d){
  //do your processing

//now set balance
balance = balance - d;
}


//in your other ui code call
double newBalance = accounts.get(j).getBalance();

You need a semicolon at the end of the sql statement

itemsNeeded"  & "';"

use a left join and specifiy your columns with a coalesce on avatar id

select
user_id,
coalesce(avatar_id, 1) as avatar_id
from members 
left join avatars

Its all up to you. Typically you would not let the user know how many attempts they have left and just display a message after they have locked themselves out, that their account has been locked and will be available in 'x minutes' or if they reset their password or whatever method you choose.

Another reason that you wouldn't let them know, is if you ever decide to change the number of attempts, you might have to change the error message. Also with the hacking thing, this will let them know how many chances they have left to try for this account, before moving on to the next one.

All in all, still a personal preference.

It is a constant battle to keep up with security and hackers or what not.

The only thing you can do is try and stay ahead of the game.
Make users have secure passwords, if user's are complaining, make them do a captcha with email address or something along those lines. Make sure your database is secure, as far as accessibility from external ips and users. Make sure you don't directly take user input and try to issue a database command with it. Althought it may take a little more time to implement and code these strategies, it will deter many hacking attempts to begin with.

Yes, do the other checks first like the link showed and if they ARE EMPTY, then rely upon the REMOTE_ADDR.

select dep_id from employees
where emp_id = 10 or emp_id = 20
group by dep_id
having count(dep_id) >= 2

if you need dep_name just do a join on the results to the departments table to get it

When you set the datasource again, the process list still contains the deleted item,

This will remove the item from the end of the list, not sure what you are needing as far as position in the list, but this is the concept.

ProcessList.RemoveAt(totaal - 1);

The problem will be that if your users are behind the proxy, you will be blocking all of them from the same ip address without using the additional code.
If they aren't behind the proxy REMOTE_ADDR will work, otherwise you will be blocking the whole proxy for a client address inside of that proxy.

You are removing the item from the listview and resetting the datasource directly after.

Either don't set the datasource after that, or have a list that contains your items, and remove from that list, not just the listview.

I use lunarpages.com for ASP.NET hosting and I know they offer java hosting as well. You might want to check them out, you can host jboss on a vps for about 40 a month i believe.

http://www.lunarpages.com/id/alleratechcom

What are you having the problem with?

If its with css, make sure you add an additional css file for print.

Unit test problem with what?

One more thing, just in case they are behind a proxy, this might be better for getting the ip.

http://roshanbh.com.np/2007/12/getting-real-ip-address-in-php.html

Just to be sure you have a table named employee that have duplicate id's of 10 and 20?

Here's a link of how to get the ip address
http://www.plus2net.com/php_tutorial/php_ip.php

Then just set up table along the lines of

BLOCKED_IP
FAILED_LOGIN_ATTEMPTS
LAST_FAILED_TIME

When the user accesses the page, check the ip against blocked_ip, if it matches then check LAST_FAILED_TIME and FAILED_LOGIN_ATTEMPTS, if it is greater than 30 min and whatever value for FAILED_LOGIN_ATTEMPTS you choose, then display the login page, otherwise dispaly the access denied page and increment the FAILED_LOGIN_ATTEMPTS. If you allow access, delete the row for that ip. If the user types in a bad password insert or increment the FAILED_LOGIN_ATTEMPTS.

You might want to go about it a little different of a way, but there is a good start.

Thanks

Once again, hackers might keep trying the passwords, but you might want to try an approach of blocking ip's. 5 attempts at an ip with an incorrect password, record the ip in a table, and pull back from the table when user's are accessing the login page. If they match an ip in the table, disable the ability to log in or along those lines. Yes they can spoof the ip's, but it is a viable solution.

A good way would be to include the parameters in the query string

<a href="www.thispage.com?county=Chaffee&state=Colorado"> Chaffee </a>

Yes. You could set up it as a secondary hard drive, but if you try to just place it in and go, you will come up with all kinds of errors, that will make you come close to formatting anyway.

???? Have no clue, It worked for me and I didn't have the oracle client

For sure you got 1.296?
http://sqlexpressprofiler.googlecode.com/files/SqlExpressProfiler-0.1.296.50.zip

It might be MSSQLSERVER or SQLEXPRESS

Lol think there is login confusion.

By user, I mean the executing user of the windows process, as in administrator logon vs user logon that launches this process. There will also be a database windows user, since you are using integrated security. The launching user of this application, will need to have the priviledges inside of sql server.

The profiler should be able to show what user is calling the stored procedure.

Any information along that line?

You might be able to do it generically and set

dgBlowOut.DataMember = ds.Tables[0].TableName

Yes, that is the name of dataset. The problem seems to be that it doesn't know what table to use.
The dataset 'can' have multiple tables, and the datagrid doesn't know what to get its records from.

Check out these links for more clarification.

http://msdn.microsoft.com/en-us/library/system.windows.forms.datagrid.datasource.aspx

http://msdn.microsoft.com/en-us/library/ms810286.aspx

remember the datamember

Dim ds As New DataSet("uploads")

....

 dgBlowOut.DataMember = "uploads"

You said in the first you wanted a.id=b.id,
what are the columns for a.id and b.id?

But are you saying that a.id might not exist?

Here's a link for the profiler
http://sqlprofiler.googlepages.com/

Are you sure the code is running as the same user as your login?

It seems like the user of the code, doesn't have permissions to the user permissions on that stored procedure still.

you need to do an inner join if you are not wanting to list all in the tables that share the record ids.

Agreed, it is a little trickier in C# than some languages.

Would placing this datagrid in a user control and adding it to the forms work for you?

did you try to add these switches?

--fields-optionally-enclosed-by=""" --fields-terminated-by=, --lines-terminated-by="\r\n"

you might only need the first, just depends on what os you are on

Regular expressions are a good start.

You might want to look at the factory pattern to parse each line.

Research on google for the factory pattern, basically it allows you to apply the same logic to each of these lines, making it easier to separate the pieces.

Sure thing. Have a good weekend.