Visual Basic .NET » Database Programming
Problem with stablish connection with stored procedure -- amit --


Hi all

when i call my procedure in c# application.. code is as follows...

MySqlConnection conn=new MySqlConnection("Server=local);DataBase=Northwind;User Id=root;Password=123456;Pooling=false;");
conn.Open();

MySqlCommand cmd = new MySqlCommand("Procedure name", conn);

cmd.CommandType = CommandType.StoredProcedure;

.....

it shows error ....if i write this method then my application become slow ...
IS there any another way to stablish connection ........

-- RaviKumar --


try this MySqlConnection conn=new MySqlConnection("Server=(local);DataBase=Northwind;User Id=root;Password=123456;Pooling=false;");
conn.Open();

Thanks Ravi.P

----- Original Message -----
From: "Amit" <gamitkumar>
To: ".NetIndia" <TechdotNetIndia>
Sent: Tuesday, July 18, 2006 1:30 PM Subject:
Problem with stablish connection with stored procedure

Hi all

when i call my procedure in c# application.. code is as follows...

MySqlConnection conn=new
MySqlConnection("Server=local);DataBase=Northwind;User
Id=root;Password=123456;Pooling=false;");
conn.Open();

MySqlCommand cmd = new MySqlCommand("Procedure name", conn);

cmd.CommandType = CommandType.StoredProcedure;

.....

it shows error ....if i write this method then my application become
slow ...
IS there any another way to stablish connection ........
>

 

[Submit Comment]Home