Clarification For 'WHERE' Statement In A Dropdownlist

Feb 12, 2008

My goal is to populate a dropdownlist with only with users that are "Techs".  I am using the membership database that you ccan set up through VWD.  I added this column to the aspnet_Users table: IsTech as bit datatype. I thought I had the right SQL statement but apparently not, because I get an
Invalid column name 'True'.
Here is my statement:
 <asp:SqlDataSource
                                    ID="SqlDataSource3"
                                    runat="server"
                                    ConnectionString="<%$ ConnectionStrings:HRIServiceConnectionString1 %>"                               
                                    SelectCommand="SELECT [UserID], [FirstName]+ ' ' + [LastName] AS techid FROM [aspnet_Users] WHERE [isTech] = True ORDER BY [LastName], [FirstName]">
                                </asp:SqlDataSource>

 

View 9 Replies


ADVERTISEMENT

One Clarification

Jan 20, 2000

Hi friends,
How r u?..i have one clarification..Curently, i am doing one search engine stuff...for that, i have to populate data from sql server database to flat file..i got java script search engine code from one web-site,in that code,data's are fetching from flat-file only..so i have populate the data from sql server to flat-file, and then get the key-word value from that flat-file according to the user input..Is it possible?..send mail..

Bye from
Jan Reddy

View 1 Replies View Related

Clarification

Jan 22, 2008

I just finished getting a local database mirrored to an offsite "DR" server. Interesting experience getting that working, but that's another story! It's set up as "High Safety without automatic failover (synchronous) (without a witness). I was hoping I could get a sanity check in this flow....

Local database gets updated each morning with a few meg of data, so it's pretty low use. It's mirrored through a T1 (soon to be dual). My remove copy was restored from yesterday€™s backup, and the mirror was sync'd in less than 10 minutes, so I don't expect bandwidth to be an issue...

In the event that my local server or network is down, I'd be able to log into my remote server, and run my application remotely. From what I've seen, the "Failover" option is only available on the "Primary" server? Will this become an option if the remote no longer sees the primary, or do I need to do this through the command: ALTER DATABASE <dbname> SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS?

Since the updates are so limited, I'm not too concerned with data loss, but will need to make sure I can get this running quickly if needed...

As I understand it, this will put the mirrored database as the primary, and when the old primary comes back only, it'll become the new mirror? I can then let them sync, and force a failover from the remote system to put the primary back to the local network.

I just want to make sure I understand this correctly before I start testing. Thanks for any assistance!

Steve

View 10 Replies View Related

Clarification On DataReader

Jan 19, 2006

I want to create a DataList that shows products, which will be on
multiple pages. I have my stored proc to show paged results, which
contains a return value for more records.
I have found examples of coding the DataReader, defining all the
parameters etc, but what about the drag and drop SqlDataSource?? You
can select the DataSource Mode to be "DataReader". I can put select
parameters in, with input and my return value. I don't know how to then
access the return value, or output value if needed, from this? My
DataList references the SqlDataSource, but I don't know how to get the
return/output value out??? This is very frustrating, cause I can't find
any info about it anywhere. Always input parameters, but no output.
This is my current SqlDataSource...

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
DataSourceMode="DataReader" ConnectionString="<%$
ConnectionStrings:Personal %>" SelectCommand="sp_PagedItems"
SelectCommandType="StoredProcedure">
        <SelectParameters>
           
<asp:QueryStringParameter Name="Page" QueryStringField="page" />
            <asp:Parameter Name="RecsPerPage" DefaultValue="10" />
           
<asp:QueryStringParameter Name="CategoryID" QueryStringField="cat"
/>
           
<asp:Parameter Name="RETURN_VALUE" Direction="ReturnValue" Size="1"
/>
        </SelectParameters>
    </asp:SqlDataSource>

If I take out the RETURN_VALUE Parameter, my results display in my data
list, but that's useless if I can't access the return value to
determine the remaining number of pages etc. Is my RETURN_VALUE
parameter wrong? How do I access that? My stored proc is shown below...

CREATE PROCEDURE sp_PagedItems
   (
    @Page int,
    @RecsPerPage int,
    @CategoryID int
   )
AS

-- We don't want to return the # of rows inserted
-- into our temporary table, so turn NOCOUNT ON
SET NOCOUNT ON


