pls give same c# codeing....................................

Question

pls give the Service codes in c# (updateaddlistdeleteSearch)

Bhuvanesh Mohankumar · Answer

What service code you need WCF service or Web service Code. C-Sharp Sample Code - CRUD Operation using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data; using System.Configuration; using System.Data.Common; using VistaDB.Provider; namespace Basics { class Program { static string connectionString = @DataSource='|DataDirectory|\BasicDB.vdb4'; static void Main(string[] args) { string originalName = Roger; string newName = Kyle; InsertName(originalName); UpdateName(originalName newName); DeleteName(newName); } public static void InsertName(string name) { using (VistaDBConnection connection = new VistaDBConnection(connectionString)) { connection.Open(); using (VistaDBCommand command = new VistaDBCommand()) { command.CommandText = string.Format(INSERT INTO Names (Name) VALUES ('{0}') name); command.Connection = connection; command.ExecuteNonQuery(); } } } public static void DeleteName(string name) { using (VistaDBConnection connection = new VistaDBConnection(connectionString)) { connection.Open(); using(VistaDBCommand command = new VistaDBCommand()) { command.CommandText = string.Format(DELETE FROM Names WHERE Name = '{0}' name); command.Connection = connection; command.ExecuteNonQuery(); } } } public static void UpdateName(string name1 string name2) { using (VistaDBConnection connection = new VistaDBConnection(connectionString)) { command = new VistaDBCommand()) { command.CommandText = string.Format(UPDATE Names SET Name = '{0}' WHERE Name = '{1}' name2 name1); command.Connection = connection; command.ExecuteNonQuery(); } } } } } Mark as answer if helpful

Nishant Mittal · Answer

Do u need up and running code??