how to correct this error "Index 0 is either negative or above rows count."

Question

1.00/5 (1 vote)

See more:

C#

protected void DropDownList1_TextChanged(object sender, EventArgs e)
{
    SqlDataAdapter dam = new SqlDataAdapter("select * from Net_calculate where DistrictName='" + DropDownList1.Text + "'", con);
    DataSet dsm = new DataSet();
    // add this line to define table name in dataset 
    //dam.Tables.Add("Net_calculate");
    dsm.Tables.Add("Net_calculate");
    dam.Fill(dsm, "Net_calculate");
    DataView dvm = new DataView(dsm.Tables["Net_calculate"]);
    txtAmt.Text = dvm[0]["net_amount"].ToString();
}

Posted 21-Feb-13 21:50pm

Gilbertinino

Updated 21-Feb-13 21:54pm

_Amy

v2

Add a Solution

Comments

Sergey Alexandrovich Kryukov 12-Mar-13 15:41pm

What you really need is using the debugger. Did you ever try? I remember I advised that, but you did not respond...
—SA

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

_Amy · Answer 1 · 2013-02-21T21:54:00

Solution 1

Try this:

C#

protected void DropDownList1_TextChanged(object sender, EventArgs e)
{
    SqlCommand cmd = new SqlCommand("select * from Net_calculate(@dst)", con);
    cmd.CommandType = CommandType.Text
    cmd.Parameters.Add(New Data.SqlClient.SqlParameter("@dst", input));
    cmd.CommandTimeout = 0;
    SqlDataAdapter dam = new SqlDataAdapter(cmd);
    DataTable dtm = new DataTable("Test");
    // add this line to define table name in dataset 
    //dam.Tables.Add("Net_calculate");
    dam.Fill(dtm );
    if(dtm != null){
        if(dtm .Rows.Count > 0){
            txtAmt.Text = dtm .Rows[0]["net_amount"].ToString();
        }
    }
}

--Amit

Posted 21-Feb-13 21:54pm

_Amy

Updated 21-Feb-13 23:02pm

v3

Comments

Gilbertinino 22-Feb-13 4:07am

This code is not displaying data retrieved to the txtAmt.Text.

_Amy 22-Feb-13 4:11am

Yes, because the table is not having any data.
See my updated answer. Try to put a breakpoint and step through the code.

--Amit

Gilbertinino 22-Feb-13 4:33am

Am not using data from table but data retrieved are from a function called Net_calculate not a table and those data are predefined in the function.

_Amy 22-Feb-13 4:40am

In your question, it's very very clear that you are assigning the name of your datatable as Net_calculate.
Anyway, where is your Net_calculate function? Can I see the code?

But I think solution is clear. You are taking the data from database based on dropdown list selected text. The data coming from database is stored in a datatable named Net_calculate. Using that datatable you are assigning the text to your textbox.

--Amit

Gilbertinino 22-Feb-13 4:51am

The below is the function am using
and while exec it,it gives me data according to the district

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

alter FUNCTION [dbo].[Net_calculate]
(
@dst nvarchar(50)
--@pst nvarchar(50)
)
RETURNS @tableout TABLE(net_amount int)
AS
BEGIN
declare @dist nvarchar(50),@amt1 int,@post nvarchar(50),@amt2 int
select @dist=DistrictName from District where DistrictName=@dst
--SELECT @post=poste FROM employee WHERE poste = @pst

----------------------------PS-----------------------------
--if(@post='PS')
--begin
if(@dist='KIGALI')or(@dist='RUBAVU') or (@dist='MUSANZE')
begin
set @amt1=58750+8000
insert into @tableout values(@amt1)
select @amt1=net_amount from mission
end
--end
--if(@post='PS')
--begin
if(@dist='HUYE')or (@dist='RUSIZI') or (@dist='KARONGI')
begin
set @amt1=40250+8000
insert into @tableout values(@amt1)
end
--end
--if(@post='PS')
--begin
if(@dist='others')
begin
set @amt1=27000+8000
insert into @tableout values(@amt1)
end

RETURN
END

_Amy 22-Feb-13 5:02am

Try my updated solution.

Gilbertinino 22-Feb-13 6:00am

ok fine.still waiting

_Amy 22-Feb-13 6:30am

I have updated my solution. Take a look at that.