Good morning, I have a question regarding if something is possible to do in SQL. Is it possible to setup a Linked Server in SQL, or some other SQL connection that will access an existing Web Service? I have found various web pages about setting up SQL data to be accessable as a Web Service, but I found nothing that says if it's possible for SQL to access a Web Service to pull back records as part of a stored procedure. The reason I'm wondering about this is because as we are moving to a new database engine, it has been suggested to turn off access to Linked Servers. David

I will look into AJAX...it's something I've never used before. Do you know any good places to start? Most of my asp.net programming has focused on doing as little as possible on the html side and as much as possible on the VB Code behind. David

What I'm seeing is that the top frame (which runs a sql stored procedure in it's page load event) remains blank along with the bottom frame. When the data grid comes back in the top frame, the test button appears in the bottom frame. This takes around 10-15 seconds, which is consistant with how long I expect the stored procedure to take. I had expected the button in the bottom frame to pop up immediately and have that frame be usable while the top frame continued to wait for the sql data to come back. David

Good afternoon, I'm attempting to create an ASP.NET website that has two horizontal frames. A top frame will be a frame that loads back data from 6 sql stored procedures and dumps them into datagrids. The bottom frame will contain several buttons, listboxes, and other user interaction controls. The problem I'm having is that I want the user controls in the bottom frame to load first so that the user can use them while the queries run one by one in the top and fill out the scoreboard. I have tried both an inline frame (using one for the top section) and normal frames, but I can't get them to do what I'm looking for. Can someone point me in the right direction? David

I am using ASP.NET to create this datagrid, but I am trying to do all of the code in the VB code section and not the html section. I am building a datagrid as follows: 3 Text Columns 1 Link Button Column 1 Push Button Column In Property Builder, I have set the "Command Name" for both the Link Button and Push Button columns to "Select". This is so that when the user clicks on the column, I can use the SelectedIndexChange event and determine what row they are clicking on. The only problem is that in doing so, I cannot determine the column they are clicking on. Is there any code I can use on the VB side in the datagrid SelectedIndexChange sub to determine what column was clicked in? Anything from the header of the column or even just the column index itself. The SelectedIndexChange sub is written such: Private Sub dg_LastSevenDays_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles dg_LastSevenDays.SelectedIndexChanged End Sub When I try to see what data I can get from 'sender' or 'e', all they reference is the datagrid itself and not anything within it. Search for solutions online, I found a few that would work if this was a compiled application and not a web application. Has anyone run into this before? David

I am using ASP.NET to create this datagrid, but I am trying to do all of the code in the VB code section and not the html section. I am building a datagrid as follows: 3 Text Columns 1 Link Button Column 1 Push Button Column In Property Builder, I have set the "Command Name" for both the Link Button and Push Button columns to "Select". This is so that when the user clicks on the column, I can use the SelectedIndexChange event and determine what row they are clicking on. The only problem is that in doing so, I cannot determine the column they are clicking on. Is there any code I can use on the VB side in the datagrid SelectedIndexChange sub to determine what column was clicked in? Anything from the header of the column or even just the column index itself. The SelectedIndexChange sub is written such: Private Sub dg_LastSevenDays_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles dg_LastSevenDays.SelectedIndexChanged End Sub When I try to see what data I can get from 'sender' or 'e', all they reference is the datagrid itself and not anything within it. Search for solutions online, I found a few that would work if this was a compiled application and not a web application. Has anyone run into this before? David

With SQL Server Express, would it be possible to have it install with the application itself? The program is one I am writing for a friend of mine and isn't something I will be using. I wouldn't want a complicated install process or a hard way for them to move the database files if they had to change computers. My friend is computer literate, but not programming/sql literate. David

I was looking to create a small application that would just run on one or two systems and it would need a local database. What would be the best type of database to use in this situation? I would love to have something along the SQL lines so be able to use it's querying/database/stored procedure capabilities, but I don't know if that's a bit overkill for this application. The application itself will primarily be just a user interface for a customer database. David

Not sure if this is the right forum for this, but I'm having an issue updating an old VBA macro that runs in an IBM Reflections Application. I want to be able to control the exiting/closing of the application. I need to be able to enter some code to log a user off their ID before the Reflections window closes or else it will cause problems when they log back in. Is that possible with a macro?

You either have two options. Either manually iterate through the items in the datagrid after it is populated, do the sum and add a row. Or you can do some 'ROLLUP' functionality in the SQL query so when you pull it down into the datagrid, it already has the sum values you want in their own row(s).

I will look into it, but from a quick glance, it may just be that. Thank you very much.

I'm looking to develop an application that will require a small database table structure (not more then 4-5 tables). I wanted to make the database internal to the application so that there wouldn't have to be a link out to a web server/SQL server anywhere, but with just receiving a new datafile to replace the old one, it would be able to pick it up. Is there any code/project type in Visual Studio that would allow me to create such a database that could be deployed with the application and be able to be queried with a SQL/Oracle type interface/query? I am open to writing the application in either Visual Basic or Visual C++.

One option I can think of would be to place the system with the database in the DMZ host area on the LAN. David

The W3Schools website has some good tutorials, including SQL ones..not sure if that's what you're referring to: http://www.w3schools.com/default.asp[^] David

Here's an article with some sample code on how to pass information from one html page to another: http://www.vbdotnetheaven.com/UploadFile/avi\_sanjay/ServerTransfer02222007000910AM/ServerTransfer.aspx You can transfer which link they clicked on from the first page (or make it have two buttons instead or something). Or, even better, why not just have three html pages in this format: Page 1: Click Link/Button 1 - Goto page 2 Click Link/Button 2 - Goto page 3 That way you don't have to do anything fancy to make it work. David

Can you write some code to have it go through the "document and settings" directory on the system and count the number of profile directories. Just remember to subtract at least 3 for Administrator, Default User, and All Users. David

Why not just pass the 4 hyperlinks to the second page and set them manually when you transfer control to it? You could also do the same with just passing a single value to the second page and setting 4 textboxes with links to the specific values you want to display. David

I had to do something similiar (find every directory\file path for a server) and came up with the following code. You may be able to modify it for what you need: Dim strpath As String = "f:\mp3" 'Your starting path Dim BaseDir As New DirectoryInfo(strpath) Dim DirListing() As DirectoryInfo DirListing = BaseDir.GetDirectories() Dim tmpFI As FileInfo Dim tmpdir As DirectoryInfo For Each tmpdir In DirListing For Each tmpFI In BaseDir.GetFiles() 'Preforn your check and whatnot Next Next David

Something like this. Say you want to sort by Artist name. Make a function: Function CompareArtist(ByVal Artist1 As String, ByVal Artist2 As String) As Boolean IF (Artist1>Artist2) Then Return True Else Return False End IF End Function Then when you do your sort, have something like this: If CompareArtist(mp3file(1).Artist,mp3file(2).Artist) Then //Do you sorting here depending on the result of the compareartist function. End If You could make a seperate comparison function for each member of the object, or just 1 or 2 depending on the type's of the object's members (if they are all strings for example). I hope that makes some sense. David

Can you create an event so that when an item from AccessGroup is selected and then the 'Update' button is pressed, that the table that opens up has the selections of all the possible accesspermissions. Then all you need to do is run through a loop for each permission setup for the item on accessgroup and have it check the neccessary boxes.