I want to select many rows from my SQL Server database and combine them in a certain manner. Currently, I've been using the following method to get these rows:
[code]....
i have a select statement which returns a column value.
id like to display the lowest column value there is, but if there are multiple rows with the same (and lowest) value id like it to be random which one of the rows is selected.. how would i do this? my select statement is currently:
SELECT TOP (1) url, ABS(r1 - @r1) + ABS(r2 - @r2) AS difference
FROM type
ORDER BY difference
this picks the one lowest result for me, but if there are multiple duplicate lowest results id like to select them, and show one at random..?
Is it possible to select multiple gridview rows using Ctrl+Click and then delete all the selected rows with a button?
View 1 RepliesI created a gridview with a checkbox in front of some columns. I need to grab the data the user is delecting and building an xml file.
Here is my code so far.
[code]....
SourceForm.aspx contains a databound gridview which I have added a checkbox column for multiple row selection. OnClick of a button I want to display any selected rows on another page, Target.aspxSo far I have successfully captured textbox input properites using PostBackUrl between the two, e.g.
SourcePage.aspx <div>
Enter your name: <asp:TextBox ID="_nameTextBox" runat="server" /><br />
Enter your age: <asp:TextBox ID="_ageTextBox" runat="server" /><br />
<asp:CheckBox ID="_marriedCheckBox" runat="server" Text="Married?" /><br />
<asp:Button ID="_nextPageButton"
[Code].....
Some examples I've tried to follow point towards using DataKey Rows of chkSelected
i'm using the code below to select multiple rows in a gridview using a checkbox, how do I modify the code in a "select all" button click event to select all the rows by checking the checkboxes in all the rows? How do I also clear all the checkboxes using sa "Clear" button click event?
[code]....
I have an html table in an aspx page (C#) that has columns like
1.CheckBox 2.Text 3.Text 4.TextBox
I want to iterate through the table one row at a time and process (run a stored procedure based on column2) based on whether the checkbox is checked or not. How will I be able to do that?
I have a Telerik RadGrid with a GridTemplateColumn that contains a checkbox, as follows:
<telerik:GridTemplateColumn HeaderText="MINE" UniqueName="MyTemplateColumn">
<ItemTemplate>
<asp:CheckBox id="MyCheckBox" runat="server"></asp:CheckBox>
</ItemTemplate>
</telerik:GridTemplateColumn>
I want to set the box to be "checked" based on a value read from the database. I could handle the ItemDataBound event and read the database when each row is bound, but that results in n lookups. Instead, I want to handle DataBound, and then set all the values at once. So, in that method, I want code like this:
[code]....
I have a GridView with an extra checkbox column to select rows.
To select multiple rows, the user now has to click each separate checkbox, but I would like to offer the possibility to select multiple rows at once using Shift+click.
Thus the user would explicitly select the first row with a single click and the select the last row using Shift+click. And the checkboxes of the rows in between would then automatically be checked as well.
Suppose I have a temporary table (Shown below). The table is defined and populated in my stored procedure. After it is populated, I need to go through every row in the table. Here is what I need to do :
Check if Amount2 > Amount1 If Amount2 > Amount1 then set Amount1 = Amount2
It feels a little akward for me to use the temp table.
[code]....
I am having a problem. I need to check to see if a row has been displayed once, and if so don't display it again. I have the following code:
[Code]....
This all works perfectly, but displays the body row repeatedly. So i need to add a counter or something to check this and make sure it is only displayed once..
I tried with DISTINCT in the sql but that didn't work, so i think it may be better doing it through iteration? Can this be done?
I've got a datatable in a dataset which contains 44 rows. I can iterate through the rows and add the data to a placeholder - it's all there. However, if I bind a control (say a gridview or dropdownlist) to the datatable, all I get is one record (from the "middle" of the table). I get the same result when I create a dataview of the table - one row.
View 4 RepliesActually what i am doing in my Data Access Layer dragging store procedure to TestDbml to display records and creating data context instance in BAL to retrieve records and my method in BAL is like this
public IEnumerable display()
{
using (TestDataContext db = new TestDataContext())
{
var display = obj.USP_Actor_View_Speciality(p_UserName, 1);
return display as IEnumerable;
}
Now the problem is that how can i iterate or fetch over the records and display accordingly in my Presentation Layer so that i could return all the field parameteres Like ield1=val.field1,field2=val.field2.
I am new in asp.net..My Problem is i have 3 textboxes..
in first text box i enter A1,
Second Textbox i enter 3,
Third Textbox i enter 5
after button click i want to store
A1B1,A1B2,A1B3 as per second textbox i enter 3
A1C1,A1C2,A1C3,A1C4,A1C5 as per Third Textbox i enter 5
how to generate the above rows and how to save in database
I want to insert almost 400 rows in one database call in asp.net. I am using .net 3.5 and sql server 2005. What should be the best possible way for doing that?.
View 1 RepliesI've have to delete multiple rows from database in a table . Which is the best way to delete data to optimize performance of sql server as well as asp.net.
View 6 RepliesI have a save button outside the gridview and I want to save all the values/records of gridview at once or row by row in database(sql server) .
View 1 RepliesI have a save boutton outside the listview and i want to save all the value records of listview at once or row by row in databace (sql server).
View 1 RepliesThere's this repeater...
<asp:Repeater ID="myRepeater" OnItemCommand="rpt1_ItemCommand" runat="server" OnItemDataBound="rpt1_OnItemDataBound">
<HeaderTemplate>
<table width="99%" border="0" cellpadding="0" cellspacing="0">
<tr class="lgrey">
<td>Default</td>
</tr>
</HeaderTemplate>
<ItemTemplate>
<table>
<tr>
<td>
<asp:LinkButton ID="lnk1" Text="Make Default" CommandName="SetDefault" runat="server" Visible="True" CommandArgument='<%#Eval("UserID") %>' CausesValidation="false"></asp:LinkButton>
<asp:Label ID="label1" Text="Yes" runat="server" Visible="False"></asp:Label>
</td>
</tr>
</ItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:Repeater>
What I want is that when user clicks on any of the "lnk1" link button in the lsit that repeater renders,
the link should be replaced with the label "label1"..ie when the user clicks on "Make Default" link, it should be replaced with "Yes" label
Now when I click 2 link buttons, both get their label "Yes" displayed where as I want only one link button to display Yes ie the one which has been clciked and rest of the items should display "Make Default" link button only.
ie Only ONE item should be displaying "Yes" label...now how do I iterate through the repeater items to set only ONE item as default and not multiple ??
Is there a way to select data from multiple tables other than the UNION ALL statement. Addtionally I need to select data from a different database.
My current statement is as follows (there are alot more fields but I have shortened it ):
SELECT server.dbo.SRFILE.SR_GROUP, server.dbo.SRFILE.SROWNERSHIP, server.dbo.SRFILE.SRCONMAE, BSFLBWF_1.Incidentx,
BSFLBWF_1.Severityx FROM server.dbo.SRFILE INNER JOIN
BSFLBWF AS BSFLBWF_1 ON BSFLBWF_1.Incidentx = server.dbo.SRFILE.SRONUMBER
WHERE (BSFLBWF_1.Closex IS NULL).........
I have one big DataTable with X rows. I want to select Y rows from it and bind them to a new ViewList. While doing it, I want to delete these rows from the DataTable (Having X - Y rows).
What is the best and fast way to do it?
I don't know if it is better to create a new DataTable to have the Y and after that bind them to a ViewList or something else?
I'm also looking for example in code how to select/delete rows from DataTable.
I came across a situation where a user selects no of rows from dropdown , depending upon the user input, automatically that no of editable rows should appear to input data...(maximum 8 rows only)
View 1 RepliesI have a gridview which right now is getting loaded with four pages of data. There are 50 rows per page. My problem is I need the "select all" button on my page to select 180 rows, not just the 50 on the page. This is my javascript:
Code:
function sel() {
var frm = document.forms[0];
isSelected = !isSelected;
for (var i = 0; i < frm.elements.length; i++) {
var e = frm.elements[i];
if (e.type == 'checkbox' && e.name.indexOf("ckSelected") > -1)
e.checked = isSelected;
}
}
I am more a C# person than javascript, but I am deducing that I need something other than document.forms[0] to represent the entire gridview. Or perhaps, I can't do this in javascript at all. Do I need server code to run and set a session variable, then when the user clicks the button to do something with all his selected rows (it goes to a detail page), query that session variable to see if it's all rows instead of iterating through each gridview row individually to see if the checkbox is checked?
I was looking for such an SQL query that it will give me the first 20 records but it will skip the first 10
There are some LIMIT and OFFSET stuff with MySQL and Postgres but what works with SQL Server?
I am refering below url:
[URL]
how to select items in dropdownlist if i bind it from database.
Once i select some items and save in database , after that i want items selected when page reloads that items bind in dropdown.