I am trying to make a very simple aspx page that pulls some data from a mysql database.
The page builds without a problem. (the aspx contains just the default form and a div just to print some data)
[Code]....
I am having a weird problem. IIf is messing up when I am working with an array. Apparently it is checking my else statement even though it isn't activated. Here is some code that demonstrates the issue:[code]
View 2 RepliesI was wondering if my database got way too much table for use the designer. Would be glad to hear experience from those that using L2Q with lots of tables. How much table your database have ? How fast is VB ? (fast, experiencing slowdowns, unusable)
View 1 RepliesI am looking for formula that is accurate in converting Minutes to Decimal Minutes i.e 30 minutes is 50 Minutes in Decimals so 1.3 hours is 1.50 and not 1.5 i have used Minutes/60 but it is not accurate as some times i have to Multiply the result by 100 and some time 1000 to get correct results based on single digit Try 1/60, 10/60 99/60 or 100/60.What would be the most efficient and correct way to Convert the time into Minutes ?
View 10 RepliesI am working on RSS feed. In Rssfeed <description> (string) tag suggest using approximately 300 characters and then showing continuation with [...] after a word break.
<description>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially [...]</description>
[Code]...
How we can do with a string by showing continuation with [...] after a word break?
I am creating a VB application in Visual Studio 2010 that installs some SQL stored procedures. These stored procedures are encrypted otherwise I would just supply my clients with .sql files to create the stored procedures.
The install script that creates the stored procedure is 1500 lines in length and has been formatted in the way VS 2010 requires multi-line literals to be in:
"First Line" & _
"Second Line" & _
"etc..."
[Code]....
I have an application that provides a countdown for 60 minutes and I'm currently using the win form timer and it updates some labels and a progressbar. Now I have to change this to be a countdown for 360 minutes. Will the win form timer be sufficient or should I implement a Timers.Timer instead?
View 6 RepliesIt is possible to catch an exception and throw a new exception which wraps the first exception as an inner exception: [URL] Also, if I call a function and it throws a certain error, but I catch it, will the calling code's catch handler execute? If so, and it is of a higher exception type, is this not wrapping the exception? eg I can throw exception ex of type IndexOutOfRange, log it but rethrow, catch a higher up exception and do something, or I can throw a new exception and wrap an inner exception like:
View 1 RepliesModule Module1 Public Declare Function GET_CALCULATION_FAN_ALONE Lib "EbmPapstFan.dll" (ByRef path As String) As Long Private Declare Function GET_PRODUCTS Lib "ebmpapstfan.dll" (ByRef path As String) As Long Public Declare Function SET_XML_PATH Lib "EbmPapstFan.dll" (ByRef path As String) As Long
[Code]...
I'm exporting a table of data to CSV format, e.g.:
"COL1","COL2","COL3"
"1","some text", "£232.00"
"2","some more text", "£111.00"
"3","other text", "£2.00"
The code to export is fairly simple using an ashx handler:
[Code]...
My issue is when Excel tries to open the exported file the character appears before all £ signs, e.g. £232.00 when the value should be £232.00.
Question: How does the class for the serialization of this XML content look ?
<?xml version="1.0" encoding="utf-8"?>
<vcc:CreateTextSearchResponse xmlns:vcc="urn:veloconnect:catalog-1.1" xmlns:vct="urn:veloconnect:transaction-1.0">
[code]....
I have a bit of a strange problem with MySQL that I've never seen before. Basically, I need to enter the same entry into a table x number of times. The Primary Key is auto increment so there shouldn't be any duplicate value problems. However, it takes the last few columns and seems to clump them all into one value and is using that as a key. The error I'm getting back is:Duplicate entry '80-0--2011-06-16-0-1' for key 'idx_mtind you, there is no field called idx_mt. The primary key field is called just ID. And that 80-0--2011-06-16-0-1 is the last 8 columns or so (which you can see the names of in the cols variable) concatenated, which they obviously shouldn't be doing. Also, the first time the loop runs through, the entry goes through, but the later ones conflict with it. I confirmed that this is the problem by changing one of the last 8 columns to a value based on a loop, and that went through with no problems.
Dim cols As String = ""
Dim msi As System.Globalization.DateTimeFormatInfo = New System.Globalization.DateTimeFormatInfo()
[code]...
i am working on an application which calls the COM component of a partner's application.Ours is .Net, theirs isn't. I don't know much about COM; I know that the component we're calling is late-bound i.e.obj As Object = CreateObject("THIRDPARTY.ThirdPartyObject")We then call a method on this COM object (Option Strict Off in the head of the VB file):obj.AMethod(ByVal Arg1 As Integer, ByVal Arg2 As Integer, ByVal Arg3 as Boolean)I am a bit nonplussed that even though this call works, this overload doesn't exist in the COM interop .dll that is created if I instead add a reference to the COM server using Add Reference. The only available call to this method that it says is available is AMethod().
View 3 Repliesthis one has me stumped - problem is bolded
Compiler Error Message: BC30456: 'Login1_Authenticate' is not a member of 'ASP.login_aspx'
<asp:LoginView ID="LoginView1" runat="server">
<LoggedInTemplate>
[code].....
ok I have a form.. has too much.. so I want to now use tab controlin VB6 I would delete then paste the object into the tab control andI recall it worked ok..with vs08 I cut and paste and looks ok.. but doesnt work..lets say I had button btnInstall when I paste it over its that name.. butwhen I click on it now.. it goes to btninstallButton_Click_1why did it put the _1 on there ? I didnt copy and paste .. I cut..
View 6 RepliesI got kind a mystery situation. There's not a lot of code, only few lines but the point is that it only works partially (it saves but does not load).
I tested it with another cmbbox1, which makes it work on seperate cmbboxes but not on either one or onother on their owns.[code..]
I got other cmbBoxes with titles on them loaded from the DB and they work fully, only this one doesn't.what should I look at?
I want to supress a key for a textbox: [code]this is working, B key is supressed,but adding just a messagebox will not work..[code]
View 1 RepliesI�m using Outlook to automatically send an email to my mobile phone. To bypass the stupid "security" bug in outlook I use redemption.safemailitem.Now, this has worked for years, but for some reason I can�t change the adress to which outlook sends the mail. Instead of sending to the adress in the code, it sends to an old adress that�s not anywhere in the code (but it was, ages ago)
View 6 RepliesIt seems to be the general consensus from most places I have looked that the following code
Code:
Dns.GetHostEntry(Dns.GetHostName).AddressList()
Is the correct method of getting the local IP address of a machine, and when run against
[code]....
I cretaed a vb application where I concatenate a string to build XML code and Im getting an error stating that I must include a matching PURCHASE-ORDER-SHIP-TO end tag which clearly exists see below:
sMyXml = sMyXml + " <PURCHASE-ORDER-SHIP-TO>" sMyXml = sMyXml + " <DIRECT-QUESTIONS-TO>ATHOS PETROU</DIRECT-QUESTIONS-TO>" sMyXml = sMyXml + " <address:ADDRESS xmlns:address=""http://www.removed"">" sMyXml = sMyXml + " <address:NAME-LINE-1>Addr1</address:NAME-LINE-1>" sMyXml = sMyXml + " <address:NAME-LINE-2></address:NAME-LINE-2>"
[Code]...
I have a problem with strange character.
In mysql this character 💀 cause error Incorrect string value: 'xF0x9Fx92x80'
Samples of these characters are from [URL]
Say I want to analyze data from the web and found some strange character
how to remove this character 💀 ??
The occurance is rare.
In fact, how to know all characters that may be problematic for mysql and remove that? I am not saying escapeable characers. I am saying characters that are neither numeric, alphabeth, or chinese scripts, or punctuation. Characters that's totally bizarre.
How do I get rid of that from a string?
Its a Program i created to Sync PSP with my PC (like psp manager)you browse through titles (images) add/remove/sync options plus aconnectivity test but when i start the "Sync.exe" VB Studio 2008 saysthat theres a problem with this code:
Dim Bypass
Dim Value As Short
Bypass = FreeFile()
[code].....
I am having a strange issue when using the StreamWriter where I am getting some strange charachers in my text file when reading data from a query string.
[Code]...
Why when I wrote in a xml the char "&" it appears & ??
View 3 RepliesI am working on a program that takes 12 numbers that the user inputs and calculates the total and average but every time I run it it comes out to be like 6.5 and numbers like that.
' Store the starting values in total and count.
sngTotal = 0
intCount = 1
[code].....
i'm using lineInput to read a text file but get a problem with a certain record.it shows [code]I've changed the encoding to utf8, ansi, ... but nothing helps. Anybody an idea what could be the cause?It only does this with the first record in the file.
View 3 RepliesI'm developing with VB.NET 2008.One of my host was crashed, so I take the files and keep development on another host. But now something strange is happening:All frames, lines and shapes are disappeared on design-time, but are seen normally in runtime.
[Code]...
After a successfull bindingsource.AddNew(), .EndEdit(), TableAdapter.Update(), i'm trying to get the value of the PrimaryKey from the newlly added record wich is always = -1!
Private Sub BtnNewClient_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnNewClient.Click
If BtnNewClient.Tag = "New" Then
SetClientLayout(ClientLayouts.CLNew)
Me.ClientsBindingSource1.AddNew()
[code]....
Why does: DateTime.Now.ToString("M") not return the month number? Instead it returns the full month name with the day on it. Apparently, this is because "M" is also a standard code for the MonthDayPattern. I don't want this...I want to get the month number using "M". Is there a way to turn this off?
View 6 RepliesI have a simple datagridview that I fill from a mysql database using the latest mysql connector.net.I configured my columns in the datagridview collection and the data displays fine.I don't want the user to edit data directly in the grid so my datagridview is not readonly but all my columns are except the checkbox one. If I set the datagridview readonly I can't check my checkboxes.I added a checkbox column to be able to delete multiple rows easily but I can't uncheck a checkbox.
Let's say I have 3 rows in my datagridview I check line 1 checkbox- I check line 2 checkbox- I uncheck line 1 checkbox- I check line 3 checkbox As soon as I check line 3 checkbox, line 1 checkbox becomes checked "automagically"
[Code]...