Not an asynchronous query(that just unblocks the calling thread) but an asynchronously *yielding* query - C# Discussion Boards

First Prev Next

Re: SQL connection in the app.config file?

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?

Re: SQL connection in the app.config file?

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

Re: SQL connection in the app.config file?

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.

Re: SQL connection in the app.config file?

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]

Re: SQL connection in the app.config file?

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[^]

Re: SQL connection in the app.config file?

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 ?

Re: SQL connection in the app.config file?

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.

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

Alaric_28-Oct-14 13:26

Alaric_

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"

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

Alaric_29-Oct-14 6:07

Alaric_

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