How to execute DDL Statement in ADO.NET ?

• • Reply

  11 years ago

  by shanker123

  shanker ghimire

  Kathmandu, Nepal

  Joined 11 years ago

  I am making project using vb.net and sqlserver 2005 and for connectivity, i have used ADO.NET. In past, i used to use ADO to connect database with front end in VB6 and i used to execute any DDL statement through the 'EXECUTE method of the CONNECTION object from the front end'. But in VB.Net, i am using ADO.Net and i am running DML statement (Insert,Update,Delete,Select) through OLEDBConnection or SQLConnection object but i got problem when i tried to run DDL Statement throughm them like in previous version of ADO. So, please if any of you have ideas about it, please help me. I will be very grateful to you. Expecting good suggestion and kind help regarding this matter.

  Report abuse
• • Reply

  11 years ago

  by shanker123

  shanker ghimire

  Kathmandu, Nepal

  Joined 11 years ago

  I am making project using vb.net and sqlserver 2005 and for connectivity, i have used ADO.NET. In past, i used to use ADO to connect database with front end in VB6 and i used to execute any DDL statement through the 'EXECUTE method of the CONNECTION object from the front end'. But in VB.Net, i am using ADO.Net and i am running DML statement (Insert,Update,Delete,Select) through OLEDBConnection or SQLConnection object but i got problem when i tried to run DDL Statement throughm them like in previous version of ADO. So, please if any of you have ideas about it, please help me. I will be very grateful to you. Expecting good suggestion and kind help regarding this matter.

  Report abuse
• • Reply

  11 years ago

  by manu.net

  Manoj Bist

  Tokyo, Japan

  Joined 11 years ago

  Hi shanker,

  For executing insert/update/delete statements user following way:

  Dim cmd As New SqlClient.SqlCommand cmd.Connection = your conenction object cmd.CommandText = "insert update or delete statement comes here" cmd.ExecuteNonQuery()

  Regards

  Report abuse
• • Reply

  11 years ago

  by manu.net

  Manoj Bist

  Tokyo, Japan

  Joined 11 years ago

  Hi shanker,

  For executing insert/update/delete statements user following way:

  Dim cmd As New SqlClient.SqlCommand
  cmd.Connection = your conenction object
  cmd.CommandText = "insert update or delete statement comes here"
  cmd.ExecuteNonQuery()
  

  Regards

  Report abuse