Click here to Skip to main content
15,905,508 members
Home / Discussions / ASP.NET
   

ASP.NET

 
General[Message Deleted] Pin
yhayirsever25-Aug-09 22:36
yhayirsever25-Aug-09 22:36 
GeneralRe: Web site publishing using Asp Pin
SeMartens25-Aug-09 23:00
SeMartens25-Aug-09 23:00 
AnswerRe: Web site publishing using Asp Pin
Gaurav Dudeja India26-Aug-09 21:29
Gaurav Dudeja India26-Aug-09 21:29 
QuestionDatasource not working properly Pin
haleemasher25-Aug-09 22:04
haleemasher25-Aug-09 22:04 
QuestionSet a gridview's cell background color Pin
benams25-Aug-09 21:58
benams25-Aug-09 21:58 
AnswerRe: Set a gridview's cell background color Pin
nagendrathecoder25-Aug-09 22:10
nagendrathecoder25-Aug-09 22:10 
AnswerRe: Set a gridview's cell background color Pin
sazhubo25-Aug-09 22:29
sazhubo25-Aug-09 22:29 
Questionhow to call storeprocedure in asp.net application Pin
rinku soni 2325-Aug-09 21:16
rinku soni 2325-Aug-09 21:16 
Hello every one i have a storeprocedure and i am calling it in my application but it gives an error.i am giving code here.


=================the error is============================
ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.1.30]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'addloc2' at line 1


===================store procedure is=================
ELIMITER $$

DROP PROCEDURE IF EXISTS `addloc2` $$
CREATE DEFINER=`root`@`%` PROCEDURE `addloc2`(_loc varchar(50))
BEGIN
insert into test(Location) value(_loc);
END $$

DELIMITER ;


==================asp.net code is================================

odbcconnection con=new odbcconnection(connectionstring);
cmd=new OdbcCommand ("addloc2",con);

cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new OdbcParameter ("_loc",OdbcType.VarChar)).Value ="nagpur";
con.Open();
cmd.ExecuteNonQuery();
con.Close();
AnswerRe: how to call storeprocedure in asp.net application Pin
Christian Graus25-Aug-09 21:18
protectorChristian Graus25-Aug-09 21:18 
AnswerRe: how to call storeprocedure in asp.net application Pin
Abhishek Sur25-Aug-09 21:51
professionalAbhishek Sur25-Aug-09 21:51 
Questiongridview update Pin
4anusha425-Aug-09 20:43
4anusha425-Aug-09 20:43 
AnswerRe: gridview update Pin
Christian Graus25-Aug-09 20:47
protectorChristian Graus25-Aug-09 20:47 
GeneralRe: gridview update Pin
4anusha425-Aug-09 20:48
4anusha425-Aug-09 20:48 
GeneralRe: gridview update Pin
N a v a n e e t h25-Aug-09 20:53
N a v a n e e t h25-Aug-09 20:53 
GeneralRe: gridview update Pin
4anusha425-Aug-09 20:54
4anusha425-Aug-09 20:54 
GeneralRe: gridview update Pin
Christian Graus25-Aug-09 21:01
protectorChristian Graus25-Aug-09 21:01 
GeneralRe: gridview update Pin
4anusha425-Aug-09 21:03
4anusha425-Aug-09 21:03 
GeneralRe: gridview update Pin
Christian Graus25-Aug-09 21:05
protectorChristian Graus25-Aug-09 21:05 
AnswerRe: gridview update Pin
Robert_Pan26-Aug-09 18:44
Robert_Pan26-Aug-09 18:44 
QuestionAjax is not working Pin
Ravindra K Bisen25-Aug-09 19:59
Ravindra K Bisen25-Aug-09 19:59 
AnswerRe: Ajax is not working Pin
Christian Graus25-Aug-09 20:02
protectorChristian Graus25-Aug-09 20:02 
AnswerRe: Ajax is not working Pin
Vimalsoft(Pty) Ltd25-Aug-09 21:54
professionalVimalsoft(Pty) Ltd25-Aug-09 21:54 
AnswerRe: Ajax is not working Pin
-Dr_X-26-Aug-09 9:30
-Dr_X-26-Aug-09 9:30 
QuestionPlease Help!! Pin
Suresh Suthar25-Aug-09 19:49
professionalSuresh Suthar25-Aug-09 19:49 
AnswerRe: Please Help!! Pin
Christian Graus25-Aug-09 20:00
protectorChristian Graus25-Aug-09 20:00 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.