C#

rms123 wrote:

Do I miss a piece of code?

Luc Pattyn wrote:

you need two things: a using statement

public void changelanguage(object code) {
    con.Open();
    SqlCommand com = new SqlCommand();
    SqlDataReader dr;
    com.Parameters.AddWithValue("language", code);
    com.CommandText = "SELECT translated FROM translation WHERE languagecode=@language";
    dr=com.ExecuteReader();
    while (dr.Read()) {
        if ((string) dr["textinenglish"] == theWordIWantToTranslate) {
            ...
            }
        }
    }

Arunkumar.Koloth wrote:

AddWithValue("language",

Keith Barrow wrote:

Take your pick

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.OleDb;
namespace Access
{
   public class Connection
    {
        private string getConnectionString()
        {
            return "connetionString";
        }
 
        public static void ExecuteCommand(string command)
        {
            OleDbConnection con;
            OleDbCommand com;
            try
            {
                con = new OleDbConnection(getConnectionString());
                con.Open();
                com = new OleDbCommand(command);
                com.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                //ex shows exception
            }
            finally
            {
                con.Close();
            }
        }
    }

public void MyMethord()<br />
{<br />
Connection.ExecuteCommand("command write here");<br />
}

-ambarish-

public void connection()
       {
           con = new SqlConnection("Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=practice;Data Source=HOME-78F3176757");
           con.Open();
       }

       public DataSet filldata(string mystring)
       {
           connection();
           adp = new SqlDataAdapter(mystring, con);
           ds = new DataSet();
           adp.Fill(ds);
           return ds;
       }