Ejemplo n.º 1
0
        private void dgSP_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.RowIndex >= 0)
            {
                try
                {
                    SPGDataHelper spg = new SPGDataHelper();
                    dgSPParams.Rows.Clear();

                    lStoredProcedure.Text = spg.GetStoredProcedureContent(tConString.Text, dgSP.Rows[e.RowIndex].Cells[0].Value.ToString());
                    lClass.Text = SPGHelper.GenerateClass(tConString.Text, tNamespace.Text,
                        dgSP.Rows[e.RowIndex].Cells["SPName"].Value.ToString(),
                        Convert.ToBoolean(dgSP.Rows[e.RowIndex].Cells["Skip"].Value.ToString()),
                        Convert.ToBoolean(dgSP.Rows[e.RowIndex].Cells["ExecuteDataSet"].Value.ToString()),
                        Convert.ToBoolean(dgSP.Rows[e.RowIndex].Cells["ExecuteDataReader"].Value.ToString()),
                        Convert.ToBoolean(dgSP.Rows[e.RowIndex].Cells["ExecuteXML"].Value.ToString()),
                        Convert.ToBoolean(dgSP.Rows[e.RowIndex].Cells["ExecuteNonQuery"].Value.ToString()),
                        Convert.ToBoolean(dgSP.Rows[e.RowIndex].Cells["ExecuteScalar"].Value.ToString()),
                        dgSPParams).ToString();
                }
                catch (Exception ex)
                {
                    sbStatus.Text = ex.Message;
                }
            }
        }