Visual Basic

Re: DB Connection Question

16-Dec-04 7:07

Anonymous wrote:
I was trying to use two DataReaders. I guess I need to use two DataSets?

The number of DataSets is not the problem. You can only have one active DataReader object on a connection and any one time. You can have multiple DataSets filled by a DataReader, though.

Anonymous wrote:
"mySqlConnection.Open()"
at the top of my Sub() and close at the bottom. Is this ok?

Not really. You should .Open() your connection immediately before your fill the DataSet, or do whatever you need to do with the database, then .Close() the connection as soon as your done with it. DON'T leave it open and idle for ANY reason. This needlessly consumes resources on the SQL server, not to mention hogs a very expensive licensed connection on the server too.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

marrik16-Dec-04 8:17

marrik

16-Dec-04 8:17

thanks for all your help!

Hide Checkbox in Checkbox VB

shinay16-Dec-04 5:55

16-Dec-04 5:55

It sounds funny, but is there any way to hide
checkbox from checkbox control?

shinay16-Dec-04 5:56

16-Dec-04 5:56

I meant by program. off course I can just put another
control on top of it to hide.

Wjousts16-Dec-04 6:15

Wjousts

16-Dec-04 6:15

CheckBox.Hide() should work.

shinay16-Dec-04 6:18

16-Dec-04 6:18

Sorry this is in vb.
And I just want to hide checkbox only but not label

shinay16-Dec-04 6:29

16-Dec-04 6:29

VB 6

Wjousts16-Dec-04 6:29

Wjousts

16-Dec-04 6:29

So make the checkbox and the label two separate objects.

shinay16-Dec-04 6:33

Easy way of set scroll to bottom in richtext?

16-Dec-04 6:33

The thing is I want to display chinese, japanese, English on this control
only the control can do this is checkbox otherwise i have to install
Microsoft Form 2.0 ObjectLibrary. Since Microsoft won't allow you to distribute this library with your application, I don't want to do.
It only works if you have office installed on your computer.

database help

GaryKoh16-Dec-04 5:49

GaryKoh

16-Dec-04 5:49

hello
im a new VB.NET user
i know there are a lot of thread bout this but
i really need a small example on how to update, delete and add
data to database
i have only 1 textbox...with 3 button(delete, add n update)
with a database name TRY
i dont need much..just a small fragment of code...
i read similiar thread before..but it is very confusing to me
please help me
thank you in advance

Gary

Binding a combobox

Wjousts16-Dec-04 5:29

Wjousts

16-Dec-04 5:29

Hi,

I'm trying to bind the text property of a combobox to a property of one of my objects that is accessed using an index but I can't quite find the right way to make it work. I tried this:

<br />
MyComboBox1.DataBindings.Add(New Binding("Text", Settings.Item(0), ""))<br />
MyComboBox2.DataBindings.Add(New Binding("Text", Settings.Item(1), ""))<br />
MyComboBox3.DataBindings.Add(New Binding("Text", Settings.Item(2), ""))<br />

Which will correctly read the value from the object, but for some reason it doesn't get written back? Any ideas?

Thanks

WJ

Re: Binding a combobox

JWSantora118-Dec-04 16:30

JWSantora1

18-Dec-04 16:30

Just a guess, but maybe the item you're binding TO is not allowed to be indexed. Here's a convoluted hack we have to use to get around the NULL problem with binding combos (but that's another story).
1) create an offscreen textbox (note that it can't be an on-screen textbox with the Visible property set to false (Yes, that's another story too).
2) have your object keep that textbox popuplated
3) then bind your combo to the text property of the offscreen textbox.
In your example, you'll need three offscreen textboxes.
Good Luck
john

carlos_rocha16-Dec-04 4:44

carlos_rocha

16-Dec-04 4:44

Hi!When one writes more lines than the richtext visible area a scroll automatictly shows up, but it doesn't keep up with the text that is being written.I would like it to always be at the bottom, showing the latest writes.Isn't there any property or value that can be changed?I can't seem to find it.All i saw in the web was some strange confusing code with handlers and stuff... :P

Thanks in advance.

Re: Easy way of set scroll to bottom in richtext?

