C#

signbit wrote:

have not found any tutorials...

signbit wrote:

second problem is that I have a form that has two parts, 1. Main Part, 2. Sub Part, and I want the sub-part to appear only if the check box 'Show Sub Part' is checked, otherwise it should remain hidden...

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 />
}