"System.Data.OleDb.OleDbException" Im very confused whats the real error?!! Please help!!... [modified] - Visual Basic Discussion Boards

I did help, I have given you simple instructions to achieve what you are asking for, as has at least one other poster. What more can I do? Write the code for you? Tough.

Bob
Ashfield Consultants Ltd

ok thanx

You put your code in the timer tick event, but are you REALLY sure you want to open notepad every 2 seconds? You will soon be overloaded with them.

Bob
Ashfield Consultants Ltd

If you manage to get this working, your affection for NotePad will soon be over... Laugh | :laugh:

Luc Pattyn [Forum Guidelines] [My Articles]

Fixturized forever. Confused | :confused:

I've got 2 Buttons, Next and Previous. I'm using these to move through the images saved in my dataset.

However, looking up Buttons in help you should be able to do something in order to set the Data Source. However I'm not getting this option.

Regards

Vidhish

Buttons have nothing to do with setting a data source, so of course, you didn't find anything in the documentation for the buttons. All a button does is trigger code to run when you click them. You respond to that click by handling the button's Click event. In there, it's up to your code to make any changes required to do what you want, like setting the datasource of another control. A button will not do this for you.

Seriously, pick up a beginners book on VB.NET and work through it. Your question is coming from a complete misunderstanding of how the basic controls work.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

It sounds like you are looking for a control like the BindingNavigator control. I've never used it myself, but you may want to research it as it.

Im using Visual Studio 2005 VB in language..
i have a "application project " and compiled to produce EXE application installer..
the title is "EMPLOYEE DATABASE MANAGEMENT SYSTEM" This application is a customized user interface that manage all the employee data from an access database... it gets the data and display and you can edit, delete, update the employee information using that custom system software "EMPLOYEE DATABASE MANAGEMENT SYSTEM"

>>My OS is windows vista ultimate.
>>My Developing Tool is VS Studio 2005 Pro VB

>>my application package library or Installer Dependencies or i mean all component library or "dll" which are necessary are:
-stdole.dll
-adodb.dll
-msdatasrc.dll
-Microsoft.stdformat.dll
-Microsoft.Buil.Conversion.dll
-Microsoft.VisualBasic.dll
-Microsoft.VisualBasic.Compatibilty.dll

>>the database i use to access with my application is ACCESS 2000 version

>>and my "software" application, database connection is using OleDbConnection and ADODB Connection

so? stdole.dll is for OleDbConnection.. im i right? and adodb.dll is for ADODB Connection/Manipulation.. im i right?

when i run this installer to my "PC" Win.VistaUltimate and other computer Win2000Pro english version "WITH" or "WITHOUT" MS OFFICE 2003 english version or i mean no MS Office at all.. and after that i run the installed "EMPLOYEE DATABASE MANAGEMENT SYSTEM" application? it pops up and prompt my application "LOGIN Form" before entering the entire application... and after you fill-up, my LOGIN Form will connect to the access database 2000 and try to search valid user login then after confirm? my LOGIN Form will open the table "USER_LOG_TIMEIN" for example.. and insert the user time of login...

i just justified that there is reading and updating transaction between my application from the start you open my application and start to login... and im using OleDbConnection...

and finally?? my application run smoothly!!!

but there is a problem i can't figure it out myself and very confusing part..

that when i try to install my application to laptop with OS of Windows 2000 Prof. Japenese version with an MS Office 2003 English en Japanese version...

the application installed properly and when i try to run the my application???

it pops-up or prompt the LOGIN form... and when i try to fill-up my user account and password... then hit the enter or login??? then the error message pops-up

"System.Data.OleDb.OleDbException"
"System.Data.OleDb.OleDbCommand.ExecuteCommandText"
"System.Data.OleDb.OleDbCommand.ExecuteNonQuery"

and i guest that the error comes from a line with a code like this below from my LOGIN Form...

