DataSet Constructor
.NET Framework 4
Initializes a new instance of the DataSet class.
This member is overloaded. For complete information about this member, including syntax, usage, and examples, click a name in the overload list.
| Name | Description | |
|---|---|---|
|
DataSet() | Initializes a new instance of the DataSet class. |
|
|
DataSet(String) | Initializes a new instance of a DataSet class with the given name. |
|
DataSet(SerializationInfo, StreamingContext) | Infrastructure. Initializes a new instance of a DataSet class that has the given serialization information and context. |
|
|
DataSet(SerializationInfo, StreamingContext, Boolean) | Infrastructure. Initializes a new instance of the DataSet class. |
Example SQL Interface Code
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;
namespace STS
{
class Sql
{
public static DataTable SqlSelect(string strStatement, string strDB)
{
string strConnectionString = "";
strConnectionString += "server=" + Constants.strSqlServer;
if (!Constants.strSqlInstance.Equals(""))
{
strConnectionString += "\\" + Constants.strSqlInstance;
}
strConnectionString += ";";
strConnectionString += "database=" + strDB + ";";
strConnectionString += "User ID=" + Constants.strSqlUser + ";Password=" + Constants.strSqlPwd + ";";
SqlConnection SqlConnection = new SqlConnection(strConnectionString);
SqlCommand SqlCommand = SqlConnection.CreateCommand();
SqlCommand.CommandText = strStatement;
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter();
sqlDataAdapter.SelectCommand = SqlCommand;
DataSet myDataSet = new DataSet();
SqlConnection.Open();
sqlDataAdapter.Fill(myDataSet, "Data");
DataTable SqlDataTable = myDataSet.Tables["Data"];
SqlConnection.Close();
return SqlDataTable;
}
public static string[] GetRandomUser()
{
string[] result;
string command = "select top 1 username from users ORDER BY NEWID()";
System.Data.DataTable data = Sql.SqlSelect(command, "Users");
if (data.Rows.Count != 0)
{
result = new string[2];
result[0] = (string)data.Rows[0][0];
result[1] = (string)data.Rows[0][1];
}
else
{
result = null;
}
return result;
}
}
}
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;
namespace STS
{
class Sql
{
public static DataTable SqlSelect(string strStatement, string strDB)
{
string strConnectionString = "";
strConnectionString += "server=" + Constants.strSqlServer;
if (!Constants.strSqlInstance.Equals(""))
{
strConnectionString += "\\" + Constants.strSqlInstance;
}
strConnectionString += ";";
strConnectionString += "database=" + strDB + ";";
strConnectionString += "User ID=" + Constants.strSqlUser + ";Password=" + Constants.strSqlPwd + ";";
SqlConnection SqlConnection = new SqlConnection(strConnectionString);
SqlCommand SqlCommand = SqlConnection.CreateCommand();
SqlCommand.CommandText = strStatement;
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter();
sqlDataAdapter.SelectCommand = SqlCommand;
DataSet myDataSet = new DataSet();
SqlConnection.Open();
sqlDataAdapter.Fill(myDataSet, "Data");
DataTable SqlDataTable = myDataSet.Tables["Data"];
SqlConnection.Close();
return SqlDataTable;
}
public static string[] GetRandomUser()
{
string[] result;
string command = "select top 1 username from users ORDER BY NEWID()";
System.Data.DataTable data = Sql.SqlSelect(command, "Users");
if (data.Rows.Count != 0)
{
result = new string[2];
result[0] = (string)data.Rows[0][0];
result[1] = (string)data.Rows[0][1];
}
else
{
result = null;
}
return result;
}
}
}
- 9/8/2011
- Josh Buechel
