Mr.Wobbles

Hi Can you change the alignment of text ion a datagridview column programmatically ? i.e. Columns(0).?????????????????.MiddleCenter as I dont want to centre align all of the columns in the datagrid. Thanks Andrew

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 …

I am not able to display dataset. Can anyone help me out? Here is my code: Imports System.Data Imports System.Data.SqlClient Imports System.Windows.Forms Imports System.Data.OleDb Public Class Form3 Inherits System.Windows.Forms.Form Private WithEvents DataGridView1 As New DataGridView Private Sub Currdbbtn_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Currdbbtn.Click Dim objConnection As …

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 …

Can anyone provide me with code on how to Delete a row from a list box?? lstReorder.RemoveItem (index) I believe is the right code. However this does not actually do anything by itself. How do i tell the program what the index refers to? ie what the index is? for …

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 …

HAI! CAN ANYONE HELP ME TO RETREIVE DATA BETWEEN TWO DATES FROM MS-ACCESS USING VB.NET. I HAVE TAKEN DATETIMEPICKER CONTROLS. THIS IS THE CODE . ITS RETURS ERROR. PLEASE SOLVE THIS PROBLEM. Imports System.Data.OleDb Public Class Form7 Dim con As OleDbConnection Dim cmd As OleDbCommand Dim dr As OleDbDataReader Private …

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

oops - double post, sorry

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

Hello All, I'm Here Again!!! How Do I Import From Excel Or Csv To Vb.net Database. Moreso, I Want A Code To Export From My Database To Excel Or Csv. Great Programmers Pls, Help Me Out It Is Urgent!!!!

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 …

Season Greetings! Searching database file in the application path I want to determine the database file is existing or not... If the database (".mdb") is existing then msgbox "The database .mdb is not existing" if not existing msgbox " The database is not existing" If the database is not existing... …

Hi, My database in Access contains record since 2005 and it is not required for frequent use unless the Audit ask for. So I would like to take the backup of the data through VB6 by writing code instead of going to Access and copying in CD So will any …

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!

Hi everyone, I have included a "Send mail" module in my vb module, but I want to accept the email address from an input box instead of hard-coding the recipients email address because the recipient may be different each given time. Below is my code: [code] SENDEMAIL: Set OutlookApp = …

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 …