shorten this code( because somtiems we will use many columns) by using the second code below . is the second code write?
Form1.DataGridView1.Columns(0).HeaderText = "Name"
Form1.DataGridView1.Columns(1).HeaderText = "Tel"
Form1.DataGridView1.Columns(2).HeaderText = "ddress"
I'm using VB.net 2005. I have working programs that I populate DataGridViews with something like the following:
[Code]...
I have to create an auto installer, which create database at installation time, i created sql database script file and add in vb project. Now i want to read and execute this script file
View 6 RepliesI have use vb2008 express edition. I created a project have database(access). How can i creat setup this project.
View 3 RepliesSupose User Start My Application First Time The Text file Creat automaticly With The name Of "MyLog1.txt" if User Run Again AFter Closing !!! I want to Creat a New File Like "MyLog2.txt" it mean if User have still open My application then My App. Replace text in same file. BUt If you CLose Application and Run Again Then My App. Must be creat a NewFIle With The Different Name...
View 16 RepliesI'm creating setup application, and I try to insert a serila number to the costumer information. I foud this: %%-###-%%% it's mean the erial number will be 77-000-777. How to creat another seril number I don't even this %%-###-%%% how it converted.
View 9 Repliesi wont to creat application, in wich with file location find tables and use them in my app. as databases
View 1 RepliesI'm busy creating a multi language application, so far so good. I've googled some examples, first problem I've encountered is setting it. Accourding the msdn documentation it had to be done BEFORE initializecomponent. I didn't know how, but found out you have to creat a 'sub new' in your main class.
[Code]....
i have been coding for years, but never integrated XML. So I guess I'm a newbie. I have inserted an XSD file in my project, ARequest.xsd. I created a folder in my project called XML just to organize things, so this file ARequest.xsd, is in this folder.
Now I have a form that displays data from a database that has the same fields that are in this XSD file. Can I load the XSD file into my Windows Form, load the elements from the data on the windows form and then create an XML file then send it? If so how? Any code snippets would be helpful. Now I do know how to create the XML file, we'll call it Test as
[Code]...
i use this code to hide a column
"DataGridView1.Columns("HulpstofId").Visible = False"
[code]....
Mistakingly I have deployed an application on 20 laptops and discovered that one of the columns text size to 2 characters to small. How can I check and set this in code? If I can do it this way I don't need to get all the databases back and do it manually.
View 2 RepliesI'm trying to complete this airline reservation application, but having a problem in this part of the question:Creat an event handler for the FlightBindingSource's PositionChanged event: select FlightBindingSource in the class Name combobox then select position changed in method name combobox to creat the FlightBindingSource's PositionChanged event handler. Write a code to access the currently displayed flight object and pass its flightNumber to method DisplayPassengers as a decimal.This Is my code so far:
HTML
Public Class AirlineReservationForm
Private database As New ReservationsDataClassesDataContext()
Private Sub FillAll()[code].....
Option Strict disallows Late Binding for behind form code dynamic building grid columns VS2008 VB.NET ASP.NET 3.5 bf.DataField = strDataField(ForCount)
[Code]...
My goal is to connect to my database either manually or using an sqladapater, and get information from two of my databases on sql server 2005. Then I want to take this information and on run-time begin to add/subtract/divide/multiply certain columns and place the information into other columns. I can do this in queries, however, I want to do it on run-time what is the best way to achieve this.I had some of this working, but I just want to start fresh and see how you would go about doing this.
[Code]...
I have the below Linq query that is returning the data but I need to aggregate the columns to group on the Period and Sum the Count columns. How do I go about doing this?
LINQ
from t In tblTimes
join h In tblEngineeringDashboard_CADMachinesCounts on t.ID Equals h.TimeID
Order By t.Period
[code].....
I am using the following code to alter an table imported from an Excel spreadsheet
Dim SQL As String = "ALTER TABLE receipts ADD payee integer, account integer, category integer, reconciled boolean"
Dim dataread As New OleDb.OleDbCommand()
dataread.Connection = Connection1
[code]....
Both ExecuteNonQuery() actions yields the exception message {"Syntax error in field definition."}The error message does not happen with the first if the boolean column is not there (I tried Tes/No as a definition - but that also failed.The second query to modify the ID column from autonumber to integer I assume fails because it is a Primary KeyHas?
Imagine the following scene: I have one table which have tree columns (ID, Number, Name).
A Select query result on this:
code:
Now, the user deletes the Number 3 and 4. So, now the Select query is going to be:
code:
And I want to have:
code:
How can I organize the column?
While looking in the dataset designer for a database table I am doing in visual basic 2008 I found a line for expressions under the property menu for a specific column. I need to know the code that I would put in this expression line so that this column adds up the numbers I input into three other columns and displays that number in the column. I need it to automatically calculate this for each row in the database table.
View 13 RepliesI've the following code which successfully makes an average for all the columns from a table. What I need to do though is ignore certain columns in this equation.
Dim totalNumber as Double = 0
Dim count as Integer = 0
For x = 0 To xyz123.Tables(0).Columns.Count - 1
[Code]....
Averaging columns in a table - ignoring certain columns
View 2 RepliesWhat should I use and how to use something that functions like a label box but can handle several columns and columns? Something that looks like this. [code] Name | Age | Birthday are headers and the letters are variables
View 5 RepliesI have a datatable property called prpParametersTable in a class called clsBatch. I have a procedure that sets a datatable variable called dtP equal to prpParametersTable at the beginning of the procedure. I then add three new columns to dtP.Here is my problem. When I add the three new columns to dtP my original table prpParametersTable also gets those columns added to it, why? I only want to add the three columns to dtP and not prpParametersTable. How can I do that?
Private Function prvfnc_InsertBatchParameters(ByRef cnn As SqlConnection, ByRef trans As SqlTransaction) As String
' set new columns that have BatchID, Insert DateTime, and UserID for the SQLBulkCopy method below
Dim clm As DataColumn
Dim dtP As DataTable = clsBatch.prpParametersTable
[code]....
I have Dataset ds filled up with values Until now I was displaying values in GridView. Now I want that all the rows should be columns and columns should be rows.I have 2 options: Either 1 I can directly convert grid to columns and display it, or 2 I can convert the GridView to html and then write loops to convert. I was trying the 2nd option but I cant figure out how I should do that.[code]With this code I am still getting same as GridView. Please help me for converting rows to columns and vice versa.
View 1 RepliesI have some code to execute code at runtime...
Here is the main
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Try
If TextBox1.Text.Trim <> "" Then
If TextBox2.Text.Trim <> "" Then
[code]....
When the button is pressed, it all works and the following files are created: yahoo.dll and yahoo.pdb My question is this: What is the code to load the already compiled yahoo files to execute the code again, without having to recompile the code?
This code was posted in Chit Chat and everyone is saying how great it is. I just have Visual Studio 2010 and no familiarity with VB6 so I thought it would be good to convert the code to Visual Basic 2010.
[Code]...
I have a CheckedListBox that will be used to choose what columns they want to select from a database. Is it at all possible to display it in the format of [Table Name].[Column Name]?So far I have this:
con.Open()
theQuery.Connection = con
theQuery.CommandText = strColumns
theAdapter.SelectCommand = theQuery
[code]....
I tried adding another clbFields.DisplayMember, but this obviously just overwrites the table name with the column name. I also tried doing:
clbFields.DisplayMember = "Table_Name" & "." & "Column_Name"
but that didn't work either.I know it's not exactly life threatening if the user can only see the column name, but it'd be nice to be able to see the table name in case of any duplications?
I have some data and would like to add certain columns into a list. So if my data is
[Code]....
Although the code works, im wondering how i could relate the director to the movie with the two list types i have?
i have a datagridview table ("Bookingen") that is bound to an acces datatable
this table ("Bookingen") has columns
an i also have another form that alows people to add info like a registerform
what i would like is that when adding the info by button click
a column with the name of the person from registerform displayes in datagridview ("booking")
this my code so far
Public Class nieuw_personeel_invoer_code_
Private stroledb As String = "SELECT* FROM Loginnummer"
Private strconnection As String = "provider= Microsoft.ACE.OLEDB.12.0; Data Source=D:clifs project21.accdb; persist security Info=false;"
[Code].....
I'm having problems with adding columns to listview. [code]....
View 1 RepliesHow can i add Columns to Treeview so that first column should be as tree and rest are like listview or Listbox.
View 12 Replies