Web developer. DBA. Paramedic. Blacksmith. Jack of all trades...
|
Aug
23 |
|
answered | Error when trying to zip files VB.NET 2003 |
|
Aug
13 |
|
comment |
in below code i want to show data from database only in first row. how can i show data please healp Yup, that would make sense. :-) |
|
Aug
13 |
|
comment |
Could string variable in vb.net be a reference in SQL Where statement? As with most things in .NET, there are usually many different ways to accomplish the same thing. The two examples I have above do the same thing -- create parameter objects, name them, and append them to the parameters collection of the Command object. The only difference is whether you're using a method exposed by the Parameters collection of the Command object (.AddWithValue) or by creating the Parameter object separately and adding it in. In most cases, AddWithValue works fine, but both get you to the same place in the end... |
|
Aug
13 |
|
comment |
AddWithValue is not member of MySql.Data.MySqlClient.MySqlParameter VB.net What version of the MySql library are you using? It could be that you are using an old version; @pilgerstorfer-franz points to the download location for the ADO.Net client download. I'm using 6.5.4 (latest version) and Command.Parameters.AddWithValue is a supported method...
|
|
Aug
13 |
|
revised |
Could string variable in vb.net be a reference in SQL Where statement? Edited to use MySQL-specific objects, add alternate use of MySqlParameter object |
|
Aug
13 |
|
awarded | Editor |
|
Aug
13 |
|
comment |
Could string variable in vb.net be a reference in SQL Where statement? @catherine-takishima, is sounds like you're trying to use MySql.Data.MySqlClient.MySqlParameter -- note that in my code above, there's no reason to do so, as the cmd.Parameters.AddWithValue, which is part of the Command object, creates the parameter and adds it to the parameter collection of the Command object.
|
|
Aug
13 |
|
revised |
Could string variable in vb.net be a reference in SQL Where statement? Edited to use MySQL-specific objects |
|
Aug
13 |
|
answered | in below code i want to show data from database only in first row. how can i show data please healp |
|
Aug
13 |
|
answered | Could string variable in vb.net be a reference in SQL Where statement? |
|
Jul
2 |
|
awarded | Teacher |
|
Jul
2 |
|
answered | VB.NET - Microsoft.Office.Interop.Outlook - doesn't work when workstation is locked? |
|
May
16 |
|
awarded | Supporter |
|
Apr
30 |
|
revised |
How to close existing connections to a DB Removed "vb.net" tag |
|
Apr
20 |
|
answered | Assign values to ComboBox items from mySQL DB loop adds |
|
Apr
18 |
|
answered | Database Navigation in VB and SQL |
|
Apr
16 |
|
answered | Getting text between anchor tags |
|
Apr
11 |
|
comment |
How do I resolve "Object reference not set to an instance of an object" error? Ah, so in the demo page you referenced it looks like the barcode.aspx is being called to generate an image with the appropriate barcode, using the code passed in to the querystring. The markup for barcode.aspx should be empty, as the rendered output of the page would be generated by the codebehind. Your list of <img> tags (with source set to "barcode.aspx?code=whatever" from your database) has to exist on a different page. |
|
Apr
11 |
|
answered | How do I resolve "Object reference not set to an instance of an object" error? |
|
Apr
11 |
|
awarded | Organizer |
