How can I do this? I want to display result even if one value is just present. I've tried messing with the logical operators but still can't get it. Here is my SelectCommand.
[Code]....
I have a simple page that will display data from a particular category, using a querystring to filter my data in my sql select statement.
However, I would like to show all my data if there is no querystring present. Is there a simple way to do this?
This is not straight forward to explain but basically i want to only get the current weeks data in a table, i.e. if its say thurs or fri and i run the report i just want to filter from the previous Monday every time.
I dont want to use a parameter because there is another table that i want to see ALL data from way back.
So, if i ran the report today (28th april), the table would show Monday (26th), Tuesday (27th) and today Wed (28th).
[Code]....
than i want present data like this
[Code]....
[Code]....
but data doesn't appear on webPage ?? what's wrong with this code ??
I want to delete the rows present in the DataTable by using LINQ (with out looping)
The deleted rows will be come from a LINQ as below
IEnumerable<DataRow> MobileQuery = (from d in dtBillDetail.AsEnumerable()
where (String.Compare(d.Field<string>("Destination"), "MOBILE", StringComparison.InvariantCultureIgnoreCase) == 0) select d );
The DataRows present in the "MobileQuery" should be deleted in the DataTable "dtBillDetail"
This query does not return any record
[code]....
How to calculate a sum which get the data from a set of textboxes in asp.net page? Can write in code behind c#? Can assign the textbox value to a variable then calculate the sum at code behind them show the answer to the asp.net page? Or is it have to write javascript to perform those action?
View 1 RepliesHow can i but alternate Image if No image retrieve in image Control ?
View 1 Replies(ie.)C-Chennai
B-Bombay
-Hydrabad
A-Andhra
K-Karnataka
It may comes any order but (cbhak) is constant. i need to bring this in query, i dont want to use any funtionHow can i acheive this result
Tag TableName FieldNameabc wc s_namelbl wc s_deslb2 wc s_prodin above fieldname(s_name,s_des,s_prod) column represent field in wc table.How can i bring this result. is this possible without using cursor. i was struggling past two days. i cant able to bring result for above.
View 17 RepliesHow can I get the result with decimal place? The following will return 33.00, but how can I get the result of 33.33?
[Code]....
Table: ITMLED
Recsno itmcod opeqty inwqty isuqty
6200 001 500 NULL NULL
442 001 NULL NULL 100
22 001 NULL 700 NULL
23 001 NULL 500 NULL
443 001 NULL NULL 400
How do I get itmcod wise result in 1 row like
ITMCOD, OPNQTY, INWQTY, ISUQTY, ((OPNQTY+ INWQT) - ISUQTY) AS CLOSINGQTY
001 500 1200 500 1200
From above data in ITMLED.
I have atable for video files contains the following fieldsIDTitleDescriptionImageViewsUserCategoryI have a text box in the currency ofthe burden of private research is showing results in another page I called it asearch resultFirst of all, has a store of the research processso
[Code]....
'd Like to getthe results in the Grid viewAnd the results are imageany onecan tell me how to make my photo show and control of size in order to become like YouTube
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?
I have one sproc with Dynamic Temp Table. Sproc returns dynamic temp table rows and when I drag and drop the sporc on to Linq to Sql Designer I am not getting Return Type as "(Auto-generated Type).
how can I get Return Type as Auto-generated Type.
I'm creating a user control that enables users to search AD and add the selected names to a list (which is used to send mail lateron).
The problem is that the search results end up in the Listbox but all as the string "System.DirectoryServices.ResultPropertyValueCollection" in stead of the actual values.
I have no idea why.
This is my code:
[Code]....
[Code]....
I have a table that contains a date column along with others. I need to extract two sets of data from this table for two different time periods. Call them Current and Previous, so that I can compare them line for line. There are exactly the same number of days in both time periods.
The problem is that I need to return the data like this:
CurrentDate, Count(CurrentItems), Sum(Amt), Count(PreviousItems), Sum(PrevAmt)
JOIN puts the data into the result vertically, so that doesn't work. So far, I have not found a method that will arrange the data correctly.
how to wrote stored procedure for check two queries result this result is same return true value its not same return false value
View 2 RepliesI want make a search by which want find data and display in gridview.
View 1 RepliesI'm programming a webpage in ASP.NET which displays a list of students not listed as participants in something, and upon clicking a student name shows you a brief summary of their details, so the user can ensure they're selecting the right person. Each student is identified by a unique ID.
My code currently correctly obtains their ID, adds it as a parameter to my stored procedure and executes the procedure;
[Code]....
However, when I try to access the results, with say dv.Table.Rows[0], I get the following error:
[Code]....
Upon debugging, there don't seem to be any results returned... when running just the stored procedure in SQL Server with the same data, it does return a single row, as expected.
I am bulding a dvd catalog and have a table called DVD which holds all my details about each dvd except Genre, Director and Actor as I want more than 1 Genre, Director, Actor per DVD so put these in seperate tables to avoid repeating the data and used a joining tabe to join the tables so the tables I have are
DVD, Genre, Director, Actor, DVDGenre, DVDDirector and DVDActor
I have now written a stored procedure to pull the info about 1 DVD out of all the tables to display on the webpage I have now got the info I want out of the tables but as the data is now in 1 table I have repeating data is there a way to stop the data repeating the stored procedure i have written is
[code]....
Just after some advice I have a stored procedure that returns several tables. I then need to loop through the tables and create dynamic gridviews using the data. At the moment this stored proc is called using
[Code]....
I have used an xsd file to populate everthing else, but due to this returning multiple tables i wasn't sure how this works should it just be in its own xsd? as all the oather i just get a datatable where as with this i need a dataset... how this makes sense...
Im using SQL Server 2005 and im using stored procedures. Is this possible? i need to get a number of results and do it in one SELECT statement or just one result set. Im using MS Chart Controls for reporting and they cant seem to process multiple result sets this is my problem, so basically to run a barchart i need to assign a column to the X axis and a column to the Y axis and it will then display my results.
My stored procedure below returns a result set with columns subpolicy_name, building_name, floor_name, room_name and total_savings. Im just wondering is it possible to split my total_savings column into 4 columns, for example subpolicy_savings, building_savings, floor_savings and room_savings, i need everything in a separate column. If you run this stored procedure you will see the result set.
[Code]....
i have a form that my i use to look up whether or not there is an email address in the database. i wrote a query with this basic structure:
select *
from table A, table B
where table A.email = "email" or table b = "email"
i though that would return all instances that the email occurred in either table. what i am getting back is a bunch of null or other unrelated records from table A with a matching email in table B. the thing is, these two tables primary key to join them. i thought i wouldnt need to do that though in this case.
here is the actually query i am using if it makes things more clear:
select lm.cemailaddr, lm.b1emailadd, b.emailaddr
I'm trying to populate a treeview control using linq.
I use the following code
[Code]....
how can I declare c in fillChildren