is there any other control than text box to accept text from user - ASP.NET Discussion Boards

Sebastian T Xavier30-Oct-06 23:41

30-Oct-06 23:41

hi, today i ahave a new doubt.
i have created a datagrid and added radio button in the grid. i have used the following code

<code>
<asp:DataGrid id="DataGrid1" runat="server">
<Columns>
<asp:TemplateColumn>
<ItemTemplate>
<asp:RadioButton id="RadioButton1" runat="server"></asp:RadioButton>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
</asp:DataGrid>
</code>

it works very nicely. but the problem is that while debugging i can select(check) more than one row. it is suppossed to select only one row at a time.

can you help me to solve the problem. thanks in advance

sebastian

Re: problem with radionbutton in a datagrid

_AK_31-Oct-06 0:03

_AK_

31-Oct-06 0:03

You have to use the groupname property of the radio button to achieve that task.

Best Regards,
Apurva Kaushal

Re: problem with radionbutton in a datagrid

Sebastian T Xavier31-Oct-06 17:38

Sebastian T Xavier

31-Oct-06 17:38

i have alreday tried it out. but doesn't work. then i have tried to give some id to the radio button like
e.item.index=i in the datagrid1_itemcreated event.
first time it works but when i click any button any more time it gives the error . please help me.

Re: problem with radionbutton in a datagrid

_AK_31-Oct-06 17:51

_AK_

31-Oct-06 17:51

You can have a look at This[^]

Best Regards,
Apurva Kaushal

Re: problem with radionbutton in a datagrid

Sebastian T Xavier31-Oct-06 18:47

Sebastian T Xavier

31-Oct-06 18:47

thanks a lot. i will go thrugh this

Re: problem with radionbutton in a datagrid

_AK_31-Oct-06 18:56

_AK_

31-Oct-06 18:56

Always welcome.. Smile | :)

Best Regards,
Apurva Kaushal

Re: problem with radionbutton in a datagrid

P A N K A J31-Oct-06 22:55

P A N K A J

31-Oct-06 22:55

you can also add the javascript with the radio buttons in the datagrid.

when any radiobutton checked just check all the rows / items of the datagrid in a loop and deselect other radiobuttons.

Pankaj Gupta
(Take it easy)

is there any other control than text box to accept text from user

yogita charhate30-Oct-06 23:12

yogita charhate

30-Oct-06 23:12

hello,
Actually the problem is that I've to accept text in a control as well as have to display image in the same control .
I tried using Panel but it is not accpting text at run time .
And the Format of the contents of the control is like below:
(At the place of white space there should be image we can use Image control there.)

jhgfdjhkh
uhhiohhui
uifghihhg
ygughrihihjghhhjh
ughuhhhhhiihhhthh
h89uhhuhuyhuihuih
uyg8tryhthythutr7
guhrtuyh8rty8iuiu

yog
hui gfgh kgdgrt njjn hjgkn

Re: is there any other control than text box to accept text from user

Parwej Ahamad31-Oct-06 0:00

Parwej Ahamad

31-Oct-06 0:00

pls clerify your problems

Softy Boy

Re: is there any other control than text box to accept text from user

yogita charhate31-Oct-06 0:35

yogita charhate

31-Oct-06 0:35

i want to ask that to have
a format like below

ffjjgfghjljkk
Here the user
will enter th
text and the blank space
there will be image soin
order to satsfy6 this re
quirement what shd i do

yog
hui gfgh kgdgrt njjn hjgkn

Re: is there any other control than text box to accept text from user

Parwej Ahamad31-Oct-06 0:38

Parwej Ahamad

31-Oct-06 0:38

u can use multiline textbox.
for image u can use the html tag and replace at run time where u would like to show.

Softy Boy

ORACLE SQL statement in C# !! ??

Naif_Prof30-Oct-06 23:01

Naif_Prof

30-Oct-06 23:01

Dears

I need to write the following ORACLE SQL statement in C# in page of ASP as string

