You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near and I don't know how does this happen because whenever I check the SQL that I have made including the inserted data, it shows no error.
View 2 RepliesI have got a very simple video player wrote using Visual Basic 2010. I have embedded the windows media player into the app without the controls. Right now it has simple play, pause and open buttons that work with wmp . how to make a slider that corresponds to the normal sliders in video Players?
View 3 RepliesIf sqlquery = "Select admin FROM userlist = True" Then
Form2.Show()
Else
Form1.Show()
End If
My login script works its checking if admin from userlist = true is what i can't seem to get working.
How can i check if a value exists in mysql lets say if user: "Nick" exists."SELECT CHECKIFEXISTS (Value) FROM..." ???
View 3 RepliesI want to now how to check if a database exists in MySQl Server from Vb2010.PBL (Visual Studio 2010 Professional, Win 7 64 bit Ultimate)
View 1 RepliesI use Visual studio 2008 I use MySQL 5.1 I have created een database (test) table (table1 ) with field (Images) Data Type mediumblob size The maximum length of mediumblob is 16777215 (2^24 - 1) characters
I want to Check file size before save in MySQL table1.I want to avoid getting an error message when the image is too large for the mediumblobb field I now use the following code Dim conn As New MySqlConnection Dim cmd As New MySqlCommand
[Code]...
Is it possible for Forms to check for certain entries in an online mysql database and to create new ones? (login/registration)
View 8 Repliesi m using admin levels for a program it uses a Mysql database i now if u use a local db that u can use a dataset but how to do it when u have to Connect to a Mysql and check if the colum admin = 1 ?[code]......
View 3 RepliesI've got a vb app that writes data to a remote mysql database.
When I run the app on a client that does not have the mysql connector it crashes (obviously)
How do I programatically check if the connector is installed on the client and throw up a nice error advising to install it - instead of the unhandled exception error - could not load mysql.data etc error?
Let's say I have a MySql stored procedure that inserts a record with some nullable CHAR fields. In VB.NET if I don't check for Nothing (or Null in other languages), I get an exception from the db driver, so I write:
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("_name", if(name Is Nothing, "", name)).Direction = ParameterDirection.Input;
And this is the first thing I don't like; I'd like to pass Nothing and the driver knows it has to put NULL in the Db. But then, in the stored procedure, I have to check back the field if it is empty:
INSERT INTO mytable
(name, -- other 200 char fields)
VALUES
(NULLIF(_name, ''),
-- other 200 char fields
)
I have to check for nothingness/emptiness twice. Is there a better, more direct, way? Even worse, for non reference types (i.e: Integers) the check for nothingness makes no sense, since a primitive type can't be nothing (yes, I could set an Integer to a non meaningful value, say -1 for a positive id, but...).
how to properly connect to a MySQL database check if a login is valid.Basically i want someone to write me an example of how i connect to a MySQL database, check if username is correct, check if password is correct. If username and password is correct- it should return True as of boolean dim.
View 2 Replieshow to properly connect to a MySQL database check if a login is valid.Basically i want someone to write me an example of how i connect to a MySQL database, check if username is correct, check if password is correct. If username and password is correct- it should return True as of boolean dim.Otherwise it should return false.
View 1 RepliesI have a chat server / client system running, but I want users to authenticate with my vBulletin forum database.I don't want the client to do it, because it is possible to fake the 'successful login' and connect with a fake username. I want to send the username and password details to the server, and make the server check it with the local vBulletin MySQL database for the username and password.Is there a way to do this? To my knowledge vBulletin has a username and a password entries in the database which is salted, and the salt varies from user to user.
View 7 RepliesI have done research on how to manually create sorting in a grid-view and none of it is thorough enough for me to follow. I need more of a step by step solution, like what event should my sorting code go in, how would i enable the headers to allow sorting. normally, i just have .net do this but for some reason this time it doesn't allow it, maybe because i am not using a datasource.that's my code that creates a datable and then binds to the gridview.
Function toptable()
Dim reader As SqlDataReader
cmd.Parameters.AddWithValue("@yeartoget", DropDownList1.SelectedValue)
[code].....
I need to develop CATIA addin using Visual Basic. Does anyone have CATIA programming help or user manual?
View 1 RepliesI have my application set up with ClickOnce. It has been successfully published to my web site. I don't have updates performed automatically but on demand. I have a button that the user can click if they want to check if an update is available and install the update if it is. Here's the
[Code]...
After clicking the button a message box appears and says, "Update is available for download" as you would expect but after clicking the ok on the message box my application goes into a not responding state and I have to close it with the task manager. The application builds successfully and I have a reference for System.Deployment added to the project. Everything in my application works fine as long as I don't try to do an update. Any suggestions on what I should check or do? It should actually say "no updates are available for download" since the version of the program that is being used is the most current version.
If I turn off automatic updating of a binding data source by setting DataSourceUpdateMode = Never and then use a button to update the whole lot (using binding.WriteValue), a problem occurs - Namely, only the first bound control's data source is updated. All other controls are reset back to the original values.This is because when the current object changes (as happens after the above WriteValue), if ControlUpdateMode = OnPropertyChange, then all the other controls re-read in the value from the data source.
One way is to derive a class from BindingSource and add a WriteAllValues method.This method does the following:
(1) For each Binding, save the ControlUpdateMode
(2) For each Binding, set ControlUpdateMode = Never
(3) For each Binding, call the WriteValue Method
(4) For each Binding, reset ControlUpdateMode to the saved value
(5) For each Binding, if ControlUpdateMode = OnPropertyChange, call the ReadValue method.
If working with your own classes, would implementing IEditableObject resolve the issue?In another control I'm working on, I implement my own binding. The way I get around the issue in that is with the following code. (I've put in the bare minimum, I hope you can follow it!):
Private Shared ControlDoingExplicitUpdate As MyCustomControl = Nothing
Private Sub UpdateDataSourceFromControl(ByVal item As Object, ByVal propertyName As String, ByVal value As Object)
Dim p As PropertyDescriptor = Me.props(propertyName)
[code]....
So, when UpdateDataSourceFromControl is called, all the CurrentItemChanged events will be called for all other controls in the same BindingSource. However, because ControlDoingExplicitUpdate is set, they will not re-read in the value from the data source unless they happen to be the control that did the updating.ControlDoingExplicitUpdate is set to Nothing after all these events have completed, so that normal service resumes.
I have a DataGridView on a form in VB 2005 Express, of the 10 columns i need on this DGV 6 of them will be pulled from an MSSQL DB and 4 of them i need to manually enter. One thing i have going for me (i think) is that the 4 manual columns have the same data in each row.I have been filling this DGV using a datatable, but i am not figuring out how to add manual columns and databound ones in the same DGV. My column layout would look like this:[code]some one please explain to me how i would do something like this. if you can include the datatable definitions also it would be a big help, in order for me to verify that i am at least doing that the right way.
View 1 Replieswant to write a program that would have 4 boxes on the menu console:
Box 1) User input ( Ask the user to enter a number)
Box 2) Random Value
Box 3) Rolls value
Box 4) Counter
I want to write a If statement that shows the values of the rolls and the the counter count each time the user enters a number. If however I press the random box, a randomized number between 0-50 is generated and the counted is incremented by 1.
trying to automate some manual tasks. The task to access a web page (asp) login and then get some details from the site. The challenge is that the home page after login is build of 3 frames. when i see the page view source from the edit menu all i see are frame names. Once i right click on each frame and view source i am able to see the complete source - variables javascript function etc. The following code helps me to navigate :
vb.net
Set ie = CreateObject("internetexplorer.Application")
Dim s As String[code]....
After this the page has been logged in. Now to proceed further i have to click a "image" object.
1) I tried qualifying the image like ie.Document..........item("img1").click this doesn't work
2) I tried calling the javascript function directly
ie.Document.all.Item("frame1").Document.parentwindow.execScript "JS_WGorUsers (funcname)", "javascript"
The 1st option gives a run time error and 2nd option says access denied. (if i login manually i am able to click the image.
I had an idea to embed a PDF document into my application somehow.The PDF is a copy of the user manual. I expect that the file will be around 20 KB. This way, if people don't distribute the PDF with my app, they can extract it whenever they need to.
View 3 Replies[Code]...
And have been trying things, but haven't found how to get it fire. At run time when I look at the value of the @Appid paramter it has the first row's value so it doesn't appear to be that.
I have a form that I just want to pop up right above the time on the lower right side of the screen. Does anyone know how to set a manual start position?
View 3 RepliesI am looking to download several files from several FTP sites. Most of the time these files are all present by 08:00, but occasionally they are not there until a little later.Currently we have a bunch of excel sheets where the user goes into each and clicks a button which connects to the relevent ftp sites and downloads the files, performs some manipulation on them and then reports back to the user if the files exist, are empty, or if all is well.I am looking to redesign this, and was thinking I would encompass this within a Windows service which would have some sort of timer functionality which would start at about 7am, and end when all the files were downloaded whereby it would 'sleep' till the next business day.On the task completion it would send an email giving the information that was present in the current excel spereadsheets.
One thing with this is how often to poll the ftp sites to see if the files are there. I would ideally like to poll about once every 15 minutes or 1/2 hour, but if the user knows the file is present then they want to be able to invoke my process.One way of accomplishing this was to make the service a WCF windows service, so that it would run normally, and then if the user sends a request for amanual override, then the service would ignore its timer and run the process then an there.
Code:
dim Insert as string="insert into acaps(AppId,activity_dt,activity_cd,process_state,UserId,SeqNbr,LocCode,comments) values (@AppId,@activity_dt,@activity_cd,@process_state,@UserId,@SeqNbr,@LocCode,@comments)"
Dim x As New Odbc.OdbcDataAdapter(selectQ.ToString, DirectCast(Me._Cn, Odbc.OdbcConnection))
If x.InsertCommand Is Nothing Then
[code].....
And have been trying things, but haven't found how to get it fire. At run time when I look at the value of the @Appid paramter it has the first row's value so it doesn't appear to be that.
i have an application running on VS2010 and i'm using sql server 2008 r2. "Employee" table holds employees bio data, i can draw org chart using MS visio 2010 manual,i need to draw the org chart in Visio format from the VB.net application.
View 1 RepliesI am using the NPV() function in VB.NET to get NPV for a set of cash flows. However, the result of NPV() is not consistent with my results performing the calculation manually (nor the Investopedia NPV calc... which matches my manual results)
My correct manual results and the NPV() results are close, within 5%.. but not the same...
Manually, using the NPV formula:
NPV = C0 + C1/(1+r)^1 + C2/(1+r)^2 + C3/(1+r)^3 + .... + Cn/(1+r)^n
The manual result is stored in RunningTotal
[Code]...
The MSDN page example clearly states that the initial expense should be included in the cash flows list.
How are volume(s) created? Is it a manual or automatic process?
View 2 RepliesWhat's the best Object Browser / Syntax Training Manual? Looking for a good reference guide which helps me understand what I'm seeing with the object browser.
View 1 RepliesThis is my first post. I have just started some serious .NET programming. Can anyone help me understand what is a good, industry standard in developing the VB.NET or ASP.NET applications? Should we use the Automatically generated code by the VStudio or we should be coding manually i.e. handling the datasets, populating the controls etc instead of using the automatic generated code using wizards.
View 12 Replies