RadioButtonList Question

[Arun]

Hi Frndz,

How to pass dataList(one field) value to a Radiobutton List ??

Regards,
Arun.M.D

[sankar]

Hi Arun

i think u asking abt binding a field from database to the radiobuttonlist.If so the follwing code will be usefull

 

 SqlConnection SqlCon = new SqlConnection("ConnectionString");
  SqlCommand SqlCmd = new SqlCommand("SELECT FieldName1(like Text), FieldName2(like id) FROM TableName", SqlCon);
  SqlCon.Open();
  rbl.DataSource = SqlCmd.ExecuteReader(CommandBehavior.CloseConnection);
  rbl.DataTextField = "FieldName1";
  rbl.DataValueField = "FieldName2";
  rbl.DataBind();

 

Regards

Sankar

---

Yahoo! for Good
Click here to donate to the Hurricane Katrina relief effort.

[Arun]

hi,
I tried above example. But itz not get output .

Can any other method is possible to bind a datalist value to
RadioButton List Web contro??

Regards,
Arun.M.D

[SkyMania]

Its working fine with the follwoing code

string strqry;
strqry = "SELECT PRODUCTID,PRODUCTNAME FROM PRODUCTS WHERE PRODUCTNAME
LIKE 'A%'";
Scmd = new SqlCommand(strqry,Con);
Con.Open();
SDR = Scmd.ExecuteReader();
rbl.DataSource = SDR;
rbl.DataTextField = "PRODUCTNAME";
rbl.DataValueField = "PRODUCTID";
rbl.DataBind();

Regards,
SkyMania

[Arun]

Hi,

When i use above coding it says "rbl" is not declared error....

[Arun]

Hi,

I used like this....

myconn1 = New
SqlConnection("server=localhost;DataBase=Banking;Trusted_Connection=True")
mycommand = New SqlCommand("Select * from
Adm_Super_LoginMaster", myconn1)
myconn1.Open()
myread = mycommand.ExecuteReader()
myread.Read()
rbl.DataSource = myread
rbl.DatavalueField = "Adm_id"
rbl.DataBind()
myread.Close()
myconn1.Close()

In this coding it shows erron on this line
"rbl.DataSource = myread
"

And ERROR is:
Object variable or With block variable not set.

Regards,
Arun.M.D

[SkyMania]

Hai,
Please check your connection..and try to bind it with datagrid.
And remove myRead.Read() also, otherwise it will bind only the
first record.

Regards,
SkyMania

[Arun]