Friday, October 15, 2010

C# Code : Connection strings for SQL Server 2008

using System.Data.SqlClient;

private void ValidationFile()
{
 string FilePath = "";
 using (SqlConnection myConnection = new SqlConnection("Data Source=servername;Initial Catalog=db_name;User ID=user;Password=pass;"))
                {
 using (SqlCommand myCommand = new SqlCommand("select scanned_document_id, master_id, file_path from scanned_documents", myConnection))
                            {
                                myCommand.CommandType = CommandType.Text;
                                myConnection.Open();
                                using (SqlDataReader myReader = myCommand.ExecuteReader())
                                      {
                                            if (myReader.HasRows)
                                                  {
                                                       while (myReader.Read())
                                                           {
                                                               FilePath = 
                                                               myReader.GetString(myReader.GetOrdinal("file_path"));                           
                                                            }
                                                    }
                                       }
                              }
                }
 }

No comments:

Post a Comment