ptaylor965

You can't just do a cbo1.items = cbo2.items You will need to do somthing like:[CODE]Dim Value as string 'Im not sure if this should be a string For each Value in cbo2.Items cbo1.items.add(Value) Next[/CODE]

Connecting and using SQL in VB.NET

I have a Crystal Report that shows images using a SQL Database with the image paths When viewing the images in a report everything is fine untill you get to a page in the report when the error pops up [B](Request could not be submitted for background processing)[/B]. The image …

You could store the data in a database, XML files or just you the My.Settings area The My.Settings area is setup from the "My Project" List and it is a left side tab called Settings The My.Settings is good for quick data stores that have a fixed size (one record …

Double Click 'My Project' Goto the 'Publish' Tab Select 'The Application is available online only' In 'Prereqisites' Button Un-Check the option 'Create Setup Program to install prereqisite components' Then in the 'Options' Button Un-Check 'Use .Deploy File extension' Click 'Publich Now' The path set in the 'Publish Location' will be …

Hi, Could you please show me how to get 1.9 to show with two decimal places (1.90) you can use [CODE]Math.Round(1.99999999, 2)[/CODE] if you want to bring the decimal places down to two but how do you increase from zero or one decimal place up to two? Thanks Peter

No, Visual Basic requires the .NET Common Runtime Libraries from Microsoft and as these are not available from the start a VB.NET OS would be missing Most/All required Components

Hi, Please note: The question is at the bottom of the post [B][I][U]Background: [/U][/I][/B] The e-mail server is exchange 2007 server. I have a customer that has requested that we host a push mail account for two of his mail accounts. We did this by creating an account on our …

I am using Microsoft Sharepoint Designer 2007 to create a page from a list. I need to retrieve all but the newest record and display them. Any ideas? Pete

Hi, If the file is in a subfolder of your project then you can call it using its full path[CODE]Dim FilenameAndPath as String FilenameAndPath = My.Application.Info.DirectoryPath & "\Images\Picture001.bmp" PictureBox.ImageLocation = FilenameAndPath 'or FilenameAndPath = My.Application.Info.DirectoryPath & "\Audio\Sound001.wav" My.Computer.Audio.Play(FilenameAndPath)[/CODE]

I have a dataset (Private DS As New DataSet) and i need to make a Crystal Report from the data held within it The data comes from multiple tables then merge into a new table held in the dataset only How do i create the Crystal Report as the new …

Yes you can filter the dataset table rows. Use the select command[CODE=VB]Dim Row as Datarow For Each Row in Dataset.Tables(0).Select("Column = 'Find Me'") MsgBox(Row("Column").ToString) Next[/CODE]

I have been working on a project using Visual Studio.Net 2005 and Windows Mobile 6.1 After several builds and installers it has started throwing up an error during the build stage. Any help would be appreciated. Thanks The error contained in the output list: ------ Build started: Project: Stock - …

Hi, FormName.Show 'to open a form and FormName.ShowDialog 'to open a modal form

Hi, Our "My Documents" are redirected to our file server but vista keeps a synchronized copy of all "My Documents" files on the laptops. Our file server had the "Allow this folder to be avaliable offline" ticked to stop the files from being synced as some Laptops were not syncing. …

Hi have a form with a Multiline Textbox and a Span I save the text and load into a <span> [CODE]lblSpan.InnerHTML = txtMLBox.Text.ToString.Replace(Environment.NewLine, "<br/>")[/CODE] The Span looks fine in IE but If I do this in Firefox the Environment.NewLine is not being converted I am using Visual Studio 2008

Hi We have got a single instance of SQL Server 2005. The latest service pack 3 has been installed today. Since installing SQL Server two months ago we are finding that SQL Server times out if you try to delete records from any table that has more than 600,000 records. …

I have a datatable (sqltable) and a datagrid (dgData) if the user click the datagrid header the grid changes sort order but when i try to get [CODE]Dim Row As DataRow Row = sqlTable.Rows(dgData.CurrentCell.RowIndex)[/CODE] or [CODE]Dim Row As DataRow = sqlTable.Rows(e.RowIndex)[/CODE] the row returned is not the row selected in …

In the forms properties set KeyPreview to True and then use the Key subs that the form supplies [CODE] Private Sub Form1_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles Me.KeyDown End Sub [/CODE]AND/OR[CODE] Private Sub Form1_KeyUp(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles Me.KeyUp End Sub [/CODE] You …

You could run separate SQL Select statements for the selected item [CODE]SELECT * FROM table WHERE Tour_location = '" & cmbindiantourcode.text & "'"[/CODE] or you could download the whole table and bind to the datagrid then run a command like[CODE]ds.tables(0).Select("Tour_location = '" & cmbindiantourcode.text & "'")[/CODE]

when trying to update a sql database i get the following error message on Update Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information the column UserID is the PrimaryKey any ideas would be appreciated Thanks Peter example code: …

The Logs could be hidden files. Open the folder where the logs should be. Press the "Alt" key to show the menu bar. Select "Tools" and "Folder Options". Under the "View" Tab Select "Show Hidden Files and Folders" Press OK If the logs are there but hidden they should be …

I had this issue with my Vista when first installing it. If you wait it will eventually show the screen. I have no idea how long it takes, but with mine I left the room and came back about 5 minuets later and the screen was still hidden but 10 …

The database connection string should be like this [CODE]Dim conn As New SqlConnection("Data Source=SERVER_NAME;Initial Catalog=DATABASE;uid=USERNAME;pwd=PASSWORD;")[/CODE] If in your code you will be creating a database in SQL then you will have to connect to another database (in the connection string) first.

I have a Windows Server 2003 x64 file server and every few days i have to reboot the server as i cannot access the shares from the network. After a reboot the problem goes away for a few days then comes back. Server is Windows Server 2003 x64 R2 with …

I would use a SQL INSERT INTO Statment instead of the objDataAdapter.Update Have a look at [URL="http://www.taylorsnet.co.uk/SourceCodeDetail.aspx?SourceID=5"]http://www.taylorsnet.co.uk/SourceCodeDetail.aspx?SourceID=5[/URL] It shows how to use INSERTs and UPDATEs The code is for SQL but works fine for MDB and ACCDB files (OleDb)

We have just installed a new exchange server into our domain, moved all the mailboxes to the new server and then changed the IP address of the old server so that we could move the new servers ip into place for a clean swap over (IP wise) When we do …

I have a project that requires a barcode and other information to be printed onto a label using a Thermal Printer (i.e. Zebra, TEC) I have a print routine that will print plain text using "Generic Text" driver and has been tested for output using Dot-Matrix printers in other projects. …

Sorry for the delay. x86 (32bit) operating system are limited to 4Gb of memory (3.5Gb RAM + 500Mb Other memory) x64 (64bit) operating system do not have this limit problem and will address all of your RAM If you have a retail copy of Vista you can order a x64 …

Add a timer to your form and add some code like[CODE=VB]If Form2.Left < Form1.Left + Form1.Width Then Form2.Left += 10 End If[/CODE]

I would do one of the following: Change this line from:[CODE=VB.NET]SaveTextToFile(timeSpentTxt.Text, "C:\Docum...[/CODE] To this to save ALL the entered values:[CODE=VB.NET]'Create this as a Form Level Global Private RunningTally As List(Of Double) 'Change the code from 'runningTally += todaysTime 'To runningTally.Add(todaysTime) 'And then change this code 'timeRemaining = 10 - runningTally …

Try using a Timer to refresh the page and AJAX to just reload the part of the page that needs updating and also to stop the page from flashing during the refresh.

Add a FileUpload control to your page [CODE]<asp:FileUpload ID="FileUpload" runat="server" Width="408px" />[/CODE] And then add this code to your upload button[CODE]'Save uploaded file to server FileUpload.PostedFile.SaveAs(Server.MapPath("~/UserImages/") & _ FileUpload.PostedFile.FileName) [/CODE]

When you clicked "Publish Now" under the Publish tab it builds all the files, including one called something like "windowsApplication1.exe.deploy". This is the exe file but VB.NET has added the .deploy to the file name You can remove the .deploy yourself or get VB.NET to do it for you by: …

Look into the commands with in System.Data.OleDb System.Data.OleDb.OleDbCommand System.Data.OleDb.OleDbConnection System.Data.OleDb.OleDbDataAdapter System.Data.OleDb.OleDbDataReader These will allow you to access MS Access MDB and Accdb database files

If you are using number then the NumberUpDown control can be used as it has a property for min and max allowed plus it only allows numbers If you are using textboxes then you will have to check the value entered in the OnLeave sub

Look at creating a MasterPage The details entered onto a masterpage will show on ALL pages

First i would try using standard DataTables as it is possible that the server has not got the prerequisites installed for H2C2DataLayer.h2c2DataSet.topicsDataTable Try [CODE]Dim SQLTable as new DataTable[/CODE]

I would use SQL Select Statments to select the correct data based on a (WHERE) criteria See "VB.NET" > "How to use SQL" on or <snipped>DaniWeb Code Snippet 696

Try looking into the Microsoft XNA Framework It works with VB.NET and C#

Where is the problem? If the problem is with[CODE]Dim c As Integer = DGVShops.Item(0, i).Value[/CODE]Then try using CType[CODE]Dim c As Integer = CType(DGVShops.Item(0, i).Value, Integer)[/CODE] If the problem is the table returning a string and not an integer then this should fix it.

Try[CODE]'In the forms event (Me.Move) of Form1 If Locked = True Then 'Locked as Boolean (Global) Form2.Left = Me.Left + Me.Width Form2.Top = Me.Top End If[/CODE]

Hi, Is it possible to create merged headers and/or sub headers in a datagrid i.e. [CODE]|Column A | Column B | Column C| | SH1|SH2 | SH1|SH2 | SH1|SH2 | | 1 | 6 | 8 | 12 | 6 | 8 | | 3 | 7 | 6 | …

I would use Microsoft SQL Express (FREE) as the database and Microsoft SQL Server Management Studio Express (FREE) to manage and setup the database They are both downloadable from Microsoft's web site

Hi, Try[CODE] Dim dtXML As New DataTable Dim dtData As New DataTable Dim dtRow As DataRow Dim dtXMLRow As DataRow Dim XMLFilename As String '==============Fill dtData from database============ 'Add matching columns to your XML datatable dtXML.Columns.Add("Column Name") dtXML.Columns.Add("Column Name2") For Each dtRow In SQLTable.Rows 'Clear last row dtXML.Rows.Clear() 'Make new …

Hi Try Using Insert & Update command[CODE]Dim OLECon As New OleDb.OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = db.mdb") Dim OLECmd As New OleDb.OleDbCommand Dim OLEStr as String OLEStr ="UPDATE abc SET" OLEStr += " Forname_G = '" & ds_G.Tables("Pupils_1").Rows(j).Item("Forename_G") & "'," OLEStr += " Class_G = '" & ds_G.Tables("Pupils_1").Rows(j).Item("Class_G") & "'" OLECmd = New …

Can you ping the sites?[CODE]i.e. ping www.google.co.uk[/CODE] If you can ping them try connecting to the sites by the IP address and not the URL. If you can't ping them get the IP from one that can connect and try pinging and browsing by IP to check the machines DNS …

[url]http://www.daniweb.com[/url]

Hi, [CODE]Open "Visual Studio" Select "Tools > Options" Tick "Show all Settings" (Lower Left) Select "Debugging" Select "Just-in-Time" Uptick ALL three[/CODE] I would think this would work

You could write the whole site in XML files Read from XML[CODE] Dim dt As New DataTable dt.ReadXmlSchema("Filename_Schema.xml") dt.ReadXml("FileName.xml") For Each Row As DataRow In dt.Rows 'Do Data access code here Next[/CODE] Write to XML[CODE] Dim dt As New DataTable 'Build the datatable dt.Columns.Add("ColumnName", DataType) 'Add rows to the datatable …