Re: SQL connection in the app.config file? - C# Discussion Boards

ZurdoDev29-Oct-14 3:35

ZurdoDev

29-Oct-14 3:35

This does not make any sense. Do you have a question?

There are only 10 types of people in the world, those who understand binary and those who don't.

PIEBALDconsult29-Oct-14 4:12

PIEBALDconsult

29-Oct-14 4:12

What are you trying to accomplish? How does SSMS come in to play?
Is it simply that you are trying to connect SSMS to a database and you don't know which parts of a connection string to use?

Simon_Whale29-Oct-14 5:38

Simon_Whale

29-Oct-14 5:38

Not sure what you are trying to achieve? Are you after connecting to your SQL Server database?

If so I would look at http://www.connectionstrings.com/sql-server/[^] That will show you how to configure / create a connection string that you can use within ado.net

this MSDN sqlconnection[^] will show you an example of how to connect to your database using the sqlconnection object.

Every day, thousands of innocent plants are killed by vegetarians.

Help end the violence EAT BACON

Gerry Schmitz29-Oct-14 10:45

Gerry Schmitz

29-Oct-14 10:45

Use the ConfigurationManager class to retrieve connection strings from configuration files, and the SqlConnectionStringBuilder class to handle connection string values.

Member 245846729-Oct-14 23:05

Member 2458467

29-Oct-14 23:05

i save connectstring warning error: The index being passed in is out of range

[CODE]
public void updateConfigFile(string con)
{
//updating config file
XmlDocument XmlDoc = new XmlDocument();
//Loading the Config file
XmlDoc.Load(AppDomain.CurrentDomain.SetupInformation.ConfigurationFile);
foreach (XmlElement xElement in XmlDoc.DocumentElement)
{
if (xElement.Name == "connectionStrings")
{
//setting the connection string
xElement.FirstChild.Attributes[2].Value = con; // error here
}
}
//writing the connection string in config file
XmlDoc.Save(AppDomain.CurrentDomain.SetupInformation.ConfigurationFile);
}
[/CODE]

Gerry Schmitz29-Oct-14 23:43

Gerry Schmitz

29-Oct-14 23:43

You are on the right track, but there are easier ways to accomplish what you want.

Check out this link for "Connection Strings and Configuration Files":

http://msdn.microsoft.com/en-us/library/ms254494(v=vs.100).aspx[^]

And check out the link for "Connection String Builders":

http://msdn.microsoft.com/en-us/library/ms254947(v=vs.100).aspx[^]

Member 245846730-Oct-14 16:29

Member 2458467

30-Oct-14 16:29

when running the program does not understand why the folder bin\Debug\ always appear 2 files: Myprogram.exe.config (file containing an unencrypted connection string) and Myprogram.vshost.exe.config (containing the string encrypted connection), it normally only files appear Myprogram.exe.config why appear another file ? how can I turndown one file ?

Not an asynchronous query(that just unblocks the calling thread) but an asynchronously *yielding* query

Gerry Schmitz30-Oct-14 21:00

Gerry Schmitz

30-Oct-14 21:00

Myprogram.exe.config is what you distribute with your app.

Myprogram.vshost.exe.config is used when running within Visual Studio (and is NOT needed when you distribute your app).

HOWEVER, you should be building a "release" version (bin\Release) of your app when ready and using the EXE and config file for distribution from there.

Why one is encrypted and not the other is probably due to the way you are testing.

Build a "release" version of your app, run the EXE directly from the bin\Release folder and then check Myprogram.exe.config again.

If you need more info, start here:

http://stackoverflow.com/questions/774187/what-is-the-purpose-of-vshost-exe-file[^]

Most of this stuff is already out there if you just Google it.

Alaric_28-Oct-14 13:26

Re: Not an asynchronous query(that just unblocks the calling thread) but an asynchronously *yielding* query

28-Oct-14 13:26

Ok..so create a table in SQL Server with a [varchar](50) primary key and insert 500,000 dummy rows into the table. Now, in SSMS, select all rows from that table and you will see results immediately display in the Results window while the query is still running.

Opening an ADO.NET connection while awaiting an async reader will allow the thread to continue doing *different* work while the query runs, but I want to yield the results from my data layer to a UI layer as SQL Server prepares and marshals them.

Does anyone have any working samples (technology agnostic) or any links they can direct me towards?

"I need build Skynet. Plz send code"

Alaric_29-Oct-14 6:07

29-Oct-14 6:07

Figured it out. never mind.

"I need build Skynet. Plz send code"

need code for project

Member 1106350128-Oct-14 8:47

Member 11063501

28-Oct-14 8:47

hi....
plz help me .....i urgently need code to implement FP Growth Algorithm in C#....mail it to me at
anil.nagar19@gmail.com

Eddy Vluggen28-Oct-14 9:02

28-Oct-14 9:02

Voted as abuse.

You are asking volunteers that answer questions in their own spare time to do your work. There is no urgency here.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

OriginalGriff28-Oct-14 9:05

28-Oct-14 9:05

Eddy Vluggen wrote:
There is no urgency here

Yes there is!

He has to hand it in to his tutor tomorrow! Laugh | :laugh:

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

Eddy Vluggen28-Oct-14 9:39

28-Oct-14 9:39

Doesn't look like homework to me Smile | :)

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

OriginalGriff28-Oct-14 9:42

28-Oct-14 9:42

It's a data mining algorithm that only ever gets used on university courses, AFAIK Laugh | :laugh:

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

Eddy Vluggen28-Oct-14 10:38

28-Oct-14 10:38

Jacking up the curriculum with useless bullshit.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

OriginalGriff28-Oct-14 10:42

28-Oct-14 10:42

How much of the stuff they force-fed you during the last ten years at school have you used in anger since you stopped formal education? Probably as much as I have: little or nothing! Laugh | :laugh:

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

Eddy Vluggen28-Oct-14 11:07

28-Oct-14 11:07

Touché.

Alaric_28-Oct-14 10:15

28-Oct-14 10:15

(see signature) SEND THE CODEZ NOWZ!!!!!

"I need build Skynet. Plz send code"

OriginalGriff28-Oct-14 10:25

28-Oct-14 10:25

using System;
namespace MyHomework
{
    class Homework
    {
        static void Main()
        {
            Console.WriteLine("Hello World!");

            ExerciseForTheReader.DoFPAlgorithm();

            Console.WriteLine("Press any key to exit.");
            Console.ReadKey();
        }
    }
}

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

Alaric_28-Oct-14 13:17

28-Oct-14 13:17

Awesome sauce...but I don't care about an FP Algorithm. I need your codes for Skynet.

I know you're holding out on me.
Send code to 69inGCh1pmunks@gmail.com.
Thanks!

"I need build Skynet. Plz send code"

modified 28-Oct-14 19:31pm.

OriginalGriff28-Oct-14 9:04

28-Oct-14 9:04

1) Never post your email address in any forum, unless you really like spam! If anyone replies to you, you will receive an email to let you know.
2) It may be urgent to you, but it isn't to us. All that your stressing the urgency does is to make us think you have left it too late, and want us to do it for you. This annoys some people, and can slow a response.
3) No. We do not do your homework: it is set for a reason. It is there so that you think about what you have been told, and try to understand it. It is also there so that your tutor can identify areas where you are weak, and focus more attention on remedial action.

Try it yourself, you may find it is not as difficult as you think!

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...