I'm using ASP.net with vb, Access database and SQL query, I'm trying to
count records that match with a particular criteria after making a loop
statement and after displaying any records.
Does any one of you knows the asp.vb.net script 5 1235
First, in ASP.NET there is no "scripting". It's all compiled code now.
Second, are you asking for how to do everything you are saying below or just
how to count up how many records matched?
To count how many matched, it's easy...just include your own variable
counter in the loop that gets incremented when you've determined there is a
match.
"RAW" <de****@terra.com> wrote in message
news:Om**************@TK2MSFTNGP11.phx.gbl... I'm using ASP.net with vb, Access database and SQL query, I'm trying to count records that match with a particular criteria after making a loop statement and after displaying any records. Does any one of you knows the asp.vb.net script
wooooou
thanks for your effort to treat help mister attitude
"Scott M." <s-***@BADSPAMsnet.net> wrote in message
news:ux**************@TK2MSFTNGP09.phx.gbl... First, in ASP.NET there is no "scripting". It's all compiled code now.
Second, are you asking for how to do everything you are saying below or
just how to count up how many records matched?
To count how many matched, it's easy...just include your own variable counter in the loop that gets incremented when you've determined there is
a match.
"RAW" <de****@terra.com> wrote in message news:Om**************@TK2MSFTNGP11.phx.gbl... I'm using ASP.net with vb, Access database and SQL query, I'm trying to count records that match with a particular criteria after making a loop statement and after displaying any records. Does any one of you knows the asp.vb.net script
There's no attitutude here. I'm trying to help you to understand the
environment you are working in and I'm asking you to clarify your question
so that I can help you get your answer.
Thanks for biting a hand that's trying to help!
"RAW" <de****@terra.com> wrote in message
news:uT**************@tk2msftngp13.phx.gbl... wooooou thanks for your effort to treat help mister attitude
"Scott M." <s-***@BADSPAMsnet.net> wrote in message news:ux**************@TK2MSFTNGP09.phx.gbl... First, in ASP.NET there is no "scripting". It's all compiled code now.
Second, are you asking for how to do everything you are saying below or just how to count up how many records matched?
To count how many matched, it's easy...just include your own variable counter in the loop that gets incremented when you've determined there
is a match.
"RAW" <de****@terra.com> wrote in message news:Om**************@TK2MSFTNGP11.phx.gbl... I'm using ASP.net with vb, Access database and SQL query, I'm trying
to count records that match with a particular criteria after making a
loop statement and after displaying any records. Does any one of you knows the asp.vb.net script
Lol,
Okay if you have a data within a DataSet and if you only have one table in
that dataset
you can get the count by DataSet.Tables[0].rows.count
[] could be ( ) in vb.net
and then you can iterate through the dataset table rows and get individual
columns to display
Regards,
HD
PS: Its better to be clear when asking a question
"Scott M." <s-***@BADSPAMsnet.net> wrote in message
news:uI**************@TK2MSFTNGP12.phx.gbl... There's no attitutude here. I'm trying to help you to understand the environment you are working in and I'm asking you to clarify your question so that I can help you get your answer.
Thanks for biting a hand that's trying to help!
"RAW" <de****@terra.com> wrote in message news:uT**************@tk2msftngp13.phx.gbl... wooooou thanks for your effort to treat help mister attitude
"Scott M." <s-***@BADSPAMsnet.net> wrote in message news:ux**************@TK2MSFTNGP09.phx.gbl... First, in ASP.NET there is no "scripting". It's all compiled code
now. Second, are you asking for how to do everything you are saying below
or just how to count up how many records matched?
To count how many matched, it's easy...just include your own variable counter in the loop that gets incremented when you've determined there is a match.
"RAW" <de****@terra.com> wrote in message news:Om**************@TK2MSFTNGP11.phx.gbl... > I'm using ASP.net with vb, Access database and SQL query, I'm trying to > count records that match with a particular criteria after making a loop > statement and after displaying any records. > Does any one of you knows the asp.vb.net script > >
Thanks this work perfect
"Hermit Dave" <he************@CAPS.AND.DOTS.hotmail.com> wrote in message
news:ed*************@tk2msftngp13.phx.gbl... Lol,
Okay if you have a data within a DataSet and if you only have one table in that dataset you can get the count by DataSet.Tables[0].rows.count [] could be ( ) in vb.net and then you can iterate through the dataset table rows and get individual columns to display
Regards,
HD PS: Its better to be clear when asking a question
"Scott M." <s-***@BADSPAMsnet.net> wrote in message news:uI**************@TK2MSFTNGP12.phx.gbl... There's no attitutude here. I'm trying to help you to understand the environment you are working in and I'm asking you to clarify your
question so that I can help you get your answer.
Thanks for biting a hand that's trying to help!
"RAW" <de****@terra.com> wrote in message news:uT**************@tk2msftngp13.phx.gbl... wooooou thanks for your effort to treat help mister attitude
"Scott M." <s-***@BADSPAMsnet.net> wrote in message news:ux**************@TK2MSFTNGP09.phx.gbl... > First, in ASP.NET there is no "scripting". It's all compiled code now. > > Second, are you asking for how to do everything you are saying below or just > how to count up how many records matched? > > To count how many matched, it's easy...just include your own
variable > counter in the loop that gets incremented when you've determined
there is a > match. > > > "RAW" <de****@terra.com> wrote in message > news:Om**************@TK2MSFTNGP11.phx.gbl... > > I'm using ASP.net with vb, Access database and SQL query, I'm
trying to > > count records that match with a particular criteria after making a loop > > statement and after displaying any records. > > Does any one of you knows the asp.vb.net script > > > > > >
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Derek Cooper |
last post by:
I hope you can help me. I posted this in the microsoft sql server newsgroup
a few days ago and got no response so I thought I'd try here. If I can
provide any clarification I'll be glad to do so....
|
by: Ben |
last post by:
I have a Tabular form bound to a table. The purpose of this form is to
get times from a timer and record them in a field. The timer dumps the
time automatically through a serial port. When the time...
|
by: Skully Matjas |
last post by:
Thank you for getting back to me. I am very new at this so i didnot
understand what you said, here i will give as much cetails as possible:
1) The combo box i am using is combox39
2) I imported...
|
by: Ilan Sebba |
last post by:
I am trying to add a record using SQL. My problem is that the primary keys
are foreign keys, and these foreign keys are autonumbers. I therefore do
not know the primary keys of the record I am...
|
by: Steven Stewart |
last post by:
Hi there,
I have posted about this before, but yet to arrive at a solution. I am
going to try to explain this better.
I have an Employees table and a Datarecords table (one-to-many...
|
by: Mary Litten |
last post by:
Hi - (This is my very first post)
I have gotten to this point of registering to post because I have been
spinning my wheels so long, I believe I am all caught up in the weeds.
(and mud)
I have...
|
by: DebbieG |
last post by:
I have created a database for a client and was told that it was to be a
one-user database. Well, you know the next statement ... now they want 3
people to be able to use the database. (FYI, I...
|
by: domcatanzarite |
last post by:
How would one create a button that on click advances the form to the
next "non recurring record" as opposed to the next record.
The field the button needs to que from has groups of duplicate...
|
by: sara |
last post by:
Hi -
I have been struggling with solution ideas for this now for almost 2
weeks, and have not been able to figure this out.
I have a user who creates a Purchase Order (tblPOData). In some...
|
by: tekctrl |
last post by:
Environment; Win2K PC with 1Gb of RAM and plenty of HD space running Access
2002
Issue; Access presents a blank data entry form in the Forms view when the
New Record icon is used. However, it...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |