C#

HarveySaayman wrote:

i made a 2nd cmdBaseClass now (does not inherit Form)...

HarveySaayman wrote:

now my "GlobalMethodsClass" needs to inherit the "Non Form CmdBaseClass" but GlobalMethodsClass is STATIC... it moans that static classes should inherit from objects

Christian Graus wrote:

Two classes with the same name ?

you.suck = (you.passion != Programming)

<br />
DataTable _indicesSchema = null;<br />
using (OleDbConnection connection = new OleDbConnection("Provider=SQLOLEDB;Password=******;Persist Security Info=True;User ID=sa;Initial Catalog=*****;Data Source=*******"))<br />
			<br />
					connection.Open();<br />
<br />
					_indicesSchema = connection.GetSchema("Indexes", new string[] { null, null, null, null });<br />
<br />
					connection.Close();<br />
			<br />
			}<br />

      StreamWriter oWriter = new StreamWriter("CSV File Path", false);<br />
      // First we will write the headers.<br />
      for(int i = 0; i < oGridView.Columns.Count; i++) {<br />
        oWriter.Write(oGridView.Columns[i].HeaderText);<br />
        if(i < oGridView.Columns.Count - 1) {<br />
          oWriter.Write(",");<br />
          }<br />
        }<br />
      oWriter.Write(oWriter.NewLine);<br />
      // Now write all the rows.<br />
      foreach(DataGridViewRow dr in oGridView.Rows) {<br />
        for(int i = 0; i < oGridView.Columns.Count; i++) {<br />
        oWriter.Write(dr.Cells[i].Value.ToString());<br />
<br />
        if(i < oGridView.Columns.Count - 1) {<br />
            oWriter.Write(",");<br />
            }<br />
          }<br />
        oWriter.Write(oWriter.NewLine);<br />
        }<br />
      oWriter.Close();

private void OnExportGridToCSV(object sender, System.EventArgs e)
{
	// Create the CSV file to which grid data will be exported.
	StreamWriter sw = new StreamWriter(Server.MapPath("~/GridData.txt"), false);

	// First we will write the headers.
	DataTable dt = m_dsProducts.Tables[0];
	int iColCount = dt.Columns.Count;
	for(int i = 0; i < iColCount; i++)
	{
		sw.Write(dt.Columns[i]);
		if (i < iColCount - 1)
		{
			sw.Write(",");
		}
	}
	sw.Write(sw.NewLine);

	// Now write all the rows.
	foreach (DataRow dr in dt.Rows)
	{
		for (int i = 0; i < iColCount; i++)
		{
			if (!Convert.IsDBNull(dr[i]))
			{
				sw.Write(dr[i].ToString());
			}
			if ( i < iColCount - 1)
			{
				sw.Write(",");
			}
		}
		sw.Write(sw.NewLine);
	}
	sw.Close();
}