Perform Grouping Of Resultsets In Code, Not On Database Level?
Apr 12, 2010Stackoverflowers,I have a resultset from a SQL query in the form of:
Category Column2 Column3
A 2 3.50
A 3 2
[code].....
Stackoverflowers,I have a resultset from a SQL query in the form of:
Category Column2 Column3
A 2 3.50
A 3 2
[code].....
I have multiple sub's that i'd like to group together, however all of the groups need to be in the same class. They all work together, but it would help me organize the code and make it less confusing if I could group some of the different subs together for outlining purposes. Is there a way to do this? I tried to find answers online, but I couldn't find what I was looking for.
View 3 RepliesIs it possible to store 2 or more resultsets in a Datareader? I have different methods which each return a DataReader. Can I store resultsets of them in the same DataReader?
View 1 RepliesWe have an item cull that retrieves items and their appropriate data from one server. Their Primary Keys need to be INNER JOINed with another table. However, the second table is on another server. We can retrieve that data using a separate select statement and accompanying VB objects.
How would one go about this programmatically in VB? Is a loop the best practice available? Although we are in a Microsoft Ecosystem, Server Linking is not possible.
I remember with InterSystems Cache code, you can use indirection to take a string and turn that into real executable code by preceding the string variable with "@". Can this be done in C#.NET or VB.NET code? So I'd like to have a method that would take an arguments array of strings (with one or multiple lines of code), and run that code, assuming it doesn't throw an exception of course. Where am I going with this? I'm trying to write a compiler within .NET code.
SET x="set a=3" XECUTE x ; sets the public variable a to 3
OR SET x="tag1" d @x ; do/call the public subroutine tag1
OR Set Y = "B",@Y = 6 ; sets public variable B = 6
In my project, there are 3 user controls; BasicContact, BasicDetail and ActionTime. They are in EditOrder.aspx page. There is "ReportDate" property (Date type) in BasicContact, RadioButtonList "rdl_Priority" (with integer value from "prio_id" field) in BasicDetail and "CheckDate" property in ActionTime. The ReportDate value is derived from txt_ReportDate and txt_ReportTime and CheckDate value is derived from txt_CheckDate and txt_CheckTime.
[Code]...
how can i perform a label click event using the code only.like in button we have a code like me.button1.performclick
is there something like in label
I would like to know whether I can use the VS2005 code in VS2008 to perform the same task?
View 7 RepliesHow do I perform an sql query onto a DataTable not a Database table?
View 1 Repliesi am trying to write a program which reads a data from the database and perform some calculations. what i am intending to do is when a user selects an item from a listbox and clicks the submit button the program, calls a function to calculate using the value stored in the database and display the result in a textbox.the problem is i cant store the data retrieved from the database into a variable so that the calculations can be done. i am using vb and microsoft sql server.can anyone tell me how do i store the data retrieved by the query into a variable.
View 12 Replieshow to perform the database operation such reading data and using them for comparison within the VB programming..
Please guide me with explanation as i have very little knowledge regarding the database operation...
i am using VB.Net 2008 as frontend...and MS SQL Server 2008 (express edition ) as back end...
I need a code that will make a progress bars value equal the battery level. And have label equal the batterys time left?
View 4 RepliesI'm looking for some code that will reload a form, so its like a Restart Level button which when clicked will reset the form to its original look.
View 1 RepliesI am creating an Excel add-in written in VB.NET. I would like to bind KeyDown and KeyUp events to the spreadsheet to record when the user presses and releases the arrow keys while navigating the spreadsheetIdeally, these events would be built into Excel alongside the native SheetActivate and SheetSelectionChange events, for example. Alas, they are not.
View 1 RepliesHow to perform add, edit, delete in a dataset that will update the database as well?
View 1 Repliesi don't want to use the system date and time in my mini project.i want to create my own system date and time to be in sync with standard time i specify?
View 3 RepliesIn Visual Basic 2008, there's two different ways that I know of to accomplish the same thing:The Dim on the member level:
Dim counter1 as integer = 0
Dim counter2 as integer = 180
Public Sub SampleSub1()
[code].....
I'm writing a form that get some informations from a database to manage the User Access Level.The way i do that is to Fill a Dataset by using a DataAdapter and the Bind some controls to the Dataset.The controls i binding are a ListBox, a Textbox, and five Checkboxes.All are fine with this controls. I can delete values and update values, i can choose a record from my ListBox and the values of this record to be desplayed on the othrer binded controls and so on.
[Code]...
I have a table, lets call it Objects. It has a predefined set of records looking like this:
ObjectId ObjectName
1 Salmon
2 Trout
3 Seabass
4 Shark
Etc..
So, this I would like to implement somehow as an enum. But what's the best way, implement it in the database creating tables for it or in the application logic in an CommonEnums codebehind file etc?
I have created a simple program which uses a two tier structure of SQL Tables.At the top level, one record holds the date of the activities and linked to it using its primary key as a foreign key, three subordinate tables hold time stamped records.The issue I have been unable to solve is that before adding any of the lower level records for a given date, a newly added top level record must be saved to the database.Doing this manually is simple - but can I rely on my users to remember to do this before they start plugging in the lower level data?I thought not, so I am looking to save the top level automatically.I've failed miserably but I refuse to believe that it's not possible.
View 14 RepliesI have the error Server: Msg 5171, Level 16, State 1, Line 1Database.mdf is not a primary database file.
View 1 RepliesI have multiple level of For Each and in each level, i have a Linq that is the 'In' criteria as in:
[Code]....
It will go inside each for (because the value is not nothing), however, it will only loop (next) in the very inner 'For Each t In tFor'. After it is finish inner loops, the outer Fors' or Next will not execute... even thought there are more than one values in that 'In'... like 'sFor' or 'fFor'. i've noticed while debuging, while break at the for (for example 'sFor', before stepping in), i get the error message:
"Enumeration yielded no results" when i expand the result for that variable and it will not step into it. but if i do not expand the result, it will step in. It seem that some how, once an element is accessed for that 'In' collection, it breaks (meaning does not loop for the rest of the elements) the next for that collection is this a bug or am i missing something in Linq? BTW: i believe it has something to do with the SqlDataReader in the Linq. I'm working with IAsyncResult.
May i know how to change my below login code to support for multi access level login? So that i can differentiate between manager and normal employees login so that i can enable or disable certain features for different department? I have the below code that can serve as a basic login.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
'login code can work
conn.Open()[code]......
U0161 import a Platinum level Advisor .jar to use with this Platinum level product key.How I can get this and import it to continue my completion of setup of mysql download?From where I can download that file?To enable this application, please provide a MySQL Enterprise Product Key or your MySQL Enterprise credentials.
View 1 RepliesI'm having a heck of a time with transforming a simple SQL Query into a LINQ query(using vb btw)
Here is my SQL:
SELECT USRDEFND5
FROM int_gp_employee
GROUP BY USRDEFND5
[Code]...
I've tried a number of different variations of the LINQ. My current statement is:
From b In xmlFile...<row> Group b...<usrdefnd5> By b...<usrdefnd5> INTO group when I foreach through the resulting collection, EVERY line (17000) shows up.
My VB.net application has a lot of application settings, is it possible to group them somehow(other than having a common name)?For example, my application has a lot of winforms each of which needs to save some information about itself. Is it possible to use something like:
Form1.width = My.Settings.Form1.Width
Form2.width = My.Settings.Form2.Width
etc.
I've a large table of Items and I need to organize them by Category, then by Year and then by Month.Item has CategoryID and Dated properties.I got this far:
Dim Items = From Item In DB.Items _
Group By CategoryID = Item.CategoryID _
Into Categories = Group _
Order By CategoryID
But where I put the:
Group By Year = Year(Item.Dated)
and the
Group By Month = Month(Item.Dated)
The final result should be something like this:
For Each Category in Categories
For Each Year in Category.Years
[code].....
I am using a nice shopping cart I found online. I would like to translate this code to use a repeater or listview and dynamically retrieve my data, but I cannot seem to find a way to group my data correctly.I know the ListView can group by a certain amount of items, but I have not found a way to do it with this scenario.The shopping cart works by having a ul list of items, followed by their details in the div below. This process starts again by getting three more ul items, followed by three more details. How could I do this using a ListView or repeater? I have not found a way to repeat both of these sets of data I need in a group of three.[code]
View 1 RepliesI'm completely dense here, but I'm trying to get some stats from a DataTable. One of the columns in the datatable is called "colour".I need to find out how many of each instance of "colour" are in the datatable.
I'm trying:
Dim q = From p In PGWorkingDataTable _
Group p By p("colour") Into Group _
[code].....
I am trying to group various controls (of the same type, e.g., labels together, buttons together, etc.) on a form using a tag or a name of some sort so I can identify all those that belong to tag 'A' and those in tag 'B'. In the end I will have on a form a number of labels grouped as tag 'A' and some labels as tag 'B' so I can change their visible properties on/off.
View 4 Replies