søndag 17. mai 2009

SQL query tool

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace database_v3
{
public partial class frmSQLTester : Form
{
public frmSQLTester()
{
InitializeComponent();
}
SqlConnection booksConnection;
private void frmSQLTester_Load(object sender, EventArgs e)
{
booksConnection = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=DataDirectory\\sakerDB.mdf;Integrated Security=True;User Instance=True");
}
private void frmSQLTester_FormClosing(object sender, FormClosingEventArgs e)
{
booksConnection.Close();
booksConnection.Dispose();
}
private void btnTest_Click(object sender, EventArgs e)
{
SqlCommand resultsCommand = null;
SqlDataAdapter resultsAdapter = new SqlDataAdapter();
DataTable resultsTable = new DataTable();
try
{
// establish command object and data adapter
resultsCommand = new SqlCommand(txtSQLTester.Text, booksConnection);
resultsAdapter.SelectCommand = resultsCommand;
resultsAdapter.Fill(resultsTable);
// bind grid view to data table
grdSQLTester.DataSource = resultsTable;
lblRecords.Text = resultsTable.Rows.Count.ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error in Processing SQL", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
resultsCommand.Dispose();
resultsAdapter.Dispose();
resultsTable.Dispose();
}
}
}

Ingen kommentarer:

Legg inn en kommentar