|
Use My.Settings.MySqlConnectionString, assuming the value is a valid SQL Server connection string[^].
I just changed the name to highlight the fact that it's not a MySQL connection string. 
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
I am getting error while inserting data into column "initial_read_km".I am writting below code.
Dim t1 As String
t1 = txtiniread.Text
Dim t2 As String = Strings.Right("00000000" & t1.ToString(), 8)
cmd.CommandText = "insert into tbVehicle(Initial_read_km) values('" & t2 & "')"
cmd.ExecuteNonQuery()
please help on this.
modified 22-May-16 15:23pm.
|
|
|
|
|
The string you're attempting to insert exceeds the defined length for the target column. Either make the column "larger", if you're at liberty to do so, or take care not trying to insert longer strings than in can hold. The same applies to binary (blob) columns.
Also, you should never use string-concatenation to build SQL-statements. It's bad for a lot of reasons, the risk of losing your database to SQL-injection being the most prominent one. Use SQL-parameters instead.
If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson
|
|
|
|
|
Why do you call ToString on t1; it is already a string as shown in the previous two lines of code? Also what is contained in t2 when you add it to the CommandText?
|
|
|
|
|
|
String or Binary Data Would be Truncated means you're trying to stuff too much data into the field.
What is your string length coming out as and what is your field length set up as ?
|
|
|
|
|
How we can retrieve Gridvalue ????
I have done the code for retriveing value of gdidview,but the last row return 0 value.
|
|
|
|
|
Please edit your question and add some proper details of your code and what results you see.
|
|
|
|
|
For Each row As DataGridViewRow In dgvDepartmentReadings.Rows
With _MeterReadings
.MonthlyTarget = txtMonthlyTarget.Text
.ReadingDate = dtpReadingDate.Text
.DepartmentTitle = row.Cells("colDepartmentTitle").Value
.MeterNumber = row.Cells("colMeterNumber").Value
.MeterReading = row.Cells("colMeterReadings").Value
.Usages = row.Cells("colUsages").Value
.PercentageUsages = row.Cells("colPercentageUsages").Value
End With
Next
it doesnt give the value of .PercentageUsages column
|
|
|
|
|
Have you used the debugger to check exactly what it is retrieving?
|
|
|
|
|
|
And do you think it might be useful if you explained what is wrong with that?
|
|
|
|
|
That might be actually correct. Did you verify that the column does get it's value from the datasource? It may just as well be a calculated field, tucked away in a drawing-handler or similar.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
Hello,
I am planning to migrate from MSFlexGrid to MsHflexGrid. In MSFlexGrid, when the .col /.row property is changed programmatically, the rowcolchange event gets fired. But in MsHflexGrid the same doesn’t work. However, on manually changing the .col/.row property through mouse click or using navigation keys, the event gets fired in MSHFlexGrid
Please help.
|
|
|
|
|
So it is only missing the raising of the event when you move from code? How about raising the event yourself? Or move the code in the event to a method and call that after moving from code?
It would also be very advisable to migrate to .NET and use a DataGridView or similar control. Visual Studio 6 is a bit outdated, and so is the support for it.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Eddy is being too kind to VB6. It was outdated 15 years ago.
|
|
|
|
|
Hello, I am Quintus S. Creator of QuinSoft Netherlands and the software-collection programs named SniperOS for DOS.
I am now coding version 3 on Visual BASIC 6 for a platform upgrade and useability change. And by software-collection I mean that SniperOS is basically one program containing a lot of tools, games and other useful stuff in one package.
I am now searching everywhere to get software that people might like and/or use, so I am now asking the forum if they/you might have something others can enjoy. If you have any questions, mail me.
Thank you for your help or even just reading this.
|
|
|
|
|
You're only about 15 years too late.
|
|
|
|
|
I have no idea how this forums works anymore, you responded and now spaghetti in my messagebox full of tutorials..........
But i know VB6 is out-of date, I'm a retro guy, and win9X compatibily is crucial in my case.... who knows if anyone might have something I can fit in the program. :/
|
|
|
|
|
|
Just did, spaghetti is gone, yay....
But uhm, so you are stating the language is dead and thsi is no use seeing the last Service Pack was in 1999?
|
|
|
|
|
It's like cars - most people would like a nice new car for reasons of comfort, performance and features, but some people like classic cars that can be temperamental and don't have many of the luxuries of modern design. There is nothing wrong with this, but if you are asked to provide a taxi service I would expect it to use modern cars with aircon and satnav, rather than a Morris Minor or Model T Ford.
=========================================================
I'm an optoholic - my glass is always half full of vodka.
=========================================================
|
|
|
|
|
I'm not sure what your question is.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
Me or the ones talking about cars for some reason?
|
|
|
|
|
I think people are not entirely sure what you are asking.
Do you need code samples and such, or do you just want ideas on what sort of programs you could try to code using VB6 ?
If you want samples, you need to be more specific as to what of, and you need to show that you have made some sort of effort already yourself. Show some code that you have written that you want help with.
If you want ideas for programs to code in VB6, then you are not asking in the right place. On this forum you can get help realizing your coding goals, but very very little in determining what these goals should be.
My advice is free, and you may get what you paid for.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
