How do I insert the selections made on several checkboxes into the WHERE clause of a SQL SELECT statement? The scenario is as follows: the user selects one or more checks in different check boxes to determine the rows to be parsed in a SQL table. Then the user clicks on a Submit button and the result fills a Repeater table. How do I do this, and how do I configure the button to launch the SelectCommand?
View 2 RepliesI'm having trouble linking a form view I have on a web page with a drop down list on the same page. Basically, what I need to happen is whenever a new selection is chosen from the drop down list, the details in the form view should also change to represent that selection's criteria.
I have my drop down list connected to SQLDataSource1 and my form view to SQLDataSource2, and these are populating as expected, it's just the problem lies when changing the selection in the drop down list - the form view doesn't follow what is selected.
does anything have to be added in the properties options of either the data source controls or the form view? For example, in the "Events" section, there is a "DataBinding" and "DataBound" selection item that can be used - should anything be entered in this to connect the two?
PS - Here is the code I have in the back end of the page:
[Code]....
i have a job application process where users apply for a job, in the admin section administrators want to be able to see which applications have not been viewed. Now i have one page which lists all the job vacancies and then users can click into that specific vacancy to see which people have submitted an application. This all works fine.
However on the page i display the job vacancies i need to make it so that if there are any applications within a vacancy that need viewing it appears in RED.
The two tables i am using are below:
tbl_vacancies
job_id
job_name
location
voucher
details
availability
region
date_added
tbl_applications
application_id
job_id
fname
sname
other_info
.
.
.
.
date_addedd
viewed
Now the viewed column is in tbl_applications table, the applications relate to a specific vacancy via the job_id.
So what i need to check is IF there are ANY applications where the viewed = 0, if so that means that there are applications that need to be seen, and i want this to appear in RED.
Now i tried this several ways i.e an INNER JOIN etc.. but the full list of vacancies won't appearing.
So i tried this:
[Code]....
[Code]....
This doesnt work at all. I have a datareader which runs through the returns, i don't get any errors, and the applications display correctly but when i use the IF to check it doesnt work..
I have a horizontal menu control populated (in static mode: StaticDisplayLevels="1" MaximumDynamicDisplayLevels="0") from a site map.
I have another vertical menu control in the left toc of the page that I want to populate from the same sitemap but to be the children of the node selected in the first menu.
I'm attempting to hook up multiple DropDownLists to a single SQLDataSource, but I want the SQLDataSource to return different rows depending on which DropDownList it is populating.
Say I have a table full of names (we'll call it TABLE_NAMES):
[code]....
....and I have two dropdown lists, one with a list of person names and one with a list of dog names.
Is there a way to link up each of these dropdown lists to a single SQLDataSource and use the SelectParameter to differentiate between which records I want returned for each dropdown list?
To make matters worse, these dropdown lists will appear within a GridView control....so there will be multiple instances of each dropdown list depending on how many rows there are in the GridView.
My website is working but when I host it up, the connection are all screw up. Is it because my connectionString are all linked via SqlDatasource and is for local files only? Whats the coding that I need to put in so that my site will connect to the database via accessing the web.config or server?
View 11 Repliesam trying to use a stored procedure for the Delete Command, I don't see how to set the parameter values to link to the grid values.When using text command, I would just use "WHERE Row_ID = @Row_ID" (Row_ID being the first column of the grid, and the primary key of the table.)How do I do this using a strored procedure?
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:myConnectionString %>" SelectCommand="usp_MA_Lookup_Callbacks" SelectCommandType="StoredProcedure"
[code]...
I've editing a create user wizard to add a 2nd step, this step will collect the users address. i can't get the second step to save into a table. I'm completely new to visual web developer, so if you reply please make it as jargon free as possible, see source code and vb code, i think i'm missing code for the "finish Button click"
Source code is. [Code]....
Code Behind the wizard control
Partial Class Registration
Inherits BasePage [Code]....
I have a treeview on an ASP site that I populate from a DB using a Stored Proc that delivers XML. I am using an XML datasource that is loaded from the SP programmatically in the dadtasource's onload handler (if there is a way to load it from an SP declaratively, let me know). The treeview has its 'ShowCheckboxes' property set to "Leaf" (see code below) so that any leaf node can be checked.
The problem is this - I have a 'Checked' attribute in the leaf nodes of the XML (see below) that I would like to have databound to the treeview (I have databound the Name and ID attributes successfully) and I can't seem to find a way to do this. I also tried programmatically, but the treenode's dataitem property seems to have the value 'Nothing' even after the tree is databound.
How do I bind the 'Checked' attribute to the treeview's checkboxes? (Prefereably declaratively)
Example of XML here:
[Code]....
Note that nodes have Name and ID attributes, and Leaf nodes have Chacked attribute.
Here is the declaration of my treeview:
[Code]....
Here is the declaration of my XML datasource
[Code]....
And here is the onload event handler:
[Code]....
OBJECT_ID(N'AdventureWorks.Person.Address');
what does the "N" mean or do in this statement?
how to do do some action recurting each row? My data looks like
[Column1] [Column2]
item 1 10
item 2 5
I would like to do something like..
foreach row in Column1 <-- how would I do this part??
While (row.Column2 > 0)
BEGIN
.. do something
row.Column2 = row.Column2-1
END
If I run the following SQL script:
[Code]....
I am writing a simple form that will take in data and insert it into a db if it's a new record and update the existing record if it already exists. The insert works fine, but the update isn't working at all, yet the code looks solid to me and everything I've compared it to in my google searches.
[Code]....
I want the select statement for the above scenario.
View 2 RepliesI've done some SSIS package work in the past, but am by no means an expert.
I want to use an SSIS package to do the following:
1. Get the file name of the newest file in a windows folder (using a filename template like his: filename_ *.txt where the * part is always a date in the format of yyyy-mm-dd.
2. Use that file name in later portions of the SSIS package by reading the file and transferring data from it to a SQL table using a Data Flow task.
and use the result (which should be the name of the newest file) to open that file and pull data out of it and into a 2nd SQL table. I admit, I'm not sure how to use the dynamic result of this SELECT query as the file name in a flat file connection manager.
I am rather confused as how or where to declare this variable in asp.net.
[Code]....
Whenever i put this in my sqldatasource for it is asking me to Define Parameters:
The wizard has detected one or more parameters in your SELECT statement. For each parameter in the Select Statement, choose a source for the parameter's value.
I have SQL Details View insert statement, I need to have a Condition checked for the Insert Query. The condition is, I do have a table by name table1 with the No of Questions (for Eg: 10). The insert statement shud insert data to the table2 (Another table) only if the no of rows is less than or equal to 10 else it shud give me a message (It has exceeded the no of questions).
View 3 RepliesI am trying to do an insert statement to a table from classic ASP.I tried the below:
[Code]....
But, I am getting the error as: Incorrect syntax near the keyword 'where'.How to insert data, using a where clause in the above scenario?
How would you handle an INSERT that gets some values from another table using SELECT, where you wanted some values to come from the source table record and other values to come from a different parameter source like a session value? Is this possible?
View 3 Repliesi'm developing windows application one of its forms supposed to fill a table called rooms with data throughout a collection of text boxes and comboboxes controls, i'm successfuly bound each control to the binding source and make sure that each data adapter contains the required data but when i start to excute the insert statement
insert into rooms([room_id],[floor],[price],[currency_id],[rec_id],[s/d],[s/ns],[room_direction],status)
values( '"+Int64.Parse(textBox1.Text) +
"' ,'" +
Int64.Parse(textBox2.Text) +
"', '" +
Int64.Parse(textBox3.Text) +
"','" + comboBox1.SelectedIndex +
"','" + comboBox2.SelectedIndex +
"','" + comboBox3.SelectedIndex +
"','" + comboBox4.SelectedIndex +
"','" + textBox4.Text +
"','" + comboBox5.SelectedIndex +
"')
it displays an error message when i'm trying to select a value from the combobox for any parameter that is"column currenc_id is constrained to be unique value 2 is already exists"can any body help me it is very important
I don't know if I'm posting this in the right place - I have a feeling it can't be too difficult but I can't seem to figure it out. I've come across this problem many times and I've never solved it. I would imagine the scenario is commonplace - I have a table of Products with a PK of ProductID, and a table of related images with a FK of ProductID. Each product can have many images, but for my initial display I want to display one product record with one image record. I have a Sequence field in the Images table and I could pick the lowest one. Right and left Joins return too many records - if I have three images for Product 1 then Product 1 is listed three times.
I've gotten around this before using a flag in the Products table, or listing an image in both tables but I'm sure there must be a SQL statement that can get the information that I need.
I am currently trying to create a SQL statement that does a multiple count on a table. The table has a number of reports each listing the "User" who created that report and if that report is "Famous" (A famous report is symbolised as 2 in the table).
What I need to create is a SQL statement that returns each User with the total number of reports he/she has created and how many of these reports are famous. My current SQL statement looks like:
[Code]....
I need to execute the stored proc accross the parameters resulted from select statement
I have created one stored procedure which require one parameters ( username ) ..
i need to execute this SP accross the Select Statement which lists all the username
somethibng like :
Set @username = (Select usename from my table)
EXEC dbo.Duplicate_Data @username
[Code]....
I must have a LINQ Statement does i can show if my Time in the DB <= as the Time where i become from my Session +60 Minutes ??
I have a method to execute two "Update" sql statements.
The first one works fine and the second one I can't get to work for nothing.
Here is the entire method:
[Code]....
The error I am getting is "Incorrect syntax near '05'."
It is occuring on the next to the last line which is:
dc.ExecuteCommand(sql);
I update the variable "sql" first so I can debug. At the time it crashes the value of sql is:
"Update Blogs set Status = 'Archived', ArchiveDate = 06/22/2010 05:14:46 PM Where (BlogID != 1) and (Status = 'Published') and (AuthorID = 9e37e028-c205-4903-920e-e8643b30a724)"
It appears to be the ArchiveDate that is causing the problem here. The "05" is the hour of the time portion. Both ArcgiveDate and PublishDate are defined exactly the same in the database. If you look at the first dc.ExecuteCommand it does exactly the same
thing with PublishDate (DateTime column) in the same table and it works just fine.
Then I modifed the code and remove the ArchiveDate from the sql statement then I get the error:
"Incorrect syntax near 'e028'."
which as you can see is part of the AuthorIDs value in the where clause. So I am assuming both the date and the Guid / Author ID is causing problems. I have tried enclosing the values in quotes but I just cant make this work even though it seems to be working fine in other places.
I even remove the code for the author ID and left in the code for the ArchiveDate and it still does not work so I have proved that both are causing a problem.