revo1059
asked on
Rename Column of DataGridView
I want to display a grid with the data from this sql query
SELECT * FROM invoices WHERE ddate >= curdate() - interval 180 day AND equipment = 1 order by invoice_number desc
I think i have it working, however when i load the form in the program, I get an empty box.
I have attached the entire code
The columns i want are
invoice_number, ddate, company_name, and initials]
If possible, i would like the column names to be
Invoice Number, Date, Company Name and Initials
Just to make sure the connection works, i put a message box with the number of rows it found, and it returns the correct value.
I am just starting to learn vb.net so if the answer could explain as much as possible that would be a big help.
SELECT * FROM invoices WHERE ddate >= curdate() - interval 180 day AND equipment = 1 order by invoice_number desc
I think i have it working, however when i load the form in the program, I get an empty box.
I have attached the entire code
The columns i want are
invoice_number, ddate, company_name, and initials]
If possible, i would like the column names to be
Invoice Number, Date, Company Name and Initials
Just to make sure the connection works, i put a message box with the number of rows it found, and it returns the correct value.
I am just starting to learn vb.net so if the answer could explain as much as possible that would be a big help.
Imports MySql.Data.MySqlClient
Imports System.Data
Public Class frmLookupInvoice
Private Sub frmLookupInvoice_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim conn As New MySqlConnection
Dim myCommand As New MySqlCommand
Dim BindingSource1 As New BindingSource
Dim myAdapter As New MySql.Data.MySqlClient.MySqlDataAdapter
Dim dt As New DataTable
Dim dv As New DataView
Dim SQL
conn.ConnectionString = My.Settings.csInventory
Try
conn.Open()
myCommand.Connection = conn
SQL = "SELECT invoice_number, ddate, company_name, and initials FROM invoices WHERE ddate >= curdate() - interval 180 day AND equipment = 1 order by invoice_number desc"
myCommand.CommandText = SQL
myAdapter.SelectCommand = myCommand
myAdapter.Fill(dt)
Dim numRows As Integer = dt.Rows.Count
If (numRows) = 0 Then
MessageBox.Show("No Invoices found")
End If
If (numRows) > 0 Then
MessageBox.Show("Rows Found: " & dt.Rows.Count)
End If
conn.Close()
Catch sqlerr As MySqlException
MessageBox.Show(sqlerr.Message, "Error: " & sqlerr.Number)
conn.Dispose()
End Try
'Dim invoice_number = dt.Rows(0)("access_level")
myAdapter.GetFillParameters()
'dt.Columns.Add(New DataColumn("Invoice Number", GetType(System.String), "invoice_number"))
DataGridView1.DataSource = dv
End Sub
Private Sub DataGridView1_CellContentClick(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.CellContentClick
End Sub
End Class
ASKER
I am using visual basic and connecting to mysql database. Can you show me in visual basic?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I didn't know you could do that
You don't have to answer this, I can make another question but, How do you make a simple repeating region. See, I am used to web design using dreamweaver. If i wanted a table full of data, I would just drag the items from the bindings panel, and slap on a repeating region, and it would display all the records. I am trying to find a way of doing that here, and I just can't seem to figure out how
You don't have to answer this, I can make another question but, How do you make a simple repeating region. See, I am used to web design using dreamweaver. If i wanted a table full of data, I would just drag the items from the bindings panel, and slap on a repeating region, and it would display all the records. I am trying to find a way of doing that here, and I just can't seem to figure out how
Actually, it's very simple with VB2005. Go to the "Data Sources" tab, click "add new data source" and follow the wizard questions. There's a list of walkthroughs:
http://msdn2.microsoft.com/en-us/ms171923(VS.80).aspx
http://msdn2.microsoft.com/en-us/ms171923(VS.80).aspx
The sample below is in C# if you don't mind.
protected void GridView1_RowDataBound(obj
{
if(e.Row.RowType == DataControlRowType.Header)
{
e.Row.Cells[0] = "Column Name";
}
}
http://forums.asp.net/p/1106969/1696341.aspx