No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
30 Posted Topics
 | This should help you out.. [url]http://msdn2.microsoft.com/en-us/library/system.windows.forms.datagridview.columnheadersdefaultcellstyle.aspx[/url] I believe you will want the code example second down (VB Usage) |
| | I am getting information from a database and reading it into an xml file - I've tested the SQL and it works just fine on the database I am using - but it won't return anything once I've got it and am trying to use it. Here is my code: … |
| | I have no problem getting it there in the first place - my problem lies in the fact that I cannot get it to update - I have this code: [CODE] Private Sub reloadFieldNames(ByVal tableName) Dim da As New OleDb.OleDbDataAdapter Dim oDS As New DataSet Dim sSQL As String = … |
| | I've been looking for answers to this problem for awhile, and none of what I find seems to work. I have a program that creates a database, and a form based on that database, where the form fields are movable (the user can drag them around in the form) in … |
| | Im not sure about this, but I think the "Runsheet Info" should be the table name that you are pulling from. According to your SQL the table is "Sheet1". Now, again I'm not sure about this, but it is something simple to try and it might fix your problem... |
| | I am trying to insert tables into a database that I created at runtime, I am using MS SQL Server Express, and I have tested this query and it works, in the sense that a table is created. However the small text field (stringText [char]) only has a length of … |
| | You could iterate through the list box items in a for loop, keep a variable that changes by one each time (usually i) and use lst.Reorder.RemoveItem(i), replace i with whatever you use, and if you want to delete only a specific item, check the value of each on with an … |
| | The Title says it all - I don't really need the exact code, but a point in the right direction would be appreciated. |
| | I am writing a program that will take input from the user in the form of a tree-view and create a form and a database based on the tree-view. I have everything working except the group-box control for the boolean expression. I will give a sample code of the text … |
| | I have a program that creates a SQL statement based upon a treeview list that the user makes. The SQL statement looks like this: [code]CREATE TABLE Test ( Test ID PRIMARY KEY, Check1 CHAR(255), Check2 MEMO, Check3 INTEGER, Check4 DOUBLE, Check5 DATETIME, Check6 BOOLEAN) VALUES (1, 'DefSML', 'DefLRG', 0, 0.0, …  |
| | I am trying to add child nodes to a Treeview list, I have the parent node and this is the code I have to add the child node: [CODE] parentNode = New TreeNode() parentNode.Text = Me.headerSelect.Text.ToString parentNode.Nodes.Add(Me.fieldName.Text.ToString) [/CODE] It doesn't do anything - no errors, no adding, nothing.. Also if … |
| | I am writing a program in VB 2005 Express and I am using SQL to insert, delete, etc. I was curious if there was a SQL statement that would allow me to backup the database in Access - I have tried the MySQL syntax for it, but I can't seem … |
| | Without knowing which error you are getting it is hard to tell what to say, something to check though would be to make sure that you have the same format of date in your database as you are passing to it. That could cause a problem... |
| | First I will show you my sql, just in case it is some obvious syntax error on my part: [code] "INSERT INTO tblResults(status, enthusiasm, communication, knowledge, interaction, organization, responsiveness, instID, comment)" & _ "VALUES(""" & status & """, """ & enthusiasmB & """, """ & communicationB & """, """ & … |
| | |
| | i have this code to check and make sure that I wont be inserting duplicate records into my table. i take whatever is in the dr variable and if it is 0 then I go ahead, if not I don't do anything with the variables, I am using Excel, and … |
| | Hi, I have two things that if I can do one I won't need to do the other, so whichever is easiest you guys answer me either way. What I am trying to do is get text from an email and download it into a text file on my computer. … |
 | In order to interface with excel you have to make the reference to it, go to Project -> Add Reference -> under the COM tab select Microsoft Excel 11.0 Object Library (could be a different number based on your version). After that you can use functions that are reserved for … |
| | I have looked quite a bit for this so if anyone could help that would be appreciated. What I want to do is to access a Microsoft Outlook Web email account, I have the server name, port, there is no SSL and it is an IMAP server. I can access … |
| | [code] If(System.IO.File.Exists(path As String) = true){ MsgBox( message As String ) }else{ FileCopy(Source As String, Destination As String) } [/code] |
| | This is what I did to backup my DB whenever I had to - problem is I'm not sure how to find the file to restore it. [code] Public Sub backupDB() Dim backupName As String Dim DBName As String DBName = DBPath + "bb.mdb" backupName = Now.Hour & "-" & … |
| | If someone could tell me if there is a function or method, or some way of finding the directory that the VB project loads to when it is installed on other computers that would be great. What I want it for is so that I can save and restore a … |
| | I am currently using a database within my program and I have no problem backing it up or restoring it when i am simply debugging. However if it is published and downloaded it cannot find the path that it needs to get to the database to copy it. My code … |
| | The button changes an ugly peach color, which doesn't go well with a green theme, when they are clicked. I can't seem to find where to change this color. Any help is appreciated!  |
| | you will need a textbox, in your form, and set the OutlookMail.To = to the textbox name and put a .text after it. OutlookMail.To = textboxname.text |
| | I need to filter the results from a database by year, and so far I have tried several different things, I will list a couple of examples below, I would like to use this one: [code] ServiceAndTeamContributionsBindingSource.Filter = String.Format("WHERE datePart('YYYY',BeginYear) <= '" & endDateBox.Text & "' AND datePart('YYYY',BeginYear) >= '" … |
| | I have been having a bit of trouble with my users trying to install my program, I will list the error messages first and then let you know what my settings are for the click-once deployment. I don't see any errors when I install it on the computer I have … |
| | I have code that opens and closes the connection to the database via table adapters every time I update because it was throwing concurrency and other database exceptions left and right. Now, if I try to navigate through the records it throws concurrency exceptions? I can add, edit, delete records … |
| | I have code that opens and closes the connection to the [URL="http://www.daniweb.com/forums/thread80947.html#"]database[/URL] via table adapters every time I update because it was throwing concurrency and other database exceptions left and right. Now, if I try to navigate through the records it throws concurrency exceptions? I can add, edit, delete records … |
| | [code] [COLOR=green]Private[/COLOR][COLOR=green]Sub[/COLOR][COLOR=green] BindingNavigatorDeleteItem_Click([/COLOR][COLOR=green]ByVal[/COLOR][COLOR=green] sender [/COLOR][COLOR=green]As[/COLOR][COLOR=green] System.Object, [/COLOR][COLOR=green]ByVal[/COLOR][COLOR=green] e [/COLOR][COLOR=green]As[/COLOR][COLOR=green] System.EventArgs) [/COLOR][COLOR=green]Handles[/COLOR][COLOR=green] BindingNavigatorDeleteItem.Click[/COLOR] [COLOR=green]Dim[/COLOR] rowDeleting [COLOR=green]As[/COLOR] portfolioDBDataSet.CRS_AccomplishRow rowDeleting = PortfolioDBDataSet.CRS_Accomplish.Rows(CRS_AccomplishBindingSource.Position) rowDeleting.Delete() [COLOR=green]Me[/COLOR].CRS_AccomplishTableAdapter.Update([COLOR=green]Me[/COLOR].PortfolioDBDataSet.CRS_Accomplish) [COLOR=green]End[/COLOR] [COLOR=green]Sub[/COLOR] [/code] this is the function I have, it shows no errors, but if I try to delete the first record it shows that it deletes all of … |
The End.