--Create a temporary table
CREATE TABLE #TempItems
(
   ID int IDENTITY,
   No varchar(100),
   Name varchar(100),
   SDescription varchar(500),
   Size varchar(10),
   ImageURL varchar(100)
)


-- Insert the rows from tblItems into the temp. table
INSERT INTO #TempItems (No, Name, SDescription, Size, ImageURL)
SELECT No, Name, SDescription, Size, ImageURL FROM Products WHERE CategoryID=@CategoryID

-- Find out the first and last record we want
DECLARE @FirstRec int, @LastRec int
SELECT @FirstRec = (@Page - 1) * @RecsPerPage
SELECT @LastRec = (@Page * @RecsPerPage + 1)

-- Now, return the set of paged records, plus, an indiciation of we
-- have more records or not!
SELECT *,
       MoreRecords =
   (
    SELECT COUNT(*)
    FROM #TempItems TI
    WHERE TI.ID >= @LastRec
   )
FROM #TempItems
WHERE ID > @FirstRec AND ID < @LastRec


-- Turn NOCOUNT back OFF
SET NOCOUNT OFF

View 3 Replies View Related

Licensing Clarification

Jan 15, 2008

mine is a small organisation and we have deployed an ERP on windows 2003 server. their are total 60 ERP users and we have 25 concurrent licences for ERP.

at the backend we are running MS SQL 2000 standard edition. we have created one user in Database and ERP accesses data through this user only.

now i need to understand how many CAL for database i need to purchase. either 60 or 25 or 1.

thanks

View 1 Replies View Related

Clarification Needed

Jul 23, 2007

I hope someone can help here. I found that I was having replication failing due to the fact that there is a foreign key being referrenced, here is the error:
Could not drop object 'dbo.tblName' because it is referenced by a FOREIGN KEY constraint.
(Source: Database Name (Data source); Error number: 3726)





In searching for some sort of answer - I came across this:
Join Filters




Foreign key relationships are central to most database designs. For example, in a database that tracks product orders, you often see a CUSTOMER table with a CustID primary key and an ORDER table with a CustID foreign key that references the CUSTOMER table. In merge replication, if you filter the CUSTOMER table with a subset filter clause, you must also filter the ORDER table, so that only the rows that reference the filtered subset of rows from the CUSTOMER table are replicated. Filtering requirements that are based on a foreign key relationship must be explicitly represented in the merge replication configuration through a join filter (which lists the two related table articles and a logical expression that identifies the relationship), as shown in the following example:CUSTOMER.CustID = ORDER.CustIDThe effect of this join filter between the CUSTOMER table and the ORDER table, together with the subset filter
clause on the CUSTOMER table, is that Subscribers to the publication receive only those rows from the CUSTOMER
table where State = 'WA' and only those rows from the ORDER table that correspond to the CustID
values in the filtered CUSTOMER table.
________________________________________________________________________
Am I reading this right? If I have only one table that I need to replicate, I would need to included the other tables connected by
the foreign key for the replication to work, and in doing so - the table I designate for updating in this replication will be the only
one affected and the others that have go with this - won't update their corresponding dupe tables? Sorry - I hope this makes sense.

View 3 Replies View Related

Clarification On Variables!

Apr 1, 2008

I have a question , because I€™m not very experienced with VB.

The function declares

Public myString
Public myKey

When something is declared this way, what happens if two or more users happen to execute the report at the same time? Is myString and myKey public to all of those reports at the same time, or does the Report Server manage those variables separately for each of the reports running concurrently?

Any clarification on this......................?

thanks

View 7 Replies View Related

Basic Concept Clarification

Oct 2, 2007

The distinction between Entity and Relationship is obvious to me. But I am confused by Table. Table describes Entity, Relationship, or both?

Thanks for any input.

View 9 Replies View Related

Clarification On Product Specification

Sep 15, 2007

http://www.microsoft.com/sql/editions/compact/sscecomparison.mspx
The above link says the pros and cons of two SQL Server 2005 editions.
Document says Compact Edition is not good for €˜When you need a multi-user database server
€™.
What is the meaning of multi-user database?
Does this means the database strictly will not support two database connections at a time?
-Thank you,
Gish

View 1 Replies View Related

Small Clarification On Indexing

Jun 2, 2006

Can come one help me how to disable an index using select query.

View 1 Replies View Related

Collation Clarification/ Internationalisation

Nov 21, 2007

Hi,

