602 Posted Topics
 | @malarsevli - do you just want some sort of random ID containing letters and numbers? Or is it some sort of password generator you are trying to get? If you have a SQL database, it has a field type GUID which will generate a randomish ID that uses numbers and … |
| | Hi I would suggest using the keypress event of the login name to only allow letters (Upper and Lower case,) and the numbers 0-9 and some function keys (e.g. backspace, delete and space) that way they will only be able to input valid characters into the login box and correct … |
 | Hi, I'm a bit rusty with this but I don't think you can just copy over the value from one table to another. I think you will have to stream the image out of one table and then put that stream of binary data back in the other table. I … |
| | Hi, As adam_k said if you are using the word libraries and interop to access word, the users machine must have a copy of Word installed. Furthermore, if you specifically include references to a Word library you are depending on the user having the same version of Word installed i.e. …  |
| | Hi The answer to the question you asked is yes of course, the world is littered with client server applications using a common database. (Including this very web site.) The answer to your question I suspect you are actually asking depends on the database server / program you are using. …  |
 | Re: Open Button Help Hi, WebBrowser.WebBrowser1.Navigate(BookmarksList.SelectedItems) SelectedItems implies a collection to me - did intellisense highlight it? I'd say your looking for either WebBrowser.WebBrowser1.Navigate(BookmarksList.SelectedItem) Or WebBrowser.WebBrowser1.Navigate(BookmarksList.SelectedItems(0)) However, given the error message when you tried `SelectedItem.Text` is telling you text is not a valid member on type string I'd say the first option is the … |
