C#

public AppSettings(ApplicationSettingsBase settings)
{
}

AppSettings settings = new AppSettings(MyApp.Settings.Default);

humayunlalzad wrote:

Unable to understand what the problem could be

humayunlalzad wrote:

One or more of your files has a conflict. This means that someone else has altered the same part of the file as you. Look above for the files marked "C ", and manually edit them to resolve the conflict.

humayunlalzad wrote:

One or more of your files has a conflict. This means that someone else has altered the same part of the file as you. Look above for the files marked "C ", and manually edit them to resolve the conflict.

public Dataset GetData()
      {
          Dataset dsdata = new Dataset();
          /* As you said you, you have Successfully imported data into the Dataset
          * So, i dont know how you did it, but you should end up with the same thing as 
           * the above decleation of a Dataset and the Following Code will show you how to query a Dataset
           * 
           */
          String Constr = @"User ID=sa;Password=;Database=MyDB; Server =MYSERVER";

          SqlConnection con = new SqlConnection(Constr);  

          SqlCommand cmdselect = new SqlCommand("SELECT toto as X, count(titi)as Y from MY_TABLE GROUP BY X, ORDER BY X");
          
          cmdselect.CommandTimeout = 0 ;

          cmdselect.Connection = con; 

          SqlDataAdapter da = new SqlDataAdapter(cmdselect);
          //This is the Most important Part, if you have one table from the Dataset,you can leave it like this 
          da.Fill(dsdata);

          return dsdata;

      }

Dim strFileName As String = "MyFile.csv"
Dim strPath As String = "C:\"
Dim strCon As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=" + strPath + ";Extended
Properties='text;HDR=Yes;FMT=Delimited'"
Dim con As New OleDbConnection(strCon)
Dim cmdGetCsv As New OleDbCommand("SELECT * from " +
strFileName, con)
Dim csvAdapter As New OleDbDataAdapter(cmdGetCsv)
'Dim csvReader As OleDbDataReader
con.Open()

Dim dsCsv As DataSet = New DataSet

csvAdapter.Fill(dsCsv)