أرجو المساعدة السريعة فى الربط بين vb6 و vb.net وبين SQL Oracle

المنتدي منتدي جافا ، و ليس .net

و لوعاوز تربط بين .net و sql server :

الحل حاجه زي كده، موش كده بالظبط ،

// use these namespaces
using System.Data;
using System.Data.sqlclient;

// then write this code in the main method :

// You can use connected mode : 
SqlConnection conn = new SqlConnection ("connection string, you can get it from any ado.net book");

String query = " select name, password from employees ";
SqlCommand cmd = new SqlCommand ();
cmd.commandType = CommandType.text;
cmd.Connection = conn;
cmd.CommandText = query;

SqlDataReader rdr = cmd.executeReader();

while ( rdr.Read()){
	Console.WriteLine ( rdr.GetValue(0) + rdr.GetValue(1) );
}

//or you can use disconnected mode :
SqlConnection conn = new SqlConnection ("connection string, you can get it from any ado.net book");

String query = " select name, password from employees ";

SqlDataAdapter sa = new SqlDataAdapter (conn, query);

DataSet ds = new DataSet();

sa.fill ( ds );

foreach ( DataRow dr in ds.Tables[0].Rows ){
	Console.WriteLine ( dr[0] + ", "  + dr[1] );
}