I am working on a SQL Server database that will be accessed (mainly) via a web interface that will have users from various countries. As I understand it, the best way to store data is to use 'n' (nvarchar etc) datatypes for columns, which allow users to enter data and it will be stored in the raw Unicode format. For other reasons the collation of the db has been changed (to Slovenian) but I understand that this will only affect how data is sorted. However, whenever I try to put certain data into the nvarchar field (Such as the £ symbol) the data get transferred to a letter L. Is that how it would be expected to work and if so am I missing something here - note I Know ent manager sometimes shows data incorrectly, but this happens when I add/view data from anywhere (i.e. end manager/ the website/ query analyser).

Any clarification would be much appreciated.

Kenny

View 1 Replies View Related

Clarification On Mixed Join Types

Apr 10, 2008

Hi,
I'm seeing confusing results coming back from a query and I want to make sure my joins are working as expected.

I have 3 tables, tbl_family, tbl_familyPhone, and tbl_phone. tbl_FamilyPhone is a linking table between families and phones that specifies if it's the primary number.


tbl_Family tbl_FamilyPhone tbl_Phone
--------------- ------------------------- ----------------
pk_FamilyID pk_FamilyPhoneID pk_phoneID
fName fk_FamilyID fk_TypeID
lName fk_PhoneID ...
... ...

So a family has many familyPhones and a phone has many family phones. I'm trying to get all the families and their home phone only, if they have one. I don't want families to duplicate and I don't want any left out. Here's what I've got





Code Snippet
select [whatever]

from tbl_family
LEFT OUTER JOIN tbl_familyphone on tbl_family.pk_familyid = tbl_Familyphone.fk_familyid
inner JOIN tbl_phone on tbl_familyphone.fk_phoneID = tbl_phone.pk_phoneid and tbl_phone.fk_phonetypeid = 'E6F1688E-015B-481D-8C41-DCC1FEA5D5AB'






My thinking is the inner join between tbl_Phone and tbl_FamilyPhone will cause any FamilyPhone record without a phone record to be left out (fk_phonetypeid is the id of a home phone). Though some FamilyPhone records may be left out, I will not lose any families because it is left outer joined to familyphone. Is this right? Because if I just do select count(*) from families I get 4517 records, but when running the query above with the joins, I get 4383 records.

View 13 Replies View Related

Table Lock Option Clarification

May 5, 2008

Does the Table Lock option in the OLE DB Destination task in a data flow refer to a lock on the destination table or on the source table from which the table is loading from?

The reason I ask is because I have a package run twice simultaneously pulling from the same server and table onto two different tables on two different servers. When I kick off my job to run the two data pulls, one of the jobs terminates with a

"TCP Provider: An existing connection was forcibly closed by the remote host." message. I believe this is due to a table lock on the server, but can't figure this out.

Thanks in advance for your help.

View 1 Replies View Related

DB Engine :: Clarification On MDF / LDF Sizes And Backups

Jun 7, 2015

My environment looks like:

- Windows 2008R2 SP2 VM (VMware 6)
- SQL 2012 SP2 Std.
- NetApp iSCSI LUNs, Snapmanager for SQL

So I have created a test database and configured the logs to grow to max. 120MB in size.

To check the allocated and free space I right-clicked the database -> tasks -> shrink file

I see currently allocated: 5,00MB and 2,50MB free space for the MDF Database
I see currently allocated: 1,00MB and 0,63MB free space for the LDF Logfile

Next I use a data generator to fill the database with random data.

After adding around 500k rows I check the size again:

I see currently allocated: 17,00MB and 0,44MB free space for the MDF Database
I see currently allocated: 61,94MB and 0,27MB free space for the LDF Logfile

Next I take a full backup incl. truncating log files. After that I check the size again:

I see currently allocated: 17,00MB and 0,44MB free space for the MDF Database
I see currently allocated: 61,94MB and 57,24MB free space for the LDF Logfile

So now my question is where are those 56,97MB? I imagined they should now be added to the MDF file but they seem to be just gone. I did this procedure 2x more time and the MDF stays the same size while the LDF is almost empty after backups. Then I thought maybe its in the memory of the server so I rebooted it. But still the MDF has the same size... Is this normal? How it should work?

View 2 Replies View Related

SQL Server Admin 2014 :: Modify Size For Datafile Clarification

Mar 25, 2014

From BOL, I see these remarks with respect to the MODIFY FILE subcommand (my underline added):

