اميدوارم کمکت کنه
Class
----------------------------------------------------------------------------------------------
[LTR]public MyDatabase()[/LTR]
[LTR]{[/LTR]
[LTR]SqlConnection con = new SqlConnection();[/LTR]
[LTR]SqlCommand cmd = new SqlCommand();[/LTR]
[LTR]con.ConnectionString="server=(local);database=MyDatabaseName;trusted_connection=yes;
[/LTR]
[LTR]cmd.Connection=con;[/LTR]
[LTR]}[/LTR]
[LTR]public string executeCommand(string sqlcmd)
{
try
{
con.Open();
cmd.CommandText=sqlcmd;
cmd.ExecuteNonQuery();
con.Close();
return ("true");
}
catch(Exception ex)
{
string a= ex.Message;
return(a);
}
}[/LTR]
------------------------------------------------------------------------------------------------------------------------------
[LTR]MyDatabase db = new MyDatabase();[/LTR]
[LTR]string SqlCmd="insert into table1(No,Name,Message) values(1,'Test','Hello')"[/LTR]
[LTR]db.executeCommand(SqlCmd)[/LTR]