CodeVerge.Net Beta


   Item Entry   Register  Login  
Microsoft News
Asp.Net Forums
IBM Software
Borland Forums
Adobe Forums
Novell Forums



> Asp.Net Forum > data_access.mysql
 TypeRepliesViewsDate
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

 02811/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

 01211/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

 0711/27/2009 4:04:39 AM
mysqldump creates an empty file

Hey guys (and girls)...

I have this code:

 

Protected
 01911/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

 01911/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

 0711/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

 01511/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

 03411/22/2009 5:34:57 AM
VS versional Support
Hi,
 
Currently, I programming with VS2008 Standard. This version
 01211/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

 01011/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

 01411/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

 0911/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

 01511/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

 01111/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

 01411/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&
 01211/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

 01811/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

 01911/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

 01411/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

 01211/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

 0511/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

 01511/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

 01311/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

 0811/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.  

01411/11/2009 9:23:39 AM
Stored procedure

CREATE PROCEDURE spx_ImportFromExcel03
@SheetName varchar(20),
@FilePat

 01411/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

 01111/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

 01311/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

 01111/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

 01311/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

 
01211/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

 01211/11/2009 9:22:58 AM
Error in grid view deletion

StringCollection idCollection = new StringCollection();
        string strID = string.Empty;

        //Loop t

 01511/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

 

 01211/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

 01311/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.........


 01111/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

 01011/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

 01411/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

 01211/11/2009 9:22:32 AM
Update userdetails

hi all ,

can any give the code for update the userdetais

my requ

 01411/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

 01811/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 <

 01311/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

 01111/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

 0911/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

 11035/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

 2875/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

 21935/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

 22065/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

 26165/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

 4605/16/2008 8:04:34 PM


   
  Privacy | Contact Us
All Times Are GMT