Initializing Files
By default, data and log files are initialized by filling the files with zeros when you perform one of the following operations:

Create a database

Add files to an existing database

Increase the size of an existing file

Restore a database or filegroup

Which leads me to believe that expanding the size of a datafile will also wipe out (my definition of 'initialize') any existing data within that file.

I may be misunderstanding 'initialize', because when I tested it out, I found this wasn't the case - my table data written to the file was still there after a resize.

Need to clarify to what degree I'd be taking a risk by increasing the file size on a datafile which already has data in it.

View 3 Replies View Related

Setup And Upgrade :: Clarification On Non-integer Constants Are Not Allowed In ORDER BY Clause In 90

May 15, 2015

We're upgrading our SQL Server database from 2005 to 2012.I ran the Upgrade Advisory report and got this issue "Non-integer constants are not allowed in the ORDER BY clause in 90" because of the script below

SELECT
gp.BRAND+' <> '+gp.CATEGORY AS 'full name',
gp.PRODCODE,
gp.CATEGORY
FROM dbo.GFK_PRODUCT gp
ORDER BY
'full name'

I tried running the same query in our test SQL Server 2012 and it ran successfully. Now I'm confuse if i still need to change it.I google the issue a bit and came across this link and mentioned this.

1.) Non-integer constants are ... constants that are not integer number.

Example: 'string1' represents
a string constant
0x01 represents
a varbinary constant
{ts
'2015-02-26 06:00:00'} represents a datetime constant

1.23 represents
a numeric constants

2) So single quotes are used to define a string constants / character string constants but SQL Server allows also to use single quotation marks use also as column identifier
delimiter:
SELECT ... expression AS 'Column1'
FROM ...

In this context is clear that 'Column1' is a column identifier but when used in ORDER BY : ORDER BY 'Column1' it generates confusion because SQL Server doesn't knows if it represents a string literal (character string constant) or it represents a column identifier / column name."Do I still need to change the existing code even though it's working fine in 2012? If yes, it is because of best practice reason or it will total get deprecated/not working in the future version?

View 4 Replies View Related

Gridview And DropDownList

Oct 18, 2006

Hello:I have add a DropDownList to my GridView and binded the dropdownlist to a field from a select statement in the SQLDataSource. I have EnabledEditing for my GridView. The GridView is populated with information from the select statement. Some of the information returned from the select statement is null. The field where the dropdownlist is binded it is null in some cases and does not have a value that is in the dropdownlist so I get and error when I attempt to do an update. 'DropDownList1' has a SelectedValue which is invalid because it does not exist in the list of items.Parameter name: value Is there a way to get around this besides initializing all the columns in the table that are going to be binded to a dropdownlist to a value in the dropdownlist?

View 1 Replies View Related

Sqldatasource And Dropdownlist

Nov 8, 2006

 
Hi,
I have sqldatasource that i set up in VS2005.  i have a dropdownlist using this source.  Data is added to the db from a different app and i want this dropdownlist to use the latest data on a page refresh. 
However i can not refresh the sqldatasource - the dropdownlist does not show the latest additions to the db - i  hae to rebuild to see them.  i tried turnning 'enable caching' and 'enable viewstate' to false but no luck.
How is this done.
 
Thanks.
 
 

View 1 Replies View Related

Can You Use Substring In ASP.NET On A DropDownList ?

Oct 26, 2007

I'm using the GridView to display some accounting infromation. I have a project where I have a 14 character control number. I would like to have a dropdown list to select the account classification of records to be displayed. The accounting classification is the first two characters of the control number.  So the dropdown list needs to show unique first two characters and the GridView will be filtered on these two characters.  I have been trying to use "substring" in the ASP.NET code; not even sure you can.
Any suggestions on how to accomplish this would be greatly appreciated.  See code below:
<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" DataSourceID="SqlDataSource2"
DataTextField="control_num" DataValueField="control_num">
</asp:DropDownList><asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:GPCRReportsConnectionString %>"
SelectCommand="SELECT DISTINCT [substring(control_num,1,2)] FROM [Request]"></asp:SqlDataSource>
ERROR: Invalid column name 'substring(control_num,1,2)'.

View 6 Replies View Related

Not Inserting Dropdownlist

Jan 30, 2008