| | Hi RepairInventoryDataGridView.Rows(4) Will give you a collection of cells on row 4 of the datagrid. Your Update statement is looking for a single parameter in this case the Repairnumber. Even if your grid only consists of a single column, I still think you will have to quantify exactly what you … |
| | Hi, You should look at the [Keypress event](http://msdn.microsoft.com/en-us/library/system.windows.forms.control.keypress.aspx) for the textbox  |
| | Do you have to use Notepad /text files as your storage medium? It seams to me it would be a lot quicker and more efficient to use a database to store the recipes and then out put this data to text file - you would be able to do the … |
| | Find something that interests you, and see if you can come up with a program to make some sort of associated process easier. Alternatively if there is an aspect of your course that interests you that you can create a program around use this. If you are really stuck ask … |
| | Hi Is this file "live" ie are you looping through the file until something has written to the file? In which case you will have to reload the file in each loop but ensure you only open it as read only or you will lock the file for editing and …  |
| | Hi, Unless you have a reason to open it in a richtextbox you can open it directly like so: Module Module1 Sub Main() ' Open the file 'example.docx' at the current program's directory. ' It will appear in a new instance of word. Process.Start("example.docx") End Sub End Module |
| | Check and see if your datatable is still populated after your update... |
| | Hi All, In my opinion, this is the best way to read in text from a csv file. Take for example if you are importing addresses: "1 Main Street","SmallTown","SmallCounty" The above is fine and easy to parse in BUT what if an address like this was entered: "App 1A, Tall …  |
| | Hi, I can't tell until I see your code... Is it you want to store which checkboxes the person has checked them? |
| | How about "Why you should not go onto forums and expect other people to get your work done for you"? OR "01010101010101011010101 Isn't Binary Fun?" OR "<Insert Tutors Name here> <Insert Insult here>" I'd be willing to bet no one is using any of them  |
| | Hi, I'm not sure what it is your are trying to do, are you displaying answers to questions? |
| | OK, you will need to use the UCase, and mid functions simply like this: Function GetFormattedName AS String dim FormattedName as string ="" dim FirstName as String ="" dim LastName as String ="" if trim(Textbox1.text) <> "" then Firstname = trim(Textbox1.text) end if if trim(Textbox2.text) <> "" then Lastname = … |
| | Hi, Sorry I'll confess I didn't go through all that code BUT I find the best way to handle dates is to put them into DD MMM YYYY format i.e. 23 Nov 2012 Or YYYY-MM-DD 2012-11-23. To get your value back from SQL in DD MMM YYYY format instead of … |
 | Re: filling gridview Hi I'm not 100% sure what your asking, my first guess is that you want to put the results of a query that queries two tables into your gridview? i.e. Get advTitle from another table into your grid? You need to join the two tables in your select query then …  |
| | Hi I'm not 100% sure Access would support this but your query syntax is wrong anyway. I assume field QTY is a numeric type i.e. not a string. In your query you have encapsulated the qqttyy value in Single quotes i.e. your query says it is a string: UPDATE Inventry … |
 | Hi I'd say no, a browser only uses the class for CSS formating it can not identify a certain entity by anything other than it's ID field in Javascript and Name when the form is submitted |
| | Hi, Do you mean manipulate Excel without it being installed on the machine or do you just want a way to do it in .net as opposed to vba? If you don't mind excel being installed on the machine, then you can use Interop. Here is a sample: [DevX.com](http://forums.devx.com/showthread.php?155202-Using-Excel-with-VB.net) As … |
| | Forgive my suspicious nature but that does sound awfully like you want to get up to no good…  |
 | Re: Grid View Pgmer, he has already populated the MyTable table above, he needs to set the mydata4 table to be a copy of the Mytable table. `Dim Mydata4 as DataTable = MyTable.Copy` This will copy the data structure and data from the MyTable to Mydata4. Why though do you create and populate … |
| | Hi I normally write my own command to do Updates Inserts etc then reload the data. But, I think you need to have the `cb.GetUpdateCommand()` line before the `da.update`  |
 | At a guess off the top of my head you would have to find the Latitude and Longitude of each place and use this information to convert into a distance between the two in KM. The trouble is, even if you could figure out how to do this, you'd probably … |
| | Hi, I'm updating an application to .net from VB 6.0. It uses crystal reports to display reports but we get issues around versioning and having to have the client install Crystal so we would prefer not to depend on Crystal. I was originally going to use an XMLReader object to … |
| | Hi, It looks like you are picking up some sort of formatting code or something. Have you tried opening the file in notepad? Are the characters appearing in the file in Notepad? I've had trouble in the past like this with csv files generated by excel especially if some sort … |
| | Re: time computation Change `Dim minless As TimeSpan = TimeOutHours.Subtract(TimeInHours)` to `Dim minless As Integer = CINT(TimeOutHours.Subtract(TimeInHours))`  |
 | Hi, Is this to go on a web page? or a Windows form? On a webpage - you will have to have the webform reload itself on a timer via client side script as you can not force a users browser to reload and webpages are "static" until they reload … |
| | You will need to add a column of type datagridviewImageColumn to the datagridview how are you populating the view by setting the datasource? Or adding new rows programatically? You will probably need to stream the image data into the column if you are getting the data from a database. There … |
| | Never used timespans before but at a guess I'd say: Dim BreakTime As TimeSpan = TimeSpan.FromHours(1) Dim minless As TimeSpan = TimeOutHours.Subtract(TimeInHours) Dim LessLunch As TimeSpan = minless.Subtract(BreakTime) |
| | |
| | Re: learning vb.net [Home and learn](http://www.homeandlearn.co.uk/net/vbnet.html) [Microsoft](http://msdn.microsoft.com/en-us/vstudio/hh388573.aspx) [Programmers Heaven](http://www.programmersheaven.com/2/VB-NET-School) These should get you started, also Wrox generally have good books on programming. Finally, once you are up and started this forum - I learn (or re-learn forgotten,) VB.Net techniques and skills all the time on Daniweb |
 | This is because you are not decreasing the value of i in your decrement function, you are decreasing the textbox entry not i maybe if I illustrate below: 1. Form Loads, i=0 Textbox1.Text = i i.e. 0 2. Press Increment, i=i+1 = 0+1 = 1, TextBox1.Text = i = 1 … |
| | Hi This is because your datatable is held in the computers memory - it is not the database table rather a disconnected query result held there for you. You must either run a command to update the SQL table and then refresh. Or update the Database table and then the … |
 | Here is a simple example: Form 1 Sub ShowDetials() dim RecordID as integer dim DT as datatable Dim DS as new dataset Dim DA as new OleDBDataAdapter dim mCmd as new OleDbCommand dim DetialsForm as new Form2 'I will assume your datagrid has row selection and the primary key of … |
| | Hi, You've defined ch as an oledbcommandbuilder on da1 but you have not given it a SQL Update statement or procedure to run on the update. You also haven't specified that it is the Update command for da1. I think what you are looking for is this: ch.GetUpdateCommand() da1.Update(ds) [Update … |
| | Re: RTF Formatting Hi, I think you need to get the actual RTF back then parse the rich text and strip out any RTF coding and replace the RTF new Line character with vbcrlf. It's been a while since I looked at RTF text so I'm not 100% sure of the syntax. Here … |
| | Show us your code... |
| | Hi, If you want to reseed an identity column in SQL server you would use this: CAUTION Be Very careful before doing this DBCC CHECKIDENT (orders, RESEED, 0) [Reseed Identity](http://www.howtogeek.com/howto/database/reset-identity-column-value-in-sql-server/) |
| | You're only as fast as the slowest point on your connection. I take it that the URL you're sending that too is on an outside network or remote computer? Also, without knowing what your are sending and what the URL does I couldn't say for sure there was no lag … |
| | Can we see a bit more of your code? Where are you specifying the Update commands for instance? - You will need more than one as you are updating two tables within your dataset. |
 | Hi, You should be able to pick up some freeware Screen scraping software to do this for you... |
| | Re: VB Script > The only place success comes before work is in the dictionary As my old grandmother used to say |
| | Hi I suspect the web page you are inputting the data into is performing some sort of client side validation before enabling the submit button. So you are going to have to make your form wait until the button is enabled. Before VB.Net we used to use **Do Events** but … |
| | In your retrieval SQL statement you are using an Insert Statement not a Select statement... Also, cmd.ExecuteScalar is for running queries that return a single scalar value, it would appear you wish to return information other than the picture as well. Once you get the picture out of the SQL … |
| | Hi, I'm writing a VB.net application that runs off a SQL database. If the application can not connect to the database or the connection has not been set up I'm giving the user the option to create the database on the SQL server instance of their choice I then create … |
| | if you wish to use third party tools, I've used [KnowledgeSync from Vineyardsoft](http://www.vineyardsoft.com/) and [Task Centre from Orbis](http://www.orbis-software.com/) Both of these tools can be made to monitor folders for activity as well as other event fired workflows e.g. I used KnowledgeSync to chase up tickets in a help desk system … |
The End.