C#

string str = "Select * from @table";<br />
SqlDataAdapter dataAdapter = new SqlDataAdapter(str,myConn);<br />
dataAdapter.SelectCommand.Parameters.Add("@table", tablename);<br />
DataSet dt = new DataSet();<br />
dataAdapter.SelectCommand.Connection.Open();//open the connection<br />
DataAdapter.Fill(dt,tablename);//fill the adapter<br />
...<br />

string str = "Select [username] from @table";<br />
SqlConnection myConn + new SqlConnection("Server=(local);Integrated security=SSPI;database=halkdanis");<br />
SqlCommand cmd = new SqlCommand(str,myConn);<br />
cmd.Parameters.Add("@table",tablename);<br />
myConn.Open();<br />
SqlDataReader reader = cmd.ExecuteReader();<br />
try<br />
{<br />
    while(reader.Read()) <br />
    {<br />
        lst.Add(reader.GetString(0)); //since we only asked for one colume, just get string from col 0<br />
    }<br />
}<br />
finally<br />
{<br />
  reader.Close();//close reader<br />
  myConn.Close();//close connection<br />
}

public static void test(ListBox lst, string tablename)<br />
{<br />
string str = "Select [username] from @table";<br />
SqlConnection myConn = new SqlConnection("Server=(local);Integrated security=SSPI;database=halkdanis");<br />
SqlCommand cmd = new SqlCommand(str,myConn);<br />
cmd.Parameters.Add("@table",tablename);<br />
myConn.Open();<br />
<br />
try<br />
{<br />
SqlDataReader reader = cmd.ExecuteReader(); // error points here<br />
while(reader.Read()) <br />
{<br />
lst.Items.Add(reader.GetString(0)); //since we only asked for one colume, just get string from col 0<br />
}<br />
}<br />
catch(SqlException e)<br />
{<br />
 System.Diagnostics.Trace.WriteLine(e.message);<br />
}<br />
finally<br />
{<br />
reader.Close();//close reader<br />
myConn.Close();//close connection<br />
}<br />
<br />
}

SqlDatareader reader = null;<br />
try<br />
{<br />
  reader = cmd.ExeuteReader();<br />
...

protected override void OnPaint(PaintEventArgs args) {
Graphics g = args.Graphics;
Pen pen = new Pen(Color.Black, 2);
Point p3 = new Point(40,125);
Point p4 = new Point(55, 125);
g.DrawLine(pen, p3, p4);
}