dickersonka

Keep an arraylist or some other sort of list of columns. [code] ArrayList columns = new ArrayList(); columns.Add("column1"); int columnCount = columns.Count; [/code]

You can just type it in using management studio, if you're in 2005. SQL Server just offers a lot more features, much better stability, much better performance, and much better growth and scalability. Don't be overwhelmed by all this, definitely a much better way to go.

I see the relationships, but don't see the actual columns. In the business table, you need the columns GENRE_ID, CATEGORY_ID, and SECTION_ID. For the businesses without categories, you can just set the column to be null.

Do some research on impersonation

You iis application will run with the security account associated with its app pool. By default this is the asp.net service account, which def wouldn't work. Change the app pool to the appropriate user for thise site.

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 …

From the example you wrote, there isn't an order by home Can you post an example that shows what you want?

Reporting services is much better than crystal. Not sure if you are meaning asp page, as manually generating a report. There is probably a little more overhead with reporting services, but much more user friendly than crystal in my opinion.

Can you post the table schema

use a left join and specifiy your columns with a coalesce on avatar id [code] select user_id, coalesce(avatar_id, 1) as avatar_id from members left join avatars [/code]

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 …

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.

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.

You need a semicolon at the end of the sql statement [code] itemsNeeded" & "';" [/code]

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 [code] private double balance = 0.0; public double getBalance(){ return balance; …

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

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. [URL="http://www.lunarpages.com/id/alleratechcom"]http://www.lunarpages.com/id/alleratechcom[/URL]

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?

A good way would be to include the parameters in the query string [code] <a href="www.thispage.com?county=Chaffee&state=Colorado"> Chaffee </a> [/code]

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

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.

There are different areas of it for sure. There are programming/networking/design/implementation categories amongst others. Advice would be to research tech jobs/categories. They are all related, but much different. Strengths in logic and math, I would say programming but its not just something to pick up so easily. Take your time …

Take a look at exams 70-528 and 70-536. There are reference materials available from microsoft for these specific tests. Research MCP (Microsoft Certified Professional).

on the longtext fields use quotes 1, 7, "allow commas, sample"

bill table should not have a primary key of patient a patient will have multiple bills that patient should not have a column of pbill, unless it something associated with the patient move pbill to bill table then you can have a patient with multiple bills, and i'm not sure …

jdbc driver needs to be Class.forName("com.mysql.jdbc.Driver");

For this you can use a query string or session, query string might be easiest. [code] [B]connect.aspx.cs[/B] protected void picUpload_Click(object sender, EventArgs e) { int year = 1870; Response.Redirect("upload.aspx?year=" + year.ToString()); } in the receiving page private void Page_Load(object sender, System.EventArgs e) { int year = Convert.ToInt32(Request.QueryString["year"]); } [/code]

Here's a link to do it [url]http://www.c-sharpcorner.com/UploadFile/mgold/HowToPrintaDataGridinCsHARPand.NET11212005060838AM/HowToPrintaDataGridinCsHARPand.NET.aspx[/url]

select * from employees group by employee_id having count(employee_id) >= 2

this is hibernate, relating database to OR mapping

Its built into .net This is C# but same thing [code] //put your image path here string imgPath = ""; System.Drawing.Image img = Image.FromFile(imgPath); Image thumbnail = img.GetThumbnailImage(64, 64, new System.Drawing.Image.GetThumbnailImageAbort(ThumbnailCallback), IntPtr.Zero); [/code] You must add the callback, but its not used.

Table layout panel is good, but not for something like this due to the number of rows you might have with dynamic sizing. Use a gridview and add a checkbox column to the row that the user can edit.

Try uninstalling and reinstalling the video driver. Try a new monitor and try a new video card if possible and display cable. It sounds like either, the video card, monitor, or display cable is bad.

Disadvantage i agree is a lookup, doesn't necessarily have to be dns if you use the ip, but once again that might be bad practice. Advantages would be scalability and most likely replicating the production environment. Issues can exist that you won't realize until production by using separate machines. Assuming …

select * from table group by sapno order by amt desc

Are you searching the correct container? ie if you add it to a panel. Use panelId.FindControl

Not the easiest task if you are just starting out, but here's the concept. You can create a table with the same structure and use it for auditing. Use the triggers to catch the insert,update, and deletes and then store the records into the second table as well. Or you …

i would suggest to use a stored procedure to do all the calculations if you haven't already declare num_days, price, temp_price int; loop through your current time spans you have, and set price each time set temp_price = select price from info where .....; if your last select had a …

The option you needed is the workstation components, so you can run management studio with running sql server on the same machine.

Might be with the dns exploits recently. Where the site you expect isn't always the one thats resolved.

Add the same code to the form_shown

Add a custom action for uninstall. You will need a code file for it that inherits from Installer. When you add this to the installer, it will be part of the package, but you can override uninstall to delete the directory.

Typically no. Employees and Country would be good for the table names. There should be no difference whether the you have a 'fixed' set or not.

Not for sure of the way you are wanting to do this, but you are allowing 1-1 of army to infantry, archers, mounted knights, I'm assuming these are groups and not singles? You might want to look at the longbows and cross bows. It looks like the distance is specified …

I don't know what your method of calling the server is, or if it is local or remote. You might want to try a web service if you can't access the file publicly. If its public it can just be a url. In the C# code, you can reference a …

try Hide and Show for the form [code] //Hides Form.Hide(); //you can use this if you are in the form's code this.Hide(); //Show the form Form.Show(); //in the form's code this.Show(); [/code]

i think this is what you are meaning select number, value from tablename where number in (select number from tablename where value='foobar')

If you don't need the relationship, I would suggest moving the remarks back up the owning table. If you do need the relationship, with the foreign key concept create a reference table. student STUDENT_ID STUDENT_NAME students2remarks STUDENT_ID REMARK_ID remarks REMARK_ID REMARK the table will can be used as a bridge …

Not sure what part you have trouble with. The concept would be loop through the results and add unique hosts to a list or hashtable and add the user to a list and each software to a list. Then loop through the hosts, for each user in the host, for …