Re: C# - How to separate configuration files and core? - C# Discussion Boards

Re: Read and Execute bunch of .Sql file using C#

27-May-06 2:13

I'm assuming you wanted to ask a question. I'm also assuming your question was something like "How do I read and execute a bunch of .sql files using C#?"

If my assumptions are correct then you may want to look at: Running SQL Scripts with a .NET application[^]

Does this help?

"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog

Paul Conrad27-May-06 8:59

Paul Conrad

27-May-06 8:59

Thanks for the link, Colin Smile | :)

I've been wanting to do this with a bunch of .sql files I have for a project.

Paul

C# - How to separate configuration files and core?

haiaw27-May-06 0:29

haiaw

27-May-06 0:29

Hi,
It's my first project in c#. I have to make an app which would export data from xls to my database. It should also validate the data from xls...
I've been working with java and for configuration purposes I've been using spring and xml - then user could change the spring file without again compilation of the apllication...
What do u use in similar projects under c#? Do u have an links?

Re: C# - How to separate configuration files and core?

Colin Angus Mackay27-May-06 2:16

Re: C# - How to separate configuration files and core?

27-May-06 2:16

haiaw wrote:
What do u use in similar projects under c#?

Use application configuration files, which are XML files that contain configuration information for .NET applications. You can add an app.config (or web.config for ASP.NET applications) to your project and then use classes in the System.Configuration namespace to access it.

haiaw27-May-06 9:05

haiaw

27-May-06 9:05

Thanks, I've read some articles covering System.Configuration. Now I have simple problem:
I want to have simple list of strings in ArrayList, these r those strings:
aas
bsd
cds
4fe
5
What should I write in app.config? (how u write lists and which handler do u provide for this collection)?

<sectiongroup name="settings">

and then
<settings>
<mylist>
????????????????

and finally in some core file:

ArrayList nvc = (ArrayList)ConfigurationSettings.GetConfig("settings/dbSettings");
MessageBox.Show("Connection String is " + nvc[0].ToString());

I've tried different ways but it doesn't work...

Programatically enable & disable USB drives using C#

abyclassic26-May-06 23:22

abyclassic

26-May-06 23:22

Dear All,

i have developed a desktop based application using C#.NET.
In this application, i wants to enable & disable the USB drives programatically. ie, enable the USB port before the application starts using it & disable it after the use.
I need to achieve the same when the application is running in a login, who doesn't have administrative rights.

Is it possible to achieve the same using .NET framework?
Do any one knows how to implement this. If so, please inform me.

Best Regards,
Abhilash Chandran

datagridview delete

kjosh26-May-06 23:01

kjosh

26-May-06 23:01

Hi,
How to perform delete with datagridview.Please provide me code for this delete operation.
Thanks in advance.

Passing value for criteria [modified]

Mairaaj Khan26-May-06 22:34

Mairaaj Khan

26-May-06 22:34

Hi All,
need suggestion and help!

which would be the best opion for passing a vlue for criteria (in where clause) to sql server database:
using member property or
using parameters or
by any other technique?
Confused | :confused:

With Thanx.

-- modified at 4:35 Saturday 27th May, 2006

Colin Angus Mackay26-May-06 23:05

26-May-06 23:05

uroojkhanpk wrote:
using member property

I don't know what you mean by that.

uroojkhanpk wrote:
using parameters

Yes, parameters are a good way. They reduce the attack surface of your application which reduces the chances of being susceptible to a SQL Injection Attack.

Mairaaj Khan26-May-06 23:23

Mairaaj Khan

26-May-06 23:23

Thanks Colin Angus Mackay!

property member means:

private int variablename;<br />
public int VariableName <br />
//Property for the variable variablename<br />
        {<br />
            get { return variablename; }<br />
            set { variablename = value; }<br />
        }<br />
string qry = "Select abc From table Where xyz = " +   this.VariableName;

is it clear know?
Thanks again.

-- modified at 5:26 Saturday 27th May, 2006

Colin Angus Mackay26-May-06 23:26

26-May-06 23:26

uroojkhanpk wrote:
string qry = "Select abc From table Where xyz = " + this.variablename

Never ever do that for two reasons:
1. It makes your code susceptable to a SQL injection attack.
2. You cannot concatenate an int onto a string. Poke tongue | ;-P

Mairaaj Khan26-May-06 23:35

Mairaaj Khan

26-May-06 23:35

that was a simple demo. while in real conversions are made.
Thanks for suggestions.

Guffa27-May-06 3:52

Guffa

27-May-06 3:52

Where the values come from when you construct the query is quite irrelevant. It's just another non-parameterized query.

A parameterized query is generally preferred.

---
b { font-weight: normal; }

Uniqe Array

emran83426-May-06 21:55

emran834

26-May-06 21:55

Hello,
Is not there any method available to make an Array with only Unique elements in C# ? after calling the method, the Array must get rid of all duplicate elements.

Thanks
Emran

leppie26-May-06 22:08

leppie

26-May-06 22:08

Use a Hashtable.

How xacc.ide transforms text to colored words on the screen
Intel PentuimM (aka Centrino) undervolting

Kevin McFarlane27-May-06 2:47

Kevin McFarlane

27-May-06 2:47

Have a look at the free PowerCollections library.

http://www.wintellect.com/[^]

You have to register to access it but registration is free and you won't get spammed! Smile | :)

Oh, I'm assuming you're using .NET 2.0?

Kevin

emran83427-May-06 20:23

emran834

27-May-06 20:23

Hi Kevin.
Yes, I am using .NET 2.0 C# Express. Wont the code snippet work for .NET 2.0 ?

Emran

Kevin McFarlane27-May-06 3:18

Kevin McFarlane

27-May-06 3:18

OK, I've found an example I wrote a while back using the PowerCollections library.

<code>
int[] source = { 1, 4, 4, 6, 1, 2, 2, 3, 1, 6, 6, 6, 5, 7, 5, 4, 4 };
List<int> list = new List<int>(source);
list.Sort();
Algorithms.RemoveDuplicatesInPlace(list);
foreach (int var in list)
{
Console.WriteLine(var);
}
</code>

Kevin

emran83427-May-06 20:22

emran834

27-May-06 20:22

Hello Kevin,.
Thanks for your reply. Ok, would this remove duplicate with case insensitive or case sensitive. ?

Emran