Community discussion forum

VB.net class to connect to sql database

• • Reply

  11 months ago

  by finixx

  Tinashe Muchenje

  Harare, Zimbabwe

  Joined 11 months ago
  hello i need to write a class in vb.net to connect to sql database. the class is to be compiled and save so that everyone can use it to connect to what ever database they want. pliz help
  Report abuse
• • Reply

  11 months ago

  by puneetshadija

  puneetshadija

  Mumbai, India

  Joined 4 years ago
  We already have Enterprise Data Access Library for achieving the same. Refer to "Data Access Block" on Microsoft website.
  Report abuse
• • Reply

  11 months ago

  by senol01

  senol01

  istanbul, Turkey

  Joined 1 year ago
  hi c# class public static SqlConnection sqlBaglanti = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["data source=ipnameorlocalhost;UID=user; pwd=pass;initial Catalog=dbname"]); ----------------------------------------------------------------------------------------------------- DataView class public static DataView Toplam_kayitlar(string sql) { SqlDataAdapter sqlAdapter = new SqlDataAdapter(sql, sqlBaglanti); DataSet ds = new DataSet(); sqlAdapter.Fill(ds); sqlBaglanti.Close(); return ds.Tables[0].DefaultView; } ımm vb convert code http://converter.telerik.com/ go good ? my blogg [paslanmaz](http://www.paslanmazbul.net/) [evden eve nakliyat](http://www.evdenevenakliyatbul.com/) [bul](http://www.paslanmazbul.net/)
  Report abuse
• • Reply

  11 months ago

  by prav_kumar4u

  prav kum

  Hyderabad, India

  Joined 11 months ago
  hello hi.... i created 3 tables in oracle 10g. one column is common in 3 tables so i want to concatinate those three tables and view in a single form Using VB.net . plz help as early as possible.
  Report abuse
• • Reply

  11 months ago

  by prav_kumar4u

  prav kum

  Hyderabad, India

  Joined 11 months ago
  hello hi.... i created 3 tables in oracle 10g. one column is common in 3 tables so i want to concatinate those three tables and view in a single form Using VB.net . plz help as early as possible.
  Report abuse
• • Reply

  10 months ago

  by militia

  militia

  kathmandu, Nepal

  Joined 1 year ago
  Hi,the solution might be to use join condition.
  Report abuse