DataSource Controls :: Summing Multiple Columns With SQL?
Mar 9, 2010
is there a SQL statment i could write that would sum each column and allow me to then access each sum individually
i.e
Dim objCmd As New OleDb.OleDbCommand("SELECT SUM(expression) FROM orderForm WHERE OrderDate=@OrderDate", objConn)
is there anything i can replace expression with such that all the columns in orderForm could be summed and returned as one record
or is there a way to replace expression with something that would allow me to just keep changing the paramater so i could continuously reexectute the same command w/o having to create a new command for each column
I currently have a datasource that displays several rows on an editable gridview where the user can update several rows at once. Each row contains an ActivityTotal column per row. I'd like to sum all the ActivityTotal rows displayed and have one totalValue.
I have two tables - dt(Mods) and dt(Mods2) - I am trying to create a relationship between them. So dt(mods) has department, category and item columns dt(mods2) has parentDept, Parentcategory and parentItems Now I need add them to a dataset with a relationship key - Something like this but with three cloumns
Dim ParentCol As New DataColumn, ChildCol As New DataColumn
how I add multi-column constraint to a table in SQL2005 ?
I want to prevent a user from entering a row in the table where Column_A = 1, Column_B = 2 etc where there is already a row where Column_A = 1, Column_B = 2.
Is it possible in to set up an SQL table column to have multiple values? Or would I have to put my values into a new table and link it to the original one?
This question is for wrapping up work on a database driven AJAX AutoComplete Control that I am using to provide keyword hints to user on search pages. Each record has 6 columns for keywords where each column is for an advertiser to add a keyword. These are used in meta keywords tags, but I also want to use them for AutoComplete. The problem is that I don't know how to write a SELECT statement in Visual Studio that treats all 6 keyword columns as if they were all one column. I am looking for something like
SELECT (keyword1 + keyword2 + keyword3) AS Keywords FROM (Merchandise) WHERE Keywords LIKE @term
The only other thing I can think of the gain this level of functionality would be to combine them into a new table.
I've requirement where user can enter multiple columns like first name, lastname, email, age, sex fields and insert them into database.on my frontend aspx page, i'll be showing a single row initially with 5 text boxes(first name, lastname, email, age, sex) and a button to add more columns. when user clicks on add more, another 5 textboxes will be shown and then i'll be taking 5 + 5 (textbox values) and comma seperate them and need to insert into a table with primary auto increment key ID and the remaining 5 columns(firstname, lastname, email, age, sex). I previously worked on the same requirmeent but with only single column. Now i need to insert for 5 columns, How can i do this? Below is my stored proc which i used for single column insertion.
I want search with multiple names in Name coloumn. example I have pass the criteria to Name cloumn is 'Atul', 'Mayur', 'Suraj' this three names how to pass in a query.
I have a question in gridview, I want to combine my two or more records into a single cell with two rowsfor Example i have a ID, Name, Year Start, and Year End for Column name in database and i want call it into my gridview that the Year Start and Year End will combine to Year like:
In my table of entries, there are other entries commenting on the orig entry. The comment entries are marked in the table by having a commentID field that matches the ID field of the post being commented on. Follow?
How would I sum the nbr of comments for each orig entry?
I want it displayed in upper superscript fashion like the "2" in E=MC "2"
I have a datasource, which includes many columns, idealy, I need use a gridview to show:
1) first 3 columns: template fields, these fields depends on values in some columns of datasource. I use template fields, hard coded. works fine.
2) the other columns. This is I do not know how to do it. In the data source, there are about 10-20 columns data, each time, the # of columns of the data varies. idealy, I need show each of them as a seperated column in gridview. The entire data source may have 30 columns, but some of them are used in 1), and I only want show these 10-20 columns in gridview. Some columns in data source, I may not use them at all. is there a way to do this? or have to seperate them as a detail view style UI?
I have a scenario in which I want to display Multiple Columns in ListBox. I am working in .NET 1.1I am binding data to ListBox from DataTable. Example: I have Two Columns in Table ID, Name. So I want to display ID and Name in a Single LISTBOX.
The user enter the name,address,country,qualifiction,experience the user enter more than one qualification, and experience the add another button click will add another qualification, and experience...i am confused in designing the database how to design the database for this . i am design this tables .
I am trying to design my logic to do this but I want to create a dataSet which will have records from several databases, The records all have the same layout.
I am reagin the connection string paths from a table in a database.
I am asking for your help in trying figure out my logic.
Should I use the connectionString builder in conjunction with a loop to Connect, read a record into a dataset Until therer are no more records to be read from my databse table with the database name/paths tables ?
Here is my beginning code which deals with one database:
