|
Hi.
My problem is simple, but detailed.
Instead of creating list items for the drop down list (Mr,Mrs,Miss), I would like to instead get the information from a table in SQL server DB which holds thats information.
The table has 2 fields.. UserTitleID and Description.
There is another User table, holds the foreign key "inUserTitleID". I need to be able to store new users in the User table, selecting the entries from a drop down list with entries which the UserTitle table can hold(variable number-not fixed like list items).
I request for a hint(or a push in the right direction) on how to tackle this issue..
PS. Sorry if this sounded more like a rant =(
Thanks.
-- modified at 11:38 Thursday 17th August, 2006
|
|
|
|
|
One way is to read the items into a DataSet and use that as DataSource for the DropDownList. Set the DataTextField and DataValueField properties to the names of the fiels in the DataSet. Assign the DataSet to the DataSource property and call the DataBind method to populate the list.
Another way is to get the items using a DataReader and iterate the reader to populate the list. Read the values from the DataReader and use them to create a ListItem object for each item and add it to the list.
---
b { font-weight: normal; }
|
|
|
|
|
Thanks for the suggestions.
I'll get cracking on then 
|
|
|
|
|
|
Thanks for the link!
|
|
|
|
|
Hi there,
I am currently looking into how we can integrate PHPBB into an ASP .NET website, by integration, I do not simply mean placing the forum into and IFrame and forgetting about it...
One of the main challenges is to implement a 'Single Sign On' mechanism, has anyone here done something like this? any suggestions?
My ideas are along the lines of, accessing the PHPBB (mysql) database using Connector.NET and 'planting' an auth cookie for PHPBB when the user logs in, are there any known issues with this approach?
Any general advice would be welcome.
Thanks,
Paul
|
|
|
|
|
Hi,
I am using the logging block to capture events in my web application. I need to configure the database listner to point to my database (sql server) instead of the one provided by default.
How can that be done? Can anyone point me to any articles on this?
Thanks
Minu
|
|
|
|
|
Hi Nish,
Could u pls explain in details regarding
'Client-side validation of radio button column in a DataGrid By gn_srini'
I tried it on my application, but it is not working.
As per ur article, user should be able to select only one option button, but it is selecting all the options in the datagrid. can u help me in this regard. I might be wrong in some where.
-- modified at 10:15 Thursday 17th August, 2006
Balasaheb
Software Developer
Platform: Asp.net,vb.net
Database: SQL Server 2000
|
|
|
|
|
If you want to ask a question about an article, then you should use the forum right below the article, and the author is also notified by your post.
|
|
|
|
|
Hi,
in my asp.net appln i have displayed the data in a crystal report.but i canot able to print that document using network printer.i want to print that one without going for export option.so could u plz help me.
|
|
|
|
|
Can row in datagrid be scrollable-- if length of the row is exceed the lenght of datagrid can we make it scrollable.
thank u
uma
|
|
|
|
|
You need to create a DataGridTextBoxColumn and set the Multiline and WordWrap properties of the hosted DataGridTextBox. You can then add scrollbars if you wish.
Steve
-- modified at 8:09 Thursday 17th August, 2006
|
|
|
|
|
I kept the datagridview in a panel and made the scrollproperty of the
panel to Auto and it works. Try it
Thanks
Kal
|
|
|
|
|
i have the follow xml file :
<ListBoxes>
<row>
<Number>None</Number>
<Description>None</Description>
<Counter>999</Counter>
<Factor>0</Factor>
<Harmful>N</Harmful>
</row>
<row>
<Number>R1</Number>
<Description>R1 Explosive when dry</Description>
<Counter>1</Counter>
<Factor>1</Factor>
<Harmful>N</Harmful>
</row>
<row>
<Number>R10</Number>
<Description>R10 Flammable</Description>
<Counter>10</Counter>
<Factor>1</Factor>
<Harmful>N</Harmful>
</row>
<ListBoxes>
I have been trying to bind this to a listbox but have been unsuccessful, can anyone help. I have read that i may need an xslt file to transform it, is this true and could someone point me in a good direction on how to use xslt files
Thanks
-- modified at 6:22 Thursday 17th August, 2006
|
|
|
|
|
May be you can try giving DisplaySource property as "ListBoxes.row" OR "row" and DisplayMember as "Description" and ValueMember = "Number"
Hope this works for you.
- ashish
|
|
|
|
|
How to take reference of connection string or connection
which is written in the web.config in a c# code.
urgent
Regards
|
|
|
|
|
If it is inside the appsettings in config file then you can access it like this:
ConfigurationSettings.AppSettings.Get("the variable name");
Best Regards,
Apurva Kaushal
|
|
|
|
|
Hi there...
I have a user control (UC) which is dynamically added to a page. In this UC I have a DropDownList (DDL) (normally added - not dynamically). The problem is that the item which is set selected in the beginning in the DDL wont fire the OnSelectedIndexChanged event. In the beginning the item is selected – then I choose another item and it fires the OnSelectedIndexChanged event. When I then select the first selected item again the event isn't fired.
I don’t set the selected item in the beginning so it is the first item – but I have tried to set it as an item somewhere in the middle and then that item wont fire the event. So it has something to do with the first selected item.
Here’s my code...
The page which dynamically adds the user control:
m_plhTableForm.Controls.Clear();
UserControl ucTableForm = null;<br />
<br />
switch( strTableID )<br />
{<br />
...<br />
case CConstants.DB2ID_BUNKANUMER:<br />
ucTableForm = (UserCtrls_Tableforms_Bunkanumer_UC) this.LoadControl( "~/UserCtrls/Tableforms/Bunkanumer_UC.ascx" );<br />
break;<br />
...<br />
default:<br />
ucTableForm = null;<br />
break;<br />
}<br />
<br />
if( ucTableForm != null )<br />
{<br />
ucTableForm.ID = "WebUserCtrl1"; <br />
m_plhTableForm.Controls.Add( ucTableForm );<br />
}
The User Ctrl – aspx file (took out the brackets for rendering):
<br />
asp:DropDownList ID="m_cboBUNK" runat="server" CssClass="controlText" AutoPostBack="true" OnSelectedIndexChanged="onCboBUNKSelectedIndexChanged" /asp:DropDownList<br />
The User Ctrl – codebehind file:
Nothing big done here – data fetched and databinded to the DDL
|
|
|
|
|
spoa wrote: then I choose another item and it fires the OnSelectedIndexChanged event. When I then select the first selected item again the event isn't fired.
After the SelectedIndexChanged event gets fired, do you set any new selected index for the dropdownlist? Do you see the new item selected in the dropdownlist after the postback? Basically, the event is raised when the control detects the new selected item value in comparision with the current one which is persisted in the ViewState. You also make sure that the values (not text) of all the items are different.
|
|
|
|
|
Hi!
I want to do the Paging in the datagrid., I used data item command event also this
is for if we clicks the link button in that grid., it has to redirects to another
page., In that data grid, If i clicks the Next it shows the next form(which is i
denotes in the item command., ) instead of the next datagrid page...
The same code i used for this one is working properly in the other project there i
didn't use any item command event...
How can we solve this one..?
Prabu.T
|
|
|
|
|
You don't need any additional coding for the gridview paging (at least not in 2.0). All you have to do is to set the maximum number of records through PageSize property, and set AllowPaging property to true.
Also, since you are using a command field, make sure that EnableSortingAndPagingCallbacks property is set to false because you can't page on the client if you use a command field (due to the possibilities of a postback).
Let me know if you still have problems.
Nila
|
|
|
|
|
1. Using ADO.NET Datareader a user extracts data from a database table
having 1000 rows.He closed his browser in between.
that is after fetching only 50 records.
What happens to the Datareader?will it remain connected?
and will fetch 1000 records and what after?
will garbage collector collect and dispose it soon?
2. A user fetched dtata from a database table
using Dataset(Disconnected records) for updation.
Another user deleted the table just after.
what happens when the first user try to update the table after changes? Error or Something else
3.where is session id stored in ASP? in IIS aerver or ASP Engine
Thanks & Regards
Vishal Sharma
vishalsharma556@yahoo.co.in
|
|
|
|
|
If we help you get the job, do we get part of your paycheck, too? 
--Jesse
|
|
|
|
|
Rule #1...don't post the same question in more than one topic board.
|
|
|
|
|
Ans 1: Active connection will be there in the database, connection won't close itself, because we used a datareader, it is a not disconnected like dataadapter. We have to manually close the connection.
Ans 2: We will get an exception exception like "concurrency violation ..."
Ans 3: No idea
Ram
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