Hi folks,
I'm in trouble getting an dropdownlist inserting its selected value into an .mdb
I'll insert my datasource code. There is another dropdownlist in this formview working good.
There is a datafield ID_Org_Einheit in the database to gather the value.
Could you please look this over?
Many thanks
Rosi
 
 
This is the dropdownlist
<asp:DropDownList ID="DDL_Org_alle" runat="server" DataSourceID="SDS_Org_alle" DataTextField="OE_gegliedert"
DataValueField="ID_org">
</asp:DropDownList>
and the datasource
<asp:SqlDataSource ID="SDS_insert_FB_log" runat="server" ConnectionString="<%$ ConnectionStrings:FahrtenbuchConnectionString %>"
 
InsertCommand="INSERT INTO tab_Fahrtenbuch_log([Datum_Eintragung], [Fahrer], [ID_Org_Einheit], [pol_Kennzeichen], [ID_Einsatzzweck], [Strecke_von], [Strecke_bis], [Zeit_von], [Zeit_bis], [km_von], [km_bis]) VALUES (@Datum_Eintragung,@Fahrer,@ID_Org_Einheit,@pol_Kennzeichen,@ID_Einsatzzweck,@Strecke_von,@Strecke_bis,@Zeit_von,@Zeit_bis,@km_von,@km_bis)" ProviderName="<%$ ConnectionStrings:FahrtenbuchConnectionString.ProviderName %>"
SelectCommand="SELECT Datum_Eintragung, Fahrer, ID_Einsatzzweck, Strecke_von, Strecke_bis, pol_Kennzeichen, ID_Org_Einheit, Zeit_von, Zeit_bis, Bemerkung, km_von, km_bis FROM tab_Fahrtenbuch_log">
<InsertParameters>
<asp:FormParameter FormField="Datum_EintragungTextBox" Name="Datum_Eintragung"/>
<asp:FormParameter FormField="FahrerEintragTextBox" Name="Fahrer"/>
<asp:FormParameter FormField="DDL_Org_alle" DefaultValue="1" Name="ID_Org_Einheit"/>
 
<asp:FormParameter FormField="polKennzTextBox" Name="pol_Kennzeichen"/>
<asp:FormParameter FormField="DDL_Einsatzzweck" DefaultValue="1" Name="ID_Einsatzzweck" Direction="Input" Size="3" /><asp:FormParameter FormField="StartTextBox" Name="Strecke_von"/> <asp:FormParameter FormField="ZielTextBox" Name="Strecke_bis"/>
 
<asp:FormParameter FormField="AbfahrtTextBox" Name="Zeit_von"/>
<asp:FormParameter FormField="AnkunftTextBox" Name="Zeit_bis"/><asp:FormParameter FormField="kmFahrtBeginnTextBox" Name="km_von"/> <asp:FormParameter FormField="kmFahrtEndeTextBox" Name="km_bis"/>
 
</InsertParameters></asp:SqlDataSource>
 

View 3 Replies View Related

My DropDownList Won't Declare?

Mar 3, 2008

 Need a little help! I am trying to insert ListItems values from a DropDownList into a database table. However in the code behind I am continuosly met with the error Name 'ddltest' is not declared. As you can see from the code below ddltest is an object with the ID ddltest. What am I doing wrong?
 Protected Sub ddltest_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs)Dim MyVar As String = ddltest.SelectedItem.Value
 
If MyVar = "" Then
ErrorMessage.Text = "Please select a test"
Else
'Insert selection into databaseDim oConnection As New SqlConnection
Dim oCommand As SqlCommand
Dim sConnString As String
Dim sSQL As String
sConnString = "Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|xxxxx.mdf;Integrated Security=True;User Instance=false"oConnection = New SqlConnection(sConnString)
sSQL = "INSERT INTO testDB(Myxxxx) Values (@Myxxxx)"
oConnection.Open()oCommand = New SqlCommand(sSQL, oConnection)oCommand.Parameters.Add(New SqlParameter("@Myxxxx", MyVar))
oCommand.ExecuteNonQuery()
oConnection.Close()
ErrorMessage.Text = "You selected " & MyVar & " and it has been added to the database."
End If
End Sub
 
<asp:TemplateField HeaderText="Test">
<EditItemTemplate>
 
