c# - Passing string to another class -


in myviewmodel have string property (searchbox) binded textbox in view. when click searchbutton command send datalayer class searchresult (images) db.

my problem how pass string searchbox along method use in datalayer class.

public class myviewmodel : notifyuibase {     private string _searchbox;     public string searchbox    // name property     {         { return this._searchbox; }         set { this._searchbox = value; raisepropertychanged(); }     }        public myviewmodel()     {         findimagecommand = new relaycommand(findimage);     }      public relaycommand findimagecommand { get; private set; }     private void findimage()     {         var dbfunctions = new databasefunctions();         findvisualreferences = dbfunctions.findvisualreferences();     } } 

in datalayer class need use string searchbox in query search db.

public class datalayer  {      public observablecollection<image> findvisualreferences()     {         var findvisualreferences = new observablecollection<image>();          string dbconnectionstring = @"data source =mydb.sqlite";          sqliteconnection cnn = new sqliteconnection(dbconnectionstring);         cnn.open();   ====>  string query = "select* images title = '" + searchbox.toupper() + "'";          sqlitedataadapter sda = new sqlitedataadapter(query, cnn);         datatable dt = new datatable();         sda.fill(dt);          // rest of db method     } } 

how string searchbox in myviewmodel query search database in datalayer class?

firstly, change method take in string paramter:

public observablecollection<image> findvisualreferences(string search) 

now, can pass in searchbox string when call method, so:

findvisualreferences = dbfunctions.findvisualreferences(searchbox); 

you can rewrite query reference parameter, this:

string query = "select* images title = '" + search.toupper() + "'"; 

now, @floris made point use parameters instead of string concatenation, recommend looking this, has been answered already.


Comments

Popular posts from this blog

toolbar - How to add link to user registration inside toobar in admin joomla 3 custom component -

linux - disk space limitation when creating war file -

How to provide Authorization & Authentication using Asp.net, C#? -