I have many record in the datatable and these record is grouped by section col. How can i assign seq no to record for each group in sql
section seq
A 1
B 1
A 2
C 3
In my ASP.Net application, I am using ajax accordian control on my aspx page and vb.net for code behind pages.
I have used validation summary for page validation.
1st accordian Pane contains following fields:
First Name
Last Name etc.
2nd accordian Pane contain following fields:
Address
City
Country etc.
while validating the page It displays error messages in following sequence:
Address cannot be blank
City cannot be blank
Country.....
First Name....
Last Name....
But I want to display error messages in following order:
First Name cannot be blank
Last Name....
Address cannot be blank
City cannot be blank
Country.....
I tried to resolve it by giving tabIndex to textboxes and RequiredFieldValidator, but sequence doesn't change I created RequiredFieldValidator again in sequence, but it doesn't affect.
n a form I have multiple group of controls which are grouped using validation group property. I want to assign validation group to asp.Button dynamically on client side using javascript on the base of item selected in drop down list.
Here is JavaScript which I am using, but it is not working. It shows validation group undefined but actually a default group is defined.
<script type="text/JavaScript">
function NextClicked() {
var _ddlStatus = document.getElementById("<%=ddl.ClientID%>");
var _selectedIndex = _ddlStatus.selectedIndex;
var _btn = document.getElementById("<%=btnNext.ClientID%>");
alert(_btn.ValidationGroup); // here in messge it shows undefiend, yet I have defiend a group in button as default.
if (_selectedIndex == 1) {
_btn.ValidationGroup = "G1";
}
if (_selectedIndex == 2) {
_btn.ValidationGroup = "G2";
}
}
This is my table.
I want ms sql query to get result
ID ProcessID Processname Date
105 123
Sammying 2010-04-22 12:09:02.827
i have two tables (Users, Roles) and each user belongs to one role. Can I make a sql query that returns 10 newest users from each role in one query?
View 5 Repliesi have create a local Group (on server2003) name: Group_Test
SQL-Server:
i want to grant execute on usp_test. i have to specify the group with hostname
i tried
[Code]....
but it doesn`t work
i have to Count Data Month wise and Date format would be like this Feb-10 and iam using the below query but no luck .
SELECT REPLACE(CONVERT(CHAR(9), ADate, 6), ' ', '-') As 'MonthYear', COUNT(AID) AS 'Planned' FROM Employee where Status =1 and YEAR(Adate) = '2009' GROUP BY YEAR(Adate), MONTH(Adate) ORDER BY YEAR(Adate),MONTH(Adate)
I'm trying to display using this query:
SELECT documentcategoryname, documentname, documentid FROM documents
INNER JOIN documentcategory
ON documents.documentcat = documentcategory.documentcategoryid
WHERE documentsiteid = @siteid
GROUP BY documentcategoryname, documentname, documentid
Which gives the following results:
documentcategoryname | documentname | documentid
About Us doccy3 3
About Us doccy4 4
Map Of Medicine doccy5 5
Is there a way using vb.net I can just display the category name once, and the documents underneath it like below:
About Us
doccy3
doccy4
Map Of MEdicine
doccy5
My code so far is:
If pagesreader.Read() Then
' output documentcategoryname
mydata &= "<h2>" & reader.Item("documentcategoryname") & "</h2>"
'display document list here using while loop?
End if
i want to use group by
var origina = (from m in _db.MeSetgroup by m.Categoryselect m)
but it have error in. how can i use group by in mvc?
I've written this code to display a group of events when the value is 12/19/2010. This means each day I need to change the "default value" to the current date to display the events of the day. I would like to make this such that the change occurs automatically, that is, on 12/20/2010, I'd like to see just the events for 12/20/2010.
<asp:SqlDataSource ID="testeventdate" runat="server" ConnectionString="<%$ ConnectionStrings:testdateConnectionString %>" SelectCommand="SELECT [eventDate], [eventDesc] FROM [programEvents] WHERE ([eventDate] = @eventDate)">
<SelectParameters>
<asp:querystringparameter DefaultValue="12/19/2010" Name="eventDate" QueryStringField="eventDate" Type="DateTime" />
</SelectParameters>
</asp:SqlDataSource>
I'm trying to create a menu structure, subpages within pages, for use with my cms. I have 3 tables in sql server, I would like to query all three tables and list those pages with a certain siteid, and subpages where the subid is the pageid. how to use the GROUP BY Statement to create the menu below? Or could I use vb.net to display it for me? Something like this:
sitename
page
page
page
page
subpage
subpage
subpage
page
page
Here is my query so far:
SELECT * FROM sites
LEFT JOIN pages ON sites.siteid=pages.siteid
LEFT JOIN subpages ON pages.pageid=subpages.pageid
WHERE sites.siteID = 1ORDER BY sites.siteid, pages.pagesub ASC
These are my tables:
sites
siteID int Unchecked PK
siteName nvarchar(MAX) Checked
siteAdmin nvarchar(MAX) Checked
siteLive bit Checked
Pages
pageID int Unchecked PK
siteID int Checked FK linked to siteid in sites table
pageLink nvarchar(MAX) Checked
pageBody ntext Checked
pageSummary ntext Checked
pageTitle ntext Checked
pageOrder int Checked
pageHome bit Checked
subpages
subID int Unchecked PK
PageID int Checked FK linked to pageid in pages table
subBody ntext Checked
subSummary ntext Checked
subTitle nvarchar(MAX) Checked
subOrder nvarchar(MAX) Checked
I'm attempting to further reduce a dataset/table by various user input. Part of this process is grouping the data by a timestamp prior to a summation. I'm trying to use LINQ and cannot get the data returned that I need.
[Code]....
How do I translate the following query into LINQ to SQL?
[Code]....
Am using the addrotator in an update panel to display people images.
The data source is MS SQL server.
On my data access layer I have queried the information Ordered alphabetically using Names.
However the add rotator displays them randomly.
I am looking to cache a dataset and then filter the results as they will be used repeatedly. However, I don't know how to assign values in the filtered dataset to variables in C#. I have looked on the internet for the past few hours but all I can get in binding the dataset to a control.
View 4 Repliesassign updateParameter value to sqlDataSource programmatically?
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:InternalConnectionString %>"
i have to combobox which default selected value is "select all" and other values USA GERMANY vs.
and i have countries table.how can i query all country names when "select all" value is selected.My stored procedure is look like this
select * from countries where countryname=@prmcountryname
[Code]....
How do I get the "NewID" parameter value form the above datasource and assign it to a select parameter in a different sqldatasource?
I have a GridView that displays records based on a SQLDataSource, which gets it's data from a very simple stored procedure. I want to use stored procedures to update & delete records in the GridView, which I have done in the past.
Our organization requires that the names of the parameters within our stored procedure start with "@p" to differentiate between passed parameters and internal variables. This is causing me my issue. If I change the stored procedure code to reference the fields without the "p", everything works properly. This is because the SQLDataSource parameters use the default ParameterPrefix of "@" and correctly references the stored procedure parameters. Here is the relevant code:
[Code]....
I found a MS article describing how to override the default ParameterPrefix, but I am unable to implement it. I can add their example code, but how do I "assign" this property to my GridView?
Based on user access rights (I am using aspnet log in controls) I want a gridview to show different result set for every type of user.
I have three sqldatasources in the page each getting different data based on user role.
How do I assign these data sources to the gridview ..
I am doing something like this.. [Code]....
I have some duplication that I need to clean up. I wrote a SQL query that is supposed to return duplicate customers who are located in the same city and zipcode.
I have 2 questions regarding it:
1. Is the query syntax correct to find duplicate records by same city and zipcode, data is being returned but it just returns the same customer a few times?
2. I only need to do the GROUP BY clause for Fullname and City however it gives an error when the other columns are left out. The error is Address, State and Zip not being in the aggregate function or in the group by clause.
Adding all the remaining columns to the GROUP BY clause works.
Query is as below:
[code].....
i have the following objects:
Event:
- EventID (PK)
- GroupID (FK)
- StartDate
Group:
- GroupID (PK)
- GroupName
What i need to do is select the last 5 events for each group using LINQ to Objects. I tried starting with:
[Code]....
But i'm not sure how i only take the last 5 per group.
The simple way of doing this is to get the groups and then have a property on that which returns the last 5 events but if i databind this i will have to use a nested Repeater/ListView. Ideally i would like to have a row foreach event.
What will be the equivalent GroupJoin lambda expression in LINQ when I do this.
Dim fruit_salad = (From fruits In _DataContext_Fruits _
Group Join fruitRipe In _DataContext_FruitRipe On fruitRipe.fID Equals fruits.fID Into Group
From fruitty_lecious In Group.DefaultIfEmpty() _
[code]...
The below query produce the below output.
[code]...
select r.Name,c.Name,s.Name,(select count(p1.id)from profiles p1 where r.id=p1.religion and c.id=p1.caste and s.id=p1.subcaste and p1.Gender=1)as Male,(select count(p1.id)from profiles p1 where r.id=p1.religion and c.id=p1.caste and s.id=p1.subcaste and p1.Gender=2)as Female from religion r,profiles p,caste c,subcaste s where r.id=p.religion and c.id=p.caste and s.id=p.subcaste group by r.Name,c.Name,s.Name,r.id,c.id,s.id
I have this SPDECLARE @PERC VARCHAR(50)
DECLARE @nome_soc_repl VARCHAR(50)
set @PERC = '(select round((' + @nome_soc_repl + ' /(select sum ('+ @nome_soc_repl+ ') from exptot_perc))*100,2)
from exptot_perc)'
EXEC (@PERC)
nome_soc_repl is a varible that contains my table name
so I need to extrac the result of EXEC...for examples 15...... and put it on another variable.....