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

Question

pls give the Service codes in c# (update,add,list,delete,Search,)

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??

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

Answers (2)