602 Posted Topics
 | The SQL statement looks wrong ( not sure which database you are using) `select * from postoffice where date between '" & datefrom.Value & "' and '" & dateto.Value & "'"` try `select * from postoffice where date => '" & datefrom.Value & "' and date <='" & dateto.Value & …  |
 | Hi, Can you post the code you have so far? I'd also google and run a search on this very forum - they have loads of examples and queries on here about datagridviews |
 | Hi, OK so you have a class set up for your stock and you are using it correctly, from the looks of what you have given. How will you show the user the board?  |
 | Hi Are these tables on different databases? If not you could look at using a UNION in your Select statement to give all the results in one query. OR you can create a new blank Datatable that is a clone of one of the existing tables and populate with each … |
| | Hi, As the good reverend says drag and drop - make sure you are in the design view of the form - unless are you using something other than WinForms? |
| | Re: Vb.net Projects Hi Like the other guys here are saying, try learning a new language or technology. New things are coming out all the time - how about seeing if you can do one of the games you did in VB.Net but in C# or Java  |
 | Hi, Your going to have to loop through all the subfolders from your starting point all the way down to where you can not find any sub folders trouble is your going to have to keep doing this for each folder you find and each of it's sub folders... If … |
| | Re: my problem Hi, If I understand you, you want to add new records (and changes?) in your dataset to the database? Did you use a DataAdapter to fill the DataSet? IF so you need to specify its UPDATE Commands: Public Function CreateCommandAndUpdate( _ ByVal connectionString As String, _ ByVal queryString As String) … |
| | Hi Not sure what you are looking for, Your code will give you something like: <ServerName> <ServerName>\<Instance1Name> .... <ServerName>\<InstanceNName> if you are allowing users to configure a database connection have you tried using the DataConnectionDialog class? It will handle all that interface for you and return the necessary connection string. |
| | Hi, Getting some strange behaviour when using Interop to create a Word document from a template. I'm using word to generate a nicely formatted and printable Receipt from Sage 200 based on a Word Template. The code should open Word then create a new document based on the template I … |
 | Hi, Does your XML file only contain one entry for the Launcher? and the Launcher can only have one application and name entry? Also in your code you have `GetVerLink = _reader.Value.Trim()` on your Version entity but I don't see a value entry just a name attribute. |
 | Hi What is "WaitForLoginBrowser" and where is it stored in your application? I take it is some sort of sub routine. Is it available to your form on load? |
 | I'm luckly I live in Ireland - there are so much activities available for kids to do in the local community for free on next to nothing. For example my son's weekly activities break down as follows Monday & Wednesday nights 1 hour class BJJ (Brazilian Jujistu) €5 per class … |
| | Hi You should look up the [OLEDBConnection Class](http://msdn.microsoft.com/en-us/library/system.data.oledb.oledbconnection.aspx) to find out how to run SQL against a Database through OLEDB (as opposed to SQL Server). To connect to the Access database through the OLEDBConnection Class, you will need a [connection string to connect to Access](http://www.connectionstrings.com/access/) This should get you started … |
 | Hi Are you sure the default format is **yyyy-dd-MM HH:mm:ss**? Try formating it as **yyyy-MM-dd HH:mm:ss** (Serial date) Dim eventdate As String = Format(DateTimePicker1.Value, "yyyy-MM-dd HH:mm:ss") Also you may want to double check that syntax, - I'm always mixing my months and minutes up hence I usually do this: Dim … |
| | Hi All, I'm fairly new to using Linq but I thought I had a handle on it, apparently not though. I'm processing an XML file sent out as an error report by a third party. I have no control over this file and it has been developed to an industry … |
 | Hi, Try modifying the SQL statement from `Select Dept From SoldItems Where SalesDate >= @StartDate And SalesDate <= @EndDate` to `Select Distinct Dept From SoldItems Where SalesDate >= @StartDate And SalesDate <= @EndDate` The DISTINCT command does precisely that i.e. returns only DISTINCT results. |
| | Hi you may want to look up Interop - it will enable you to open a new word application, create a word document and write to it. A word on Interop: * It will only work if a version of word is installed on the clients machine. * You may … |
| | Hi, Do your code behind functions fire on postback? |
| | Hi, Sorry not 100% sure what you mean. Maybe some of the code you've written so far would help?  |
 | Hi, You can use the dropdown on the properties window to select any controls or forms, even ones you can not see on the screen (simply scroll to the one you want,) upon being selected it will become active and you can cut and paste etc. |
| | Hi Try: while objDataReader.read() cmbExecutor.selecteditem.value = objDataReader.GetInt32(0) End While Which will force it to supply the first integer value in the row One Question though as you loop through the data rows returned by the data reader, you will be constantly changing the selected value of cmbExecutor, is this what … |
| | |
 | I know this is from the C# forum but it maybe worth having a read of... [What Resources are available to you](http://www.daniweb.com/software-development/csharp/threads/448647/new-programmers-what-resources-are-available-to-you)  |
| | Hi, I'm a bit rusty at this but here goes, in your code the buttons are being dynamically created based on the database records so you have to specify which sub routine to run on each button that takes the command arguments and uses them. i.e. you can not rely … |
| | Hi You can move objects around in VB.net using bottom, top, left, right properties for example a [Button Control](http://msdn.microsoft.com/en-us/library/system.windows.forms.button_properties.aspx). You will however need to use a DO events as well. |
 | Re: tic tac toe Look at your code on setplayerturn: Sub setplayerturn() If isFirstPlayerTurn = True Then isFirstPlayerTurn = False isSecondPlayerTurn = False txtfirstplayer.BackColor = Color.LightGreen txtsecondplayer.BackColor = Color.White ElseIf isSecondPlayerTurn = True Then isSecondPlayerTurn = False isFirstPlayerTurn = False txtsecondplayer.BackColor = Color.LightGreen txtfirstplayer.BackColor = Color.White End If End Sub If `IsFirstPlayerTurn` is **True** … |
 | Hi, The fact he sent you an updated exe to accomplish this suggests he did hard code it somewhere. |
| | Hi, Sorry but you will have to read in every line of the text in order to identify where the text you are looking for begins and ends and begins again if you see what I mean. You will only want to retain the sections of text you need. Why … |
| | Hi, The OLEDB connection to Access is not as sophisticated as the SQLDB to SQL server, basically it doesn't support named parameters so you must pass each parameter in in order. i.e. taking your query: `SELECT [Customer Number], [Last Name], [First Name], Address, City, State, [ZIP Code], [Telephone Number], [Account … |
| | Hi, It is refering to a formula : `a = SUM(MyField1)` |
| | Hi, Can you give us what code you have so far and we can take it from there? As I understand it, for a given person, you want to retrieve their "visits" from the database and display the details of each visit in a separate tab page in the Tab … |
 | Hi, I'll assume that you do realise that the `</a>` tag is the end tag for `<a>` and not `<img>` Also are you sure the attributes inside the tag are using single quotes rather than double quotes? `<img class="stat_icon" src="/images/red.png">` is different from `"<img class='stat_icon' src='/images/red.png'>`. Why not use Instr …  |
| | I was going to say you could use the [AddHandler](http://msdn.microsoft.com/en-us/library/7taxzxka.aspx) Statement **BUT** if you follow the example given by tinstaafi you don't need to - the custom class is always set to read only and always has a white background. I'll give you an example of using addhandler on a … |
| | Re: Command Object Hi, I'm not sure exactly what your question is but this link will give you all the information on the [SQL Command](http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.aspx) Object. The **OLEDB Command** object would have a similar syntax. |
 | Hi, It'd be easier to figure out if we can see some of your code - where you make the calls etc between the projects. |
 | Hi, You will need to output the new Order Number as an output parameter or return in your Stored Procedure. You should drop the datareader too and use cmd.ExecuteNonQuery as you are not returning a data result set. Tweek your stored procedure something like as follows: CREATE PROCEDURE Update_OrderNo @OrdNo … |
| | Hi, the "**p**" at the end was to allow him to refer to the **Personel** table as **p** instead of writing out **Personel** all the time i.e. **p.PersonelID** instead of **Personel.PersonelID**. Try generating the query inside your Access using the **QBE**, make sure your happy with the results then switch … |
 | Hi Do you know what user the program is running under? Is it a local machine user? You will need to use a network domain user account so that both machines will recognise it and grant this account access under SQL server Management studio. |
 | Hi, You've concatenated the fields in your query and you want to split them back out again? You could try using the split function on the space character: dim Names() as String .... Names = dgvProfessor_bs.Rows(e.Rowindex).Cells(1).Value.Split(New Char() {" "c}) textboxFirstName.Text = Replace(Replace(Names(0), ",",""),".","") TextboxLastName.Text = Replace(Replace(Names(1),",",""),".","") TextboxMiddle.Text = Replace(Replace(Names(2),",",""),".","") |
| | Re: Blob Columns You need to use a [stream](http://msdn.microsoft.com/en-us/library/system.io.stream.aspx) to to stream the data into your RichTextbox |
| | hi, If you do a view source can you see the <img> tags? If they are there, I suspect they are pointing to a local path relative to your word doc - If memory serves correctly when you save a word file to HTML it creates a folder to keep … |
| | Hi, Your code to get the sections looks wrong, you should be passing in the whole rich text box text not data1 and I'm not sure you are calculating the point correctly i.e. `sLeft = left(rtb.text, rtb.selectionstart-1)` would get you the text in the rich text box just before the … |
 | In terms of the law, once when I was younger and more foolish I was running late to the wedding of my then girlfriends sister. I had been held up in traffic so when I got to an open bit of dual carrage way I nailed the car and (of … |
 | Hi, They've cross posted on your post... I suspect your query is only returning a single record. You are reading the results in two different places though. You have the following line (#16): `datareader.read()` This will read in the record from the datareader but you don't do anything with it... …  |
 | Yes, clearer definition and sample code would help... |
 | Hi, I see you adding to the datagridview and I see you inserting via your insert command - are you getting an issue or something? |
| | Hi, As far as I can see there are two ways to do this, just use the replace function: IF Instr(StartPosition,HTMLopt.rtb.text, txtSearchTerm.text,SearchType) = 0 then Messagebox.show("String :'" &txtSearchTerm.Text &"' not found", "No Matches", MessageboxButtons.OK, MessageboxIcon.Asterisk) Else HTMLopt.rtb.Text.Replace(txtSearchTerm.Text,txtReplacement.Text) End if Or if you fancy scrolling through the textbox and replacing as … |
| | > this method will return the contents of a specific field in the curtrent record This is in a comment on one of the functions in "your" class I suggest starting here... |
 | Hi, What errors do you get and where did you get them? You need to add a reference in your project to **adventnet** which I assume is the software that communicates wih your card. - there should be a .dll file somewhere on your machine called aventnet if that is … |
The End.