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

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

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

Reagrds,
Shazia.

Thats my pleasure...
Cheers

_________________________
- Vijay G
Strive for Perfection

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

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

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

prashant

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);