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

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bhuvanesh Mohankumar10y ago
Accepted 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
+1
Nishant Mittal10y ago
Do u need up and running code??
-1