Visual Basic

how do you add new item to databound combobox vb.net

24-Feb-07 13:25

You have to reload your dataset that the combo is bound to. Depending on what you're doing, you may also have to call ResetBindings on your BindingSource to get the controls bound to it to reread their values.

Dave Kreskowiak
Microsoft MVP - Visual Basic

rctriplane23-Feb-07 19:15

rctriplane

23-Feb-07 19:15

DatagridviewCheckBoxColumn

vnilo23-Feb-07 13:58

vnilo

23-Feb-07 13:58

I would like to know if it is posible to show some text next to check box.

Thanks.

Victor Omar Nilo Valenzuela
Santiago, CHILE

Dave Kreskowiak24-Feb-07 13:27

24-Feb-07 13:27

Just set the CheckBox's Text property to whtever you need.

Dave Kreskowiak
Microsoft MVP - Visual Basic

vnilo27-Feb-07 3:03

vnilo

27-Feb-07 3:03

Thanks, but how can access the datagridviewcheckbox when we are working with the rows.cells collection (the ColumnType was defined as DataGridViewCheckBoxColumn), example:

Row.cells(Index).value = true
row.cells(index).text ??????????

Thanks.

Victor Omar Nilo Valenzuela
Santiago, Chile

Dave Kreskowiak27-Feb-07 3:38

27-Feb-07 3:38

OK. The question went from a CheckBox to a CheckBoxColumn in a DataGridView. It might have helped if you specified this in your original post. CheckBoxColumns don't have text with the CheckBox.

What are you doing with this. It sounds like you have a design problem with your presentation.

Dave Kreskowiak
Microsoft MVP - Visual Basic

vnilo27-Feb-07 3:49

vnilo

27-Feb-07 3:49

OK, my question was about DATAGRIDVIEWCHECKBOXCOLUMN, how to show a text aside the check box, well, the answer is that it is not possible.

Thanks

Victor Omar Nilo Valenzuela
Santiago, Chile

Dave Kreskowiak27-Feb-07 15:20

27-Feb-07 15:20

vnilo wrote:
how to show a text aside the check box, well, the answer is that it is not possible.

Cool it. I just asked you a question about why you're doing this. There may be an alternative solution to the problem.

It's not impossible, just not doable using the standard controls. You'll have to create your own DataGridViewCheckBoxColumn class to add Text support to it. You'll need to replace the painting code with your own implementation, and possibly add some new properties to control how you want the cells painted, like checkbox on the left of the text, or on the right, among others...

You can check out this[^] example for a start. You'll notice that doing something like this can be very tedious and difficult to get every detail in the drawing code correct.

Dave Kreskowiak
Microsoft MVP - Visual Basic

My web browser

c3p0b223-Feb-07 12:37

c3p0b2

23-Feb-07 12:37

I'm currently trying to create my own web browser, for fun only. Smile | :)

And i have three problems, i don't know how to:
1. Display URL, i'm currently pointing with mouse, in status bar.
2. Display URL (of the link i clicked) in the combobox/textbox.
3. Refresh the page.

Any help?

Thanks in advance. Smile | :)

BTW, i'm just a beginner in VB.

Re: My web browser

JUNEYT3-Mar-07 5:00

JUNEYT

3-Mar-07 5:00

Here some advice ans sample statments:

1. WebBrowser1.Navigate(StatusStrip1.Text)
I assumed you don't have any other items in statusstrip
2. WebBrowser1.Navigate(ComboBox1.SelectedItem)
3. WebBrowser1.Refresh()

I hope that helps! WTF | :WTF:

What a curious mind needs to discover knowledge is noting else than a pin-hole.

Report designer question

dptalt23-Feb-07 10:08

dptalt

23-Feb-07 10:08

In the .net report designer I'm trying keep some text boxes and label from spilling over to the next page. They are located on the bottom of the page but there is a table control above them and if this table control has many rows to display it pushes everthing below it onto the next page. Can I somehow force the textboxes and labels to keep their position?

format date

jds120723-Feb-07 9:34

23-Feb-07 9:34

I am trying to insert some date columns into a MySQL database using vb.net. When trying, I get the error "Incorrect date value: '02/07/2006' for column 'Orderdate' at row 1. MySQL has a date format like YYYY-MM-DD and will not let me insert those dates because of the format. I am inserting text files and the date columns are formatted like MM/DD/YYYY. When I change the data type in the database to varchar, the dates will insert just fine but when I change the data type to date they won't insert in which the date data type is preferred. I have tried so many different things trying to format this including parameterized queries. Any ideas on how to fix this problem?

