пʼятниця, 14 листопада 2008 р.

Це називається код....

try
{
SqlCommand AddCommand = new SqlCommand();
AddCommand.CommandText = "Select * From Projects Where Name='" + Name + "';";
AddCommand.Connection = DBConnect.CreateConnection(XML_Class.ReadSettingsParam("Setings_Server", "Name"), XML_Class.ReadSettingsParam("Setings_Server", "Base"), XML_Class.ReadSettingsParam("Setings_Server", "User"), XML_Class.ReadSettingsParam("Setings_Server", "Password"));
ReadDate = AddCommand.ExecuteReader();
if (ReadDate.HasRows == false)
{
if (ReadDate.IsClosed == false) ReadDate.Close();
AddCommand.CommandText = "insert into Projects (Name, Description , ProjectGroup ,CreatedBy,Created,Active) values ('" + Name + "','" + descr + "','" + Group+ "','" + CreatedBy + "', '" + DateTime.Now.ToString("MM.dd.yyyy") + "' ,'1')";
AddCommand.ExecuteNonQuery();
AddCommand.CommandText = "Select * From Projects Where Name='" + Name + "';";
ReadDate = AddCommand.ExecuteReader();
ReadDate.Read();
AddCommand.Dispose();
return (int)ReadDate["id"];
}
else
{
return -1;
}
}
catch (Exception err)
{
XML_Class.WriteToLog(err.ToString(), "Normal");
MessageBox.Show("Error! Message Stoper!", "Outgoing Call System");
return 0;

}

Немає коментарів:

Дописати коментар