molze

[code] [COLOR=#0000ff]Private[/COLOR][COLOR=#0000ff]Sub[/COLOR][COLOR=#000000] Form1_Load([/COLOR][COLOR=#0000ff]ByVal[/COLOR][COLOR=#000000] sender [/COLOR][COLOR=#0000ff]As[/COLOR][COLOR=#000000] System.Object, [/COLOR][COLOR=#0000ff]ByVal[/COLOR][COLOR=#000000] e [/COLOR][COLOR=#0000ff]As[/COLOR][COLOR=#000000] System.EventArgs) [/COLOR][COLOR=#0000ff]Handles[/COLOR][COLOR=#0000ff]MyBase[/COLOR][COLOR=#000000].Load[/COLOR] [COLOR=#0000ff]Dim[/COLOR] conn [COLOR=#0000ff]As[/COLOR] [COLOR=#0000ff]New[/COLOR] ADODB.Connection() [COLOR=#0000ff]Dim[/COLOR] rs [COLOR=#0000ff]As[/COLOR] [COLOR=#0000ff]New[/COLOR] ADODB.Recordset() [COLOR=#0000ff]Dim[/COLOR] connStr, sSQL [COLOR=#0000ff]As[/COLOR] [COLOR=#0000ff]String[/COLOR] [COLOR=#0000ff]Dim[/COLOR] Results, i [COLOR=#0000ff]As[/COLOR] [COLOR=#0000ff]Integer[/COLOR] connStr = "Provider=SQLOLEDB.1;Initial Catalog=xxxx;Data Source=x.x.x.x;User ID=sa;Password=xxXXxx;Application name = New_Businessnew" conn.Open(connStr) sSQL = "sp_helpdb" rs = conn.Execute(sSQL, Results) rs.MoveNext() [COLOR=#0000ff]Do[/COLOR] …

[code] IF LEN(Datetimepicker1.value.dayofweek.toString)=0 THEN dates_chosen.text = datetimepicker1.value.dayofweek.toString ELSE dates_chosen.text = DATES_CHOSEN.TEXT +", " + datetimepicker1.value.dayofweek.toString END IF [/code]

I am upgrading a vb 6.0 app to .net and I'm having trouble moving a file. The app retrieves info from an XML. When it's done I try to move the .xml file to a history folder and I'm getting an error: An unhandled exception of type 'System.IO.IOException' occurred in …

something like [code]SELECT "firstname" as FirstName, "lastname" as LastName INTO newTable;[/code] or if you are putting data in the new table from another then [code]SELECT "firstname" as FirstName, "lastname" as LastName INTO newTable from OldTable;[/code]