adam_k

Create a second var to hold the house number. Then when you set the maxVal you'll set the house as well.

It all depends on the values you want to assign and the criteria used. Can you please be more specific?

I'm pretty sure that this doesn't belong to Web Development section, but I'll answer it anyway. Go to settings and you'll find : *Conversation View: (sets whether emails of the same topic are grouped together)* Select *Conversation view off* and save your changes.

You need to share more details. What happens after you get the job name? If you store it in a table then you can join to that table and exclude all records in that table. By doing this you can use a transaction and eliminate the possibility of 2 users …

Have a look at this article: http://www.daniweb.com/software-development/vbnet/threads/423833/datatable-to-access-database-table

Can you please explain a bit better what you want to do?

@ChrisHunter: You can't update more than 1 tables with the same query. You can join tables if you want to limit your results, but you can update only the table after `UPDATE` @OP: Your way of doing it is the correct one.

Since you've concatenated into txtDisplay.text the minus or plus sign, I don't think that txtDisplay.text is numeric. With that said, when you are assinging Number2 = txtDisplay.text means that Number2 is not numeric, so you shouldn't be able to add or subtract anything with Number2 as part of the calculation. …

Welcome

I don't see an issue. Install your app in the client machine and you should be good to go. Unless there is no SQL server in the client site. Then you need to a) tell them to buy one or b) use SQL Express

The statement that you are assinging to cmd won't take you anywhere. 1st of all you should change it to : cmd = New SqlCommand("SELECT COUNT(*) FROM IssueMBA WHERE ida='" & textbox1.text & "' and rda='" & textbox2.text &"'", con) And then you can add date criteria like this cmd …

I don't mind, I don't like it, but don't mind. It takes less than a second and after the first time you see it, you know what it is and you move your mouse.

