Encrypted Connection Strings in app.config - C# Discussion Boards

King Shez6-Sep-06 20:55

6-Sep-06 20:55

Thankx man for ur example when i am using this code snippet of the server it is giving the error on this

m_tcpListener.Bind(new IPEndPoint(IPAddress.Any,10000))

and shows no method of the tcp listener with the name of bind thers is the Server property of TCP Listener which have the method Bind , but its not workin plzzzzzzz, Reply me ASAP,thankx for ur reply.

Re: How to make client server

Andrei Ungureanu7-Sep-06 3:02

Andrei Ungureanu

7-Sep-06 3:02

Hi,
I must appologise. Please in the server code replace TCPListener with Socket. I confused the server declaration

Do your best to be the best

Re: How to make client server

Rob Philpott5-Sep-06 4:36

Rob Philpott

5-Sep-06 4:36

...or the easist way if it's sufficient for your purposes is ASP.NET webservices.

Regards,
Rob Philpott.

Re: How to make client server

King Shez5-Sep-06 21:10

King Shez

5-Sep-06 21:10

Well i don't want to use web services , iknow abt the web services , but i wanna make client Server with out web services, thanks in advance

crystal Report problem

ranandbe5-Sep-06 1:27

ranandbe

5-Sep-06 1:27

hi folks,

i know how to use crystal reports in asp.net with c#. but it connected with only one table at a time but i need to connect different table with single rpt file ,if any one knows about this plz share with me

regards,
ranandbe Roll eyes | :rolleyes:

Re: crystal Report problem

trannguyen865-Sep-06 1:47

trannguyen86

5-Sep-06 1:47

you should create view in database for connect many table a time

Re: crystal Report problem

ranandbe5-Sep-06 2:49

ranandbe

5-Sep-06 2:49

thanx for reply,
plz give me sample code

regards
ranandbe

Encrypted Connection Strings in app.config

Gomac5-Sep-06 1:03

Gomac

5-Sep-06 1:03

Hi,

I am using the following code to encrypt/decrypt a connection string in my app.config file:

    private void ProtectConfiguration()<br />
        {<br />
<br />
            // Get the application configuration file.<br />
            config = ConfigurationManager.OpenExeConfiguration(myGlobalFilePath);<br />
        <br />
            // Define the Dpapi provider name.<br />
            string provider =<br />
                "DataProtectionConfigurationProvider";<br />
<br />
<br />
            // Get the section to protect.<br />
            ConfigurationSection connStrings =<br />
                config.ConnectionStrings;<br />
<br />
            if (connStrings != null)<br />
            {<br />
                if (!connStrings.SectionInformation.IsProtected)<br />
                {<br />
                    if (!connStrings.ElementInformation.IsLocked)<br />
                    {<br />
                        // Protect the section.<br />
                        connStrings.SectionInformation.ProtectSection(provider);<br />
<br />
                        connStrings.SectionInformation.ForceSave = true;<br />
                        config.Save(ConfigurationSaveMode.Full);<br />
<br />
                        Console.WriteLine("Section {0} is now protected by {1}",<br />
                            connStrings.SectionInformation.Name,<br />
                            connStrings.SectionInformation.ProtectionProvider.Name);<br />
<br />
                    }<br />
                    else<br />
                        Console.WriteLine(<br />
                             "Can't protect, section {0} is locked",<br />
                             connStrings.SectionInformation.Name);<br />
                }<br />
                else<br />
                    Console.WriteLine(<br />
                        "Section {0} is already protected by {1}",<br />
                        connStrings.SectionInformation.Name,<br />
                        connStrings.SectionInformation.ProtectionProvider.Name);<br />
<br />
            }<br />
            else<br />
                Console.WriteLine("Can't get the section {0}",<br />
                    connStrings.SectionInformation.Name);<br />
<br />
        }<br />
