HA HA I LIED Good day to you all and i hope you are well. Not a direct code question guys, just in need of advice. Imagine this scenario if you will, You have a internet server with a SQL Server 2000 database and a client with a MSDE installation. Both are running the same database say MYDATABASE. MYDATABASE on server is very large, say 100mb. The client needs one table from the server to do the work they wish to do on their local machine. They want to just get that one table (and all related obviously) updated on their machine as they don't need the full database as that would take ages (being 100mb). How would you suggest passing that one table to the client, the client app updating the database on the local machine. Then, once they have done their work they re-connect to the internet server pass back the data they have added/updated and the server then updates accordingly. Any help would be greatly appreciated. My thoughts and ideas so far - DTS (not used this before though), dynamically formed SQL (clunky, unreliable). Pleaaaaaseeee Help Many Thanks Harry

Good day to you all and i hope you are well. Not a direct code question guys, just in need of advice. Imagine this scenario if you will, You have a internet server with a SQL Server 2000 database and a client with a MSDE installation. Both are running the same database say MYDATABASE. MYDATABASE on server is very large, say 100mb. The client needs one table from the server to do the work they wish to do on their local machine. They want to just get that one table (and all related obviously) updated on their machine as they don't need the full database as that would take ages (being 100mb). How would you suggest passing that one table to the client, the client app updating the database on the local machine. Then, once they have done their work they re-connect to the internet server pass back the data they have added/updated and the server then updates accordingly. Any help would be greatly appreciated. My thoughts and ideas so far - DTS (not used this before though), dynamically formed SQL (clunky, unreliable). Pleaaaaaseeee Help Many Thanks Harry

Dim lIndex As Long lIndex = ListBox1.Items.IndexOf("Germany") ListBox1.SelectedIndex = lIndex Many Thanks Harry

Imports System.data.oledb Private sub ExtractData() 'connection Dim oConn As New OleDbConnection 'command Dim oCmd As New OleDbCommand 'dataset Dim oDS As New DataSet 'dataadapter with command assigned Dim oDA As New OleDbDataAdapter(oCmd) 'set connection string, you'll have to fill that bit in though 'should be easy to find if you don't know how to form it oConn.ConnectionString = "Provider...." oCmd.CommandType = CommandType.Text oCmd.Connection = oConn oCmd.CommandText = "SELECT * FROM Table1" oDA.Fill(oDS) 'You then have a dataset to work with. If you know SQL then you should be able to adapt that to perform all actions Many Thanks Harry

Dim oConn As New OleDbConnection Dim oCmd As New OleDbCommand Some thing like this: Dim oDS As New DataSet Dim oDSNew As New DataSet Dim oDA As New OleDbDataAdapter(oCmd) Dim oCol As New DataColumn Dim oCol2 As New DataColumn Dim oCol3 As New DataColumn Dim oRows As DataRow Dim oTable As New DataTable oConn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=HealthandSafety;Data Source=." oConn.Open() oCmd.CommandType = CommandType.Text oCmd.Connection = oConn oCmd.CommandText = "SELECT * FROM HSDocumentFloorZone" oDA.Fill(oDS) With oDS.Tables(0) oCol = .Columns(1) oCol2 = .Columns(3) oCol3 = .Columns(5) End With oDS.Tables(0).Columns.Clear() oDS.Clear() oDS.Dispose() With oTable .Columns.Add(oCol) .Columns.Add(oCol2) .Columns.Add(oCol3) End With oDSNew.Tables.Add(oTable) With DataGrid1 .DataSource = oDSNew End With Many Thanks Harry

Sorry, i wrote the above reply and i didn't mean to sound in any way cheeky/ sarcastic, I meant can you explain that a little better as it doesn't make much sense at present? Thanks Harry

Good Afternoon All, Just a quick question, has anybody tried to use the visual studio .net installer conditional statements box. I need to only install some components if the operating system is pre xp or 2003 server (less than windows build 2600 basically), i want to use the property windowsbuild but i set the condition to Windowsbuild<2600 (so it should install on w2k, w98 etc.,) but it doesn't install anywhere, what is going on? Am i doing it wrong? Can anyone offer any advice? Thanks Haaaarrry

I am at the end of creating a wizard to install MDAC, MSDE, restore a database and then back it up. aaaaarrrggh what a.......!! What the issue is, is that the MSDE install is in the middle and requires a re-boot so i have added some reg keys to kick off the wizard when it comes back up in the run-once key. When it comes back up it says the "file is not found 53" and doesn't start the wizard obviously. What am i doing wrong? The key added holds the value G:/MSDESetup.exe as this is where the exe is stored. Any help greatly appreciated.... Many Thanks Harry

Hi Again, another quick question if anyone can help, i was wondering how to, on the registration screen verify that the new password is the same as the confirm AGain any help greatly appreciated **** Many Thanks Harry

hi am developing an application with a frameset and three frames how do i get a print button on there to only print the main frame and not the navigation and banner frames. Any help would be greatly appreciated as i am new to asp.net and have to have this done by tomorrow Many Thanks Harry

Thanks, do you know how to do it with the selected index property instead? Sorry to be a pain. Someone also mentioned reverse lookups are they possible? Many Thanks Harry

Thank you that is a sort of help. But, I have added the values from the access levels table through this method: i formed a sql string using a stored procedure to pull the accesslevels from the table, then formed the dataadapter and then filled a dataset. This is then used to fill the ddl. What i need help to do is taking the selected item in the combo, find the corresponding id in the accesslevels table and store that id in the users table in the database. How? as i am lost, is it possible to do it this way or can you suggest any other ideas..... Many Thanks again, Harry

Hi, I am a junior developer, developing a simple web-application. As i am new to ASP.NET i don't know how i go about taking the text in a drop down list then enter it into a table using its ID from the same table. To be more clear I have a users form with only one ddlist stating the access levels of admin, dev, and user, taken from an accesslevels table which holds those three descriptions and their ids (1,2,3). I need to be able to select the description from the ddlist and when submit is pressed the id of the accesslevel needs to be stored in the user table. Does that make sense? Many Thanks Harry "Not everything that can be counted counts, and not everything that counts can be counted" Albert Einstein.

found it out myself, thanks all using this jscript if anyone is interested Response.Write("window.open(" & Chr(34) & "Search.aspx" & Chr(34) _ & "," & Chr(34) & "main" & Chr(34) & ")") Many Thanks Harry

Hi, I am developing an applicaiton in VS.Net using ASP.NET and HTML. I have a frameset (frameset.htm) with three frames (banner, navigation and content). I wish to use the navigation frame to hold asp buttons, i have done this but i can't get the asp buttons when pressed to load the next aspx page in the content frame. Please can anybody advise on this? Is it possible? Many Thanks Harry