HOW CAN I POPULATE TEXTBOX FROM DATASET
EX:
SELECT MAX(ID) FROM EMP

Use DataBinder.Eval method 
like

text1.Text  = DataBinder.Eval(container.DataItem ,"ToTRec").ToString(); 

Satish


----- Original Message ----- 
From: "B.VENKATESHWAR RAO" <BVRAO9@H...>
To: "ASP.NET" <aspx@p...>
Sent: Tuesday, December 03, 2002 6:38 AM
Subject: [aspx] POPULATE TEXTBOX FROM DATASET


> HOW CAN I POPULATE TEXTBOX FROM DATASET
> EX:
> SELECT MAX(ID) FROM EMP
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 

1) setup a dataview with the value you want 
2) assign the value
textbox.text = dataview(0)("fieldname")

-----Original Message-----
From: B.VENKATESHWAR RAO [mailto:BVRAO9@H...]
Sent: Tuesday, December 03, 2002 6:39 AM
To: ASP.NET
Subject: [aspx] POPULATE TEXTBOX FROM DATASET


HOW CAN I POPULATE TEXTBOX FROM DATASET
EX:
SELECT MAX(ID) FROM EMP

> HOW CAN I POPULATE TEXTBOX FROM DATASET
E> X:
S> ELECT MAX(ID) FROM EMP

> 

> 

> 

> 

> 

> 

> 

> 

> 

> HOW CAN I POPULATE TEXTBOX FROM DATASET
i tried my level best but still i did't get the value,
so please check my code and give a solution,i will wait for reply
thank u for ur help.

My code is:

<script language="C#" runat="server">
void okclick(Object Src, EventArgs E)
{
String total;
String bv;
SqlCon=new SqlConnection("server=BVRAO;User Id=sa;pwd=;database=APTS");
String selectCmd="select count(*) as total from emp";
	SqlCommand SqlCom=new SqlCommand(selectCmd,SqlCon);
	SqlCon.Open();
	SqlDataReader dr;

1)   bv=dr("total")

	
  2)	dr = SqlCom.ExecuteReader();    



      Txtsno.Text=SqlCom.ExecuteScalar();

          SqlCon.Close();
    }
</script>

i tried for these two options.



> 

> 

> 

> 

> 

> 

> > HOW CAN I POPULATE TEXTBOX FROM DATASET
i>  tried my level best but still i did't get the value,
s> o please check my code and give a solution,i will wait for reply
t> hank u for ur help.

> My code is:

> <script language="C#" runat="server">
v> oid okclick(Object Src, EventArgs E)
{> 
S> tring total;
S> tring bv;
S> qlCon=new SqlConnection("server=BVRAO;User Id=sa;pwd=;database=APTS");
S> tring selectCmd="select count(*) as total from emp";
	> SqlCommand SqlCom=new SqlCommand(selectCmd,SqlCon);
	> SqlCon.Open();
	> SqlDataReader dr;

> 1)   bv=dr("total")

> 	
 >  2)	dr = SqlCom.ExecuteReader();    

> 

>       Txtsno.Text=SqlCom.ExecuteScalar();

>           SqlCon.Close();
 >    }
<> /script>

> i tried for these two options.

Please put  code here.

> HOW CAN I POPULATE TEXTBOX FROM DATASET
E> X:
S> ELECT MAX(ID) FROM EMP

> Use textbox.text property. Assign it to the value from dataset and do a 
databind

> 

> 

> 

> 

> 

> 

> 

>