Hmm. Something is starting ie on startup that shouldn't be. If active desktop is off, and no 'visible' programs are launching it. Maybe an antivirus client, who knows. Check out the event log to see any errors.
I have used this in the past to query the domains. To get users, you will use the same concept of directory searcher, I think objectCategory=User. Make sure you have rights to query when using the directory searcher.
ArrayList domains = new ArrayList();
DirectoryEntry dirEntry = new DirectoryEntry("LDAP://");
DirectorySearcher dirSearcher = new DirectorySearcher("objectCategory=Domain");
SearchResultCollection coll = srch.FindAll();
foreach (SearchResult sr in coll)
{
ResultPropertyCollection resultPropColl = sr.Properties;
foreach( object domain in resultPropColl["name"])
{
domains.Add(domain.ToString());
}
}
The network isn't really a problem, just make sure you properly configure sql to accept tcp ip connections and there shouldn't be much of a change than you have now, as long as there no concurrency issues within your application.
Dim basePath as String
Dim filename as String
Dim ext as String
ext = ".jpg"
basePath = "C:\Images\"
filename = Text3.Text
filename = filename & ext
Dim oFile As New Scripting.FileSystemObject
FileExists = oFile.FileExists(basePath & filename + ext)
If(!FileExists)
filename = "mypic" + ext
End If
Image1.Picture = LoadPicture(basepath & filename)
i didn't test this, might be a syntax error, but this is what you need to do
select
dv.clientid, c.lastname
-- put the rest of your columns here
from
(select clientid, sum(amount) from payments where creditorid = 1015 or creditorid = 1014
group by clientid) as dv
inner join clients c on
dv.clientid = c.clientid
I would recommend to set up possibly inside the uploads directory, you just want to be sure that permissions on this images directory aren't able to access your other directories, because you are allowing users to write to them.
First part. You are going the right route by storing files on the server and paths in the database. You should create a main image directory and possiblty have your images table have a subpath off of that. I'm sure each row will have an 'owner' or client column, so each client can have its own subfolder for images. Then each client, will have a house id lets say. So you can use something like this /images/clientid/houseid/imagename.jpg
Second part. This will work a little different. You will only want to load content, and not necessarily the entire webpage from the database.
If you can be a little more clear from the second part feel free.
any column you are querying against you will want to use an index assuming you are querying a lot against the title and description, you might want to separate them out to a separate table, and have bigint field inside of the stiri table that is a foreign key to that table query the smaller table that has the description on title, get the id then query the larget table with your ids, much quicker to search based upon an int value, and search a smaller when searching for text
Also be sure to optimize your code as well ie use stringbuffer instead string +, you know the usuals. When you are comparing characters, you might be running into speed and performance issues when you get into the larger documents.
1. The database is already built for transactional processing to handle multiple users. You will most likely have a single 'user account' that you will use to communicate with the database.
2. There are a couple of ways to do this. Normally you can put the connection string in the web.config and encrypt it. Also remember the pages are compiled, so they won't have direct access to your .net code.
Mainmenu mainmenu = new Mainmenu(playername);
mainmenu.run();
// in the mainmenu class
private String playerName;
public void mainmenu (String playername) {
this.playerName = playername;
}
public void run(){
while (makerestart <= 200000);
//... continue on with your original mainmenu code
}
once again you need to group by using the outer query
from ships where classes.class=ships.class)
-- note the end parenthese
-- now put your group by and total
group by name, classmatch, borematch, displacementmatch, countrymatch, launchedmatch, typematch, numgunsmatch
where total>=4
haven't tested this but this is closer to what you need
select name, classmatch, borematch, displacementmatch, countrymatch, launchedmatch, typematch, numgunsmatch,
Sum(classmatch ,countrymatch , launchedmatch , typematch , displacementmatch , borematch , numgunsmatch) as total
from
-- subquery
(select name,
(case when class = 'Kongo' then 1 else 0 end) as classmatch,
(case when country = 'USA' then 1 else 0 end) as countrymatch,
(case when launched = '1915' then 1 else 0 end) as launchedmatch,
(case when type = 'bb' then 1 else 0 end) as typematch,
(case when bore = '15' then 1 else 0 end) as borematch,
(case when numguns = '8' then 1 else 0 end) as numgunsmatch,
(case when displacement = '32000' then 1 else 0 end) as displacementmatch
from ships
-- you need to do your joins on the tables here to pull class, country ... etc)
group by name, classmatch, borematch, displacementmatch, countrymatch, launchedmatch, typematch, numgunsmatch
where total>=4
Static is meant to be thought of as that it doesn't apply to a specific instance of the object or class. As java addict's example, you can printMyName at any time without creating an instance.
You could possibly tell them their account is inactive, and go through some sort of steps to reactivate and set their active flag back to '1' so their data won't be lost.
There is really no right answer on how long to keep the information. A lot of times I would never delete unless it became an issue of database size or critical information.
Also, assuming you have some sort of houses table with a user_id owning the house. If you physically delete the user row, then you will have to delete house row as well as long as constraints are in place. Therefore I would say its not normally that important to delete the data, but it can be under the right circumstances.
i mean to pull back the active column from the user table
for example lets says a user places orders
table orders order_id user_id order_number
then in the query you can do something like this
select o.order_id, o.order_number, o.user_id from orders o
inner join
users u
on o.user_id = u.user_id
where u.active = 1
like for example if you let a user to see orders without logging in, you would want to join on the user table to make sure that they are still active before showing the results
Yes, same sort of update query as normal if you want to delete. This way also allows you to keep your database in tact and not worry about fk constraints on deletes, or a good way to recover data if it was 'deleted' (just set inactive).
Just remember if you are doing any joins on the user table or based upon a used_id to always add the active column to the query as above.
select person_id, hairmatch, colormatch, eyematch, sum(hairmatch, colormatch, eyematch) as total from
(select person_id,
(case when Hair = 'Tall' then 1 else 0 end) as hairmatch,
(case when HairColor = 'brown' then 1 else 0 end) as colormatch,
(case when EyeColor = 'blue' then 1 else 0 end) as eyematch
from
person)
group by person_id, hairmatch,colormatch,eyematch
-- add this to filter totals
where total >= 2
Add something like an active flag to the user. And in all queries when pulling users add where active_flag = 1 for active users, and the '0' user will not be pulled back. So this allows you to maintain the user still in the db, but not returned from queries to display in the website.