Dave Kreskowiak16-Dec-04 4:51

Re: Easy way of set scroll to bottom in richtext?

16-Dec-04 4:51

This question has been answered many times in the forums. I would suggest you try searching the comments before posting a new question. I answered this one back on Sept.3rd.

In order for the .ScrollToCaret function to work, the RTB must have the input focus:

RTB1.SelectionStart = RTB1.TextLength
RTB1.Focus()
RTB1.ScrollToCaret()

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

carlos_rocha16-Dec-04 23:10

carlos_rocha

16-Dec-04 23:10

Hi!
I can't seem to make it work.My code is like this:

RichTextBox1.SelectionColor = System.Drawing.Color.Red
RichTextBox1.SelectedText = texto
RichTextBox1.SelectionStart = RichTextBox1.TextLength

RichTextBox1.Focus()
RichTextBox1.ScrollToCaret()

Please say that my code has some stupid error, or that i need to set some property to some value.

PS:I'm sorry i haven't searched this forum for the answer, but in my PC this site is very, very, very slow (once i wanted to punch my monitor) and i don't know why it's always transferring data, it never says done...

Re: Easy way of set scroll to bottom in richtext?

carlos_rocha16-Dec-04 23:51

carlos_rocha

16-Dec-04 23:51

Hi! It works fine after all.I had an error in my code.Sorry.

Thank you very much for all your help.

searching a Date field in Access

jlawren7716-Dec-04 4:10

jlawren77

16-Dec-04 4:10

" SELECT PassID FROM Users WHERE (Today_Date) = #Date# " <---- gives me a Syntax error

how can i search the date field for the current date? I also have a query in Access that asks for the passid . if i can't run the search from my vb code, then how can i call the query from code and pass in the passid into the query?

Dave Kreskowiak16-Dec-04 4:45

16-Dec-04 4:45

You should never, Never, NEVER use string concantenation when building SQL queries. You should be using a parameterized query to do this. The parameter object will handle the validation and proper conversion of the date for you.
Check out the docs on the OleDbParameter class here[^] for more information.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

jlawren7716-Dec-04 7:32

jlawren77

16-Dec-04 7:32

I'm not using the .Net framework

I'm only trying to look for a record with the todays
date only to verify it exists.

Dave Kreskowiak16-Dec-04 8:20

16-Dec-04 8:20

This is the Visual Basic Forum, not Access. If you were writing code for this, this wouldn't be a problem, but you run the risk of getting flamed for asking questions in the wrong forums.

Since Access can store dates and time in various formats in the same column, for the best results you have to search between todays date and tomorrows:

SELECT PassID FROM Users WHERE ( (Today_Date>=#12/15/2004#) AND (Today_Date<#12/16/2004#) );

This query will work regardless if the date is also stored with the time, like "12/15/2004 10:14:23 AM". If your dates are also stored with the time, then your query never would have worked, even if you got the syntax correct.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

16-Dec-04 8:36

I am writing this Vb

<br />
strSQLUpdate = "SELECT PassID From Users WHERE (PassID)= " & SearchSQlPassID & " AND (Today_Date)=Date()"  <--- works Sweet :)<br />
    <br />
'open Connection<br />
strCnxn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\RMSC LOGIN\MYDataBase.mdb;Persist Security Info=False"<br />
Set Cnxn = New ADODB.Connection<br />
Cnxn.Open strCnxn<br />
Set cmdChange = New ADODB.Command  ' Create command object<br />
Set cmdChange.ActiveConnection = Cnxn<br />
cmdChange.CommandText = strSQLUpdate<br />
Set rsUser = cmdChange.Execute   ' execute the SQL command<br />

Now i want to test the value of the results

<br />
If rsUser.Fields("PassID").Value = 0 Then <-- error here  Error 3021  either BOF or EOF is true or the record has been deleted<br />

if the passid doesn't meet the criteria above i want it to display a message

<br />
MsgBox ("You first need to log In before you log out!!")<br />
     Cnxn.Close  ' Close everything<br />
     Set Cnxn = Nothing<br />
     Unload Me<br />

how can I test the result without throwing this error?