iX Talk

Code: Select all

	public void DoSQLWrite(string strEntry, string strDatasource,string strInitialCatalog, string UserName, string Password)
	{
			
		SqlConnection myWConnection;		

	
		try
		{
			myWConnection = new SqlConnection("Data Source=" + strDatasource + ";Initial Catalog=" + strInitialCatalog + ";User Id=" + UserName + ";Password=" + Password);
		}
		catch (Exception ex)
		{
			MessageBox.Show(ex.Message);               
			return;
		}

		try
		{
			myWConnection.Open();
		}
		catch (Exception ex)
		{
			MessageBox.Show(ex.Message);
			return;
		}

		try
		{
				
				SqlCommand myWriter = new SqlCommand(strEntry, myWConnection); 
				SqlParameter exParam1 = new SqlParameter("@param1", SqlDbType.Int);
				SqlParameter exParam2 = new SqlParameter("@param2", SqlDbType.Int);
				SqlParameter exParam3 = new SqlParameter("@param3", SqlDbType.Decimal);
				exParam1.Value = Globals.Tags.tag1.Value;
				exParam2.Value = Globals.Tags.tag2.Value;
				exParam3.Value = Globals.Tags.tag3.Value;
				myWriter.Parameters.Add(exParam1);
				myWriter.Parameters.Add(exParam2);
				myWriter.Parameters.Add(exParam3);
		
			myWriter.ExecuteNonQuery();

         myWConnection.Close();
		}
		catch (Exception ex)
		{
			MessageBox.Show(ex.Message); 
			myWConnection.Close();
		}
}

Code: Select all

Globals.Sql.DoSQLWrite("INSERT INTO db (Column1, Column2, Column3) VALUES (@exParam1, @exParam2, @exParam3)", "localhost\\NAMEDPIPE", "DB", "user", "pwd");