How to return an enture mysql recordset from a function
I've written a function that calls a mysql stored procedure and, via the rdr.Read() function converts each column into an object property. The function overall returns a collection of these o | | 0 | 49 | 11/28/2009 9:31:13 PM |
how to pass date time fom asp.net 2.0 into Mysql
hello,
I have just started worhking with mysql and am having a problem getting the bithdate of the employees into the mysql table.i am actually fetching data from my sql | | 0 | 35 | 11/28/2009 9:30:18 AM |
Using database MySQL instead of MS SQL
Hi friendz, i am using VS 2008 and in my site i choose MySQL as my database whereas for membership provider it is default SQL Server.??? is this ok? and can u tell me Mysql is better | | 0 | 17 | 11/27/2009 4:04:39 AM |
mysqldump creates an empty file
Hey guys (and girls)...
I have this code:
Protected | | 0 | 39 | 11/26/2009 4:35:30 PM |
Extract the first sentance from a field in mqsql database - asp.net
Hello People,
I am creating a news website which displays news headlines which are hyperlinked, when a specific headline is click it goes to another page which displays the ful | | 0 | 43 | 11/25/2009 4:13:12 AM |
Establishing a database connection using Putty to tunnel over SSH
I currently have an ASP.NET web application that is using a MySQL database as the source data. I would like to connect to this database using the standard MySQL listening port of 3306 and tunnel | | 0 | 27 | 11/24/2009 7:33:06 PM |
MySQL and timeout connection issues
Hello,
I am having terrible time. I have deployed my website. I have developed the website using ASP.NET 3.5 and the database used is MySQL. I have used MySQL Connector and | | 0 | 33 | 11/22/2009 12:00:57 PM |
MySQL and timeout connection issues
Hello,
I am having terrible time. I have deployed my website. I have developed the website using ASP.NET 3.5 and the database used is MySQL. I have used MySQL Connector and have not used | | 0 | 61 | 11/22/2009 5:34:57 AM |
VS versional Support
Hi,
Currently, I programming with VS2008 Standard. This version | | 0 | 33 | 11/20/2009 12:21:23 AM |
asp.net gridview using mysql, Will not update if PK column is not visible
I have a asp.net webform on it I have a sqldatasource and a gridview that has two columns a primary key and a description . ( I have more columns in my gridview, however i | | 0 | 32 | 11/19/2009 4:28:39 AM |
migrating the entire database from sql server to mysql
Hi all,
I want to move the database of my asp.net application
from one server(sql server 2005) to another(mysql).The new server use
mysql and it is a linux server.My first doubt is whet | | 0 | 34 | 11/18/2009 1:11:23 PM |
Plural search in mysql
consider a table have the record for both the "cover" and "covers" so,
when i do the like keyword search with "cover" text will return both the re | | 0 | 28 | 11/17/2009 11:58:29 AM |
How to update two tables using code behind/session vars
Hello all, I'm getting farther along but seem to have hit a snag. I am trying to update two tables when user hits submit button via code behind. I have my queries written and I've set the | | 0 | 34 | 11/16/2009 11:17:36 PM |
Godaddy and mysql with asp.net
Hi friends,
I created a site with asp.net and mysql , and ofcourse it works great in localhost. I tried to host with godaddy...wow it is not working. The reason is godaddy | | 0 | 29 | 11/16/2009 11:17:35 PM |
using LIMIT in sub query? (in code behind)
Hi,
I would like to include LIMIT in a subquery and although it is not fully supported yet by MySQL there is a workaround posted. It's working fine when I try it in MySQL Query Br | | 0 | 38 | 11/16/2009 11:17:31 PM |
What is the difference between "= ANY " & "IN"
I have used IN quite often but now I came across =ANY and im wondering if there is any difference between them two and if either one shall be preferred? I tried a search in Google but it& | | 0 | 27 | 11/16/2009 3:00:25 AM |
update
hi all,
when we enter id in textbox the second page will display the user details of that id
webapplication
my database is mysql | | 0 | 42 | 11/14/2009 8:54:19 AM |
Query problem
Hi, I have a query like the one below which is working fine. But now I would like to add some specific rows from table1. How do I do that in a proper way? My original query: SELE | | 0 | 40 | 11/13/2009 5:30:34 PM |
Writing trigger is driving me crazy
Ok, I'm trying to create a trigger for my database and from all the various internet sources, my syntax should be fine but MySQL is not agreeing. The trigger I'm writing is (line numbers | | 0 | 32 | 11/13/2009 5:30:33 PM |
JOIN same Table, different Table, different Databases??
I have a table where two of the columns are named "ItemA" and "ItemB". Both columns consist of numeric itemnumbers such as 1,22,55,195 etc. I often cobine these coumns with so | | 0 | 35 | 11/13/2009 10:07:10 AM |
MySQL Net Connector 5.1.7
I made my website using MySQL Connector 6.1.2 but when it comes to publishing the website. The hosting company told me that they only support up to MySQL Connector 5.1.7.
I uninstall | | 0 | 20 | 11/12/2009 7:58:46 PM |
Newbie confused MySQL and SQL
Im a little confused, do i need to run mysql and sql?
I seem to have database problems and i dont remember seeing mySQL and now i have it.
My connection str | | 0 | 39 | 11/12/2009 12:29:44 PM |
ASP.NET Membership security MySQL vs SQL Server
This is kind of convoluted but I'm going to try to explain this as best I can.
I am using ASP.NET role/membership to secure my web appl | | 0 | 26 | 11/11/2009 6:11:55 PM |
Nested SQL Query Problem
I'm making a simple forum with subforums in categories (similar to how this forum works) and it is to be written out like this: CATEGORY - forum - fo | | 0 | 29 | 11/11/2009 9:23:42 AM |
Foreign key constraint problem
This question should probably be in an mysql forum, but since this is the place where I seek my wizdom I will put it here. | 0 | 35 | 11/11/2009 9:23:39 AM |
Stored procedure
CREATE PROCEDURE spx_ImportFromExcel03 @SheetName varchar(20), @FilePat | | 0 | 36 | 11/11/2009 9:23:29 AM |
Connection string
I am trying to get my form to connect to a mySQL on a windows-based GoDaddy server and I keep getting errors. I talked to them, and they said their test script works fine so it's a script err | | 0 | 24 | 11/11/2009 9:23:23 AM |
Need help - alter time stamps based on time record written
Ok, let me see if I can make this understandable in human language. I have a table that gets written into in batches of 30 records every 2 1/2 hours by cellular modem. There is currently a | | 0 | 42 | 11/11/2009 9:23:22 AM |
Query Problem
I was adivsed to post my question here so here we go: Im trying to create a photo album where pictures are ordered by date
inside each album. In the database I have three columns: FileName | | 0 | 22 | 11/11/2009 9:23:11 AM |
Vb.Net Code For Mysql Database Back up and Restore when Click on the Butto n
I have done one POS application with Mysql Database via Creating DSN. I have a form with Two Button . One For Back uping Mysql Database (Dump Sql file)and another for restoring the | | 0 | 41 | 11/11/2009 9:23:11 AM |
SqlDataSource - Syntax Error with MySQL query?
I was using SQL Express but I have to convert all the things into MySQL now, and I get all kind of Syntax errors | 0 | 31 | 11/11/2009 9:23:09 AM |
update the userdetails
hi all,
i need to update the userdetails if first.aspx enter the empid
then second.aspx access that empid
and display with values | | 0 | 32 | 11/11/2009 9:22:58 AM |
Error in grid view deletion
StringCollection idCollection = new StringCollection(); string strID = string.Empty;
//Loop t | | 0 | 39 | 11/11/2009 9:22:57 AM |
Mysql Select Query
Ok, i have a question about a select query
lets say i have two tables
we call them
customers with the following fields customerID, dateentered, status
  | | 0 | 27 | 11/11/2009 9:22:54 AM |
Concat in a MySQL SELECT Query
Leave it to me to want to do the impossible, which I think this is, but let me ask just to make sure. I have used CONCAT in a select statement. This works totally fine: WHERE _NAME L | | 0 | 33 | 11/11/2009 9:22:51 AM |
delete from gridview
hi all,
can u give the code for delete row while check the checkbox in gridview.........
| | 0 | 32 | 11/11/2009 9:22:43 AM |
Using the MySQL .net provider with Visual Web Developer Express
I have installed VWD 2008 and the mySQL .net provider when I look at the Database Viewer I cannot see the mysql .net data provider installed. I see microsoft access, odb | | 0 | 30 | 11/11/2009 9:22:42 AM |
MySql ODBC driver and asp.net website administration tool
I want to use asp.net membership in my website for login/logout functionality. I am using MySql ODBC driver for database access and I didn't find any toturial regarding my problem. I fo | | 0 | 37 | 11/11/2009 9:22:34 AM |
MySQL Asp.net Membership Issues
Hi, I'm using MySQL connector 6.1.2 with my asp.net page for the past couple days trying to get it posted on GoDaddy.com to use membership for my site. I've encountered a series of proble | | 0 | 36 | 11/11/2009 9:22:32 AM |
Update userdetails
hi all ,
can any give the code for update the userdetais
my requ | | 0 | 41 | 11/11/2009 9:22:28 AM |
form not submitting the data to MS-SQL
Hi I am building a .NET 3.5 web site with visual studio 2008 and MS SQL server 2008. I have a refrence to the database in the server explorer database.dbo,
I have a form | | 0 | 39 | 11/11/2009 9:22:27 AM |
Is it possible to read data from MySql dump without parsing file?
Hi All,
Is it possible to
"open" mysql table (which is dumped as a file) in memory, read and
transform data in memory and then simply insert rows into MSSQL using < | | 0 | 34 | 11/11/2009 9:22:23 AM |
how to display binary data from the database.
Haiii All,
Here am uploading a video file using File upload control and i store that file in database in a binary | | 0 | 31 | 11/11/2009 9:22:22 AM |
xquery in mysql
i have involved in writing xquery to manipulate xml data in mysql database
is that supported?
if yes , how can i do this?and what tools i need?
thanks | | 0 | 22 | 11/11/2009 9:22:21 AM |
How to Connect to MySQL Database
Hi Everyone!
I have never used MySQL and could use a little help getting started. There are 2 things I need to know how to do.
1. How to connect to a My | | 1 | 117 | 5/19/2008 2:38:43 PM |
Connector for MySQL-4 and ASP.NET-2.0
Hello all,
We are going to develop a web site in DOTNET 2.0 framework with MySQL 4 in backend. I found that there are many connectors available -
two versions of&nbs | | 2 | 104 | 5/18/2008 2:40:29 PM |
Unable to convert MySQL date/time value to System.DateTime
Hi
I get the following error when i call my method from the class any ideas?
Unable to convert MySQL date/time value to System.DateTime | | 2 | 213 | 5/18/2008 8:23:13 AM |
ERROR [42000] [MySQL][ODBC 3.51 Driver][mysqld-4.0.24-nt]
Hi Frndz, why am I getting this error on deploying it? It runs fine locally. what can be the problem on server side? is the version problem? pl elaborate it. what steps should i take to avo | | 2 | 223 | 5/18/2008 8:20:17 AM |
Unable to connect to any of the specified MySQL hosts
Hello friends I am trying to connect to my MySql database on a dedicated server (from my home computer), but i keep running into different kind of errors. I keep debugging and try to solve | | 2 | 632 | 5/18/2008 8:18:09 AM |
Display data from multiple tables
I want to list a few articles along with information about the author, how many views it has, how many comments there are on it and what the average rating is. The article itself is in the | | 4 | 77 | 5/16/2008 8:04:34 PM |