Wrox Programmer Forums
|
SQL Server ASP Discussions about ASP programming with Microsoft's SQL Server. For more ASP forums, see the ASP forum category.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server ASP section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 13th, 2007, 05:43 AM
Authorized User
 
Join Date: Jun 2005
Posts: 35
Thanks: 0
Thanked 0 Times in 0 Posts
Default STORED PROCEDURES

how can i insert parameters in stored procedures using Datasource.InsertParameters.Add() command??

 
Old March 13th, 2007, 09:25 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Did you post this in a wrong place? Are you looking for ASP.Net help? If so have a glance at this thread insert using stored procedure & sqldatasource ctrl and see if this helps you out.

Cheers

_________________________
- Vijay G
Strive for Perfection
 
Old March 15th, 2007, 03:00 AM
Authorized User
 
Join Date: Jun 2005
Posts: 35
Thanks: 0
Thanked 0 Times in 0 Posts
Default

may b i was wrong ...
but ur link really helped
Thanks a lot :)

Reagrds,
Shazia.

 
Old March 15th, 2007, 07:20 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Thats my pleasure...
Cheers

_________________________
- Vijay G
Strive for Perfection
 
Old May 8th, 2007, 12:48 AM
Registered User
 
Join Date: May 2007
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to nirmal_s19
Default

cmd = new SqlCommand("Select isnull( max(date),0), isnull(max(balance),0) from chinnamaniaccounts where customerid='" + TextBox1.Text + "'", con);

I did used the above querry to call the value balance stored in the max date row. But when retreving this value i'm receiving the max value from balance instead of max date. So how could i call the balance value under max date value . Please help mew out i cant get it done...

 
Old May 8th, 2007, 01:06 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

This has been answered in the other topic that you posted on this forum.
Selecting MAX Value

Please avoid cross posting.

_________________________
- Vijay G
Strive for Perfection
 
Old July 9th, 2007, 04:45 AM
Registered User
 
Join Date: May 2007
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to prashant_telkar Send a message via MSN to prashant_telkar Send a message via Yahoo to prashant_telkar
Default

following code here-
 dataset ds
 cmd=cmd.commandtype;
 ds.parametrs.add("@id",sqldatatype.int,5);
 ds.parameters("@id").value=txtid.text;

prashant
 
Old September 26th, 2007, 06:11 AM
Authorized User
 
Join Date: Dec 2006
Posts: 25
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Try This One -

cmd = new SqlCommand("Select isnull( max(date),0) as dt, isnull(max(balance),0) as bal from chinnamaniaccounts where customerid='" + TextBox1.Text + "'", con);







Similar Threads
Thread Thread Starter Forum Replies Last Post
Stored Procedures KeviJay VB Databases Basics 1 June 5th, 2008 07:17 AM
stored procedures MunishBhatia SQL Server 2005 4 April 12th, 2008 01:39 AM
Stored Procedures itHighway SQL Server 2000 3 November 23rd, 2005 10:08 AM
Stored Procedures jazzcatone Classic ASP Databases 0 August 28th, 2005 02:57 PM
Stored Procedures stu9820 Access 3 February 8th, 2004 01:13 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.