rastinrastini
سه شنبه 09 تیر 1388, 06:37 صبح
به نام خدا
سلام به همه
class editDBClass
{
int ProgramID;
public SqlConnection myConnection;
public SqlDataAdapter myDataAdapter;
public SqlCommandBuilder myCommandBuilder;
public DataSet myDataSet = new DataSet();
public editDBClass(string dbName,string tableName,string []fieldNames,string sql)
{
string a="";
for (int i = 0; i < fieldNames.Length; i++)
{
a += fieldNames[i];
}
SqlConnection thisConnection = new SqlConnection(@"Data Source=.\SQLEXPRESS;" +
@"AttachDbFilename='|DataDirectory|\"+dbName+"';" +
@"Integrated Security=True;connection Timeout=30;User Instance=True");
SqlDataAdapter thisAdapter = new SqlDataAdapter(
"SELECT "+a+ " from "+tableName, thisConnection);
SqlCommandBuilder thisCommandBuilder = new SqlCommandBuilder(thisAdapter);
myConnection = thisConnection;
myDataAdapter = thisAdapter;
myCommandBuilder = thisCommandBuilder;
myDataAdapter.Fill(myDataSet, "ProgramTable");
}
public editDBClass(string dbAddress, string dbName, string tableName, string[] fieldNames)
{
string a = "";
for (int i = 0; i < fieldNames.Length; i++)
{
a += fieldNames[i];
}
SqlConnection thisConnection = new SqlConnection(@"Data Source=.\SQLEXPRESS;" +
@"AttachDbFilename='"+dbAddress+"'" + dbName + "'';" +
@"Integrated Security=True;connection Timeout=30;User Instance=True");
SqlDataAdapter thisAdapter = new SqlDataAdapter(
"SELECT " + a + " from " + tableName, thisConnection);
SqlCommandBuilder thisCommandBuilder = new SqlCommandBuilder(thisAdapter);
myConnection = thisConnection;
myDataAdapter = thisAdapter;
myCommandBuilder = thisCommandBuilder;
myDataAdapter.Fill(myDataSet, "ProgramTable");
}
~editDBClass()
{
myConnection.Close();
}
این کد باز کردن پایگاه داده و جدول من هست اما وقتی می زنم جدول جدیدی که بطور دستی در پایگاه داده ساختم از بین میره کسی میدونه چرا؟
موفق باشید.
خدانگهدار.
سلام به همه
class editDBClass
{
int ProgramID;
public SqlConnection myConnection;
public SqlDataAdapter myDataAdapter;
public SqlCommandBuilder myCommandBuilder;
public DataSet myDataSet = new DataSet();
public editDBClass(string dbName,string tableName,string []fieldNames,string sql)
{
string a="";
for (int i = 0; i < fieldNames.Length; i++)
{
a += fieldNames[i];
}
SqlConnection thisConnection = new SqlConnection(@"Data Source=.\SQLEXPRESS;" +
@"AttachDbFilename='|DataDirectory|\"+dbName+"';" +
@"Integrated Security=True;connection Timeout=30;User Instance=True");
SqlDataAdapter thisAdapter = new SqlDataAdapter(
"SELECT "+a+ " from "+tableName, thisConnection);
SqlCommandBuilder thisCommandBuilder = new SqlCommandBuilder(thisAdapter);
myConnection = thisConnection;
myDataAdapter = thisAdapter;
myCommandBuilder = thisCommandBuilder;
myDataAdapter.Fill(myDataSet, "ProgramTable");
}
public editDBClass(string dbAddress, string dbName, string tableName, string[] fieldNames)
{
string a = "";
for (int i = 0; i < fieldNames.Length; i++)
{
a += fieldNames[i];
}
SqlConnection thisConnection = new SqlConnection(@"Data Source=.\SQLEXPRESS;" +
@"AttachDbFilename='"+dbAddress+"'" + dbName + "'';" +
@"Integrated Security=True;connection Timeout=30;User Instance=True");
SqlDataAdapter thisAdapter = new SqlDataAdapter(
"SELECT " + a + " from " + tableName, thisConnection);
SqlCommandBuilder thisCommandBuilder = new SqlCommandBuilder(thisAdapter);
myConnection = thisConnection;
myDataAdapter = thisAdapter;
myCommandBuilder = thisCommandBuilder;
myDataAdapter.Fill(myDataSet, "ProgramTable");
}
~editDBClass()
{
myConnection.Close();
}
این کد باز کردن پایگاه داده و جدول من هست اما وقتی می زنم جدول جدیدی که بطور دستی در پایگاه داده ساختم از بین میره کسی میدونه چرا؟
موفق باشید.
خدانگهدار.