<asp:DropDownList ID="ddltest" runat="server" AutoPostBack="True" OnSelectedIndexChanged="ddltest_SelectedIndexChanged" >
<asp:ListItem Selected="True" Value="" ><-- Please Select a test --></asp:ListItem><asp:ListItem Value="1">1</asp:ListItem>
<asp:ListItem Value="2">2</asp:ListItem>
<asp:ListItem Value="3">3</asp:ListItem>
<asp:ListItem Value="4">4</asp:ListItem>
<asp:ListItem Value="5" >5</asp:ListItem>
</asp:DropDownList>
 
</EditItemTemplate>
</asp:TemplateField>

View 7 Replies View Related

Fill Dropdownlist

May 7, 2008

hi,
how can i fill dropdownlist through code not through visit.and i need to know which is fastest and easy way for web application throught this below query.
cmd.Connection = conn
conn.Open()Dim ds As New DataSet
cmd.CommandText = "SELECT Emp_Name,Emp_ID FROM Employee "
da.Fill(ds, "data")
cmd.ExecuteNonQuery()
conn.Close()

View 4 Replies View Related

Dropdownlist -default Value!!

Feb 3, 2004

hi ,

need your help please

I have got a dropdownlist which is getting it's items and values from the table with in SQL server , everything works fine.

I just want to be able to select default item , so when the page is loaded the dropdown list default will be that selected item.

as an exmple if the drop downlist items and values are as follow

item ----> value
---------------------
city -----> 1
tokyo -----> 2
london ------>3

these info is imported from the database
and I want by default tokyo to be selected

many thanks

M


----------------------------------------
here is my code:

Dim sqlConnection As SqlConnection
Dim sqlDataAdapter As SqlDataAdapter
Dim sqlCommand As SqlCommand
Dim dataSet As DataSet
Dim dataTable As DataTable


sqlConnection = New SqlConnection("user id=sa;password=testfirm;database=ken_live;server=csfirm03")

'pass the stored proc name and SqlConnection
sqlCommand = New SqlCommand("Select * From _aci",sqlConnection)

'instantiate SqlAdapter and DataSet
sqlDataAdapter = New SqlDataAdapter(sqlCommand)
dataSet = New DataSet()

'populate the DataSet
sqlDataAdapter.Fill(dataSet, "AA")

'apply sort to the DefaultView to sort by CompanyName
dataSet.Tables(0).DefaultView.Sort = "bsheet"
city.DataSource = dataSet.Tables("AA").DefaultView

city.DataTextField ="bsheet" ' what to display
city.DataValueField ="bsheet" ' what to set as value

city.DataBind()

View 15 Replies View Related

Inserting DropDownList Value Into DB

Jan 16, 2006

Hi... im trying to insert whatever value a user selects from a drop down list box into a database.
So I have already stated that there are 5 different options (eg. 1,2,3,4,5) so I want it that when someone selects '2' and then clicks a button it inserts '2' into a db... I tried the following (DDL is the id of the drop down list box) :
Dim myCommand As SqlCommandDim objUsers As SqlTransactionDim strnumber As String = DDL.SelectedValueconnstring = System.Configuration.ConfigurationManager.AppSettings("ConnectionString")conUsers = New SqlConnection(connstring)conUsers.Open()objUsers = conUsers.BeginTransaction
"INSERT INTO tblsomething (number) VALUES (strnumber)"
myCommand = New SqlCommand(strSQL, conUsers)myCommand.Transaction = objUsersmyCommand.ExecuteNonQuery()objUsers.Commit()conUsers.Close()
 - Anyway suffice to say that this isnt working sssooooo...... help. Please

View 3 Replies View Related

Populating Dropdownlist

Mar 23, 2006

