Comments by Member 7767311 (Top 12 by date)

k i accept the solution .. but how to call this function in stored procedure

Regards
Sarthak

Hi...so far i have done please check my below code...

protected void Page_Load(object sender, EventArgs e)
{


if (!IsPostBack)
{

if (Request.QueryString["id"] != null)
{
fillquestion();

}
}
}

public void fillquestion()
{
jaya j = new jaya();
int id = Convert.ToInt32(Request.QueryString["id"]);

DataTable dt = j.fillquestionuser(id);

int i;

for (i = 0; (i <= (dt.Rows.Count - 1)); i++)
{
TextBox txt = new TextBox();
txt.ID = "txt" + i;
txt.Text = "txt" + i;

}
if (dt.Rows.Count == 0)
{

DataList1.Visible = false;

}
else
{
DataList1.Visible = true;
DataList1.DataSource = dt;
DataList1.DataBind();
}


}


I mam not getting a dynamically text boxes while executing...pls go through it..

I am getting an error while exec this SP ..Pls modify it accordingly i have created function also..

Error:-The multi-part identifier "pv.val" could not be bound.

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER proc [C244570_marriage].[sp_fillexpectation]
@CustomerId nvarchar(max)
as
begin
with custexp as
(
select c.*, pv.val as Comp1 from customerexpectation c
cross apply dbo.ParseValues(complexion1,',') as a
where len(a.val)>0
)
select * from CustExp ce
left outer join familystatus fs on ce.familystatus1=fs.id
left outer join complexion cp on ce.complexion1=cp.id
left outer join familytype ft on ce.familytype1=ft.id
left outer join foodhabit fh on ce.foodhabits=fh.id
left outer join education e on ce.qualification=e.id
where ce.CustomerId=@CustomerId
--select * from customerexpectation ce
--left outer join familystatus fs on ce.familystatus1 like fs.id
--left outer join complexion cp on ce.complexion1 like cp.id
--left outer join familytype ft on ce.familytype1 like ft.id
--left outer join foodhabit fh on ce.foodhabits like fh.id
--left outer join education e on ce.qualification like e.id
--where ce.CustomerId=@CustomerId
end

Yes Exactly You are right