|
select DISTINCT will ignore duplicate values.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Its as SQL question really - thats where you need to clean it up.
Select keyfield1, keyfield2, keyfield#, count(*)
From anyTable
Group By keyfield1, keyfield2, keyfield#
Having count(*) > 1
There are reams of information on cleansing said tables!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Dear all, I found problem on changing the value which have been set inside my app.config file. I would like to use a window form to change/edit the value inside my cpp.config setting at runtime. The following are my code setting for my Ap.Config file:
?xml version="1.0" encoding="utf-8" ?>
configuration>
appSettings>
add key="Location" value="KK" />
add key="Terminal_ID" value="CTR01" />
add key="MyServer" value="localhost" />
/appSettings>
/configuration>
Hope someone can give me some solution for this here. Thank you for reading!
|
|
|
|
|
Why do you want to edit your app.config file at runtime? It exists to hold constants etc that are used by your app.
-------------------------------------------
Don't walk in front of me, I may not follow;
Don't walk behind me, I may not lead;
Just bugger off and leave me alone!!
|
|
|
|
|
Its because I want to let the advanced user to change the setting of the TerminalID(define the workstation Identity) and Location(define the location of office locate) when they move the pc. So the server can track what the user running. So I need it to let the advanced user to change the key in app.config file in runtime. Thanks~!
|
|
|
|
|
The best way I've found is to create a settings file, which adds keys to a new section of the app.config, and can be saved at runtime, by changing the value and executing the Save method.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Its a good idea. But how do you do this in VB.NET Window Form Application? Can you give me some sample solution?
|
|
|
|
|
Exactly what I said. Add a settings file to your project properties. These get added to the app.config at compile time, but if you have an instance of this class, you can change the settings and call the save method to update the app.config
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
I'm sorry Mr. Christian Graus. How to add the setting file to my project properties? I'm just a beginner user. Can you give me some details on how to do this??
Thanks for the help.
|
|
|
|
|
Add/NewItem/Settings File
And, please, buy a book.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Ok,thank you Mr.Christian Graus. Sorry to disturb you about this my friend. I'll try to find it out. Sorry~~!
|
|
|
|
|
Look under MyProject in Solution Explorer, enter the setting under the setting tab
In your code use My.Settings to modify the user settings - once you find them they are really simple.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I'm sorry,can you give me further explanation about this? What code should be include for changing the value in my app.config file?
|
|
|
|
|
Did you read the response, do you know what Solution Explorer is, have you opened the VS IDE?
Read the bloody response, try and follow what was suggested, I told you want to type in you code My.Settings. Intellisense will do the rest for you.
You don't manipulate the config file directly you use the My.Settings class to do it, it's built into VS, use it!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Yes,I am still running with my Visual Studio 2003 here. I didn't found any Setting tab on my Solution Exlporer. This is the things I create inside my Project now>> 2 Form, 1 Module and 1 App.Config file. And another Reference file which auto generate by VC2003. So,what should I do next my friend?
|
|
|
|
|
: Look under MyProject in Solution Explorer
NOT Settings tab that is under My Project - btw try double clicking.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hmm.. So weird,let me write down what I see at my Solution Explorer here my friend.
Solution 'POS_System'(1project)
-POS_System
-References
-System
-System.Configuration.Install
-System.Data
-System.Drawing
-System.Windows.Forms
-System.XML
-bin
-POS_System.exe
-POS_System.exe.config
-POS_System.pdb
-obj
-Debug
-temp
-TempPE
-POS_System.exe
-POS_System.FrmLogin.resources
-POS_System.FrmSetting1.resources
-POS_System.pdb
-App.config
-AssemblyInfo.vb
+FrmLogin.vb
+FrmSetting1.vb
-Module1.vb
This is all the file inside my Solution Explorer. What should I do next to create some files or add in any code?
Thanks~~!
|
|
|
|
|
I'm wondering if someone might be able to help me. I've spent a bunch of time on this, read everything I could find, but still can't seem to crack it.
I want to load an assembly .dll into a separate appdomain, from the root directory c:\.
The assembly asm is loaded into the new appdomain fine, BUT ONLY IF ShowForm.dll is in the application default path. I've monkeyed with Applicationbase to request that the load look elsewhere, to no avail. Do I need to specify a security policy?
In any case, is this really the way to load an application into a new appdomain (one which I can subsequently unload)?
Thanks in Advance
Dim Asm = System.Reflection.Assembly.ReflectionOnlyLoadFrom("c:\ShowForm.dll")
Dim ads As New AppDomainSetup()
ads.ApplicationBase = "C:\"
Dim ad As AppDomain = AppDomain.CreateDomain("App2", Nothing, ads)
Dim Asm2 = ad.Load(Asm.fullname)
|
|
|
|
|
I need to create an application in VB.net that will be used for printing sheets in a printing press company. the critical points that are required are:
1. The placement of the printing figures and characters on the sheet has to be very precise.
2. Printing of rectangles with rounded shapes with exact precision.
Will this be possible through a reporting tool or is there any 3rd party tool in VB that I can use?
|
|
|
|
|
You can do this with your own code. Any code will print with precision of location. The issue is how precise the hardware is that feeds the paper through.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
The client will be using HP laser printer. Can you give me a clue on how to do all this with my code?
|
|
|
|
|
Again - the code will position with accuracy, they are at the mercy of the sheet feeder on their printer.
You can't NOT position stuff exactly. The problem is the printer needs to feed stuff exactly.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Thanks for the reply. I appreciate it.
|
|
|
|
|
I have a DataGridView that is not bind to dataset or datatable or any datasources.
I want to clear the content of all cells in DataGridView whitout recreating its rows and its columns.
How ?
|
|
|
|
|
For Each drow As DataGridViewRow In DataGridView1.Rows
For Each dcol As DataGridViewColumn In DataGridView1.Columns
DataGridView1.Rows(drow.Index).Cells(dcol.Index).Value = ""
Next
Next
Shay Noy
|
|
|
|