<br />
myOleCommand = New OleDbCommand("Insert Into tblLogHistory(Log_ID,Log_Name,Time_In,Date_In,Computer_Name) " & _<br />
                            "Values ('" & .lblIDNo.Text & "','" & .lblActiveUser.Text & "',#" & Format(Now, "hh:mm tt") & "#," & _<br />
                            "#" & Format(Now, "MM/dd/yyyy") & "#, '" & System.Net.Dns.GetHostName.ToUpper & "')", myOleConnection)<br />
                            myOleCommand.ExecuteNonQuery()<br />

if my application works smoothly from other pc?? how come this one comes out error related with the OleDbConnection error??? i've check out if the library from installed folder are present and all of library are there specially "stdole.dll" AND "adodb.dll" for my oledbconnection and adodb connection...

Anybody there have any idea??? please help... im very frustrated to find a way out with this mess... please help....

im very greatful to anyone who can help... please??

modified on Thursday, November 6, 2008 3:24 AM

vbDigger'z wrote:
myOleCommand = New OleDbCommand("Insert Into tblLogHistory(Log_ID,Log_Name,Time_In,Date_In,Computer_Name) " & _
"Values ('" & .lblIDNo.Text & "','" & .lblActiveUser.Text & "',#" & Format(Now, "hh:mm tt") & "#," & _
"#" & Format(Now, "MM/dd/yyyy") & "#, '" & System.Net.Dns.GetHostName.ToUpper & "')", myOleConnection)

This is all garbage. Rewrite this code to use a parameterized query instead of string concantentation to build the query directly. The OleDbParameter objects will worry about formatting each value for you to so you can limit strange errors like this.

Search the articles for "SQL Injection" and you'll come up with a very good article by Colin Angus Mackay describing the concepts and showing examples.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Hello all,

I'm new to this forum site,I found a problem here with my vb program. I need found multiple field of data for 1 main id. Can I put a button to a vb6 grid? My idea is if I click that button,then it will linkup another vb6 grid to show the data that using the same id.
Example such as this: Student A take 3 subject for this semesterin Uni,so the subject column of this student row will be a button. So when I click the button it will expand a new grid from the column so we can see the subject took y the student.

Hope someone can give me ome guidelines for this problem or any sample reference for this using VB6 codes? I have read some sample or VB.NET but not VB6.

Thanks for reading and hope someone might give me some idea/solution. Thank you~!

Regards
JACSON

First, VB6 is dead. It has not been supported by Microsoft for some time now, and the runtime will not be supported by Windows 7. Support for VB6 by the community and third party controls is also waning. If this is new developement, I highly suggest abandoning VB6 and moving to VB.NET.

Google results for "vb6 add button to msflexgrid[^]".

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Actually its not a toally new system. i am trying to improve the system by adding in the button into one of the grid so easier to display for the user to check it. Anyone can give me any idea about this?
Thanks for reading~!

Why do you want to add a button? Why not trap a mouse click anywhere on the row and display the next row?

Hi i have a datagrid which has textbox with calendar icon image when i click the calendar and select a date the date should display

and the code which i wrote for it is:

but its not working i dono why?Can anyone help me how to modify the code and make it work

my source html for datagrid text box is:

<asp:TemplateColumn HeaderText="Start Date">
<ItemTemplate>
<asp:textbox id="txtFStart" runat="server" Width="80px"></asp:textbox>
<asp:ImageButton id="imgDate" runat="server" ImageUrl="Images/calendar.gif" Height="18px"></asp:ImageButton>
</ItemTemplate>
</asp:TemplateColumn>

and the code behind page i have written as:

Dim imgDate As ImageButton

Dim txtStart As TextBox

Dim strtxtboxID As String

If e.Item.ItemType = ListItemType.SelectedItem Then

txtStart = DirectCast(e.Item.FindControl("txtDate"), Web.UI.WebControls.TextBox)

strtxtboxID = txtStart.ClientID

imgDate = DirectCast(e.Item.FindControl("imgDate"), Web.UI.WebControls.ImageButton)

imgDate.Attributes.Add("OnClick", "Javascript:window.open('Calendar.aspx?textbox=" + strtxtboxID + "','Calendar_window','width=200,height=180,left=315,top=500');")

