dickersonka 104 Veteran Poster

Lol the paper method, I like that one.

I assumed you meant unit tests, here are some links for them.

http://www.deitel.com/ResourceCenters/Programming/CGameProgramming/CUnitTestingFrameworks/tabid/1537/Default.aspx

dickersonka 104 Veteran Poster

Of course we can see what the error is, here is something to help you rather than just tell you.

After assigning your sql statement, do this.

System.Diagnostics.Debug.WriteLine(selectsql);

Then you will be able to tell where the error is at.

dickersonka 104 Veteran Poster

ddanbe gave the way c# does it, i would suggest to stay with some modification of that, try to stick with what the language gives you if its possible, rather than trying to mimic c++

here is an article the has an implementation of findfirstfile in c#
http://www.codeproject.com/KB/files/FileSystemEnumerator.aspx

dickersonka 104 Veteran Poster

Regarding dba what? Do you have any specific questions?

dickersonka 104 Veteran Poster

Use the DataSet.WriteXml method.

Post the code you have where you set the datasource if you are having trouble still.

dickersonka 104 Veteran Poster

Couple things that seem unclear, that could affect the choice.

1. How did the meta data get there in the database if its a new file?

2. When you say "process file", does that mean you have application code or sql code that does this processing?

3. Is the processing of the files heavily intensive or quickly done?

dickersonka 104 Veteran Poster

Agree with ezzaral, the call is right in there.

Also, put your code in code tags, much easier on the eyes.

dickersonka 104 Veteran Poster

What are you wanting then?

Are you wanting the data or gridview to be written?

Also you are using htmltextwriter, which is exporting html.

dickersonka 104 Veteran Poster

A suggestion would be not to use numeric unless you needed to, i'm assuming parentid and childid could be int

also nvarchar is used for multilingual data, if you have that keep it, otherwise use varchar

dickersonka 104 Veteran Poster

agree with jbennet

you can choose to create your own method of locking, or go by sql physical locking

not sure what db or version you are using, but the sql concepts are row lock or table lock

if you want to implement this yourself, you can add a locked column to the row and set to 1 or 0 depending upon its current state

dickersonka 104 Veteran Poster

not sure what your methods look like, but lets say you have a method that will add a number and return the sum

your test case, will provide the number and ensure it is the correect result when its returned

dickersonka 104 Veteran Poster

try adding the word AND in your where statement

dickersonka 104 Veteran Poster

Calling a constructor with account number and balance is a little redundant. Are you sure you don't need a constructor with account number and deposit instead?

public BankAccount(int anAccountNumber, double depositAmount)   {  
accountNumber = anAccountNumber;
balance = //do something here to load balance from account number

//your other code in here

//make the deposit
deposit(depositAmount);
}
dickersonka 104 Veteran Poster

you need to correct the insert statement portion

insert into parentchild(child, parent, parentchild)
values(@child, @parentid, @parent + " / " + @child)
dickersonka 104 Veteran Poster

Lol a professor wants you to make it more complex. One of the objectives in programming, is to make a complex task into manageable and logical separated parts, but maybe he just wants to see a little more.

Maybe something more complex, could be added functionality similar to that of amazon where they give suggested items. Based upon what items you have, try to create suggestions for other items, based upon other user's buying habits.

dickersonka 104 Veteran Poster

Agree with stultuske. You need to create something like a "wrapper" class. Lets say for example the jar file will load an employee, but you want to add a check if the employee is still active.

Create a method in your wrapper class to call the jar and load the employee, then add in your check for active into your wrapper class as well.

dickersonka 104 Veteran Poster

A possible solution could be to use events, to pass whatever you needed.

dickersonka 104 Veteran Poster

i think maybe a small correction to that, since he is getting them from the newEmployee object

string sql = "INSERT INTO employeeTable(EmployeeName, Salary) VALUES ('" + newEmployee.EmployeeName + "', " + newEmployee.Salary.ToString() + ")";
ddanbe commented: Errare humanum est! Aways correct me if you think you must. +1
dickersonka 104 Veteran Poster

There shouldn't be a driver (at least most likely) for the actualy usb-parallel converter. It is hardware based and does its conversion for you. The driver you need is for the plotter. Agree with caperjack, take a look at device manager and check for unknown devices in there.

dickersonka 104 Veteran Poster

Hmmm. Well if you are on windows, you can use shift + f10. Or you can turn on mouse keys in accessibility in the control panel and the minus sign will be a right click.

dickersonka 104 Veteran Poster

What way are you wanting it to work, and what is it giving you now?

dickersonka 104 Veteran Poster

Show us what you have then we will help. We won't just give you code.

dickersonka 104 Veteran Poster

Asking a question on a forum where you don't seem to read the reponses.

dickersonka 104 Veteran Poster

although you are not too close, good to see another ga user on daniweb :-)

dickersonka 104 Veteran Poster

it does mix them, it is your job to separate them

users are security based (normally) meaning roles

schemas are grouping based (meaning organization)

dickersonka 104 Veteran Poster

What lines?

dickersonka 104 Veteran Poster

Agree with narue, mysql is a very good open source database. What are you looking for about your select statement that is different than the rest?

dickersonka 104 Veteran Poster
dickersonka 104 Veteran Poster

What are you getting errors, anything?
Post your code and config and we can help.

