Hi,
i have written a query for selecting the column names with registrationid as foriegn key this is receipt form so i need to add the registrationid at several times but this is my primarykey of personnal details table so
when i am selecting the field its not taking any values and displaying null
this is my procedure
CREATE procedure viewfeestudentinfo
@registrationid varchar(50)
as
begin
select distinct studentname,department,totalfee from studentfeedetails where registrationid=@registrationid
end
this is my code behind action
panelfeeview.Visible = true;
DataSet ds = new DataSet();
ds = class1.viewfeestudentinfo(txtfeeregid.Text.ToString());
txtfeename.Text = ds.Tables[0].Rows[0][0].ToString();
dropfeedep.SelectedItem.Text = ds.Tables[0].Rows[0][1].ToString();
txttotalfee.Text = ds.Tables[0].Rows[0][2].ToString();
Button1.Visible = false;