Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. General Programming
  3. C#
  4. class problem!!

class problem!!

Scheduled Pinned Locked Moved C#
databasetestingbeta-testinghelp
3 Posts 3 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • X Offline
    X Offline
    xiaowenjie
    wrote on last edited by
    #1

    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

    S K 2 Replies Last reply
    0
    • X xiaowenjie

      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

      S Offline
      S Offline
      Stefan Troschuetz
      wrote on last edited by
      #2

      What do you mean exactly by "read ccF"? What do you want to read and where?


      www.troschuetz.de

      1 Reply Last reply
      0
      • X xiaowenjie

        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

        K Offline
        K Offline
        Ketty Avashia
        wrote on last edited by
        #3

        First 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

        1 Reply Last reply
        0
        Reply
        • Reply as topic
        Log in to reply
        • Oldest to Newest
        • Newest to Oldest
        • Most Votes


        • Login

        • Don't have an account? Register

        • Login or register to search.
        • First post
          Last post
        0
        • Categories
        • Recent
        • Tags
        • Popular
        • World
        • Users
        • Groups