I've got the following code and it's not really what I want. With the below code I can select in a dropdownlist a value and in the other dropdownlist the correspondending value will be selected. But when I select a value the second dropdownlist won't be filled with all the data in the database. It is filled only with the correspondending value and not with the rest of the value. When someone changes his mind and want to select a value in the dropdownlist it can't be done. Any ideas??Default.aspx:<body>    <form id="form1" runat="server">    <div>        <asp:Label            ID="Label1"            runat="server"            Text="Botanische Naam: ">        </asp:Label>        <asp:DropDownList            ID="DDL1"            AutoPostBack="True"            runat="server"            OnSelectedIndexChanged="ChangeBotanicName"            DataSourceID="SqlDataSource1"            DataTextField="Botanische_Naam"            DataValueField="Botanische_Naam">        </asp:DropDownList>        <asp:SqlDataSource            ID="SqlDataSource1"            runat="server"            ConnectionString="<%$ ConnectionStrings:BonsaiDataBaseConnectionString %>"            SelectCommand="SELECT [Botanische Naam] AS Botanische_Naam FROM [BonsaiSoorten]">        </asp:SqlDataSource>        <asp:sqldatasource           id="SqlDataSource2"           runat="server"           connectionstring="<%$ ConnectionStrings:BonsaiDataBaseConnectionString%>"           selectcommand="SELECT [Nederlandse Naam] AS Nederlandse_Naam FROM [BonsaiSoorten]WHERE [Botanische Naam] = @Title1">          <selectparameters>              <asp:controlparameter              name="Title1"              controlid="DDL1"              propertyname="SelectedValue"              />          </selectparameters>        </asp:sqldatasource>         <asp:Label            ID="Label2"            runat="server">Nederlandse Naam:</asp:Label>                <asp:DropDownList            ID="DDL2"            AutoPostBack="True"            runat="server"            OnSelectedIndexChanged="ChangeDutchName"            DataSourceID="SqlDataSource3"            DataTextField="Nederlandse_Naam"            DataValueField="Nederlandse_Naam">        </asp:DropDownList>        <asp:SqlDataSource            ID="SqlDataSource3"            runat="server"            ConnectionString="<%$ ConnectionStrings:BonsaiDataBaseConnectionString %>"            SelectCommand="SELECT [Nederlandse Naam] AS Nederlandse_Naam FROM [BonsaiSoorten]">        </asp:SqlDataSource>        <asp:sqldatasource           id="SqlDataSource4"           runat="server"           connectionstring="<%$ ConnectionStrings:BonsaiDataBaseConnectionString%>"           selectcommand="SELECT [Botanische Naam] AS Botanische_Naam FROM [BonsaiSoorten]WHERE [Nederlandse Naam] = @Title2">          <selectparameters>              <asp:controlparameter              name="Title2"              controlid="DDL2"              propertyname="SelectedValue"              />          </selectparameters>        </asp:sqldatasource>     </div>    </form></body>Default.aspx.vb:Partial Class _Default    Inherits System.Web.UI.Page    Sub ChangeBotanicName(ByVal Sender As Object, ByVal e As System.EventArgs)        DDL2.DataSourceID = "SqlDataSource2"    End Sub    Sub ChangeDutchName(ByVal Sender As Object, ByVal e As System.EventArgs)        DDL1.DataSourceID = "SqlDataSource4"    End SubEnd Class
P.S. I posted this before but can't find it anymore so here it is again

View 3 Replies View Related

DropDownList Attribute ????

Dec 11, 2007

can someone please tell me if you can implement a drop down list within a table attribute.

If anyone could show me an example please do.


Kind Regards

Rob

View 11 Replies View Related

Handle Null Value For DropDownList?

Nov 11, 2006

Using asp.net 2.0 and visual studio 2005. The question is regarding the following ER diagram: I've made Firstname, lastname, buildingID and RoomNum all required fields. I've got a modified GridView that displays all of the table Faculty columns.  It's been modified so the BuildingID and DepID are resolved to their actual field names and displayed in a DropDownList.  In the dropdown list I used for inserting (a seperate DetailsView control), I manually inserted an item into the Department dropdownlist which had the text "-- Select a Department --" with a value of -1.  MS SQL didn't like that -1 value so I wrote the following code to fix it:  protected void dsFaculty_Inserting(object sender, SqlDataSourceCommandEventArgs e)
{
if (e.Command.Parameters["@DeptID"].Value.ToString() == "-1")
{
e.Command.Parameters["@DeptID"].Value = null;
}
} That means of course DeptID is null, which is ok.  The problem arises is when I try to edit that row in the GridView.  I get the an error 'ddlDepartment' has a SelectedValue which is invalid because it does not exist in the list of items.Parameter name: valueIdeally, I'd like to make the dropdown list in the GridView show "-- None --" for the DeptID if it comes across a null value.  I already tried playing around with the Command.Parameters in the dsFaculty_Selected function, but it didn't work.  Ideas? 

View 1 Replies View Related

How To Implement A DropDownList W/o A Table

Jun 9, 2007

I am using Visual Studio 2005 & SQL Server. How do i implement a DDL for users to select which value to input. like i can with Access. i do not need a table i think. if not the table would have only ID & Value.?

View 2 Replies View Related

