skmr_ae
یک شنبه 10 اردیبهشت 1391, 18:21 عصر
سلام
عاجزانه خواهش میکنم
معادل این کد برای بانک اس کیو ال چیه؟؟؟
دوستان اگه کسی میدونه لطف کنه و بهم بگه
ممنون
(منتظرم دوستان محترم)
// Define the database query
string mySelectQuery="SELECT Name, Sales FROM REPS;";
// Create a database connection object using the connection string
OleDbConnection myConnection = new OleDbConnection(myConnectionString);
// Create a database command on the connection using query
OleDbCommand myCommand = new OleDbCommand(mySelectQuery, myConnection);
// Open the connection
myCommand.Connection.Open();
// Create a database reader
OleDbDataReader myReader = myCommand.ExecuteReader(CommandBehavior.CloseConne ction);
// Since the reader implements and IEnumerable, pass the reader directly into
// the DataBindTable method with the name of the Column to be used as the XValue
Chart1.DataBindTable(myReader, "Name");
// Close the reader and the connection
myReader.Close();
myConnection.Close();
//=============
// Define the database query
string mySelectQuery="SELECT * FROM REPS;";
// Create a database connection object using the connection string
OleDbConnection myConnection = new OleDbConnection(myConnectionString);
// Create a database command on the connection using query
OleDbCommand myCommand = new OleDbCommand(mySelectQuery, myConnection);
// Set chart data source
chart1.DataSource = myCommand;
// Set series members names for the X and Y values
chart1.Series["Series 1"].XValueMember = "Name";
chart1.Series["Series 1"].YValueMembers = "Sales";
// Data bind to the selected data source
chart1.DataBind();
عاجزانه خواهش میکنم
معادل این کد برای بانک اس کیو ال چیه؟؟؟
دوستان اگه کسی میدونه لطف کنه و بهم بگه
ممنون
(منتظرم دوستان محترم)
// Define the database query
string mySelectQuery="SELECT Name, Sales FROM REPS;";
// Create a database connection object using the connection string
OleDbConnection myConnection = new OleDbConnection(myConnectionString);
// Create a database command on the connection using query
OleDbCommand myCommand = new OleDbCommand(mySelectQuery, myConnection);
// Open the connection
myCommand.Connection.Open();
// Create a database reader
OleDbDataReader myReader = myCommand.ExecuteReader(CommandBehavior.CloseConne ction);
// Since the reader implements and IEnumerable, pass the reader directly into
// the DataBindTable method with the name of the Column to be used as the XValue
Chart1.DataBindTable(myReader, "Name");
// Close the reader and the connection
myReader.Close();
myConnection.Close();
//=============
// Define the database query
string mySelectQuery="SELECT * FROM REPS;";
// Create a database connection object using the connection string
OleDbConnection myConnection = new OleDbConnection(myConnectionString);
// Create a database command on the connection using query
OleDbCommand myCommand = new OleDbCommand(mySelectQuery, myConnection);
// Set chart data source
chart1.DataSource = myCommand;
// Set series members names for the X and Y values
chart1.Series["Series 1"].XValueMember = "Name";
chart1.Series["Series 1"].YValueMembers = "Sales";
// Data bind to the selected data source
chart1.DataBind();