Search results for query: *

Ah I got it. Yes okay remote servers, then add a server, then there you have it. Thank you so much for sending me in the right direction!! :)

Okay cool, thank you. I am looking through the books online and such trying to find out how. The client tools are installed, however I have not figured out how to set up the remote attachment. I'm sure I'm missing something simple!

I was wondering if it is possible to attach a local version of sql server to a remote database file. I have someone working on my program from the next desk over, and he needs access to the actual database we're using to add tables and stored procs. Is this even possible?

Thanks very much RiverGuy...I will read those sections. :)

OH okay. I misunderstood, sorry. Although I still must be doing something wrong...However, before your last post I managed to get the thing to work by doing: Dim theDDLs(3) As DropDownList Private Sub LoadDDLs() theDDLs(0) = ddlBuilding theDDLs(1) = ddlElectrical...

Thanks...I changed the code to this: Dim theDDLs() As DropDownList = {ddlBuilding, ddlElectrical, ddlMechanical, ddlPlumbing} Private Sub LoadDDLs() Dim DDL As DropDownList For Each DDL In theDDLs DDL = New DropDownList Next End Sub ....(In Private Sub...

Okay, I probably don't understand completely. I tried Friend Sub LoadDDLs(ByVal theddl As DropDownList, ByVal theddls() As DropDownList) Dim Index As Int32 Dim theddl As New DropDownList If theddls Is Nothing Then ReDim theddls(0)... But it says theddl has...

I have an array of drop down lists. I also have a procedure that initializes the array (at least I thought) or rather, loads the ddls if I'm saying that right. I also have a for loop that takes the data from a data table and binds it to each of the four drop down lists. When I run the program...

I had to make changes to a vb6 program for a customer. I converted the program into vb .net and made the changes. Now, my customer cannot run the program. He gets the error message: An unhandled exception of type 'System.IO.FileNotFoundException' occurred in system.windows.forms.dll Additional...

Thanks very much Golom! I was working with MOD but I had the syntax all wrong. Thank you! :)

I need to update address records based on whether the address is odd or even. Is this possible? I have not found the syntax. Basically I want to say: UPDATE Addresses SET StreetId = 2 WHERE StreetId = 3 AND Address >= 1 AND Address <= 4197 AND [Address is ODD] Is this totally ridiculous or...

I should also mention that I downloaded NETCFSetup.msi but I can't seem to figure out how to install it on the actual iPAQ.

I need help please. I have no experience with handhelds or Windows CE. I have an iPAQ on which I am trying to run a .net mobile device program written by our company. It was working fine. I need to install the pgm on a customer's iPAQ because their battery died and when they replaced it, and...

I have a table with 4 different status fields. I have a stored procedure that would work for updating each one, the only difference would be the name of the field that was to be updated. Being new at this, I tried: CREATE PROCEDURE [dbo].[pPermit_UpdateForms] @Field varchar(20), @PermitId int...

I have a datagrid with textboxes. I have figured out how to access the textboxes for input and save the data. Now I need to display a record's data. If there is an existing record, I need the info to display in the textboxes. However I cannot seem to access the cells or the textboxes. I've tried...

Thank you!! That makes more sense now! :)

Thanks so much for your replies. I kind of feel like a dummy because I realized I was overcomplicating the whole thing. This: SELECT tStatus.Queue FROM tStatus WHERE tStatus.Id = (SELECT tPermits.Status FROM tPermits WHERE tPermits.Id = 1008) Worked just fine. How brain dead am I?? :) I...

Is it possible to create a single stored procedure that does two things from two different tables? I would like to write one that says SELECT this value from table1 WHERE othervalue = whatever THEN SELECT this value from table2 WHERE table1Value = table2value Is that possible or do I have to...

Yes it turned out it was because I did not say If not IsPostBack at the PageLoad event. When I added that before calling my procedure everything started working. Apparently the page was pulling the old information before the new information could be saved. (I probably didn't say that right. :) )

Yes I have. Everything goes how it should except for the fact that the record changes back to what it was before the update.