Community discussion forum

Can any one help me?

• • Reply

  6 months ago

  by ddlathia

  D.D. Lathia

  ahmedabad, India

  Joined 6 months ago

  I am using visual basic 2008 with back end sql 2000 server. I want to export selected data in data set to .mdb file.

  how can I do this?

  Please guide me.

  Post was edited on 28/05/2009 09:12:35 Report abuse
• • Reply

  6 months ago

  by msuniliitkgp

  Sunil Kumar

  Delhi, India

  Joined 6 months ago

  Hi Dd Lathia,

  Im not getting your question properly? Do you want to export data from mdb file to Dataset or reversely

  Regards, M>Sunil>Kumar

  Report abuse
• • Reply

  5 months ago

  by aa_yassin

  Ahmed Yassin

  Esbjerg, Denmark

  Joined 5 months ago

  Hi Dd Lathia,

  Eventhough I did not get really what you ment by your request, however I will send here a code of how u can set select date in a dataset

  public void GetMovieList()
  {
     SqlCommand command = new SqlCommand();
      command.CommandText = "SELECT * FROM MyMovies";
      command.CommandType = CommandType.Text;
      command.Connection =**MySqlcon;** *(E.g, this is your sql connection path,database file location or the string connection in ur webconfig file)*   
  
   SqlDataAdapter da = new SqlDataAdapter(command); 
      DataSet ds = new DataSet();
      da.Fill(ds, "MyMovies");
      if (ds.Tables[0].Rows.Count > 0)
      {
          grd.DataSource = ds;
          grd.DataBind();
      }
  }
  

  Hope this might meet your requirment.

  Best regards, Ahmed Yassin.

  Report abuse