|
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.
|
|
|
|
|
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.
|
|
|
|
|
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[^]".
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
Damn! Beat me to it! 
|
|
|
|
|
Sorry. Other opportunities will arise though.
|
|
|
|
|
Environment.UserName gives you the account name that started the current thread.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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 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.
|
|
|
|
|
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.
|
|
|
|
|
sunil goyalG wrote: 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.
It's simple gradeschool math. Get the highest and lowest values in each axis. This gives you the bounds of the graph. Then it's a simple matter of dividing by the available space to get your scaling values. Multiple each point by the scale value and you've got your graph.
|
|
|
|
|
Hi,
am using crystal report in my application.Am binding a stored procedure to populate the data on to the crystal report. These days i used to pass only one parameter to stored procedure and i get the data accordingly. But now i need to pass two discrete parameters, based on which the data has to be populated.
I posted the old code below which i use now. In that i send MONTH(@month) to the stored procedure and i get the corresponding data. but now i want to send both month and year to stored procedure and get the crystal report populated..
Dim crParameterDiscreteValue As ParameterDiscreteValue
Dim crParameterFieldDefinitions As ParameterFieldDefinitions
Dim crParameterFieldLocation As ParameterFieldDefinition
Dim crParameterValues As ParameterValues
crParameterFieldDefinitions = rptDocument.DataDefinition.ParameterFields
crParameterFieldLocation = crParameterFieldDefinitions.Item("@month")
crParameterValues = crParameterFieldLocation.CurrentValues
crParameterDiscreteValue = New CrystalDecisions.Shared.ParameterDiscreteValue
crParameterDiscreteValue.Value = month
crParameterValues.Add(crParameterDiscreteValue)
crParameterFieldLocation.ApplyCurrentValues(crParameterValues)
Please help me out .......
|
|
|
|
|
Hi i want to change listindex of DataGridViewComboBoxCell, it can be changed by assigning value to cell like DataGridView1.Rows(1).Cells(1).Value = 1, but my DataGridViewComboBoxCell is dynamic so it updates runtime also, when it reinitiated its default values got null and it displays blank. because it is reinitiated at runtime so i dont know what could be its default value next time, i want to change it to first item in the list as default value, but DataGridViewComboBoxCell dont allow any change in listindex. can anyone help
|
|
|
|
|
I have no idea what you're trying to get at. Perhaps a simpler explanation would help.
|
|
|
|
|
The basic question is this: How do you set the value of a combobox cell? Example:
At runtime, you create a comboboxcell, and add Yes and No as items.
Now, you want to display the Yes in the cell. No luck. Setting .Value does not help. The Yes does not appear.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