Select emp_name as “employees Name” , emp_Add as “address” , dept as “department”
From test.emp_tab ;

Im using as to rename the column name in datagrid

Any one help me to write it by C# as string

Notes we in oracle to rename column name we have to use “ ” same as in defining string in C#

Thanks

Re: ORACLE SQL statement in C# !! ??

Akhilesh Yadav30-Oct-06 23:26

Akhilesh Yadav

30-Oct-06 23:26

try this

string SqlQry;

SqlQry = "Select emp_name as ""employees Name"" , emp_Add as ""address"" , dept as ""department""
From test.emp_tab";

Regards,
Akhilesh Yadav

Re: ORACLE SQL statement in C# !! ??

Naif_Prof31-Oct-06 6:19

Naif_Prof

31-Oct-06 6:19

Dear Akhilesh Yadav

its not working by after a lot of time the correct syntax is

SqlQry = "Select emp_name as \"employees Name\" , emp_Add as \"address\" , dept as \"department\"
From test.emp_tab";

so we use \ to cancel meaning of “ in string

thanks

DropDownList - ListItem

Dayekh30-Oct-06 22:53

Dayekh

30-Oct-06 22:53

Hi,

I have a DropDownList which is databound and also has one ListItem. The DropDownList is populated with all ProjectNames from the Project Table.
The ListItem's Text is "All" and the Value is "".

This DropDownList is supposed to be for a search funtionality. When I click on a project, a datagrid will display the records involving the selected project. When I select "All", I would like the datagrid to display the records involving ALL the projects.

I would just like to know if keeping the ListItem's value entry blank will be perfectly fine. If not, then what should it be?

Thanks.

Re: DropDownList - ListItem

just3ala230-Oct-06 23:18

just3ala2

30-Oct-06 23:18

let me get it right
what u do is that u select a list item and u put its value in the query string and then do the select, assign the datasource, then bind

why do u want to keep the listitem's value blank?

Best Regards
3ala2 Smile | :)

Re: DropDownList - ListItem

Dayekh30-Oct-06 23:34

Dayekh

30-Oct-06 23:34

Thanks for the reply 3alaa2,

The thing is, I'm trying to make sense of how the list item will work. Let's say I names the value of the list item All just like the text for the list item.

Currently the query to populate the dropdown is simply:

"SELECT tblProject.inProjectID, tblProject.vchProjectName

FROM tblProject ORDER BY tblProject.vchProjectName"

If I am to include the list item, All, how would the query look?

Re: DropDownList - ListItem

just3ala231-Oct-06 0:31

just3ala2

31-Oct-06 0:31

No problem Big Grin | :-D

U can simply use the If/Else condition and use the sql statememnt
"SELECT tblProject.inProjectID, tblProject.vchProjectName FROM tblProject ORDER BY tblProject.vchProjectName" if the user select listitem(0) and use your other sql statement that has the Where clause

If u r using stored procedures there is another better solution.
Tell me if u do...

Best Regards
3ala2 Smile | :)

Re: DropDownList - ListItem

Dayekh31-Oct-06 0:48

Dayekh

31-Oct-06 0:48

I am using stored procedures for saving/delete/updating records. This Query is a one off query populating a dropdownlist..

Would the solution look something like :

If Me.ddlProject.SelectedValue = ListItem(0) Then

"SELECT tblProject.inProjectID, tblProject.vchProjectName
FROM tblProject
WHERE tblProject.vchProjectName = [Any value(lol no idea what to write here!)]
ORDER BY tblProject.vchProjectName "

Else

"SELECT tblProject.inProjectID, tblProject.vchProjectName
FROM tblProject
ORDER BY tblProject.vchProjectName"

Thanks again for the replyin..

Re: DropDownList - ListItem

just3ala231-Oct-06 1:05

just3ala2

31-Oct-06 1:05

it's more like ...