This is weird, so I'll give you a weird suggestion. Could it be that there are 2 views with the same name under different owner and the user you are using to login into management studio can't see both views (or you haven't refreshed the list of views, or you …

Google vb.net decompiler and take your pick. PS: You can also find free versions.

After you exit your app, is the value different in your table? (check directly) If it is you are saving it on or before exit. If it isn't and you find it different when trying to login (again check directly in your table) then you are changing it in startup. …

Wouldn't you also need a field for the actual image ( or the path of the actual image, depending on what you are trying to implement)?

I hate ads in TV or the radio, as it feels to me that every 2 mins of movie or show I get 5 mins of ads. I sometime watch them just to see what marketers are thinking to create new "needs" to the people and then wonder if I'm …

I'd call it evolution, but you call it blackmail to buy their new fancy little something only to get their hands in our money. I see your point, but then again we've gone from DOS to windows 7 & 8 and it wouldn't be possible unless software kept up with …

If this was MS SQL I'd join 2 subqueries. 1st) select user_id,client_id, min(time_start) as time_start from tl_appt where time_start >= getdate() group by client_id, user_id If you join all 3 fields returned your data will be limited only to the earliest appointment. 2a) select client_id, count(*) from tl_appt group by …

When expecting only 1 value and especially if you are assigning that value to a variable/textbox/label you should use ExecuteScalar. This way you don't waste resources bringing in a reader for just 1 value and it's a lot easier to handle and control. Try this: Try sqlstatement.CommandText = "select sum(amount) …

Long version: Friend, apart from describing the layout you've provided no info on your project - that is unless there is no project, just the need for this printout. If you can read the data from a db then I suggest you Google VB.Net crystal reports tutorial and I'm sure …

Post your code and we'll see where you went wrong.

I'm guessing that you are looking for Form.FormClosing event. Read about it here: http://msdn.microsoft.com/en-us/library/system.windows.forms.form.formclosing.aspx

This might be silly, but try changing `date` to `[date]` , as it might be reserved word.

I'm having this feeling that since the migration to the new system the number of posts (new articles or replies) has been significantly reduced? At least in VB.Net and databases that has to be true, with new registrations or not.

@Reverend: It must have been lost in the mail. :D Look at the bright side, you are not the last poster. Users... always look for something to nag (I'm joking of course).

If you disable these permanately then you won't be able to use them either. If you disable them while your program is running (I don't see how) then how are you going to make sure that your program won't close/crash ? I don't see how disabling My Computer or Command …

There is a way, but it's not just an update query. I don't have a server available, so this might contain errors, and you didn't give a table name so I'm using MyTable. select ROW_NUMBER() over (order by Timestamp) as 'row' , * into MyTable_fix from MyTable update a set …

For another, there is no need for a data set if you are only retrieving a count. Use ExecuteScalar instead and get the value directly in string.

Loop through all records in your datagridview - after populating the dgv and not on form load necessarily - and set the color as per your criteria. Have you tried anything yet?

It seems to me that you got something working, but not all the way. You need to replace your inner joins with left joins and you'll be set - provided that you only have 1 subcategory. Also your where could be replaced with only `where t1.id = [a value here] …

We rarely need to recognise barcode devices in programming. They usually simulate keyboard entry and you accept their input as would with normal keyboard. To generate barcodes as hericles said you need a font. A free 3of9 font will do the job, usually by starting and ending your string with …

It would help to know the error or the exact nature of the "problem" you are having and possibly know how you are trying to use this string. As a rule of thumb when having problems executing a command in a different system, start by verifying the command you are …

Do you have Contact_dataDataSet1 modifier set to public or friend? If it's private then you can't reference it outside it's class/module. If it's friend then you can access it within the same project and if it's public then you can access it from anywhere.

I see a problem with seslie's script. If for example you had a reservation for room 111 for period starting 1st of May and ending 10 of May, then the seslie's script would return it as available. For this particular script to work you need to insert a record in …

May I ask why go with a file in the first place? Why invent the wheel all over, when there are dbs you can use? Handling 10 million records for mySQL or MS SQL (even for Express) will be a walk in the park and you get all the goodies …

You can use ROWCOUNT (http://msdn.microsoft.com/en-us/library/ms188774.aspx ) or TOP (http://msdn.microsoft.com/en-us/library/ms189463.aspx) to limit the number of records affected by your statements, if your data are EXACTLY the same in all fields. I really don't like using TOP or ROWCOUNT, and try to create unique keys if possible. Can you please explain what …

Open it and verify that all wires are in place and correctly connected. If it still doesn't work (test it without screwing it together) then try your old monitor. You might got the wrong monitor or the new one just doesn't work. If you don't get it to work with …

The syntax for counting number of records with 2 criteria is : `select count(*) from table where column1 = 'value1' and column2= 'value2' ` I'm guessing that you are a beginner and won't get you messed up with parameters, so set up your command like `x = "select count(*) from …

Google can do wonders : http://social.msdn.microsoft.com/Forums/en-US/sqldenreportingservices/thread/51ec52b1-5bae-4834-bde3-81212dff21bb

If it's Excel and it's a one time thing - or even if it's re-occuring rarely - then I'd concatenate the values into SQL statements in Excel and copy paste them in SQL. It can either be the update statement itself or it can be an insert statement for your …

I agree with utrivedi. My guess is you've used the graphic environment to join the 2 tables and see only the 2 word fields and it didn't work. What you need to do is insert both words in the Words table and then insert their "relationship" in the Meanings.

you can use the immediate pane and messagebox or debug.print them

Don't hijack threads, use proper English and show effort

It sure looks like it's encrypted

I think that l(i) and t(i) don't exist. You've named your objects as txtField & i. Try to cast "txtField" & i in textbox and get it's value this way.

> I tried but stil could'n made it. Please show your code and we'll indicate what you've done wrong.

I'll focus on you adding the blank records rather than deleting them. change your code to : For test = 0 To containerdetaildatatable.Rows.Count - 1 dim i as integer = DataGridView1.Rows.Add() DataGridView1.Rows(i).Cells(0).Value = containerdetaildatatable.Rows(test).Item("Roundtrip") DataGridView1.Rows(i).Cells(1).Value = containerdetaildatatable.Rows(test).Item("NoTrips") DataGridView1.Rows(i).Cells(2).Value = containerdetaildatatable.Rows(test).Item("Distance") DataGridView1.Rows(i).Cells(3).Value = containerdetaildatatable.Rows(test).Item("TypeofTrucks") DataGridView1.Rows(i).Cells(4).Value = containerdetaildatatable.Rows(test).Item("frm") DataGridView1.Rows(i).Cells(5).Value = containerdetaildatatable.Rows(test).Item("Destination") Next …

I don't think it makes a difference. Worse case scenario go with single table and use it only through views to control the ammount of info available. I always take into account the sensitivity of data when designing a db. In your example it doesn't matter (unless you are treating …

In my library I've got a script found ages ago in the internet. It's for MS SQL server but it might help you get an idea or something. This stored procedure creates a temporary table for storing search result data and steps through each column found. CREATE PROC [dbo].[SearchAllTablesAllColumns] ( …