End If

Post this in the ASP.NET Forum. It has little to do with VB.NET.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

This is probably really simple, but I'm not sure how to do it, and didn't see an answer when I searched the VB.NET message board here, so gonna ask.

In VB.NET, how do I get the windows login name of the person logged onto the computer.

Environment.UserName

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

Fixturized forever. Confused | :confused:

Damn! Beat me to it! Big Grin | :-D

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Sorry. Other opportunities will arise though.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

Fixturized forever. Confused | :confused:

Environment.UserName gives you the account name that started the current thread.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Dave Kreskowiak wrote:
the account name that started the current thread.

Strange way of putting it.

MSDN states "... gets the user name of the person who is currently logged on to the Windows operating system."
I see no way to change my account name while my process is running and possibly creating new threads,
so I assume your statement is correct.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

Fixturized forever. Confused | :confused:

Luc Pattyn wrote:
the account name that started the current thread.

Strange way of putting it.

Actually, the .NET 1.0 through 2.0 documentation says exactly that:
Gets the user name of the person who started the current thread.

The .NET 3.0 and above documentation says the user that is currently logged on. Though, I don't think that's entirely accurate considering you can have multiple people logged in at the same time. So, it's got to be the account (security context) the thread is running as.

Luc Pattyn wrote:
I see no way to change my account name while my process is running and possibly creating new threads,
so I assume your statement is correct.

Sure you can - impersonation.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Gee,

I am unfamiliar with impersonation, i.e. I never needed it in my code.

The way I understand it now is the original sentence ("the user name of the person who started the current thread") was correct but not all that clear: a first thread started by person A can start to impersonate person B, then launch a second thread, which would have B as starter, hence both threads would then get different values from Environment.UserName

And the new sentence ("the user that is currently logged on") is not accurate at all, since
1. several people can be logged on at the same time, so which one would it be (I guess the one
that launched the process)
2. it does not reflect the subtleties of the former sentence.

Once more, a lot is hidden behind a simple sentence. IMO when they change the words, they should
explain exactly why they changed them...

Regards,

Luc Pattyn [Forum Guidelines] [My Articles]

Fixturized forever. Confused | :confused:

Luc Pattyn wrote:
Once more, a lot is hidden behind a simple sentence. IMO when they change the words, they should
explain exactly why they changed them...

I agree. I hate that Microsoft tends to "dumb down" the documentation. It misleads the new people comming into the game. I'd like to see full details about the implementation of each method in each class and deeper examples of concepts, such as creating your own data-bound controls. I can do it, but there's just too many newbie's that don't understand how controls work.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

hi all
i want to draw some couple of point into form(or picture box).

sample coordinates for some points are following

PointNo-----	  X-----	 Y		<br />
1-----	0.4064	-----   7.4848		<br />
2-----	2.5184	-----   7.4848		<br />
3-----	6.3904	-----   7.4144		<br />
4-----	9.5584	-----   7.344		<br />
5-----	5.44E-02-----   4.176		<br />
6-----	2.8704	-----   3.8944		<br />
7-----	6.9536	-----   4.3168		<br />
8-----	9.7696	-----   3.6128		<br />
9-----	1.1104	-----   1.2896		<br />
10-----	5.616	-----   1.0784		<br />
11-----	9.84	-----   0.8672		<br />
12-----	-1.05	-----   8.603703704		<br />
13-----	2.209259259-----	8.603703704		<br />
14-----	7.994444444-----	8.685185185		<br />
15-----	10.60185185-----	8.603703704		<br />
16-----	-1.05	   -----     -0.603703704		<br />
17-----	5.142592593-----	-0.603703704		<br />
18-----	10.68333333-----	-0.359259259		<br />
19-----	-3.16347308-----	10.54256687		<br />
20-----	2.377079047-----	10.3067987

Problem is that some value is negative and so small. So how can i draw the point on form which contains negative value.

simply i want to ask that how can i calculate scale for X and Y axis so all of my point is easily visible on form or picture box.