SQL Server :: Select & Declared Variable Select Not Connected?
Jan 6, 2011
I am trying to write a stored procedure that takes out a list of blog entries from a table (tblFeedEntry) as well as the amount of comments that each blog entry has gotten (tblFeedComments) but all I can get is the total amount of comments of all blog entries together, displayed on all entries. This is how my code looks today:
[Code]....
I am guessing that the problem is that the declared variable is not picking up the id of the blog entries, instead it picks up everything. The original select and the select in the declared variable are not connected. How do I connect them?
I am moving to the world of ASP.NET from an Access VBA / VB6 background and having read a few books on the subject I am still confused about communicating with SQL server in VB with ASP.NET.
As a very quick explination I am used to communicating with the server by passing strings containing the data I want to write (or read) such as:
[Code]....
I do not seem to be able to work out from ALAX, Dynamic Data, Bound Controls, DataViews, connecting to services with SOAP, DataSources and all of the other methods of database communication in ASP.NET which is the right system to do the simple reads and writes in SQL that I want to do.
At present I have a page with all of the controls on it required to collect a block of data I want to insert, it is all now fully validated but although I can build the SQL INSERT command in a string I cannot figure out how to fire it over to the local SQL Express server. Am I even doing this correctly or do I need to look at other controls?
I have a problem with SELECT COUNT query in ASP.net. I want to create CMS with articles which have categories (which have the option to be deleted). The problem is that I want to get the number of articles within the specified category so if there aren't any articles with the specified category I can proceed with the category deletion.I have the following code:
[Code]....
After I click the button "ObriĊĦi" (Delete) I receive the following error: "Must declare the scalar variable "@KategorijaID"." I understand that the problem is with parameter, but I don't know how to correct it to use it for both the "command" and "brisanje" SQLCommands.
I am new to all this, and ignorant beyond compare. I believe I have the same problem as this :
[URL]. However, the solution proposed for him doesn't seem to work for me. I have a session variable that 'march_cpi_session' that I wish to include in an sql select statement to multiply the values I get from a datatable before they're used to populate a gridview control. The session variable works fine elsewhere in my application, but causes a variety (depending upon how I fiddle about with the syntax) of sql errors. This is the currrent code:
The drop down list is used to determine what search criteria will be used to find an invoice. I tried to set the Select method in the switch statement. I don't understand how to set the Select Method and the select parameters programmatically though . I tried a few different ways but can't make the compiler happy. My ODS is in scope in the code behind. I'm not able to access it's properties though. The BAL resides in a separate project that is a ClassLibrary. I also have a using statement for the ClassLibrary project in the code behind.
Can any one let me know about the below issue. I have a page which has three labels, say startdate,enddate and username. My issue is if the user doesnot select any of the above three then a message gets displayed as "Please select one search criteria" or if the user doesnot enter the date in correct format then i dispaly "Please enter date in mm/dd/yy" format. But what is happening is first time if the user doesnot select any then "Please select one search criteria" is getting displayed and after this message gets displayed if the user enters wrong format of date then both the messages are displayed.
I will declarate a attribute, but it gives me an error
This query works fine and returns 1 record from type int:
SELECT TOP 1 DataObjectVersionID FROM tblDataObjectVersionPropertyValueText WHERE PropValue like CAST('00010281' AS ntext) ORDER BY DataObjectVersionID DESC
And when I will declarate a attribute/parameter it gives me an error:
DECLARE @dataObjectVersionId INT SET @dataObjectVersionId = SELECT TOP 1 DataObjectVersionID FROM tblDataObjectVersionPropertyValueText WHERE PropValue like CAST('00010281' AS ntext) ORDER BY DataObjectVersionID DESC
Error message:
Msg 156, Level 15, State 1, Line 2 Incorrect syntax near the keyword 'SELECT'.
I have gridview. some columns are data, and some are link buttons. now, I need move these link buttons to a hovermenu. this is done. but I got a javascript exception, and it is because if there is no row was selected in gridview, it will pop this.
so, the question is: how can I select a row in gridview without select command? simply by code?
I need to run a select statement on log in event and store the value of the select statement (returning one item) in a session variable.Do I have to u sqldatasource for this.. or is there someway I can run a single select statement and store the resulting value in a variable?
How would i make a select statement select the row with the nearest values? e.g.: I have 3 labels, labels1 2 and 3, with values of 1.2, 2 and 5.8 In my table i have 4 columns, first is the data im after, and the next 3 relate to the three labels. I want to select one row, where the values of labels match it the closest.......
1.LookupPageInfo and (LookupPageInfoId,pathmessageID,pagemessageID)
2.Messages (MessageId,MessageText,ChannelID)
Now i need to write a query something like this........in the query i need to pass the pathmessageid and needs to get messagetext from Messages Table,i am not sure how i need to write the below query..can someone guide me how can i write a query......as below..
select LookupPageInfoId, PathMessageID, pagemessageID, (select messagetext from Messages where MessageID=PathmessageId) as TEXT from LookupPageInfo
I'm using the code below to extract data from a gridview and populate it into textboxes for the days and two drop downs for Project and Category.
For some rows in the gridview everything but the category ddl populates correctly. If I click the row a second time the category ddl displays the correct category.
I'm creating some url rewriting for asp.net. Now I am tobbing if I should include the id in url or just the title. Do you guys know if it's a significant performance hit to lookup an item by title instead of id?
Use Html element SELECT in aspx page like:Data is feed by setting its property DataSource:MySelection.DataSource = IEnumerable collection DataSuppose data is stored in table in DB like:
1 - Option A 2 - Option B 3 - Option C 4 - Option D
From MySelection.Value, I can get the ID value, like 1,2,3.From MySelection.Name, I will get "MySelection", not the selected item name like "Option A"How to get the selected item Name?
I have 2 separate code-block asp.Net expressions in an aspx markup, with an html content between (span element in the example below). In the first code-block, there is "i" as an increment variable for the for loop.Then the code-block is cut with an html content.And another code-block expression is opened but as I see I can reach the "i" variable which was declared in the previous code-block.
So, how asp.net handles -compiles- the pieces of code-block experrions declared in the mark up? Does it check the semi-colons and generates some anonymous methods which will end up with many calls to Response.Write in the last place? <p> <%for (int i = 0; i < 30; i++) {
