C#

        public SqlDataReader GetData()
        {
            SqlDataReader rd;
            SqlConnection con;
            SqlCommand cmd = new SqlCommand();

            string ConnectionString = "server=INDUS-SERVER;uid=sa;pwd=victory;database=northwind";

            con = new SqlConnection(ConnectionString);

            cmd.CommandText = "SELECT FirstName, LastName" + "FROM Employees" + "WHERE (LastName LIKE @Find)";

            cmd.Connection = con;

            cmd.Parameters.Add(new SqlParameter("@Find", SqlDbType.NVarChar, 20, "LastName"));

            cmd.Parameters["@Find"].Value = txtFind.Text;

            try
            {
                con.Open();

                // Execute the query
                rd = cmd.ExecuteReader();
                rd.Close();

                con.Close();
            }
            catch (SqlException e)
            {
                Messagebox.show(e.Message);
            }
            return rd;
        }
    }
}

this.dataGridView1.KeyPress +=new KeyPressEventHandler(dataGridView1_KeyPress);<br />
<br />
private void dataGridView1_KeyPress(object sender,KeyPressEventArgs e)<br />
{<br />
    int i;<br />
    i = ((DataGridView)sender).CurrentRow.Index;<br />
}

srisravani wrote:

implements interface ISortable