public FormView BindFormView(FormView grdVGenIn, string strSqlIn) { objConnection = open_connection(); if (open_con == true) { try { objDataSet = new DataSet(); objAdapter = new OracleDataAdapter(strSqlIn, objConnection); objAdapter.Fill(objDataSet, "tblGrdV"); grdVGenIn.DataSource = objDataSet.Tables["tblGrdV"].DefaultView; grdVGenIn.DataBind(); gridView_bind = true; return grdVGenIn; } catch (OracleException objError) { if (objError.Message.Substring(0, 21) == "Table does not exist.") { ErrorStr = ErrorMsg(objConnection, "MSG1201"); } else if (objError.Message.Substring(59, 25) == "ORA-00904: invalid column name") { ErrorStr = ErrorMsg(objConnection, "MSG1202"); } else { ErrorStr = objError.Message; err_flag = true; } gridView_bind = false; return null; } finally { objConnection.Close(); objConnection.Dispose(); objAdapter.Dispose(); } } else { return null; } }
public FormView ClearFormView(FormView grdVGenIn) { grdVGenIn.DataSource = null; grdVGenIn.DataBind(); return null; }