DataSource Controls :: How To Write A Query Which Reads Data From Optional DDL's?
May 5, 2010
I have couple of DDL's which let user choose couple of different values from it. Once the user has made his selection he clicks on the "Submit" buttion which redirects the user to the other page, which then displays table from backend SQL DB. The pages are named Page1.aspx and Page2.aspx resp. I am using Querystring to carry forward the values of the DDL's to Page2.aspx.
How can i modify the query in such a way that even if one of the DDL's is left blank the Query would ignore that and shall produce the table considering value of DDL2 in the where clause. In case both the DDL's are empty then the query will not have a where clause and shall showcase the complete table as such. I've written a query for this but it's not working the way it shoul.Here is my code for the SQLDataSource: [Code]....
View 3 Replies
Similar Messages:
Jan 30, 2010
I have a data grid with a lot of information on it - to easily filter the data, I would like to be able to pass parameters to it. My problem is that I do not want the parameters to be required. So if I just put 1 or 2 of them in the query string, I would like for it to return all of the data related to those two parameters.I am using a data grid & stored procedures:My Stored Procedure looks like this:
[Code]...
View 1 Replies
Mar 3, 2010
I have a table with columns A and B, values as follows..
A B
-- --
1 11
1 12
1 13
2 21
2 22
2 23
View 7 Replies
Mar 22, 2010
I have the following code which writes to a Gridview:
[Code]....
Using the same methods of connecting to the database, how can I amend this code to write the result of a second query (which only returns a number) to a label?
View 11 Replies
Jan 26, 2010
Need to figure out the correct way to do a simple SUM function in Linq, but also manipulate one of the feilds coming back by doing a Substring on it, here is the original SQL query:
[Code]....
View 1 Replies
Jan 16, 2010
i have a table for customer forecast with following fields.. customer, year, week, quantity. now i need to write the SP to retrive the records based on the from week,year and to week,year... like this... from 45th week of 2009 to 25th week of 2010. how can write the query...
View 4 Replies
Jun 18, 2010
how do i write my alter schema query in Asp.net
using the sqlclient object..
View 3 Replies
Jun 2, 2010
How to write select query to get counts in row values
View 6 Replies
Jan 7, 2010
i have a table for customer forecast which contains customer, week number and quantit as columns. now i need to write query and list the week as column for each customer and each cell should have a quantity. how to write query for this using pivot logic. i dont want to use cursor.
View 3 Replies
May 2, 2010
I want to write the query for finding second highest salary in my employee table how to find it??
View 3 Replies
Feb 2, 2010
I'm trying to define a computed column that will contain an auto-incremented number. In other words, I want it to work exactly like identity, but since I can have only one identity column per table, I wanted to make a computed column that reads its latest value and increment it by 1.
View 5 Replies
Oct 1, 2010
Suppose we want to select the data from the database then we write the query for that. Example:
SqlConnection con=new SqlConnection(Connetion name) string selectPkId = @"SELECT PK_ID FROM TABLE" SqlCommand cmd=new SqlCommand(selectPkId ,con);
So,my question is that why we basically use @ before the sql query.If I don't use @ before that then it again work fine (does not give any error), then what is need of using "@"?
View 1 Replies
Jan 28, 2011
I am using NLog for logging in an ASP.Net application and making use of the database target with Microsoft Sql Server.I have some logging parameters that are optional and not always specified. I would like these to be written as null when they are not provided, however NLog seems to always write them as empty strings.
Is there a way to configure it to write null as the default?
Ref: http://nlog-project.org/wiki/Database_target
View 2 Replies
Oct 29, 2010
I receive lists from a web service and then I convert the lists to datatable and then I add the datatables to a dataset and from there I get the xml from the dataset where I can save it into a sql database. But the problem is that the xml has /r/n between all attributes and elements. I dont know how to get this out of the xml. Can this be because of my converter. If so can anyone give me a better way to get multiple lists into a dataset.
View 2 Replies
Apr 22, 2010
I am getting return some data through stored procedure in a asp.net 3.5. Below is the method.
public DataSet GetDataSet(string strConnection,string strSPName, string param1)
{
DataSet ds = dataAccessLayer.getDataSet(strConnection, strSPName);
return ds;
}
In some cases, I have to pass 3-4 parameter. How can we do pass optional parameter here....
View 3 Replies
Oct 6, 2010
I have a form that searches for images in a database. I have several DropDownLists with various search criteria e.g. Genus, Photographer, State, Project.I'd like the user to be able to filter using any combination of these. For example they might pick a specific photographer and a specific genus but choose not filter by project or state.I'd like to find a good, clean, elegent way to do this.Here is an example of the code I have now, it has only two possible criteria. It works but I have a feeling there are better ways to do this....
[Code]....
View 3 Replies
Nov 3, 2010
I'm pretty new to C# and ASP.NET, so bear with me on this one. I'm setting up a page that receives query strings from the url. It then passes these strings to another method (in another class, actually), which goes on to do lots of things depending on the value of the query string.
The general structure looks something like this, where DoSomething() is actually part of another class that will be used by lots of different pages:
pretected void Page_Load (object sender, EventArgs e)
{
DoSomething (Request.QueryString["name"]);
}
public void DoSomething (string UrlVariable)
{
// if UrlVariable isn't set, initialize it to some value
// do stuff with UrlVariable
}
Here's what I'm wondering:
If the query string "name" isn't defined in the url, what does Request.QueryString return? an empty string? null? If it returns null, what happens if I try to pass null to a method that is expecting a string? Does the whole program fall apart, or can I check for null inside the DoSomething() method (after receiving the null string)?
The "name" is optional, so if the user doesn't set it, I'd like to detect that and initialize it to some default value. If possible, though, I'd like to put any validation inside DoSomething(), instead of doing the check on every page that requests the string.
View 2 Replies
Apr 9, 2010
I have a GridView bound to an DataSource query with parameters tied to form controls.What is the standard / best-practices way to handle optional query parameters?
View 3 Replies
Dec 15, 2010
I'm creating a webpage with serveral web controls to set search parameters for querying an SQL table. My plan is to use a TableAdapter to hold the query. If the user decides not to use one, several, or any of the web controls to filter their search, I want the SELECT to execute without complaining that it doesn't have parameter values. Should my SQL query look like
[Code]....
View 2 Replies
May 6, 2010
I have to write data to multiple (two) tables.
tbl1 has a column "ORDERID" with auto increment. I have to get this "ORDERID" whenever I write to tbl1 (Insert new record)
tbl2 has a coumn "ORDERID" as foreign key, I have to write "ORDERID" in tbl2 received from the tbl1.
How to do it using SQL ( I am not using StoredProcedure)
View 5 Replies
Aug 16, 2010
how to write sql query to retrive data as follows....
've a table with two columns..
brno brname
100 hyd,hyderabad
102 cni,chennai
03 mm,mumbai
104 kalk,kolkata
View 4 Replies
Jun 30, 2010
I am about to write a method that uses SQLParameter to insert some data into SQL server. However, do I "have" to specify a DBType? If not how is this handled?
Here is an example of the code I intend to write:
[Code]....
View 6 Replies
Mar 17, 2010
I would like to write an MVC application that accesses multiple data stores (SQL Server, MySQL, Cloud based, etc.).Most of the examples I see use LINQ to SQL for their data access but I read somewhere that LINQ only supports SQL Server - it may have been an old post.I was wondering what the best way to access these different data stores would be. Can I use the Data Access Application Block from MVC to access these data stores?
View 4 Replies
Aug 22, 2010
1. I have a GridView on my page and it uses sqldatasource with parameterized query. What I want to do is, on page load (where nothing has been selected so no parameter supplied), I want it to query everything (something like SELECT * FROM [this_table]) but since my SelectCommand is something like
SELECT * FROM [this_table] WHERE [this_column] = @someParameters AND [that_column] = @someParameters.
Can I play around with default value to achieve something like that but how ? Now, when the page loads, it doesn't show anything (No Gridview).
2. On my page, I made something like (username, gender, address, and more) and one single search button. That means, no single control enable auto postback. What I am trying to accomplish is building dynamic query
(if username specifed -> SELECT * FROM [this_table] WHERE [username] LIKE @username).
If both username and gender are specified (SELECT * FROM [this_table] WHERE [username] LIKE @username AND [gender] = @gender) and you know the rest. How can I do this using GridView and SqlDataSource ? To my knowledge, I can only specify one SELECT statement in a sqldatasource.
View 11 Replies
Jan 15, 2010
[code]...
This query works perfectly on the query analyser.
But when configuring the Table adapter ,I try executing the query and i get 0 rows affected.
What could I be getting wrong in this case.
NB:Existing GalleryID has been supplied.
View 1 Replies
