C# - SQL Server Connection

sure you can do so as u open one connection and you can get your data in dataset and each time you need a new data you can clear this dataset

طبعا ممكن يا باشا ........ حط ال connection في class فيها function من نوع SQLConnection بتعمل return لل connection

مثال :

using System;
using System.Data;
using System.Data.SqlClient;

namespace Dentistry_system
{
	/// <summary>
	/// Summary description for Connection.
	/// </summary>
	public class Connection
	{
		public static SqlConnection connection()
		{
			SqlConnection con=new SqlConnection();			
			con.ConnectionString="workstation id=local;packet size=4096;integrated security=SSPI;initial catalog=MyDBName;persist security info=False";
			return con;
		}
	}
}

وبعد كده في أي form استخدمها كالتالي :

SqlConnection MyConn = Connection.Connection();

وهكذا

جزاكم الله خيرا كثيراااااااااااااااااااا

نجحت الفكرة

:rolleyes: