Search:

Thanks guys. Now this really steams me ... I spent several days struggling with this and had no luck, Just now I opened both projects at the same time (which I swear I did all weekend because it...

I made some changes to a text box control and saved them as a class inheriting the textbox control. I created a new project and put one of my control on it. All works just fine. However, if I make...

Well, I found the problem although it makes absolutely no sense to me. It was disabling the group box that contained the detailed data. If I do not disable the box after updating the data, the...

These three subs are used to load the datatable (TABLE)


Imports System.Data.OleDb

Public Class clsMDBDatabase
Dim OLECmd As New OleDbCommand
Dim OLEDA As New OleDbDataAdapter

Using VB.net 2012 and a datagridview. I'm using a datatable to populate a datagridview programmatically. If I click a cell, the data on that row should be displayed in greater detail elsewhere. This...

The angle works great .. thank you. Sometimes the syntax on things is not exactly intuitive.

The binding is still the same problem. I used an alias in the sql statement for Date .. but the problem...

Thanks for the information guys. What I ended up doing was this:


Dim s As New Series
s.Name = "PPG"
s.ChartType = SeriesChartType.Line

Dim mn As Double = 1000
...

I'm using the stock chart control in vb 2012 and getting the data from an MS Access dB.


SQL = "SELECT Fuel.DatePurchased as [Date], Fuel.PPG FROM Fuel " &
"WHERE (Fuel.DatePurchased...

OK ... I found the answer. I went into VS and experimented with split until I understood it. Then I went back to CR and used Basic Syntax with this:

dim birthday() as string
dim mnth as string...

I think I'm posting in the right place. I'm using Crystal Reports XI developer with an MDB database. One field in the database is called Birthday and is a text field in the format for example, of...

Yep ... that was it .. the sorting icon. Thanks a million. I might try fiddling around and try to adjust the spaces to allow for the sorting arrow since I would like the user to have that available...

I can't seem to get my text centered in column headers on a datagridview for some reason. The text in the cells is centered ... but not in the column headers. I'm using VB 2012 with the default...

Thanks for the visual ... that helped me get things straight in my head. After a lot of fiddling around with conditions I now have things working the way I want them. For anyone reading this and...

Thanks for putting up with me, tg ... I've been writing code since 1970 but until now I've been able to get by with pretty simple sql. This is working sort of backwards to my mind ...
I follow the...

Thanks for the reply TG. The Units.UnitID field is autonumbered so it's unique and never null - the BuildingID will never be null either. What I was wanting to do is fill a grid with available units...

I've never had to try using EXCEPT in sql but I think that is what I need for this. I've stripped off all the irrelevant fields to make this as straightforward as I can here. I'm using VB 2012 and an...

Thanks jm. The buildingID in the reservation table was experimental as I couldn't seem to get that information from the Unit table. Once I managed to get the syntax in order I removed it. I...

After fiddling around for a couple hours I stumbled on the correct syntax and order. I removed the BuildingID field from the Reservation Table as it was just superfluous.:


"SELECT...

Thank you for the reply jmcilhinney. Your answer is what I had been trying but without success. (I built the SQL statement line by line because it made it easier for me to include or exclude a line...

I assume this belongs in this forum ...

I've got an Access 2003 type dB with 3 tables, Reservations, Buildings and Units. The Units table has UnitID, BuildingID and UnitNumber fields. The Building...

Thanks for the reply jmcilhinney. I ended up adding a new column, hiding the integer column and then stepping through the data to populate the new column. I tried doing that once before in this...

Thanks for the replies guys.

I tried that approach initially but

frmMain.grdUnits.Columns("Occ").Value = "open"
gives the error "'value' is not a member of...

I'm trying to get one column to show "open" when the value is 0 and "occ" when the value is 1.

I'm using vb 2012. Somewhere I'm missing something ... this should be really easy. In fact I use the same technique on another grid which works fine. This grid won't cooperate. The column I'm...

Thank you for the quick reply. Setting the sorted property of the combo resulted in scrambled results. However, using a dataview and sorting that did the trick. I've never used a dataview so I never...

Using vb 2012 I bind the combo to a datatable (TABLE). I also add a new row <None>.


Dim row As DataRow
row = TABLE.NewRow()
row("EmployeeID") = 0
row("EmployeeName") = "<None>"...

Yes indeed ... that's what it was. I was busy thinking columns. Who'da thunk it?

Thanks to you both!

Ken

This is probably ridiculously easy but I've tried searching for an answer without success. I don't think I'm using the right terminology. I want to hide the selection column in a DataGridView control...

Of course! Silly mistake .. thanks for pointing it out. Duh! Thank you!

Thanks for the reply! I made the changes you suggested which make perfect sense to me .. but I still get the complaint:



On the Return CNT line.

Back with another simple question that I cannot seem to get past. Everywhere I look on the net people are using readers but it seems to me a nonquery is indicated for this ... Unfortunately my syntax...

That worked a charm wes4dbt! Thank you! I figured it was some pretty simple syntax that I just couldn't quite get hold of. THANK YOU!

Thanks for the reply, KG. With either approach, the null dataset apparently is never true - although the grid is empty. I tried both ways and the code always thought the dataset was populated so it...

I've been unable to figure out how to do this although it ought to be really simple. I'm using VB 2012.




Dim connection As SqlConnection = clsConnection.GetConnection()
Dim DataAdapter As...

Thank you! That was it.

(Mod: I'm not sure if this is the right place to post this ... )

I'm getting pretty confused about using dates in grids in VB 2012.

I am using 10 grids in the program so I wrote reusable code...

Thanks for the reply, Kevin. That gives me some stuff to consider and look into. Most everything I see on the net is very specific to a single question but not much goes into program architecture....

I'm pretty new to VB2012 having come from years of working with VB6. In VB6 I rarely worked with classes with the occasional exception of using classes for repetitive forms. Since I'm just getting...

Ah I see .. thanks. I'll give that a try and see where it leads me.

I tend to agree with you ... using the wizards are fast, but I find myself completely confused and lost much of the time.

The problem I had was trying to figure out how to make a connection in...