|
Hi
First of all thanks for the reply
i am stuck at building sql query from the fields selected and then passing it on to the reports
Can you please help me out
|
|
|
|
|
Do you know any SQL at all ? I can't give advice that's any better than what google will offer unless I know what's in the tables you're searching.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Yes i do know sql
I will give you a brief description with example
I have two different tables Say StuMaster and StuDetails
In StuMaster i have rollno,name,year
in studetails i have his rollno,addressinfo,marksinfo of eachsubject
Now i need something like selecting
rollno,name,year from master and marks of selected subjects of that year from the details table
So i will select the required subjects from the listbox and those fields are to be displayed onto the report.
|
|
|
|
|
Anonymous wrote:
marksinfo of eachsubject
Does this mean there's a column per subject, or are they all lumped in there ?
You want to select subjects, but that makes no sense, there's no column there to search by subject.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
each subject each column
and its search by column ie subject
|
|
|
|
|
You said : in studetails i have his rollno,addressinfo,marksinfo of eachsubject
Now you say : each subject each column
What does 'each subject each column' mean ? Each subject has it's own column ? So every possible subject has a column, even the ones a student is not taking ? That's *terrible* database design.
So how do you mark that a person didn't take a subjuct, is the column null ?
All you need to do is join on the ID, and check that the subject you want to recieve is not null. But the core problem is that if I understand you correctly, your database is crap. Are you able to change the schema to something reasonable ?
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
its the example one christy its not the actual one actually my TL asked me to find out solution
so i made up an example for it
|
|
|
|
|
I don't get it - so the example you gave me is NOT the table structure ? What's a TL ?
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Yes its not the table structure its a temporary one
TL is team leader
|
|
|
|
|
Hi,
I am trying to connect to a database using VB6, ADO and Access 2000. I have a combobox with the names of all the registered DNSs on the computer. When I select a DSN from the combobox I have to retrieve some records from the DB indicated by the chosen DSN. How can I connect to the database using the DSN name?
Thanks very much for your help,
dlarkin77
|
|
|
|
|
I'm making an ASP webpage using VB.NET. I'm creating controls on the fly. When I create my dropdownlists on the fly I am getting an odd behavior. When I change the selected value of one of the controls in the array it changes it for all of them.
I'm currently filling an array of listitems from a database and then using AddRange to add the values to each dropdownlist.
When I attempt to use the SelectedValue property of the dropdownlist to set which value is selected, it effects all of the dropdown lists. I can tell this because every drop down list is set the value the last item should have.
This is the loop I use to fill the listitem array (it's redim-ed to the proper size)
ctr = 0
For Each drddlFill In ds.Tables("dtEmps").Rows
lsiUpline(ctr) = New System.Web.UI.WebControls.ListItem
lsiUpline(ctr).Text = drddlFill("employee_id") & " - " & drddlFill("first_name") & " " & drddlFill("last_name")
lsiUpline(ctr).Value = drddlFill("employee_id")
ctr += 1
Next
Next I fill each drop down list
Row = new TableRow
Cell = new TablecCell
ddlUpline_Array(ctr).Items.AddRange(lsiUpline)
ddlUpline_Array(ctr).SelectedValue = databaseInfo("ID")
Cell.Controls.Add(ddlUpline_Array(ctr))
Row.Cells.Add(Cell)
tblBaseshop.Rows.Add(Row)
databaseInfo is pulling correct information. The rest of the row is filled with information from this so I know it is different for each row.
Every dropdownlist in ddlUpline_Array gets set to the selection of the last it.
Any advice on how to get each ddl set to a different selection? If I do a loop and fill each box from the database each time, the selection will be different for each box, but that is much too time consuming.
Thanks
The wisest of the wise may err. - Aeschylus
|
|
|
|
|
Well I want to do a sort of stat tracker for my first true project in VS.NET. It will be for a wrestling team. 13 players. about 5 or 6 categories. Data entry, Data accessing, Stat sorting..
Im planning on using a VB.NET frontend w/ an Access 2003 backend. I think it should be a fun project and ill be well acquinted with vb.net afterwards.
Your input? Mind Numbing easy project? How many man hours are you estimating? Im thinking until mid September with all of the bugs worked out.
Thanks for your E-ear
._._._._._.-.-.-.-.-._._._._._.-.-.-.-.-._._._._._.-.-.-.-.-
Spimoles.NET
clean and elegant. a beautiful craft
|
|
|
|
|
Does anybody have any idea what this means?
************** Exception Text **************
System.ArgumentException: Invalid parameter used.
at System.Drawing.Bitmap..ctor(String filename)
at Mule.DataManagementTool.frmMain.populateListView()
at Mule.DataManagementTool.frmMain.TreeView1_AfterSelect(Object sender, TreeViewEventArgs e)
at System.Windows.Forms.TreeView.OnAfterSelect(TreeViewEventArgs e)
at System.Windows.Forms.TreeView.TvnSelected(NMTREEVIEW* nmtv)
at System.Windows.Forms.TreeView.WmNotify(Message& m)
at System.Windows.Forms.TreeView.WndProc(Message& m)
at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
Thanks
Brad
|
|
|
|
|
You clicked on a TreeView node and the code in the AfterSelect event called a populateListView method, which apparent tried to create a Bitmap object, but with the wrong arguments supplied or a bad filename.
Without seeing the code in that populateListView method, it's pretty difficult to say exactly why it happened.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Okay, Thanks.
I see what I did. I hard coded a non-existent path.
Brad
|
|
|
|
|
Hi
i am a beginner at vb.net and has got stuck with a problem where i have to generate datatable dynamically
(i dont have any fixed structure for the table) and feedit into crystal report as a source.
i hve been able to build the data table but i dont know how to provide this data table tht i have generated as the input to the crystal report.
pease help me!
thanks in advance
|
|
|
|
|
HI,
I know this subject appears all over the place, but I still can't seem to find a satisfactory solution.
I need to be able to parse HTML in VB.NET, does any one have any links?
I'd prefer source code rather than an built assembly. This is for a commercial project, so the the appropriate financial arrangements would be made.
Thanks
...No better than I ought to be...
|
|
|
|
|
you've failed to mention exactly what you want to parse (eg, all the links, all the images, the css class used for header text etc) so i wouldnt expect any code.
Regex is arguably the best way to achieve most text parsing tasks.
|
|
|
|
|
Good point...
I guess I was a bit too quick to look for answers without understanding my own question.
Anyway I had been thinking if there was a way to get XML DOM type functionality with an HTML source.
I've found an SGML parser which is doing most of the job for now. Although it does seem VERY slow.
The aim of my project is to download web pages, and re-serve them later. We have permission from the owners (various on-line versions of newspapers), but most of these pages have various embeded anti-copy constructions, which are of course a complete pain to overcome.
...No better than I ought to be...
|
|
|
|
|
I need to check if a .dll is registred at install time and if not I need to roll back the instalation
how can be done under vb.net ?
Thanks.
best regards ravin
|
|
|
|
|
This is standard stuff in MSI package builders like Wise for Windows Installer. The installation can have a list of prereq's so that if any of them fail, the install can roll install itself back, no code required.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
can you tell me how to do it ? I use vb.net to build the installation kit and i did not see any option for rolling back if.. smth.
the file .dll is declared as vital in the project install kit
|
|
|
|
|
Are you talking about in the Setup and Deployment project for your VB app? There, I don't think you can do this. At least, I've never tried.
In Wise for Windows Installer, it's simple. There's a wizard for adding a dependancy such as this.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
The MSI best practices advise not using self-registration of DLLs at all. Instead the package should write all the registry keys required by all components directly from the MSI Registry table.
The main reason for self-registration failure is the dll cannot load one of it's dependencys. Assuming you have all the dll dependent components in your package, this can still occur because there is no guarantee the dlls will be registered in the required order. This is why they advise writing registry keys.
Unfortunately, it is not that simple because you have to determine all the registry keys required by a DLL. You can find Registry spy tools that record any changes made to the registry and use these to determine what keys need to be added to the setup. It's still a tedious process and easily prone to errors, so you must test carefully on a machine with a clean Windows install to make sure the package works.
As far as checking self-registration success, you can add an Installer class as a custom action and write code in it to load the DLL. If this fails, you can raise an exception from the Installer class. This will cause the entire setup to be rolled back. The problem with this is if the setup fails one time it will likely fail every time so your user has a setup that essentially never works.
A better option is to write a custom action that registers the dlls in a specific order that you have determined will always succeed.
|
|
|
|
|