|
Halo,
Iam very new to vbnet so i need help to solve the following,
i have a database file with students exams information whereby a student
participated in 8 subjects.
now i want to get the count of the students who got A, A-, B+ etc in
evey subject and in every class i. e.in form1 form2 e.t.c where subject
marks <>n/a (not applicable)
I also need to count the number of students who participated in every subject where
subject_mark <> n/a-
and also get the average in every subject.
I also want to show and print this information in crystal reports or ms-reports in
vbnet 2005 pro.
i would be very happy if i get anycode sent by email.
Thank you.
|
|
|
|
|
This sounds suspiciously like a class assignment.
You must do your own work young man.
Firstly no-one will ever write your code for you, you must write your own, and people will help you out.
Secondly, you are asking for a lot, don't. Ask for a little each time.
Also, have you tried Here[^] I find it helpful.
------------------------------------
"Children today are tyrants. They contradict their parents, gobble their food and tyrannize their teachers. I despair for the future."
Socrates 400BC
|
|
|
|
|
Jimnahsh wrote: i would be very happy if i get anycode sent by email.
I bet you would, however this is generally called cheating where I come from. Do your own homework, or at least attempt it and come back with specific problems.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
Thank you for being concerned about the complex question-
but surely i am not a student but my project is real, i had been
programming with vb6 but wanted to get the depth of the net
this is an example where i tried to get the results in v6 but found that if i use aloop the code could be to long:
Set conn = New ADODB.Connection
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/Program files/Ease_Mark2010/ExamsFile.Mdb;Persist Security Info=False"
Set rs = New ADODB.Recordset
Dim strSQL As String
strSQL= "SELECT Count(*) AS [Mean Grade]From Results WHERE (((Results.[Mean Grade])='B-'And (Form_ID)='2")
from this code i was getting the correct rusults for the selected class.
The question is, i have 12 arugements for one class (A,A-,B+, etc)
and also 12 subjects to loop through.
therefore i wanted a clue to get used with vbnet 2005.
thank you.
|
|
|
|
|
Well, without knowing the database structure its difficult to advise you, but generally I would do this sort of processing in the database, but I wouldn't be using access.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
Thank you Ashfield,
I am using ms Access 2003 mdb, and my database file
has only one Table, every student has a single Record with Stud_name,Form_ID and
Grades for eight subjects- Maths, English,Kiswahili,Physics, Biology,Chemistry,Agriculture,
CRE,
Actually i wanted to get the (select Count(*)data to appear in Report as follows-
Subjects A A- B+ B B- C+ C C- D+ D D- E
English 2 1 0 2 1 0 3 4 5 0 10 23
Maths 3 2 3 3 3 1 2 1 0 2 1 0
Physics
Biology
further more, if i cant get this type of Results from Access SQL statement,
How can i do it from the Crystal Reports formulas?
hope i have explained my situation
|
|
|
|
|
You may be able to get it from an access, you need a pivot query - I don't have access installed to try it.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
Hi,
How can I have the date from a monthcalendar when I do a drop.
Basicly I do a drop from a label on a picturebox or on a monthcalendar. From the picturebox I have all the info I need, but from the calendar I can't find that info. In the Question[^] on this forum There was no anwser. (It was not me who asked). In google I can't find nothing relevant.
Jan
|
|
|
|
|
Here 1[^] Here 2[^] or Here 3[^]
Set the picker so that on change or selection it assigns a variable the date.
You can use it how you like then.
------------------------------------
"Children today are tyrants. They contradict their parents, gobble their food and tyrannize their teachers. I despair for the future."
Socrates 400BC
|
|
|
|
|
hello,
i am stuck. i have one web application. i want to pass contract number from my web page and give a link to open my windows form with contract number and search all the details for that contract number and populate it in the forms.
so basically i want to pass the parameter from web page to my windows form to populate all the related fields.
hemaxi
|
|
|
|
|
IS the web form running inside your app ? If not., you're creating a link to the exe and assuming it's in a known location ? You can pass parameters to an exe on the command line.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
No. Web form is not running in my windows application. both are seperate applications but now we want to merge it. so we decided, instead of writing code again , we call windows application from webpage and pass the parameter.
my question here is how to fetch that parameter in windows main form.
ex. if i am passing parameter called "ID" with .exe. when windows application is loading that time i need to know "ID" so that i can write code in FORM_Load event to populate other fields from the table for that "ID".
Pls. reply asap.
|
|
|
|
|
|
Excellent..but Where to write...i've main form in solution. and i dont know how the asp.net team is going to call my windows application. is there any other way.
Thanks for ur help.
Hemrk.
|
|
|
|
|
Nope. And you can make the call to get the command line args anywhere you need to in your code.
Before you start writing it though, you better sit down with the ASP.NET guys and come to an agreement on the format of the arguments you're going to use.
Also, you might also want to discuss with them the security problems you're going to run into running an external .EXE from inside the web-browser. This is normally not allowed unless you've made changes to IE's security policies.
|
|
|
|
|
Thanks Dave.
Its working fine. yes..i was thinking to meet asp team and find out how they are going to call my exe. actually we are working on the same project so there is not security issues as its for our internal office users..so doesnt have to worry about security ..but i dont know whether they are going to pass the parameter commandline or not.
anyways do u have any idea how to pass commandline arguments with calling exe from asp .net
?let me know so i can tell them to use that way.
Thanks again
Hemrk.
|
|
|
|
|
hemrk wrote: so doesnt have to worry about security
Uhhh, the security issue isn't going to be something that you setup. It's going to be something that you have to relax to get it to work. The browser defaults will not let you do this.
|
|
|
|
|
Hi, hope you can help out someone fairly new to programming (well...relearning). I'm using VB.NET in Visual Studio. I have a combo box that is bound to a binding source. Basically, what I am trying to do is refresh the data after I submit the form. The closest I have been able to do is to refresh the data but get data that is one iteration old (i.e. client name changes from name to name - config1 in the database but I won't see the change until I submit a second time...and the name in the database then would be name - config1 - config1 but the combo box displays name - config1).
So...I am first changing the name when I click the submit button:
Select Case tsmConfig1.CheckState = CheckState.Checked
Case True
NewName = Name & " - Config1"
Me.Tbl_NameTableAdapter.UpdateName(NewName, ConfigtKey)
End Select
And then I attempt to re-fill the table adapter associated with the binding source...but it's not working correctly: Me.Vw_GDXActiveClientsTableAdapter.Fill(Me.GDX_ServicesR2DataSet.vw_GDXActiveClients)
I'm sure the answer is obvious and simple but I am missing it. Thanks in advance for any and all help!!
|
|
|
|
|
After the re-fill the datatable, rebind the combo to it. Just set the Combo's DataSource to whatever you had originally.
|
|
|
|
|
I can't to open my database with my program or in access database when I try to open in MS Access give me this error "Unrecognized database format" how repair this problem
|
|
|
|
|
ivo75 wrote: how repair this problem
Fix your code.
Seriously. How are we supposed to tell you how to how to fix a problem when you haven't shown the code when the problem occurs??
|
|
|
|
|
Code is very long how to post this code and I try to open with MS Access but again don't open
|
|
|
|
|
I said post the relevant part where the problem occurs, NOT the entire class.
|
|
|
|
|
give me your e-mail I post You all project I don't know where is problem
|
|
|
|
|
No way in hell am I giving out my email address.
Copy and paste the code snippet into a Reply and surround it with <PRE></PRE> tags.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
