I want to add four values to the arraylist when i click on UP button. and if i click on UP button again i need to add four more values to arraylist.
While getting the values from arraylist i need get four values at a time and so on .
Stack-Overflow :3 I've got a kind of hard-case question.
So I'll try clearly explain my idea with my poor english :/ need select to DataTable SOME values from ???_**GetDisplayData **procedure for each day of previos month (GROUP IT) where group rules for different columns is different
I need to select some values in stored procedure from other stored procedure like this :
SELECT X FROM Y_Procedure(@ProcedureParameters)Also I need to select from dynamic SQL Procedure like
Y_Procedure=@Y+'_Procedure'
SELECT X FROM Y_Procedure(@ProcedureParameters)
Also I need to load it to DataTable :-/INSERT INTO @Report (CellHorizontal, CellVertical, CellValue) --to TABLE
SELECT Date,X2,X3 FROM Y_GetDisplayData(@Param)
SET NOCOUNT OFF;
SELECT *
FROM @Report
GetDisplayData works as select with parameters and that doesn't returns SQL DataTable
And there is no way to recode GetDisplayData's procedures, it's just constant procedures for me.Finally I need to Group nodes from this table
INSERT INTO @Report (CellHorizontal, CellVertical, CellValue)
SELECT T1.Date,
IF ((Select grouptype...)=1) T1.X2 + T2.X2
ELSE IF ((Select grouptype...)=2) AVG(T1.X2,T2.X2),
IF ((Select grouptype...)=1) T1.X3 + T2.X3
ELSE IF ((Select grouptype...)=2) AVG(T1.X3,T2.X3),
(SELECT T2.Date,X2,X3 FROM Y_GetDisplayData(@Param) T2
WHERE T2.Date>T1.Date AND T2.Date>=T1.Date)
FROM Y_GetDisplayData(@Param) T1
GROUP BY EVERY DAY ???--and here is epic fail
I can make all stuff on asp server :And C# allows me to use something like SelectCommand = IzmProc + "_GetDisplayData"; And then I will work (select special data) with DataTables on ASP.NET Server but it's better to make all on SQL ... But looking like it's just unrealizable on SQL >_<
I gonna think about C# realization,but my code is very weird , got errors and doesn't works >_<
public static DataTable GetReport(string Param)
{
System.Configuration.ConnectionStringSettings connSetting = ConfigurationManager.ConnectionStrings["FlowServerConnectionString"]; [code].....
I have a procedure that is used to look up user permissions in our custom table, There is 1 record for each user and about 20 columns for each of the permissions.
How can i take the column values and place into an array?
All the column are bit type and 1 is int. Is it possible to take the values returned and add to an ArrayList?
And then once the values are in the array, how to loop thru it and go to certain index to check the value.
This is what i have now:
[Code]....
[Code]....
[Code]....
openDB() Dim inList As String Dim getCourses
For k As Integer = 0 To arLcID.Count - 1
If k > 0 Then inList &= ","
End If inList = arLcID(k).ToString
getCourses = "select cID,cCode,cUnit from [university].[Courses_1] where cID ='" & inList & "'"
insertCMD = New Data.SqlClient.SqlCommand
[Code] ....
This code is not returning any value, when the arraylist is removed it returns value.
i need to select the values inside an arraylist into a listbox control, when i am doing the loop of the arraylist only the last value of the array stays selected, i need all values of the array list to stay selected, here is the code.
' businessTypeList is an array list that contains values 39 31 51 but only 51 stays selected in the list box i need to maintain selected all three.
For i = 0 To (ddaEdit.businessTypeListID.Count) - 1
I want to passed stored procedure parameters from crystal report to pass those parameter dynamically by arraylist because user will pass parameters by using data driven web pages (can be different reports with different parameter). how can i pass through parameter array lists to crystal report setreportparameters fields.
My code;
public void ConfigureReports(ArrayList valuesLists,ArrayList parameterLists) {
rptReportViewer.RefreshReport();
DataBaseHelper.myReportConnectionInfo = new ConnectionInfo();
DataBaseHelper.defineConnection = null;
[Code] ...
I have a master table relationship, i.e. depending on what is selected in the dropdown list the grid show the relevant data.In the database there are several identical entries for the Position field, for instance there are four marketing managers that have different name. How can i group the identical Position name in the dropdown and when selected the grid should display all marketing managers. Here is the code:
<asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="sqlDdl"
DataTextField="ID" DataValueField="Postion">
</asp:DropDownList>
<asp:GridView ID="grid" runat="server" AutoGenerateColumns="False"
DataKeyNames="ID" DataSourceID="sqlCon" EnableModelValidation="True">
[Code] ....
i want to create a arraylist which will able to store user info like (username,machineIP,port ) for each user in the list & retrive this data when needed . any one tell me how i can do it or any alternative way without database or xml file.
View 6 RepliesI have to select checkboxes besed on group column values. If you see below gridview, column 3 (GroupN) has 1,1,1,1,2,2,2,2....etc (this column data is not static, will change based on page index. i.e PageIndex =2 may starts with 7,7,7,8,8,8,8,8,9,9,9 etc).
Now My question is.
1). If user selected '1', we have to store value and user must and should select another '1' (atleast two times).
2) If user selected '1', and user trying select '2'. Giving error says "Must have select one then one record in group to combine' (will not allow) and unselect '2'.
3) If user selected '1' atleast two times, and user trying select '2'. Will allow.
4) If user selected '1' atleast two times and selected '2' one time, trying to select '3'. will not allow user to select '3'.
How group by and sum values in DataTable??I have a DataTable that looks like this:Id Value1 4.01 5.03 1.02 2.03 3.0I want to end up with (probably a new DataTable) that contains the sum ofvalues grouped by Id like this:Id SumOfValue1 9.02 2.03 4.
View 10 RepliesI'm making an "Edit Customer" page in asp .net and want to enter in all the current values into the TextBoxes on PageLoad. Is there a way to do this using databinding, or do I have to get the Customer from the DataContext and then set the TextBoxes line-by-line? ie
firstNameTB.Text = Customer.FirstName;
lastNameTB.Text = Customer.LastName;
...
I need to develop a page in my applicaiton like the image for the user lists.
I need to get the list of users under a group and need to show likw this.
I'm using a linq group by query (with two grouping parameters) and would like to use the resulting data in a nested repeater.
var dateGroups = from row in data.AsEnumerable()
group row by new { StartDate = row["StartDate"], EndDate = row["EndDate"] };
"data" is a DataTable from an SqlDataAdapter-filled DataSet. "dateGroups" is used in the parent repeater, and I can access the group keys using Eval("key.StartDate") and Eval("key.EndDate").
Since dateGroups actually contains all the data rows grouped neatly by Start/End date, I'd like to access those rows to display the data in a child repeater. To what would I set the child repeater's DataSource? I have tried every expression in markup I could think of; I think the problem is that I'm trying to access an anonymous member (and I don't know how.) In case it doesn't turn out to be obvious, what would be the expression to access the elements in each iteration of the child repeater? Is there an expression that would let me set the DataSource in the markup, or will it have to be in the codebehind on some event in the parent repeater?
I am binding gridview details from the datatable, i need to use groupby in gridview.
View 1 RepliesI'd like to gruop data from a table, for example, by DATE or CATEGORY, something like this:
29/01/2010
News 1
News 2
News 3
30/01/2010
News 1
News 2
News 3
or group by CATEGORY, like this:
ASP.NET
News 1
News 2
News 3
PHP
News 1
News 2
News 3
We have many different clients, and each client can have multiple user accounts.Right now, we have user settings set up on the ASP project, and a WinForms application can see these settings, depending on which user logs into the winforms application. They are specific to the user. I want to make them specific to the client, so users can be in "groups" by their client, and all users in the group would see/update the same settings.
View 1 Replieshow to distinct arraylist value using c#?
View 10 RepliesI am trying to retrieve a arraylist frm a session and add in more objects into the arraylist on top of the existing object in the arraylist.But i have encounter problem at the foreach loop where it promted me a error message shown below
Object reference not set to an instance of an object.
below are the sample code.
public void addItemToArraylist(List<LibraryItem> temp) //l temp pass in 5 items each tim
{
ArrayList storeItems = new ArrayList();
storeItems = (ArrayList)Session["storeItems"];
foreach (LibraryItem items in temp)
[Code]....
I have a function and I am getting an error message. I need to convert my DataTable to an array and be able to access each line individually. This is the error message: Operator '-' is not defined for types 'System.Data.DataRowCollection' and 'Integer'.
[Code]....
I am working on a VS 2005 based Environment, on .NET 2.0.am trying to Bind a ArrayList to a GridView. The ArrayList consists of Objects of a Specific Class. When i bind it now all the Properties in the class. The catch is I do not want to display all these properties on the GridView.For Example: The objects of this class is held in ArrayList, when i Bind it to GridView it shows all the four Columns, Where as i want to show only 2...
[Code]....
How do you go about removing multiple items from a array list?
I'm using the RemoveAt() method to remove but doing that resets the ArrayList's index which cause me problems if the user selects to remove 1 & 3 out of a 3 list array since once it removes 0 the array list now just has 0 & 1.
i want to show the arrayliust items in the listbox, for that i had stored some data in array list, and now i want that if i gv any id which is in the array list its corresponding details are displayed in listbox. I had two fields ID, Name, and when i give id its corresponding name should be shown in list box.
View 3 RepliesI have a GridView control of 5 columns out of which 2 are actually computed (there cell values comes from column 1, 2 and 3) columns. I want to save all the values of my gridview columns in a 5 dimension ArrayList and then lateron bind that ArrayList with a repeator control.
View 1 RepliesI am doing a leave application in which I want to display working days (dates) apart from holidays and weekends. So first I make sure that it is not a holiday by comparing with my holidaymaster table and not saturday or sunday. My code so far looks like this...
asp.net:
< asp:GridViewID="grdWorkingDays"runat="server"AllowSorting="true"AutoGenerateColumns
="true"></asp:gridview>
c#:
//Check whether it is a holiday(compare with holiday_master) or saturday or sunday
for (DateTime
i = LeaveStartDate; i <= LeaveEndDate; i = i.AddDays(1))
[Code]...
I've been trying to bound an arraylist to a grdview for display and managed to work out the following:
[Code]....
At the point where rows are added to dt, i'm trying to get arraylist (Tweet) to be read row by row to insert each of it's fields into dt. There is no error but when run in browser, each cell of the gridview shows 'DataExtraction.Tweet'.I'm not sure where to go from here.