dickersonka 104 Veteran Poster

So you are wanting us to do a game hack?

dickersonka 104 Veteran Poster

then post your code so we can help

dickersonka 104 Veteran Poster

and to extend upon ddanbe, you can also set the modifiers on the methods

public void MyStuff()
{
}

private void MyStuffAgain()
{
}

the access modifiers match except these
VB -> C# equivalent
Friend -> internal
Protected Friend -> internal protected

dickersonka 104 Veteran Poster

Along with Lizr, we won't do this for you.

The concept of 3 tier architecture is that you have separation within your code.

UI Tier - display only, your forms will be this
Business Tier- You do your necessary business rules in here, maybe something like ensuring first name length is at least 2 characters long
Data Tier - This is where you do all your data access and updates, you could make your call to insert or select an employee in this piece

The goal of 3 tier architecture is to be able to change all 3 independently of each other, or at least independent as possible of each other

dickersonka 104 Veteran Poster

And also, since it is on another server, make sure to use its mail.xxx.xxx address. Normally mail servers, will require you to authenticate to send mail from a machine other than itself.

dickersonka 104 Veteran Poster

most likely, this is a security issue then, and you will need to authenticate with the server to be able to send mail to other domains

dickersonka 104 Veteran Poster

aspx is not straight html code, it must be compiled, whether thats at runtime or precompiled

you can right click on your file in visual studio and click view in browser, this will launch the vs asp.net host to allow you to view it, otherwise you need to publish to iis to view it

dickersonka 104 Veteran Poster

A good place to start would be posting what you have and what part you are having trouble with.

dickersonka 104 Veteran Poster

Where are you loading and setting the session variables?

You can load them in Page_Load, and set them for example lets say after the user clicks login

Also ensure your web application supports it. I believe it is
EnableSessionState=true

dickersonka 104 Veteran Poster

You can paste the html into the aspx page, this will be html.

If you want to convert it to use asp.net controls, rather than html controls, do some research on it.

dickersonka 104 Veteran Poster

What is this ? What is the colon by the way?

:CLOSEDDATE
dickersonka 104 Veteran Poster

Of course you can call macro's from c#

http://support.microsoft.com/kb/306683

That is a word example, you'll just need to use excel automation instead

dickersonka 104 Veteran Poster

you are calculating average incorrectly

this is wrong

//Calculates average		
Average = Average + Salary[i];

you need something like this in its place

int totalSalaries;

//now your for loop here


//Calculates average		
totalSalaries= totalSalaries+ Salary[i];


//then after your for loop
//We can calculate average
Average = totalSalaries / numEmployees;
dickersonka 104 Veteran Poster

Sure thing. Any other questions, feel free to post to the forums.

dickersonka 104 Veteran Poster

no, that is a negative -1

then it will count

for (int number=10; number > -1; number--)

10, 9, 8, 7, 6, 5, 4, 3, 2, 1, 0

if you don't want to include the 0 set

for (int number=10; number > 0; number--)
dickersonka 104 Veteran Poster

it will be this

for (int number=10; number >= 0; number--)

you must say, while number is greater than or equal to 0

i normally also try to avoid >= in for loops and use only >

for (int number=10; number > -1; number--)

also be aware this will execute 11 times, because it includes 0, but then again that may be what you are looking for

dickersonka 104 Veteran Poster

I know you are a beginner, but please post your code in code tags

dickersonka 104 Veteran Poster

Post what you need help with

dickersonka 104 Veteran Poster

Atlanta, GA -- USA

dickersonka 104 Veteran Poster

Lol agree with ddanbe, like we told you yesterday use
tbSendText.Text

And just to shed some light on what the other guys are saying about the crlf (\r\n), the socket you are connected to needs to know when you are done sending. Since you can send 5 bytes, then later 10 bytes for example, you must tell the connected socket when you are done. The crlf typically is used to say "i am done", then the response is sent back from the connected socket.

ddanbe commented: respect +1
dickersonka 104 Veteran Poster
select cat_id,obj_id,date_added,date_updated,data,title,business_contacts_id,address_string, USERID

(SELECT	od.cat_id,od.obj_id,od.date_added,od.date_updated,od.data,bc.title,bc.business_contacts_id,gde.address_string, od.uid as USERID
FROM ol_obj_data od
INNER JOIN ol_obj_2_business o2b ON od.obj_id = o2b.obj_id
INNER JOIN ol_business_contacts bc ON o2b.business_contacts_id = bc.business_contacts_id
INNER JOIN ol_geo_data_ext gde on gde.geo_id=bc.geo_id
WHERE od.uid = USER_ID AND od.cat_id = 8 ) as query1

inner join

(SELECT	od.cat_id,od.obj_id,od.date_added,od.date_updated,od.data,bc.title,bc.business_contacts_id,gde.address_string, od.uid as USERID
FROM ol_obj_data od
INNER JOIN ol_obj_2_business o2b ON od.obj_id = o2b.obj_id
INNER JOIN ol_business_contacts bc ON o2b.business_contacts_id = bc.business_contacts_id
INNER JOIN ol_geo_data_ext gde on gde.geo_id=bc.geo_id
WHERE od.uid = USER_ID AND od.cat_id = 9 ) query2

on query2.USERID = query1.USERID

you must specifiy each column using 'AS' like the one for userid