Dropdownlist With Multiple Fields

Sep 24, 2007

How can I get two fields to appear side by side in the DropDownList?  Ex.  FName and LName
 
Thanks

View 1 Replies View Related

Get Info From Database With Dropdownlist

Dec 19, 2003

How do you get info from an SQL database to be displayed on a dropdownlist?

View 2 Replies View Related

DropDownList Inside CreateUserWizard

Mar 25, 2006

I am using the createuserwizard, and have set up my own profile table which hold first name, last etc. In my CreateUserWizard, the field for Vendor is a dropdownlist that is to be populated from a list in a database. I set up the form without the createuserwizard, and everything went skippy, but when I placed it into the wizard, I now cannot access the control of the dropdownlist.
I have tried doing..
Using SqlConnection As New SqlConnection(WebConfigurationManager.ConnectionStrings("Personal").ConnectionString)Dim VendorID As DropDownListVendorID = CType(CreateUserWizard1.FindControl("VendorName"), DropDownList)
Dim MyReader As SqlDataReaderDim sel As String = String.Format("SELECT VendorID, Name FROM Vendors")Dim MyCommand As SqlCommandMyCommand = New SqlCommandMyCommand.CommandText = selMyCommand.CommandType = CommandType.TextMyCommand.Connection = SqlConnectionMyCommand.Connection.Open()MyReader = MyCommand.ExecuteReader(CommandBehavior.CloseConnection)But when I go to databind, it says:Object reference not set to an instance of an object. VendorID.DataSource = MyReaderLine 30:             VendorID.DataValueField = "VendorID"Line 31:             VendorID.DataTextField = "Name"

View 3 Replies View Related

Dropdownlist Database Search

Mar 19, 2008

Hi all.

I have a huge problem that ive been sitting with for awhile.

I have a web page with 4 dropdownlist boxes on it

Gender:
Race:
Field:
Location:

Now a user can search a SQL db from selecting values from these 4 dropdownlist boxes which are equal to values in the db obviously.

when they have done that and pressed submit a Gridview is populated with the people corresponding details and the user is able to view each row seperately.

Now the problem i am having is that when i havent used all 4 selections for eg

Gender: null (no value selected)
Race: Black
Field: Accounting
Location: Los Angeles

then no information is returned from the db in the gridview.
im using a sqldatasource to populate the gridview and here is the query string that i am using :


Code:

sql
SELECT [title], [gender], [initials], [name], [surname], [birthdate], [postaladdress], [suburb], [city], [zipcode], [criminalrecord], [drivers], [maritalstatus], [dependants], [citizenship], [province], [contactref], [hometel], [cell], [jobtitle], [relocate], [emmigrate], [email], [worktel], [enddate], [startdate], [FIELD], [education], [company], [positionheld], [jobdescription], [contactperson], [contacttel], [startdate2], [contactperson3], [jobdescription3], [positionheld3], [company3], [enddate3], [startdate3], [contacttel3], [other] FROM [cvinformation] WHERE (([race] = CASE WHEN @race IS NOT NULL THEN @race ELSE [race] END) AND ([province] = CASE WHEN @province IS NOT NULL THEN @province ELSE [province] END) AND ([education] = CASE WHEN @education IS NOT NULL THEN @education ELSE [education] END))



what i want to do is whether the user doesnt choose any selection and leaves the choice null that ALL the information in the table of the db be shown and even if they only choose 2 values and leave the others null then it still brings back the information from the criteria chosen..

Is this possible.?

View 8 Replies View Related

How To Make A Dropdownlist Empty

Nov 18, 2006

I have a listbox that lists countries....and if you choose a country, another listbox show cities in that country (fetched from a sql database)....And if you then chose a city in the second listbox, a dropdownlist will show restaurants in the city....(also fetched from a sql-database)...

Ok...I hope you understand...now to the problem....:

If you first chose a country, a city and a restaurant but then want to chose another country in the first listbox, the dropdownlist for the restaurants is still there filled with restaurants for the first country...I dont know how to "remove" the restaurants so that the dropdownlist is blank if someone switch country....

I think I need to do something in countryListbox_SelectedIndexChange....but I dont know what to write there....

I know that I can make the dropdownlist invisible by entering the following code:

sub countryListbox_SelectedIndexChange

    dropdownlistRestaurants.visible = false

End sub

But I want it to be visible all the time!

Do you know what I could do? 

  

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved