602 Posted Topics

Member Avatar for KafitiJr

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 & …

Member Avatar for Reverend Jim
0
141
Member Avatar for Lejan

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

Member Avatar for elie.karkafy
0
253
Member Avatar for dan.gerald

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?

Member Avatar for ddanbe
0
132
Member Avatar for IT_Techno

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 …

Member Avatar for IT_Techno
0
131
Member Avatar for deepaktiwari.k

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?

Member Avatar for G_Waddell
0
70
Member Avatar for Pride

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

Member Avatar for sashyn01
0
407
Member Avatar for Ahmed.C

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 …

Member Avatar for Ahmed.C
0
2K
Member Avatar for Jhermzb_22

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) …

Member Avatar for G_Waddell
-1
112
Member Avatar for nazmule27

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.

Member Avatar for imkhan2845
0
338
Member Avatar for G_Waddell

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 …

Member Avatar for G_Waddell
0
257
Member Avatar for Trle94

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.

Member Avatar for Trle94
0
159
Member Avatar for boher

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?

Member Avatar for G_Waddell
0
508
Member Avatar for matthewwhite011

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 …

Member Avatar for Reverend Jim
0
962
Member Avatar for gayzlein

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 …

Member Avatar for gayzlein
0
8K
Member Avatar for monching

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 …

Member Avatar for shashikumar s g
0
3K
Member Avatar for G_Waddell

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 …

Member Avatar for G_Waddell
0
657
Member Avatar for yvrej17_1

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.

Member Avatar for yvrej17_1
0
157
Member Avatar for lexaeterna

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 …

Member Avatar for G_Waddell
0
322
Member Avatar for while(!success)
Member Avatar for zurehman

Hi, Sorry not 100% sure what you mean. Maybe some of the code you've written so far would help?

Member Avatar for M.Waqas Aslam
0
128
Member Avatar for Eternal Newbie

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.

Member Avatar for Eternal Newbie
0
3K
Member Avatar for tieties

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 …

Member Avatar for Eternal Newbie
0
179
Member Avatar for dev.mohitpatel
Member Avatar for dev.mohitpatel
-1
124
Member Avatar for jagan.rao

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)

Member Avatar for geniusvishal
0
178
Member Avatar for joeyliew7

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 …

Member Avatar for joeyliew7
0
674
Member Avatar for kazekagerandy

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.

Member Avatar for Eternal Newbie
0
301
Member Avatar for roy.tarabay

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** …

Member Avatar for Reverend Jim
0
199
Member Avatar for o Chantelle o

Hi, The fact he sent you an updated exe to accomplish this suggests he did hard code it somewhere.

Member Avatar for o Chantelle o
0
131
Member Avatar for loso09

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 …

Member Avatar for Reverend Jim
0
2K
Member Avatar for SLMQC

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 …

Member Avatar for G_Waddell
0
268
Member Avatar for Nebil
Member Avatar for pc20912

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 …

Member Avatar for pc20912
0
436
Member Avatar for dhimanbiswas4u

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 …

Member Avatar for tinstaafl
0
273
Member Avatar for PM312

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 …

Member Avatar for PM312
0
1K
Member Avatar for Iamateur

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.

Member Avatar for Iamateur
0
202
Member Avatar for androidz

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.

Member Avatar for G_Waddell
0
252
Member Avatar for Papa_Don

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 …

Member Avatar for G_Waddell
0
11K
Member Avatar for 404notfound

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 …

Member Avatar for G_Waddell
0
119
Member Avatar for xLuFeT

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.

Member Avatar for M.Waqas Aslam
0
305
Member Avatar for ses03

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),",",""),".","")

Member Avatar for ses03
0
208
Member Avatar for maiga

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

Member Avatar for G_Waddell
0
97
Member Avatar for ppstyle

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 …

Member Avatar for tinstaafl
0
248
Member Avatar for ppstyle

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 …

Member Avatar for G_Waddell
0
166
Member Avatar for <M/>

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 …

Member Avatar for G_Waddell
0
279
Member Avatar for blivori

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... …

Member Avatar for Dili1234
0
1K
Member Avatar for robnederland
Member Avatar for Sammys.Man

Hi, I see you adding to the datagridview and I see you inserting via your insert command - are you getting an issue or something?

Member Avatar for G_Waddell
0
288
Member Avatar for ppstyle

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 …

Member Avatar for G_Waddell
0
199
Member Avatar for dusto

> 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...

Member Avatar for dusto
0
193
Member Avatar for Hazuan Nazri

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 …

Member Avatar for Hazuan Nazri
0
2K

The End.