Adding data to table from code

Epicor ERP 10
, ,
1

I am trying to add file path to textbox on Customer part Cross Reference.
this is my code:

private void epiButtonC1_Click(object sender, System.EventArgs args)
{

	// ** Place Event Handling Code Here **
	using (OpenFileDialog openFileDialog = new OpenFileDialog())
     {
		string destFile;
		openFileDialog.InitialDirectory = "c:\\";
		openFileDialog.Filter = "All Files (*.*)|*.*";
		openFileDialog.FilterIndex = 1;
		openFileDialog.RestoreDirectory = true;
       	string tPath = @"E:\Attachments";

		if (openFileDialog.ShowDialog() == DialogResult.OK)
		{
			string sFileName = openFileDialog.FileName; //path to the selected file
			string FileName = System.IO.Path.GetFileName(sFileName);
			destFile = System.IO.Path.Combine(tPath, FileName);
			if (!System.IO.Directory.Exists(tPath))
        	{
            	System.IO.Directory.CreateDirectory(tPath);
				
        	}
    		System.IO.File.Copy(sFileName, destFile, true);
			epiTextBoxC8.Text = destFile;
		}
	}
}

epiTextBoxC8 is bind to UD02View.ShortChar20

When i click on button, select file, it add the file path to text box, then clicked save, then when I go back, it’s blank.

2

You need to set the value of the dataView not the textbox. While working with epicor it is highly recommended you do not use controls to drive your program. Rather use the data and the dataviews as drivers.
You may want to do some cursory reading of the Epicor Customization Guide before you jump in with both feet so that you start out doing things the “right” way as they say.
In your case you’ll want to get a hold of the appropriate dataView (as shown below) and set the value of the field

var myDv = oTrans.Factory("NameOfYourDataView");
myDv.dataView[myDv.Row].BeginEdit();
myDv.dataView[myDv.Row]["FieldName"]= destFile;
myDv.dataView[myDv.Row].EndEdit();

Also you may want to rename your controls from button1 and epitextboxc8 to something that makes more sense, when you come back to this customization 6 months from now you’ll have no idea what any of this means if you don’t take the time now to rename those fields.

Sorry for all the extra advice but it looks like you are starting at the beginning and it is way better to learn this stuff now.
Again please read the Customization Guide, the ICE Tool Guide and the Programmers Guide available in EpicWeb before you do much more development, you and your company will be much better off.

PS: Also read our FAQs and learn how to format the code in the posts it’ll make things a lot easier to read.
Thanks!

1 Like