SNK111

To connect to SQL Server from C#.NET, you need to create a connection string such as below: [CODE]private SqlConnection connection; private string connectionString = @"Server=(local);Database=Embedding_SQL_Test;User ID=sa;Password=123"; connection = new SqlConnection( connectionString );[/CODE] Next, you use the SqlConnection object created above to create a 'SqlCommand', as shown below: [CODE]SqlCommand cmd = …

I agree with steelshark; it seems this will have to be web application which will be connecting to a database. You can use a language such as C# and a database such as Microsoft SQL Server. To connect to SQL Server from C#.NET, you need to create a connection string …

To connect to SQL Server, you need to create a connection string such as below: private SqlConnection connection; private string connectionString = @"Server=(local);Database=Embedding_SQL_Test;User ID=sa;Password=123"; connection = new SqlConnection( connectionString ); Next, you use the SqlConnection object created above to create a 'SqlCommand', as shown below: SqlCommand cmd = new SqlCommand( …

Check this article ([I]<<snip>>[/I]) for details on how to connect to SQL Server database from C#.NET database applications as well as Java database applications. It also describes how to pass embedded SQL queries (SELECT, INSERT, UPDATE, DELETE), calling stored procedures, pass parameters etc.

You can check this article (<URL SNIPPED>HOW TO: SQL in JAVA) for the best practices on how to connect to SQLServer from Java. It also describes how pass SQL queries, pass parameters, call stored procedures etc.

Check this link ( <URL SNIPPED> ) for a reply to your question. Here you will find detailed description of how to connect to a SQL server database from a Java database application and pass embedded SQL queries. It describes how to create the connection string, pass parameters to the …