Search results for query: *

  1. djjeavons

    Tabpages Image

    Hi You can use the "My" namespace to access the image from your resource file and set it to the BackgroundImage property of each tab page: TabPage1.BackgroundImage = My.Resources.ResourceName HTH
  2. djjeavons

    open text file write to file close file

    Hi Could you elaborate a little more on what you mean when you say some values are missing.
  3. djjeavons

    What is the BEST Magazines to subscribe?

    Hi Your absolutely right, 2005 does simplify a lot of things. If you want to you can grab yourself a free copy of VB 2005 Express which will allow you to get your feet wet and explore the new features before deciding to buy any other version. http://msdn.microsoft.com/vstudio/express/vb/ HTH
  4. djjeavons

    How can I program a "save" and "delete"?

    Hi If you new to database programming then maybe the following couple of articles will be of use: http://www.devcity.net/Articles/215/1/article.aspx http://www.devcity.net/Articles/240/1/article.aspx They detail how to execute SQL statements against an Access database to Retrieve, update...
  5. djjeavons

    displaying date in asp.net

    Hi If you are creating the columns yourself in the DataGrid (i.e. AutoGenerateColumns=False) then you can use the DataFormatString property of the BoundColumn to specify how the data will be formatted. For example, it may have a format of: DataFormatString="{0:dd/MM/yy}" Alternatively, you...
  6. djjeavons

    What is the BEST Magazines to subscribe?

    Hi I only subscribe to MSDN and find it packed full of interesting articles and ideas. I invariably find at least one article per month that will help me in my working role. The only downside to this is that I see your primary platform is .NET 1.1 and much of the material in MSDN now is geared...
  7. djjeavons

    open text file write to file close file

    Hi I wouldn't have thought that the StreamReader would throw an exception simply because it came to a word that was enclosed within apostraphe's. Have you stepped through your code and pinpointed the exact line that is causing the error? If you could then post the code and highlight the...
  8. djjeavons

    create Faq page

    Hi I'm sorry, but I am a little confused. Do you want to write the questions and answers all on the same page and then use anchors to jump around the page or do you want the questions on one page and hyperlinks to another page that will display the answer? If I was to assume that you were...
  9. djjeavons

    open text file write to file close file

    Hi Do you mean that there is a syntax error with your SQL statements when you are faced with words that contain apostraphe's. If so, then this is a common issue and is caused by the fact that string values are enclosed within apostraphe's, and if the value itself also contains an apostraphe...
  10. djjeavons

    Calling external exe files

    Hi If you use the System.Diagnostics.Process object rather than the older Shell method you can then instruct the Process to wait until it has exited before continuing with your code. At least, this is true for .NET 2.0 but I imagine the same works in .NET 1.1. Dim proc As New...
  11. djjeavons

    MS word tables in vb.net

    Hi Basically, remove your inner For Loop as it is not required (or at least that is my understanding). HTH
  12. djjeavons

    MS word tables in vb.net

    Hi I'm not totally familiar with the syntax for reading tables in Word but looking at your code, it suggests to me that if your table has two cells then your for statement will iterate twice and therefore print the value of cellText twice. Could you not change this to one for loop to iterate...
  13. djjeavons

    Not able to debug program

    Hi Not that it is of much help to you now that you have resolved the issue, but maybe others will find this useful. If you have installed IIS after installing Visual Studio then you can perform a re-install of ASP.NET which should then fix your debugging issues etc. To do this, open a...
  14. djjeavons

    open text file write to file close file

    Hi Your INSERT statement is a little off which may well explain the syntax error. It should read: cmd1 = New SqlCommand("insert into test1(material_number) values (" & lineValues(1) & ")", sqlconnection1) Notice the additional parenthesis after the Values keyword and after the value you are...
  15. djjeavons

    open text file write to file close file

    Hi There are lots of resources available for detailing how to read an Excel spreadsheet using ADO.NET. The following is a link to a post I helped somebody with that shows how to open a spreadsheet and retrieve all of the data from a specific worksheet. It should only need some slight...
  16. djjeavons

    open text file write to file close file

    Hi I don't believe you can read an Excel file using a StreamReader (I could be proved wrong but as far as I know, this is binary data and therefore, using a StreamReader would be like viewing the file in Notepad). However, I would recommend that you using ADO.NET and the OleDb objects to...
  17. djjeavons

    open text file write to file close file

    Hi How have you declared your cmd2 variable? Make sure you haven't declared it like: Dim cmd2() As SqlCommand HTH
  18. djjeavons

    open text file write to file close file

    Hi Do you mean that the CSV file you are reading from contains duplicated data and you only want to store unique values in the database? If so, then one way you could do this is to store a list of values read from the CSV file and before adding the value to the list you can check for it's...
  19. djjeavons

    Repetitive Code

    Hi Probably the best way would be to create a Data Access Layer that will handle all of your database operations for you. For example, you might create a class file that communicates with SQL Server and performs all operations such as executing a stored procedure or returning data in the form...
  20. djjeavons

    Converting VB6 codes to VB.NET

    Hi To convert VB6 code to VB.NET you simply open your vbp project file in VB.NET and the conversion wizard should then start. However, having said this, it is usually better to re-write your project as the conversion code invariably requires a lot of work to get working and it also uses the...
Back
Top