602 Posted Topics
 | Hi, I'm guessing the file is a csv (comma delimited file) or some other delimited 1 Read in each line of the file to a string 2 Use split on this string to generate an array of substrings (or columns) 3 Print out the necessary Columns from that array - … |
| | Hi, I now this thread is like intially two years old but I keep seeing people trying to connection to the SQL express instance using ServerName. SQLExpress [B]always[/B] installs its instance as ServerName\SQLEXPRESS N.B. You can have as may instances of SQL running on the same machine as you wish … |
| | Hi, I'm sorry but I'm not 100% sure what you are trying to do. Are you wanting to pick a bill number then see all items on the bill? |
| | Hi, Why use the Access DB? you can link directly to the Excel document as if it was a database table. Try looking at the Data Files section of [URL="http://www.connectionstrings.com"]http://www.connectionstrings.com[/URL] for the excel version you are using. Also you can google ADO.net and Excel or VB.Net and Excel and get … |
| | Err.. you've posted to the Vb.net forum not C++ |
| | Re: vb.net hi, Try this link it should show you the ADO.net connectionstring to Oracle. [URL="http://www.connectionstrings.com"]http://www.connectionstrings.com[/URL] |
| | hi, see my reply to your other post.... |
| | Hi Do you have access to a Database? If so store the login records with a timestamp and when the user logs out retrieve this record and get the time difference between the stamp and current time. If not store your logins in another file and parse it from to … |
| | Hi Here is the offical ADO.NET (What VB.NET generally uses to connect to datasources) page: [URL="http://msdn.microsoft.com/en-us/library/h43ks021(VS.71).aspx"]http://msdn.microsoft.com/en-us/library/h43ks021(VS.71).aspx[/URL] Here is a site on generating connection string to databases including Access: [URL="http://www.connectionstrings.com"]http://www.connectionstrings.com[/URL] You may also what to try "googling" "DataSets VB.NET", "DataAdapter VB.Net" and "DataReader VB.NET" etc. |
| | Hi, What I would do is before your are going to Insert your new city record check for matching records first, if it is clear insert, if not then query the user: [CODE] strSQL="SELECT COUNT(*) FROM CITY_MASTER WHERE LOWER(CITY_NAME) = '" &lcase(MyCity) &"'" ..... If CityCount > 0 then msgbox … |
| | Hi Go into Visual studio, select make new project and save. You have made a new project - it doesn't do anything but it is a new project... The only place success come before work is in a dictionary. *This advice is programming language independent |
| | Hi I think I see what your issue is if your text is over a certain value in length you wish to put in a line break but of course not in the middle of a word! Try something like this: [CODE] Sub InsertLineBreaks(ByRef MyInput As String, ByRef MaxLength As … |
| | Hi, This link will point you in the right direction using the built in ASP.Net login class. [URL="http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.login.aspx"]http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.login.aspx[/URL] |
| | Re: store procedure Hi These sites will show you how to use SQL server and Stored Procedures: [URL="http://www.microsoft.com/sqlserver"]http://www.microsoft.com/sqlserver[/URL] [URL="http://www.functionx.com/sqlserver/"]http://www.functionx.com/sqlserver/[/URL] This Site will show you how to connect: [URL="http://www.connectionstrings.com"]http://www.connectionstrings.com[/URL] To put values in to textboxes it is the same as if you had created the SQL query on the fly: [CODE] Dim mCommand As … |
| | Hi, First of all, it looks to me like youi are not passing in the database values but strings e.g. "[Line 1]" Second, what are the values that you are storing in the database? As far as I'm aware CheckState is looking for three possible values: Checked - displays a … |
| | Hi, There are a lot of in build common functions too many to go into on a single post e.g. there are String functions like Split, lCase, Ucase, there are Maths functions like Sqrt, Log, Sin, conversion functions like CStr, CInt, CBool and many more. Best thing you can do … |
| | Hi So youve created a load of new checkboxes on the fly and then you want to go through each one and check if it has been checked? To see if a checkbox is checked in VB.net (and VB too) you need to do something like this: [CODE] IF MyCheckBox.Checked … |
| | Hi You'll need to be more specific, it really depends on the program you are communicating with and other factors. For example, an ASP.NET website on a webserver will usually be using ADO.NET to communicate with a database program on another server. which may in turn be used by an … |
| | Hi What exactly is Login? If that is the name of your form then the line [CODE]Login.Close()[/CODE] Is probably why your form closes. |
| | Hi You want all the [B]Rows[/B] from the database table returned not just [B]Row 0[/B]? (that was a pretty big hint BTW) |
| | Hi I've more experience with Microsoft SQL server but to me it looks like you are finding the database but don't have the rights to access. Try pointing the server entry to somewhere that can't / doesn't exist do you get a different message? If so, that means you were … |
| | Hi This isn't really a Vb.net question... A tip for you though is to open the sql managment console, point it at your Database and run the following in a query window: [CODE] EXEC spGetAdjustmentDetail @AdjustmentId=#### [/CODE] (### = a value for adjustment ID) It will output the results to … |
| | Hi Create a new form, put a textbox on it. Create a button with the text value 0 onthe onclick event add a zero to the text of the textbox repeat for numbers 1-9. add a button for each function you wish to carry out and use the onclick event …  |
| | Hi Can you give us some sample code? It really depends on which type of file you are printing - if it is a word, excel etc file then you can easily use the built in print functions to print the page. Acrobat has it's own internals too. The last … |
| | Hi Try this URL: [URL="http://www.dreamincode.net/forums/topic/30894-working-with-the-active-directory-in-vbnet/"]http://www.dreamincode.net/forums/topic/30894-working-with-the-active-directory-in-vbnet/[/URL] #It should help you get started |
| | Hi To Refer to the OpenFileDialog you would use something like this: [CODE] dim MyDialog as New OpenFileDialog [/CODE] You should be able to find out how to use the dialog here: [URL="http://msdn.microsoft.com/en-us/library/system.windows.forms.openfiledialog.aspx"]http://msdn.microsoft.com/en-us/library/system.windows.forms.openfiledialog.aspx[/URL] To actually open, edit and save the file then you should use System.IO Namespace if you look … |
| | Hi You would need to hold your values in a string or some other variable that you can then put into a message box at the end of your loop. e.g. [CODE] dim ReOrderItems as String For increment = 0 To MaxRows - 1 quantity = KiwicyclesDataSet.Stock_Control.Rows(increment).Item("Quantity") reorderlevel = KiwicyclesDataSet.Stock_Control.Rows(increment).Item("Re-Order … |
| | [QUOTE=cscgal;1219964]The [code] button spelled out, watermark in the editor window, and Code Explanation page are all coming back. The "New" button in thread listings is also coming back. So is solved threads and reputation within posts.[/QUOTE] Hi, Can you do something about the dropdown menus hiding behind the google ads …  |
| | Hi Folks, I wonder if anyone knows what is happening here because I'm very confused... I have some nested repeater that I'm using to display a list of Categories, projects and tasks on my ASP.net site written in VB.net i.e. Repeater 1 Category Repeater 2 Project Repeater 3 Task In … |
 | Re: The New Design Hi, I'm having an issue with IE 8 and the new design I can't access most of the forums because dropdown menus are appearing behind the Google ads along the top. I tried to go to the category page and navigate from there but unless there is a recent post … |
| | Hi, I have an issue involving retrieving a set of child rows in a dataset. I have populated a dataset with three tables Categories, Projects and Tasks. In the dataset relations I have set up a relationship between Categories and Projects and between Projects and Tasks. [CODE] Private Sub Defaults_Load(ByVal … |
 | Hi, It sounds fine for a starter project, it has a real life application and is in an area of interest most people can relate to. What are you going to use to search on? Are you intending to use a backend Database? If so you should only use enough …  |
| | You probably can guess this from the previous threads but I use: [CODE]dim MyTable as Datatable 'fill datatable.... If (MyTable Is Nothing) Or (MyTable.Rows.Count =0 ) Then 'it's empty Else 'it exists and there are rows End if[/CODE] |
 | Hi, I don't see in your code where you INSERT a record.... You only SELECT records and UPDATE an existing record (if there are any) Also I'm not sure I follow exactly what it is you are doing. I see that you get a username value from a list box … |
| | Open the prescribed text on VB programming for whatever course you are on at chapter one |
| | Hi All, I've published a app using Clickonce Deployment for use on our LAN (so I've set it to online only for ease of updates etc) When I run the setup on my own machine, the app installs and runs with no issue however when I run the setup on … |
| | Hi All, I hope someone out there can help with this. I'm writing an app where a user selects a folder on the network for a job to deposit output into. The person setting up the job will not necessarily be the same person who runs the job and that … |
| | [QUOTE=ssgatbliss;1118683]All, Currently we have macros built so my guy just highlights the excel cells (each one represents an hour of the day) and hits a key to color the cells red (green is default). [/QUOTE] I'd open up those macros and expand on them to build one that parses through … |
| | [QUOTE=twalton42;1090895]I'm using mysql database..I have forms setup main form has datagrid..you can add to this datagrid and save to datbase with my add form and it works fine. I can delete from the datagrid and it works fine...when I select an account to edit is when I have my issue...form … |
| | Hi I think you are looking for a data item.... e.g. [CODE] sub populatecomboboxManually () dim MyCombo as New Combobox 'do whatever you need to get your data..... for i = 1 to 10 'New DataItem(ID (is not displayed) , Value (is displayed)) MyCombo.items.add(New DataItem(i,MyValue)) Next end sub sub readvaluefromcombo() … |
| | Hi Try this: [CODE] dim dtTable as Datatable dim drRow as DataRow dim intRecord as integer 'assume you populated the table etc for intRecord = 0 to dtTable.Rows.count -1 drRow = dtTable.Rows(intRecord) myCombox.Items.Add(New DataItem(drRow(0).Tostring, drRow(1).ToString) next [/CODE] |
| | Hi All, In my VB.Net app, I want to read in a load of addresses from a database and then use word to create address labels on an Avery template L7163 which is then printed to the printer. However, I have two issues: 1. Before word prints, I'm asked to … |
| | Hi I've written a printing application which is working perfectly when I debugg and step through but does not print anything when running a debugg with no breaks / step through. I suspect I need to use something like Do Events to get the application to print out. However when … |
| | [QUOTE=ViRiPuFF;1079628]Hi I need to insert some data from Text boxes in an aspx page into an Access DB but I keep getting a Data type mismatch in criteria expression error. The problem is the Double which I think I have converted correctly. All the other fields are OK as strings … |
| | HI Guys, I have written an app the prints out batches of documents for postings. Each batch is to be seperated by a red coversheet. I know that in our printing department, no matter what printer they use to print the batches on to they will always have the red … |
| | Sorry, I'm just trying to understand exactly what is happening you say: [QUOTE=SarahInc23;1078897] The problem is as follows: Each salesperson is assigned a 4 character ID, with the first character either an F (full-time) or a P (part-time). And the last character is either a 1 (sells new cars) or … |
| | Re: sql in vb.net [QUOTE=wiss.dev;1076983]hi im trying to retrieve data from a foxpro database in a date range selected by the user from 2 datetimepicker boxes dim date1, date2 as date date1=datetimepicker1.value.date date2=datetimepicker2.value.date i used this command oSql="select * from customer where between(customer.date,{^date1},{^date2})" an empty table comes up.....can any one help pleas[/QUOTE] Hi There … |
| | Here is a good site for finding out what connections you need to use to connect a datasource (e.g. SQL Server, Excel, Oracle etc) to your code. [url]www.connectionstrings.com[/url]  |
 | You basically want to find a piece of text within another piece of text? [CODE] function findit(byRef TheText) as integer dim i as integer i=instr(RichTextBox1.text, TheText) return i end function [/CODE] or if you wish to find all occurances something like this will do (I'm a bit rusty with arrays … |
| | Hi Guys, I'm obviously missing something here. Basically I'm writing a program that will read in a csv file or excel file, and allows the user to pick which fields thay wish to use for what line of an address, and then import all the addresses to a SQL table … |
The End.