Here is some code were I tried using the CDate function and got the error "Conversion from string "" to type 'Date' is not valid."

Dim MyCommand As New Odbc.OdbcCommand("INSERT INTO ls_orderitems (OrderDate, OrderCustomer, OrderAcctNum, OrderType, OrderSoNum, OrderItemPartNum, OrderItemPartDesc, OrderItemQty, OrderItemQtyRec, OrderItemQtyDtRec, OrderItemBO, OrderItemBODt,OrderItemCanceled, OrderItemCanceledDt, OrderItemNotes, OrderItemPONum, OrderItemRetailPrice, OrderItemSalePrice, Status, InsertDate) VALUES('" & CDate(OrderDate).ToString("yyyy-MM-dd") & "','" & OrderCustomer & "','" & OrderAcctNum & "','" & OrderType & "','" & OrderSoNum & "','" & OrderItemPartNum & "','" & OrderItemPartDesc & "','" & OrderItemQty & "','" & OrderItemQtyRec & "','" & CDate(OrderItemQtyDtRec).ToString("yyyy-MM-dd") & "','" & OrderItemBO & "','" & CDate(OrderItemBODt).ToString("yyyy-MM-dd") & "','" & OrderItemCanceled & "','" & CDate(OrderItemCanceledDt).ToString("yyyy-MM-dd") & "','" & OrderItemNotes & "','" & OrderItemPONum & "','" & OrderItemRetailPrice & "','" & OrderItemSalePrice & "','" & Status & "','" & InsertDate & "')")

jds1207

Marcus J. Smith23-Feb-07 9:44

23-Feb-07 9:44

jds1207 wrote:
CDate(OrderItemQtyDtRec).ToString("yyyy-MM-dd")

That should be CDate(OrderItemQtyDtRec). I thought this was already answered.

CleAkO

jds120723-Feb-07 9:53

23-Feb-07 9:53

What?

Marcus J. Smith23-Feb-07 9:57

23-Feb-07 9:57

Dont convert it to date then convert it back to string, just leave it as a date object when you insert it into the DateTime column. The database knows what to do with a Date object as well as a correctly formatted Date String object.

CleAkO

Marcus J. Smith23-Feb-07 10:01

23-Feb-07 10:01

It also helps if the variable isnt blank when you try to convert it. If it is blank you should probably pass DBNull.Value, which you may or may not be able to set to a string before hand.

CleAkO

jds120723-Feb-07 10:10

23-Feb-07 10:10

What variable?

Marcus J. Smith23-Feb-07 10:16

23-Feb-07 10:16

Did you even write this code???

CleAkO

jds120723-Feb-07 10:19

23-Feb-07 10:19

yeah

Marcus J. Smith23-Feb-07 10:26

23-Feb-07 10:26

jds1207 wrote:
Dim MyCommand As New Odbc.OdbcCommand("INSERT INTO ls_orderitems (OrderDate, OrderCustomer, OrderAcctNum, OrderType, OrderSoNum, OrderItemPartNum, OrderItemPartDesc, OrderItemQty, OrderItemQtyRec, OrderItemQtyDtRec, OrderItemBO, OrderItemBODt,OrderItemCanceled, OrderItemCanceledDt, OrderItemNotes, OrderItemPONum, OrderItemRetailPrice, OrderItemSalePrice, Status, InsertDate) VALUES('" & CDate(OrderDate).ToString("yyyy-MM-dd") & "','" & OrderCustomer & "','" & OrderAcctNum & "','" & OrderType & "','" & OrderSoNum & "','" & OrderItemPartNum & "','" & OrderItemPartDesc & "','" & OrderItemQty & "','" & OrderItemQtyRec & "','" & CDate(OrderItemQtyDtRec).ToString("yyyy-MM-dd") & "','" & OrderItemBO & "','" & CDate(OrderItemBODt).ToString("yyyy-MM-dd") & "','" & OrderItemCanceled & "','" & CDate(OrderItemCanceledDt).ToString("yyyy-MM-dd") & "','" & OrderItemNotes & "','" & OrderItemPONum & "','" & OrderItemRetailPrice & "','" & OrderItemSalePrice & "','" & Status & "','" & InsertDate & "')")

The stuff in bold, just leave it as CDate(VariableName). Before you run this command do something like If OrderDate.Trim = "" Then OrderDate = DBNull.Value to insert a NULL value instead of trying to convert a blank value to a date.

CleAkO

jds120723-Feb-07 10:53