updateinfo.cs

网上购物中介

using System;
using System.Data;
using System.Data.OleDb;

namespace _3DLib
{
	/// <summary>
	/// UpdateInfo 的摘要说明。
	/// </summary>
	public class UpdateInfo
	{
		public UpdateInfo()
		{
			
		}
		public static string updateOneInfo(string table,string value1,string tj,string id)
		{
			string returnString;
			OleDbConnection con=DataBaseCon.GetCon();
			System.Data.OleDb.OleDbCommand cmd=new System.Data.OleDb.OleDbCommand();
			cmd.Connection=con;
			con.Open();
			cmd.CommandText="update "+table+" set "+tj+"='"+value1+"' where ID='"+id+"'";
			try
			{
				if(cmd.ExecuteNonQuery()==1)
				{
					returnString="OK";
				}
				else returnString="!OK";
			}
			catch(Exception e1)
			{
				return e1.Message;
			}
            con.Close();
			return returnString;
		}
		public static string updateOneIfoCom(string table,string value1,string tj,string name)
		{
			string returnString;
			OleDbConnection con=DataBaseCon.GetCon();
			System.Data.OleDb.OleDbCommand cmd=new System.Data.OleDb.OleDbCommand();
			cmd.Connection=con;
			con.Open();
			cmd.CommandText="update "+table+" set "+tj+"='"+value1+"' where 名称='"+name+"'";
			if(cmd.ExecuteNonQuery()==1)
			{
				returnString="OK";
			}
			else returnString="!OK";
			con.Close();
			return returnString;
		}
	}
}