<br />
If ddlProject.Items(0).Selected Then<br />
'The (All) statement<br />
<br />
"SELECT tblProject.inProjectID, tblProject.vchProjectName FROM tblProject ORDER BY tblProject.vchProjectName"<br />
<br />
Else<br />
'The specific project statement<br />
"SELECT tblProject.inProjectID, tblProject.vchProjectName FROM tblProject WHERE tblProject.vchProjectName = '"& ddlProjects.selectedValue &"' ORDER BY tblProject.vchProjectName"<br />
<br />
End If<br />

Hope this solves the problem

Best Regards
3ala2 Smile | :)

Re: DropDownList - ListItem

Dayekh31-Oct-06 1:19

Dayekh

31-Oct-06 1:19

Thanks man,

One issue though... It is throwing an 'Out of range' error exception..

This is how I am populating the dropdownlist:

<br />
Dim sQueryDDL As String<br />
Dim sTableDDL As String<br />
Dim dsDDL As DataSet = New DataSet<br />
<br />
If ddlProject.Items(0).Selected Then<br />
                sTableDDL = "SELECT tblProject.inProjectID, tblProject.vchProjectName FROM tblProject ORDER BY tblProject.vchProjectName"<br />
            Else<br />
                sTableDDL = "SELECT tblProject.inProjectID, tblProject.vchProjectName FROM tblProject WHERE tblProject.vchProjectName = '" & ddlProject.SelectedValue & "' ORDER BY tblProject.vchProjectName"<br />
            End If<br />
            sTableDDL = "tblProject"<br />
            dsDDL = clsCommon.getData(sQueryDDL, sTableDDL)<br />
            dsDDL.Tables(0).DefaultView.Sort = "vchProjectName"<br />
            Me.ddlProject.DataSource = dsDDL.Tables(0).DefaultView<br />
            Me.ddlProject.DataTextField = "vchProjectName"<br />
            Me.ddlProject.DataValueField = "inProjectID"<br />
            Me.ddlProject.DataBind()<br />
            Me.ddlProject.Items.Insert(0, New ListItem("<< All >>", ""))

I have a creeping suspricion that the last line is the problem. Let me know if you can. Thanks..

Re: DropDownList - ListItem

just3ala231-Oct-06 1:33

just3ala2

31-Oct-06 1:33

u don't need the last line of code because the drop down list is already binded and the fields are inserted after the Me.ddlProject.DataBind() statement

let me know if u r still havin a problem ...

Best Regards
3ala2 Smile | :)

Re: DropDownList - ListItem

Dayekh31-Oct-06 2:30

Dayekh

31-Oct-06 2:30

hi again,

This statement is thrown at me:

System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index

This is the line it highlighted as the erroneous one:

If ddlProjectRequestSearch.Items(0).Selected Then

Question: Shall I implement a <asp:listitem> tag in the front end code for the "All" option? I'm gonna try that now and see what happens.

Re: DropDownList - ListItem

just3ala231-Oct-06 3:02

just3ala2

31-Oct-06 3:02

u can do that as a solution

If u wanna keep it as before:

<br />
If ddlProjectRequestSearch.SelectedValue = "All" Then<br />
            'The code for all ...<br />
        Else<br />
            'The code for the rest ...<br />
        End If<br />
<br />
<br />
End If<br />

Put this code in the ddlProjectRequestSearch_SelectedIndexChanged and make the postback property "True"

or put it in a button and leave the postback property for the ddlProjectRequestSearch in the default state (False)

This should work fine, i tried it now Big Grin | :-D

Best Regards
3ala2 Smile | :)

Re: DropDownList - ListItem

Dayekh31-Oct-06 3:42

Dayekh

31-Oct-06 3:42

I am populating the DropDownList in the PageLoad event. When will the list populate if the code is in the ddlProjectRequestSearch_SelectedIndexChanged method ?

Also, exactly where are we defining the ListItem "All". Since I erased it from the .aspx.vb file shall I make a <listitem> tag for it ?

Sorry bout taking up your time and Thanks.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.