class problem!!
-
hi, i've got this window form. i need to pass this value string d into another class to do some dbconnection..
public class Form1 : System.Windows.Forms.Form { public string d = "20"; . . . . private void testing() { dbConnection dbcon = new dbConnection(); dbcon.Connection() } }//end of class Form1 public class dbConnection { public OleDbConnection conn; public string SQL ; public OleDbCommand cmd; public OleDbDataAdapter adpt; public DataSet ds; public dbConnection() { conn = new System.Data.OleDb.OleDbConnection(); conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" + "Data source = "+Application.StartupPath +@"\db.mdb"; } public void Connection() { Form1 ccF = new Form1(); SQL = "SELECT * FROM Table WHERE ID <='" + (ccF.d) + "'"; cmd = new System.Data.OleDb.OleDbCommand (SQL, conn); adpt = new System.Data.OleDb.OleDbDataAdapter(cmd); ds = new System.Data.DataSet(); adpt.Fill(ds,"Table "); } }//end of class dbConnection
my problem is that it can't read ccF.d.. sorry im kinda bad in using class.. Chris -
hi, i've got this window form. i need to pass this value string d into another class to do some dbconnection..
public class Form1 : System.Windows.Forms.Form { public string d = "20"; . . . . private void testing() { dbConnection dbcon = new dbConnection(); dbcon.Connection() } }//end of class Form1 public class dbConnection { public OleDbConnection conn; public string SQL ; public OleDbCommand cmd; public OleDbDataAdapter adpt; public DataSet ds; public dbConnection() { conn = new System.Data.OleDb.OleDbConnection(); conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" + "Data source = "+Application.StartupPath +@"\db.mdb"; } public void Connection() { Form1 ccF = new Form1(); SQL = "SELECT * FROM Table WHERE ID <='" + (ccF.d) + "'"; cmd = new System.Data.OleDb.OleDbCommand (SQL, conn); adpt = new System.Data.OleDb.OleDbDataAdapter(cmd); ds = new System.Data.DataSet(); adpt.Fill(ds,"Table "); } }//end of class dbConnection
my problem is that it can't read ccF.d.. sorry im kinda bad in using class.. Chris -
hi, i've got this window form. i need to pass this value string d into another class to do some dbconnection..
public class Form1 : System.Windows.Forms.Form { public string d = "20"; . . . . private void testing() { dbConnection dbcon = new dbConnection(); dbcon.Connection() } }//end of class Form1 public class dbConnection { public OleDbConnection conn; public string SQL ; public OleDbCommand cmd; public OleDbDataAdapter adpt; public DataSet ds; public dbConnection() { conn = new System.Data.OleDb.OleDbConnection(); conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" + "Data source = "+Application.StartupPath +@"\db.mdb"; } public void Connection() { Form1 ccF = new Form1(); SQL = "SELECT * FROM Table WHERE ID <='" + (ccF.d) + "'"; cmd = new System.Data.OleDb.OleDbCommand (SQL, conn); adpt = new System.Data.OleDb.OleDbDataAdapter(cmd); ds = new System.Data.DataSet(); adpt.Fill(ds,"Table "); } }//end of class dbConnection
my problem is that it can't read ccF.d.. sorry im kinda bad in using class.. ChrisFirst check that u have called ur testing function at some point in ur Form1. Second I tried ur code and it works for me as far as reading ccF.d is concerned. So i guess there is come problem in the way ur accessing it. My working code of Form 1 is as under public class Form1 : System.Windows.Forms.Form { public string d = "HI"; private void Form1_Load(object sender, System.EventArgs e) { testing(); } private void testing() { dbConnection dbcon = new dbConnection(); MessageBox.Show(dbcon.Connection()); } } public class dbConnection { public string SQl; public string Connection() { Form1 ccF = new Form1(); return SQl = ccF.d; } } Ketty