Loading Selected [C#]

[Nikolee]

Here i have an example for you, thats from my Cash Tool to see the Statpoints from the Character in a textbox

 

MySqlConnection con;
MySqlConnectionStringBuilder csb = new MySqlConnectionStringBuilder();
csb.Server = Server;
csb.UserID = user;
csb.Database = _Chardb;
csb.Password = pw;
con = new MySqlConnection(csb.ConnectionString);
MySqlConnection connection = new MySqlConnection(csb.ConnectionString);
connection.Open();

string _Sql1 = @"SELECT * FROM t_characters a_index WHERE a_nick='"+textBox16.Text+"'";
DataTable dttable = new DataTable();
MySqlCommand insertBann = new MySqlCommand(_Sql1, connection);
int i = insertBann.ExecuteNonQuery();
MySqlDataAdapter dtAdp = new MySqlDataAdapter(_Sql1, connection);
dtAdp.Fill(dttable);
string result = Convert.ToString(insertBann.ExecuteScalar());

DataTable datatable = new DataTable();
String sql1 = @"SELECT * FROM `t_characters` `a_statpt_dex` WHERE a_index =" + result + ";";
MySqlDataAdapter dataAdapter = new MySqlDataAdapter(sql1, connection);
dataAdapter.Fill(datatable);
textBox15.DataBindings.Add("Text", datatable, "a_statpt_dex"); // that is what are you searching for