C#

public LookupEntity AddLookup(LookupEntity entity)
{
    using (FMGDataContext dc = getDataContext())
    {
        // See if a lookup with the same Caption already exists
        var lookupExists = dc.Lookups.Where(l => l.Caption.Trim().ToLower() == entity.Caption.Trim().ToLower() &&
                                            l.LookupCode.Trim().ToLower() == entity.LookupCode.Trim().ToLower()).Any();

        // If the lookup doesn't already exist...
        if (!lookupExists)
        {
            // Add the lookup
            Lookup newLookup = new Lookup
            {
                LookupCode = entity.LookupCode,
                LookupTypeName = entity.LookupTypeName,
                Caption = entity.Caption,
                Description = entity.Description,
                ParentId = entity.ParentId ?? 0,
            };

            dc.Lookups.InsertOnSubmit(newLookup);
                    
            try
            {
                dc.SubmitChanges();

                entity.Id = newLookup.LookupId;
            }
            catch (Exception e)
            {
                // Handle exception here
            }
        }
        else
        {
            throw new DuplicateLookupException(string.Format("Lookup {0} already exists", entity.Caption));
        }
    }

    return entity;
}

public class _ResponseBase
{
    [DataMember]
    public Result Result { get; set; }

    [DataMember]
    public string Message { get; set; }

    private Exception _Exception;
    [DataMember]
    public Exception Exception
    {
        get { return _Exception; }
        set
        {
            if (_Exception != value)
            {
                _Exception = value;

                Message = _Exception.Message;
                Result = Result.Failure;
            }
        }
    }
}

public AddLookupResponse AddLookup(LookupEntity entity)
{
    AddLookupResponse response = new AddLookupResponse();

    using (FalconDataContext dc = getDataContext())
    {
        bool exsits = (from l in dc.Lookups
                        where l.LookupCode.Trim().ToLower() == entity.LookupCode.Trim().ToLower()
                        select l).Any();

        if (exsits)
        {
            response.Result = Result.Failure;
            response.Message = string.Format("Lookup code '{0}' already exists in the Lookups table", entity.LookupCode);
        }
        else
        {
            Lookup newRecord = new Lookup
            {
                LookupCode = entity.LookupCode,
                LookupName = entity.LookupName,
                Caption = entity.Caption,
                Description = entity.Description,
                SystemCode = entity.SystemCode,
                ParentId = entity.ParentId
            };

            dc.Lookups.InsertOnSubmit(newRecord);

            try
            {
                dc.SubmitChanges();

                entity.Id = newRecord.LookupId;
                response.Data = entity;
            }
            catch (Exception e)
            {
                response.Exception = e;
            }
        }
    }

    return response;
}

AddLookupResponse response = Engine.APIProxy.AddLookup(SelectedLookupItem);

if (response.Result == Result.Success)
{
    // Do something
}
else
{
	HandleResponse(response);
}

<DataGrid Height="418"  VerticalAlignment="Top" IsReadOnly="True" Width="846" ItemsSource="{Binding Path=MyDataBinding}" Name="datagrid1" BorderBrush="#FF0C5900" Style="{DynamicResource DataGridStyle1}" Background="#FF1F1F1F" ColumnHeaderHeight="30" ColumnWidth="127" BorderThickness="1,0,0,1" SelectionMode="Single" RowHeight="40" FontSize="14">
               <DataGrid.RowStyle>
                   <Style TargetType="{x:Type DataGridRow}">
                       <EventSetter Event="MouseDoubleClick" Handler="DataGrid_MouseDoubleClick"/>
                   </Style>
               </DataGrid.RowStyle>
           </DataGrid>

private void DataGrid_MouseDoubleClick(object sender, MouseButtonEventArgs e)
       {
           DataGridRow dgr = sender as DataGridRow;
           DataRowView drv = dgr.DataContext as DataRowView;

           string hybridInfo = drv.Row["HybridInfo"].ToString();

           conConnect = new SqlConnection("Data Source=GERRY;Initial Catalog=MMJDB;Integrated Security=True");
           SqlCommand cmd = new SqlCommand("SELECT * FROM StrainInfo WHERE HybridInfo=@HybridInfo");
           cmd.Connection = conConnect;
           cmd.Parameters.AddWithValue("@HybridInfo", hybridInfo);
           conConnect.Open();

           dAdapter = new SqlDataAdapter(cmd);
           DS = new DataSet();

           dAdapter.Fill(DS, "MyDataBinding");

           datagrid2.ItemsSource = DS.Tables[0].AsDataView();

           dAdapter.Dispose();
           conConnect.Close();

       }

string hybridInfo = drv.Row["HybridInfo"].ToString();