I need to display the table name in the select statement. how?
exact question:
we have common columns in two tables. we are displaying the records by using
select column_name from table_name_1 union select column_name from table_name_2
But the requirement is, we need to display the source table_name along with the data. consider a,c are present in table_1 and b,d are present in table_2. we need the output in the following way
eg: column_name table_name a table_1 b table_2 c table_1 d table_2
the select statement for my gridview contains a sub select statement..that should allow users to see how many queries are associated with a particular record..how can I get the queries column to display in my grid. As it is a count and not directly bound to any field
SELECT WardID, ScriptID, DateAdded, (SELECT COUNT(scriptID) FROM query WHERE scriptID = main.scriptID) AS queries.......
I am quite new to LINQ, and I am stuck with this probably basic problem, but haven't been able to find a solution, so I thought I could ask here.
So, I have this repository where I put my functions for data accessing, and now I need to write a function to get all the applicants that have applied for this particular advertisement, and their values too. Now, the values are stored in a separate M:N table, where every row consists of the applicantID,advertisementID and value. I just wanna append the value to every applicant that I show, so that it would look like a Ranking List.
However, I do not seem to know how to select just the name column from the Applicant table, and just the Value column from the ApplicantValue table.
And there's this Iqueryable interface that further confuses me...
Here's my function to get the Applicants only:
[Code]....
Now, if I try to add to the definition of the type two columns, it says that it only messes with types, i.e. one type should be passed. So I figured I would do a ViewModel and then pass it, like this
[Code]....
and then in the function I have no idea how to pass the values:
I have two sections of users data on my site, customers and employees, each one has a UserID that is FK to the UserID from aspnet_Users table.
I have a table that stores User messages
Looks Like This:
[URL]
It Has a FromUserID and ToUserID
Because Employees are Identified through EmployeeID and Customers are identified through CustomerID, I needed to use UserID's so Employees can leave messages for employees and Customers and Customers can leave messages to employees and other Customers 1-2 and 2-1
My Quandry is this, How Do I retrieve the information if the UserID might be a Customer or Might be an Employee, when the UserID could be from one of two tables
ie
How Would I Write?
SELECT wms.FromUserID, ed.FirstName, ed.LastName FROM ed INNER JOIN wms ON wms.FromUserID = ed.UserID OR SELECT wms.FromUserID, cd.FirstName, cd.LastName FROM cd INNER JOIN wms ON wms.FromUserID = cd.UserID
I need to execute a stored procedure and show the value it returns as a usertype column in a selection list. Eventually this select statment will be converted into a stored procedure, so basically the stored procedure will be called in another stored procedure. I can't quite get the syntax correct. I am showing a simplified version of a very long query so it's easy to understand. It gives me the 'Incorrect syntax near the keyword 'CREATE' error. The capitalized the code produces the error:
anyone know that can we used select statement to called queries table in database or not?usually people used select statement to called common table in database.
I have a table with lots of fields. To display every record that has lots of columns on a web browser will inconveniently force the users to drag the scrollbar to the right.
Is it possible to divide each record to two or three inner rows in gridview?
e.g. My table has these fields: - UPC - Description - AdType_Week1 - AdType_Week2 - AdType_Week3 - AdType_Week4 - AdType_Week5 - Price_Week1 - Price_Week2 - Price_Week3 - Price_Week4 - Price_Week5 - OrderStatus_Week1 - OrderStatus_Week2 - OrderStatus_Week3 - OrderStatus_Week4 - OrderStatus_Week5
Instead of showing everything in one header like this:
|-UPC-|-Description-|-AdType_Week1------|-AdType_Week2------|-AdType_Week3------| 01 banana type abc type def type feg |-Price_Week1-------|-Price_Week2-------|-Price_Week3-------| $97.51 $78.48 $41.45
sql_select = "SELECT auid FROM tbl_auAccount WHERE username='" & IUN & "'" 'Add Error Trapping Later con = Server.CreateObject("ADODB.Connection") con.Open(data_source) 'Execute the SQL Command con.Execute(sql_select) 'Close the connection con.Close() con = Nothing
Now this works and I was able to put the value into a dropdown list box, but I need the value returned placed into a label such as:
lblShowNewUserID.Text = ? (? being the value returned from the Query). I thought this would be simple, but it is not (at least for a newbie like me). NOTE: (I will have instructions before this to be sure that only one value will be returned and taht the value will not be null).
While executing select statement for a table then iam getting arithmetic overflow error.I found that retrieviing the data for a particular column showed that error ,sum() for that column is showing error.Is there any way i can rectify this problem.
I am trying to create a multi column listbox by combining fields in Linq select statement, as Let Name = Last + First. The problem is how to pad the Last column with spaces as you would in SQL using REPLICATE so when I bind the listbox to the data, it looks like two columns.
I have walked through other posts with a similar problem but I am very stuck.I am normally use Php/MySQL and am new to ASP (actually only this new client uses it and I'm trying to help them). I am trying to filter a table to only show the last 90 days of records. I found what I thought was the easy solution shown below:
FilterExpression="columnname < GETDATE() - 90" Or, if you can modify your SQL SELECT statement SELECT col1, col2, col3 FROM tablename WHERE col3 < GETDATE() -90
However when I added it I get this error:Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately. Parser Error Message: Type 'System.Web.UI.WebControls.BoundField' does not have a public property named 'FilterExpression'.I think I have added the code to the wrong place or have another file to edit but I have no clue honestly. The best I can do is show you the file I have the code to in hopes someone may know what this is. Here is the code from the file I added the solution to (my edit is bold/italics/underlined towards the bottom): And shouldn't I have some select statements somewhere like I normally do with MySQL?
How can i select all columns of table but to distinct by one column? i am tryin to figure it out without success, i know how to make distinct (select distinct column from table, but i need all the values from the table and to distinct by Delcompany.
I want to select the list of messagetext from the messages table where the message text contains any of the Carriage Return Characters?? (Eg: /r/n) what are the other Carriage Returns characters and how can i filter those from the message text?
I want to display gridview column heading when mouse over to the particular column in the gridview.I am working in VisualStudio 2005 with MS.Net2.0 framework.I don't want to use ajax.
I want to SELECT a user from a table using the WHERE clause. I know how to write the query, but how do I execute it and how do I match the UserId with the current one (how do I know what the current userid is using the login controls)? I basically want to display profile information by selecting the table and matching it to the userid.
I have a GridView; one of the columns displays concatenated records from a tables. to extract the records that are going to be concatenated and put in this column, i have used: FOR XML path('') and it works just fine for displaying those records. the problem now is the whole gridview can not be sorted anymore and gives me a 404, document not found, error whenever i try to click the columns to sort. here is my select statement for my sql datasource select command:
SqlDataSource2.SelectCommand = "Select a1.*, keyword = substring( ( SELECT DISTINCT ', ' + keywordName FROM keywords JOIN key_mm_articles ON key_mm_articles.keywordID = keywords.keywordID WHERE key_mm_articles.articleID = a1.articleID FOR XML path(''), elements ),2,500) FROM articles a1 WHERE title LIKE '" & titles & "' Order By a1.articleID"
