|
Either in the applications Program Files folder or in
Program Files\Common Files\manufacturer\appname
|
|
|
|
|
hi All again i managed to solve my previous adapter. as Acces does not support substring function, i used Mid instead. so now i have problem in my search button. and the Problem is Poiting to the following line.
damixed.SelectCommand.Parameters("Boundary_Area").Value = cmbboundary.Text
damixed.SelectCommand.Parameters("Lis_key").Value = txterf.Text
i used "mid" function to Extract the value to is needed to be searched. like this
SELECT Boundary_Area, Compl_Boundary_Area, Extension, Current_Values, Improvements_Value, Improved_Value, First_Prop_Address, Lis_key, Num_key, Own_Name, Parcel_No, Parcel_Portion_No, Primary_ID, Prop_Address, Purchase_Date, Site_Value, Street_Name, Street_No, Actual_Extent, Title_Deed_No, Values_Effective FROM Property_ValRoll WHERE (Boundary_Area = ?) AND (MID(Lis_key, 5, 5) = ?)
When i run project code, it tell me that
An OleDBParameter with Parametername 'Lis_key' is not contained by this oledbParameterCollection.
As you can see am connecting to Acces database,i had a same project that is successfully but DB as SQL, so the code will differ in the adapter and in the parameter. So please tell me if its the correct way to get input from a user's textbox and combobox this way? and what is wrong with my code.
Thank you
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding
|
|
|
|
|
Vuyiswamb wrote: damixed.SelectCommand.Parameters("Boundary_Area").Value = cmbboundary.Text damixed.SelectCommand.Parameters("Lis_key").Value = txterf.Text
OleDb doesn't use named parameters. You have to create the parameters and assign values to them in the order they are seen in the SQL statement.
|
|
|
|
|
i understand, please Post an example code.
Thanks
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding
|
|
|
|
|
Hi Friends,
I am Beginner in ADO.net.I can Connect the SQl server Database and display the record in the text box and navigate the record.Now I want to insert new data in sql server and delete the selected data from the database.Please help me for this task.
|
|
|
|
|
Good morning Wlink
it is a wonderful day indeed. i would like to start by saying Buy a book in VB.net, i think everybook contain that example or Google Vb.net e-books they are books ,they can help you. try to google first before you post here, because there are many articles that can help you.if you can follow this link, you will find what you are looking for
http://www.codeproject.com/vb/net/[^]
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding
|
|
|
|
|
Hi ,
I have some problems. I have sql query that join tables and show results based on Date value of a table in the join. I can create crystal report using that query directly. But, that's not what I want. I want to pass the Date parameter from vb.net. I'm using visual studio 2003.
My query is like this,
Select Table1.Description as 'Name', Sum(Table2.Fee) as 'Amount'
From Table2
INNER JOIN Table3 On Table3.xxxxID = Table2.xxxxID
INNER JOIN Table4 On Table4.xxxxID = Table3.xxxxxID
INNER JOIN Table5 On Table5.xxxID = Table4.xxxxID
INNER JOIN Table1 On Table1.xxxx = Table5.xxxx
WHERE Session.EndDate between '01/01/2007' and '12/01/2008'
Group by Table1.Description
Please help me,
Thanks in advance,
RB
|
|
|
|
|
How I can draw an image like gauge on the form by using listview values at run time?
Or
Is there is any freeware gauge component which can be used in vb.net application?
Any help will be appriciated.
Thanks in advance
Ejaz
|
|
|
|
|
ejaz_pk wrote: How I can draw an image like gauge on the form by using listview values at run time?
Create your own custom-drawn control. This is not an easy feat if you're unfamiliar with drawing, or creating controls. As with any application, creating controls has two sides to it. Managing the data model and drawing the control. After all, there's nothing to draw if you can't manage and understand the data your representing with the graphics.
ejaz_pk wrote: Is there is any freeware gauge component which can be used in vb.net application?
I don't know of any free ones.
|
|
|
|
|
Actually I use dlls for Mobile Application
And when I handling event using code as code is :
AddHandler callState.Changed, AddressOf callState_changed
But when I run Project then following error will occur in above line :
Could not load type Microsoft.WindowsMobile.Utilities.Registry from assembly Microsoft.WindowsMobile.Utilities, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35.
Please Give me Solution If anybody have
|
|
|
|
|
|
Nimesh U wrote: Could not load type Microsoft.WindowsMobile.Utilities.Registry from assembly Microsoft.WindowsMobile.Utilities, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35.
The file may not be there either in GAC (as shared assembly) or in bin folder (in case of private assembly).
Also
1) Wrong Forum.
2) Direct Person Addressing (in subject Dave Kreskowiak)
|
|
|
|
|
What makes you think I do any Mobile development??
That's probably why I didn't reply to your message(s)...
|
|
|
|
|
please help me unload my dll and plugin,i have a program that can load a plugin but i dont know how to unload it,they say that my loading should be different so that i can unload it.
<rattlesnake><3:16>
|
|
|
|
|
Bascially, if you didn't load the DLL into a new AppDomain, there's no way to unload the DLL.
|
|
|
|
|
How to load DLL to AppDomain? I really don't have any idea about this,hope you could help me with this,thanks...
<rattlesnake><3:16>
|
|
|
|
|
|
Theres generally 2 ways of loading plugins, either into the current AppDomain or in to a new AppDomain.
The only way to unload an assembly is to unload the entire AppDomain, so if you require unloading of plugins you need a new AppDomain. This doesn't come for free however as serialization has to take place on any objects passing over AppDomain boundries and so incures a performance penalty.
If you load into the current AppDomain then things will run at full speed but as you have found you cannot unload the assembly.
If your application rarely changes plugins or is often restarted there is very little to gain from using a seperate AppDomain. And so conversly if the app is long running (and so is vunerable to a build up of assemblies) or has a large number of plugin changes then it might be worth taking the hit to allow cleaning up of the assemblies.
Personally I wouldn't bother about the unloading unless there is a real need for it ... it would be nice but it's not essential and you can always remove the plugins from use, you just can't remove them from memory.
One final note, the seperate AppDomain structure does have one bug advantage when running untrusted plugins. It allows you to place a different set of security restrictions on the code and keep it away from your own code to enhance security and stability. Basically it can be used as a sandbox.
|
|
|
|
|
Hi, does anyone know when Microsoft will stop offering MCSD tests for dotnet 2.0 and replace them with version 3.0? I'm thinking about taking the tests for MCSD, but not sure if I have enough time to study for all of the required tests before they are discontinued. Thank you in advance for your help.
-- modified at 21:52 Tuesday 28th August, 2007
|
|
|
|
|
ASPnoob wrote: does anyone know when Microsoft will stop offering MCSD tests for dotnet 2.0
Nope. The only people who know would be Microsoft. The .NET 2 tests will probably be around for at least a year after the release of Visual Studio 2008, whenever that happens...
|
|
|
|
|
Hi everyone, how long does it take the average person to study and pass the tests? Do you know of a free site that can help me speed up my study? I've been studying version 1.1 but did not finish it, and from what I have experienced it took forever for me to get everything down pat. Part of the problem was I was studying on my own, when I get stuck on something it takes a while to find the answer. I just want to get the MCSD under my belt as soon as I can, then try to get experience afterwards. Thanks for responding.
|
|
|
|
|
ASPnoob wrote: just want to get the MCSD under my belt as soon as I can, then try to get experience afterwards
The fact that this is possible is one of the many reasons that these tests are useless.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
I don't know of any free sites, nor practice tests that are any good. Remember, you get what you pay for.
ASPnoob wrote: I just want to get the MCSD under my belt as soon as I can, then try to get experience afterwards.
This is why I don't bother with certifications. Too many "paper-pros" out there who can prove they passed the tests, but couldn't code their way out of a wet paper bag.
|
|
|
|
|
I understand where you are coming from Dave and Christian, but I'm not looking to go sell my ability as soon as I get certified. I just want to have it so that I can build up my skills afterwards without worrying about the tests for the version that I have studied for not being there when I'm ready to take them. I understand that there are people out there who misused the certification and degrade the values of the certification. How did you build your skills? I'm sure there was a time when you were as new to this thing as I am. What do you suggest I do to get real life experience? Any suggestions will be appreciated.
-- modified at 4:03 Wednesday 29th August, 2007
|
|
|
|
|
But, the test is *useless*. Just focus on getting the skills.
ASPnoob wrote: How did you build your skills?
Writing code. Downloading articles and making changes to the code to see what it did. Asking questions, and taking every answer and researching it until I understood why it worked. Buying books and reading them.
ASPnoob wrote: What do you suggest I do to get really life experience?
Imagine a system that, if you had built it, would have increased your skills in an area you care about, then do all of the above in the process of writing it.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
