Find & Find next

[ARRN_Magic-Systems]

دوستان روش شما واسه Find کردن در ADO .net طوري که رکوردست رو به جايي که رکورد پيدا شده تغيير بديم
و رکوردهاي پيدا شده رو در کنترل مجزايي نريزيم مثل حالت معمولي در ado
ado.recordset .find چيه

من کد زير رو دارم ولي واسه تغييرش براي وقتيکه از ado .net codeاستفاده ميکنم
يعني کنترل ديتاست رو رو فرم درگ نميکنم د رخط
dsFilms.tblfilmsRow cr
مشکل دارم چون اين ويژگي در زمانيکه ديتاست رو رو فرم اد نکردين و در زمان اجرا با کد و با اعلان زير ساختين
نمياد
private System.Data.DataSet dsFilms




------------

کد:

System.Data.DataView dv = this.dsFilms1.tblfilms.DefaultView;  
int id;
int idx;

string name;
System.Data.DataTable dt = this.dsFilms1.tblfilms;  
dsFilms.tblfilmsRow cr;
System.Data.DataRow[] dr;
name = TextBox1.Text;
try
{
dr = dt.Select("name = '" + name + "'");
cr = (dsFilms.tblfilmsRow) dr[0];
id =Convert.ToInt32( cr.serial) ;
idx = dv.Find(id);
this.BindingContext[this.dsFilms1, "tblfilms"].Position = idx;
}
catch
{
MessageBox.Show("name " + name + " not found", "Error");
}

[ARRN_Magic-Systems]

:?: :?: :?: :!: :!: :!:

[kimia]

سلام
اين كد يك كلاس در سي شارپ هستش كه فكر نمي كنم براي كار با بانك اطلاعاتي چيزي كم داشته باشه. بايد بهش جملات اس كيو ال بدي و بعد هم جواب رو برميگردونه يا در قالب آرايه و يا در قالب عدد و رشته.

کد:

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data ;
using System.Data.SqlClient ;
using System.Data.Odbc ;
using System.Data.OleDb ;

namespace Reporter
{
    public class Database
    {
        /*********************** DEFINE VARIABLE ****************************/

        private DataSet myDataSet = new DataSet ();
        private SqlConnection myConnection;
        private string strSql;
        private string ConnectionString;
        private SqlDataAdapter myDataAdapter;
        private DataRow newRow;
        private SqlCommandBuilder cb;    
        private SqlCommand myCommand = new SqlCommand ();

        /********************************************************************/
        
        #region Database()
            public Database(string connectionString)
            {
                try
                {
                    ConnectionString = connectionString;
                    myConnection = new SqlConnection(connectionString);
                    myDataAdapter = new SqlDataAdapter( strSql,myConnection);
                }
                catch(Exception ex)
                {
                    MessageBox.Show  ("Database.DataBase  >  " + ex.Message );
                }
            } // database
        #endregion

        #region SetField
            public void SetField(string TableName, string Field, string Value)
            {
                try
                {
                    strSql = "SELECT * from " + TableName;
                    myDataAdapter.Fill (myDataSet,TableName);
                    newRow = myDataSet.Tables [TableName].NewRow ();
                    newRow[Field] = Value;    
                    myDataSet.Tables [TableName].Rows.Add (newRow);
                    cb = new SqlCommandBuilder (myDataAdapter);
                    myDataAdapter = cb.DataAdapter;
                    myDataAdapter.Update (myDataSet, TableName);
                }
                catch (Exception ex)
                {
                    MessageBox.Show (ex.Message .ToString ());            
                }
            }//SetField
        #endregion

        #region GetRow
            // return the first result in <Data>
            public void GetRow(string SQL_Command, string[] Data)
            {
                try
                {
                    myConnection.Open();
                
                    string mySelectQuery = SQL_Command;
                
                    SqlCommand myCommand = new SqlCommand(mySelectQuery, myConnection);
                                                
                    myCommand.ExecuteScalar();
                
                    SqlDataReader myReader = myCommand.ExecuteReader();
                
                    if ( !myReader.Read () )
                    {
                        MessageBox.Show ("Database.GetRow > : No Find Any Data !");
                        return;                
                    }
            
                    myReader.GetValues (Data);
                
                    myReader.Close();

                    myConnection.Close();
                }
                catch(Exception ex)
                {
                    MessageBox.Show ("Server LecturerList> "+ex.Message .ToString ());            
                }
            }// GetRow
        #endregion