<br />
<br />
        // Unprotect the connectionStrings section.<br />
        private void UnProtectConfiguration()<br />
        {<br />
<br />
            // Get the application configuration file.<br />
            config = ConfigurationManager.OpenExeConfiguration(myGlobalFilePath);<br />
<br />
            // Get the section to unprotect.<br />
            ConfigurationSection connStrings =<br />
                config.ConnectionStrings;<br />
<br />
            if (connStrings != null)<br />
            {<br />
                if (connStrings.SectionInformation.IsProtected)<br />
                {<br />
                    if (!connStrings.ElementInformation.IsLocked)<br />
                    {<br />
                        // Unprotect the section.<br />
                        connStrings.SectionInformation.UnprotectSection();<br />
<br />
                        connStrings.SectionInformation.ForceSave = true;<br />
                        config.Save(ConfigurationSaveMode.Full);<br />
<br />
                        Console.WriteLine("Section {0} is now unprotected.",<br />
                            connStrings.SectionInformation.Name);<br />
<br />
                    }<br />
                    else<br />
                        Console.WriteLine(<br />
                             "Can't unprotect, section {0} is locked",<br />
                             connStrings.SectionInformation.Name);<br />
                }<br />
                else<br />
                    Console.WriteLine(<br />
                        "Section {0} is already unprotected.",<br />
                        connStrings.SectionInformation.Name);<br />
<br />
            }<br />
            else<br />
                Console.WriteLine("Can't get the section {0}",<br />
                    connStrings.SectionInformation.Name);<br />
<br />
        }

However whenever I encrypt and decrypt the connectionStrings section of the app.config file, the connection string is not what I entered, it comes out as:

<connectionStrings><br />
        <clear /><br />
        <add name="LocalSqlServer" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true"<br />
            providerName="System.Data.SqlClient" /><br />
    </connectionStrings>

I am trying to encrypt the following connection string:

<connectionStrings><br />
  <add name="MyDbName" connectionString="Data Source=MYDBSERVER;Initial Catalog=MYDBNAME;Integrated Security=False;User ID=MYID ; Password=MYPASSWORD" providerName="System.Data.SqlClient"/><br />
</connectionStrings>

Any ideas what I could be doing wrong?

Thank you in advance.

Re: Encrypted Connection Strings in app.config

Gomac5-Sep-06 5:39

Gomac

5-Sep-06 5:39

solved it. was trying to open config file instead of:-> exe

Returning value from threads

samtam5-Sep-06 0:43

samtam

5-Sep-06 0:43

can anyone tell me, how can i return values from threads in C#?

Reply will be appreciated

Thanx in advance

Re: Returning value from threads

WillemM5-Sep-06 1:58

WillemM

5-Sep-06 1:58

You will have to drop the return value in a place that is accessable by another thread. You will have to protect the storage with a mutex, also add a condition to signal the other thread that processing is done. This is needed because processes can't return things to eachother, instead they storage data that has to be exchanged in a central place that is accessable by others.

These two steps start the threads and let the first thread wait for a signal of the other thread.

Thread 1 -> Thread2.Start();
Thread 1 -> Condition.Wait();

These steps are performed by the second thread in such a way that the storage can only be accessed by one party at a time. After the second thread is done, it will signal the first thread that it's done.

Thread 2 -> Mutex.Lock();
Thread 2 -> Set some value
Thread 2 -> Mutex.Unlock();
Thread 2 -> Condition.Signal();

These last steps are performed after the first thread gets a signal that the second thread is done.

Thread 1 -> Mutex.Lock();
Thread 1 -> Get value
Thread 1 -> Mutex.Unlock();

I'm not sure to what extend Microsoft implemented threading and concurrency tools, but if you don't have the Mutex or the Condition, you can do it with a Semaphore. The same trick, except for these changes:

Thread 1 -> Semaphore.P();

Thread 2 -> Set value in storage
Thread 2 -> Semaphore.V();

Thread 1 -> Get value from storage

This classic is also called the producer/consumer scenario.

WM.

What about weapons of mass-construction?

dataGridView

charbelasmar5-Sep-06 0:25

charbelasmar

5-Sep-06 0:25

Hi ,

I'm Working on dataGridView i want the datagridview to scroll to specified row
like if the row # 10 is selected i want to jump to other row like row # 1010
this easy by using dataGridView1.Rows[1010].Selected = true;
but how can i make the dataGridView to scroll to that row

Thx for ur help
Regards,
Charbel

Re: dataGridView

Nader Elshehabi5-Sep-06 12:06

Nader Elshehabi

5-Sep-06 12:06

Hello

MyDataGridView.FirstDisplayedCell = MyDataGridView.Rows[MyIndex].Cells[0];

Sorry! Requires .Net 2.0 Sniff | :^)

Regards

how to set focus to a child form after I clicked a TreeNode?

CooperWu5-Sep-06 0:05

CooperWu

5-Sep-06 0:05

hi all,
I have a MDIForm, contains a TreeView. I wanna set focus to a child form after I clicked a note.
But, the TreeView doesn't lost foucs. so, my question is:
how to set focus to a child form after I clicked a TreeNode?