        #region ExecuteSQL
            public void ExecuteSQL(string SQL_String, string ConnectionString)// Execute an SQL statement
            {
                try
                {
                    //SqlConnection myConnection = new SqlConnection("workstation id=SAJEDEH;packet size=4096;integrated security=SSPI;initial catalog=VideoDB;persist security info=False");
                    SqlConnection myConnection = new SqlConnection(ConnectionString);
        
                    SqlCommand myCommand = new SqlCommand(SQL_String, myConnection);//,myTrans);

                    myConnection.Open();

                    myCommand.ExecuteNonQuery ();

                    myConnection.Close ();
                }
                catch (Exception ex)
                {
                    MessageBox.Show ("Database.ExecuteSQL > " + ex.Message);
                }
            }//SetField
        #endregion

        #region GetRows
        // return the first result in <Data>
        public void GetRows(string SQL_Command, string[,] Data)
        {
            try
            {
                myConnection.Open();
                
                string mySelectQuery = SQL_Command;
                
                SqlCommand myCommand = new SqlCommand(mySelectQuery, myConnection);
                                                
                myCommand.ExecuteScalar();
                
                SqlDataReader myReader = myCommand.ExecuteReader();
                
                if ( !myReader.Read () )
                {
                    MessageBox.Show ("Database.GetRows > : No Find Any Data !");
                    return;                
                }
            

                int Row=0;
                int i=0;
                string[] s = new string [myReader.FieldCount];
                
                while (myReader.HasRows )            
                {                                        
                    myReader.GetValues (s);
                    
                    for (i=0 ;i<myReader.FieldCount ; i++)
                        Data[Row,i] = s[i];
                    
                    Row++;

                    if (! myReader.Read() )
                        break;
                    
                }
                
                myReader.Close();

                myConnection.Close();
            }
            catch(Exception ex)
            {
                MessageBox.Show ("Database.GetRows > "+ex.Message .ToString ());            
            }
        }// GetRow
        #endregion

        #region GetTableRows
        // return number of rows in specified table
        public int GetTableRows(string TableName)
        {    
            myConnection.Open();
                
            string mySelectQuery = "SELECT COUNT(*) FROM " + TableName;
                
            SqlCommand myCommand = new SqlCommand(mySelectQuery, myConnection);
                                                
            int n = (int)myCommand.ExecuteScalar();
    
            myConnection.Close ();

            return n;
        
        } // GetTableRows
        #endregion

        #region GetTablaCols
        // return number of cols in specified table
        public int GetTableCols(string TableName)
        {
    
            myConnection.Open();
                
            string mySelectQuery = "SELECT * FROM " + TableName;
                
            SqlCommand myCommand = new SqlCommand(mySelectQuery, myConnection);
                                                
            myCommand.ExecuteScalar();
                
            SqlDataReader myReader = myCommand.ExecuteReader();

            int cols = myReader.FieldCount ;
            myReader.Close ();
            myConnection.Close ();

            return cols;
                
        } // GetTableCols
        #endregion

        #region SaveRow

        public void SaveRow(string TableName, string [] myData)
        {
            try
            {
                int i;

                strSql = "SELECT * from " + TableName;

                myDataAdapter = new SqlDataAdapter( strSql,myConnection);
            
                myDataAdapter.Fill (myDataSet,TableName);
                newRow = myDataSet.Tables [TableName].NewRow ();
                
                for (i=0;i<myData.Length;i++ )
                    newRow[i] = myData[i];

                myDataSet.Tables [TableName].Rows.Add (newRow);
                cb = new SqlCommandBuilder (myDataAdapter);
                myDataAdapter = cb.DataAdapter;
                myDataAdapter.Update (myDataSet, TableName);
            }
            catch (Exception ex)
            {
                MessageBox.Show ("In <SaveRow> : " + ex.Message .ToString ());            
            }        
        
        }//SaveRow
        #endregion         

        public int GetScalar(string SQL_Command)
        {
            try
            {
                myConnection.Open();
                                
                SqlCommand myCommand = new SqlCommand(SQL_Command, myConnection);
                                                
                int n = (int)myCommand.ExecuteScalar();
    
                myConnection.Close ();

                return n;
            }
            catch(Exception ex)
            {
                MessageBox.Show (ex.Message );
                return -1;
            }
            
        
        } // GetScalar

    }//class
}//namespace