and I googled this question, I got this:

<br />
Form newForm = this.CreateForm();//Or however you're doing it<br />
form.BeginInvoke((MethodInvoker)delegate(){form.Focus();});<br />

at MSDN Forums
but it doesn't work.
any help would be appreciate. Thanks.

COleVariant in C# ?

anderslundsgard4-Sep-06 23:33

anderslundsgard

4-Sep-06 23:33

I’m coding in C# and I am working with a COM object that I earlier in C++ made this call:

COleVariant varBeforeEnd(DISP_E_MEMBERNOTFOUND, VT_ERROR);<br />
hresult = pTemp->Add(knownObject, &varBeforeEnd );

How do I make the call in C#?

The IDE in VisualStudio say that the Add(…) function should have parameters like this:

Add(KownObject, ref object);

Any tip what to do with the second parameter? I’ve tried to block some primitive types like int and bool to an object, but I only get exceptions…

All tips are welcomed!

_____________________________

...and justice for all

APe

Re: COleVariant in C# ?

Guffa5-Sep-06 0:46

Guffa

5-Sep-06 0:46

You have to use the ref keyword when you call the method, and use a variable of type Object to reference:

object o = 42;
Add(knownObject, ref o);

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

Re: COleVariant in C# ?

anderslundsgard6-Sep-06 1:54

anderslundsgard

6-Sep-06 1:54

Found the solution:

Object obj = System.Reflection.Missing.Value;<br />
temp.Add(known, ref obj);

_____________________________

...and justice for all

APe

making a full screen application

Green Fuze4-Sep-06 23:33

Green Fuze

4-Sep-06 23:33

Hi everybody.

I want to write a full screen app. All that I want is a white dot on a black screen that moves up, down, left, right according to the keyboard.
Its all not complex at all if I would've done that on a window form, BUT I want to make it on a console (or whatever type of project it should be).

The problem is that I don't even know where to start to make such an application, can anyone at least give me directions where do I start? (an article maybe?).

Thanks!

Re: making a full screen application

Jonathan van de Veen5-Sep-06 0:28

Jonathan van de Veen

5-Sep-06 0:28

You could look into a DirectX app. I'm shure there are some articles on this site to help you out with that.

IPCChannel connection problem

GDavy4-Sep-06 23:08

GDavy

4-Sep-06 23:08

Hello there,
I'm trying to create a IPCChannel connection between 2 processes on my pc. The 1 process is a Windows Service and the other a Windows app.
The windows service is the client in this case. when doing the connection an exception is thrown saying:Failed to connect to an IPC Port: Access is denied.

When I debug this windows service (run it as a normal app not as a service), the code executes fine. So does anybody why as a Service the app is not allowed to connect and how I might fix this???

Thanks for any help you provide,
Greetings,
Davy

Re: IPCChannel connection problem

ejuanpp5-Sep-06 0:05

ejuanpp

5-Sep-06 0:05

I'm new to IPC but ...

Have you checked SecurityPermission attribute?

BTW if you know how to detect if IPC channels have been opened by the remote process, could you please tell me ?

Re: IPCChannel connection problem

Gomac5-Sep-06 5:41

Gomac

5-Sep-06 5:41

try setting account type to user on windows service. Just a stab in the dark though. I have IPC working over a windows service with account type as user

How to read values in GirdVew

Murtuza Husain Miyan Patel4-Sep-06 21:34

Murtuza Husain Miyan Patel

4-Sep-06 21:34

Dear Friends,

I have one small C# webapplication. I want to read the value of one typical coloumn of my gridview for each row in such a way that I am checking the status for one of my ItemTemplate called as checkbox1 as below

foreach (GridViewRow row in AppGrid.Rows)
{
bool st = ((CheckBox)row.FindControl("CheckBox1")).Checked;
" Here I need code to access the value of first coloumn which is bound as pCode for the same row "

}

Your quick response will be highly appreciated.

Thanks
Murtuza Patel

Re: How to read values in GirdVew

WillemM5-Sep-06 2:06

WillemM

5-Sep-06 2:06

You can retrieve values from a row by calling

String value = row.Cells[index].Text;

WM.

What about weapons of mass-construction?

Windows Application (SetROP2 function in c#)

rohita4-Sep-06 21:22

rohita

4-Sep-06 21:22

hai all,

is there any function for SetROP2 in c#.net. i want to use this SetROP2 function in C# which will take float values in draw mode

private static extern Int32 SetROP2(IntPtr hDevice, int nDrawMode)

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.