public Advertisement(OleDbDataReader reader) { this.StrId = reader.GetString(0); if (!reader.IsDBNull(1)) this.IntType = reader.GetInt32(1); else this.IntType = 3; if (!reader.IsDBNull(2)) this.StrContent = reader.GetString(2); else this.StrContent = ""; }
public Coupon(OleDbDataReader reader) { this.StrId = reader.GetString(0); if (!reader.IsDBNull(1)) this.StrSmallImg = reader.GetString(1); else this.strSmallImg = ""; if (!reader.IsDBNull(2)) this.StrLargeImg = reader.GetString(2); else this.StrLargeImg = ""; if (!reader.IsDBNull(3)) this.StrPrintImg = reader.GetString(3); else this.StrPrintImg = ""; }
public Form1() { InitializeComponent(); PC.list = new List<PC>(); PC.total = new List<PC>(); data.Columns.Add("Id", "Id"); data.Columns.Add("PC", "PC"); data.Columns.Add("Inicio", "Inicio"); data.Columns.Add("Tiempo", "Tiempo"); data.Columns.Add("Total", "Total"); data.Columns[3].Width = 130; data.Columns[3].Width = 130; r = MSAConnection.read("select * from item"); while (r.Read()) { String d = ""; PC p = new PC(); p.id = r.GetInt32(0); p.precio = r.GetInt32(2); if (!r.IsDBNull(3)) { //d = r.GetDateTime(3).ToString(); DateTime x = r.GetDateTime(3); d = x.Hour + ":" + x.Minute + ":" + x.Second; p.inicio = r.GetDateTime(3); PC.list.Add(p); } PC.total.Add(p); data.Rows.Add(r.GetInt32(0), r.GetString(1), d); } // MessageBox.Show(PC.total.Count + ""); thetimer.Start(); }
private void SaveColumnValues(OleDb.OleDbConnection conn, List <string> indexNames, ref Dictionary <string, int> dictionary) { //Call ReadColumnNames first! int indexNumber = 0; //just making sure column names are populated if (indexNames.Count() == 0) { return; } foreach (string index in indexNames) { //no need to prepare this command OleDb.OleDbCommand selectAll = new OleDb.OleDbCommand("SELECT `" + index + "` FROM `Sheet1$`", conn); try { OleDb.OleDbDataReader reader = selectAll.ExecuteReader(); while (reader.Read()) { //potentially throws invalid cast exception (null) if (!reader.IsDBNull(0)) { string word = reader.GetString(0); //clean word string cleanWord = Globals.ThisAddIn.HighlightManager.CleanWord(word); //save word if (Globals.ThisAddIn.HighlightManager.CanAddToDictionary(cleanWord)) { dictionary.Add(cleanWord, indexNumber); } } } reader.Close(); } catch (OleDb.OleDbException) { Forms.MessageBox.Show(Strings.error, Strings.errorCaption); } indexNumber++; } }
private PivotFacetCategory CreateFacetCategory(OleDbDataReader dataReader) { String name = null; PivotFacetType type = null; for (int column = 0; column < dataReader.FieldCount; column++) { if (dataReader.IsDBNull(column)) continue; String columnName = dataReader.GetName(column).ToLowerInvariant(); String value = dataReader.GetValue(column).ToString(); if (columnName == OleDbSchemaConstants.FacetCategory.Name) { name = value; } else if (columnName == OleDbSchemaConstants.FacetCategory.Type) { type = PivotFacetType.Parse(value); } } if (name == null) throw new InvalidDataException("Facet Categories data set is missing a Name column"); if (type == null) throw new InvalidDataException("Facet Categories data set is missing a Type column"); return new PivotFacetCategory(name, type); }
// Display the result set recursively expanding chapterDepth deep public void DisplayReader(OleDbDataReader myDataReader, ref uint count, uint alignment, int chapterDepth) { try { // compute alignment StringBuilder indent = new StringBuilder((int) alignment); indent.Append(' ', (int) alignment); while (myDataReader.Read()) { // add alignment StringBuilder row = new StringBuilder(indent.ToString()); // for all columns for (int i = 0; i < myDataReader.FieldCount; i++) { // null columns if (myDataReader.IsDBNull(i)) { row.Append("NULL;"); } else { //vector columns object[] myArray = myDataReader.GetValue(i) as object[]; if (myArray != null) { DisplayValue(myArray, row); } else { //check for chapter columns from "group on" queries if (myDataReader.GetFieldType(i).ToString() != "System.Data.IDataReader") { //regular columns are displayed here row.Append(myDataReader.GetValue(i)); } else { //for a chapter column type just display the colum name row.Append(myDataReader.GetName(i)); } } row.Append(';'); } } if (chapterDepth >= 0) { this.ScrubberGUIInst.DebugPrint(row.ToString()); count++; } // for each chapter column for (int i = 0; i < myDataReader.FieldCount; i++) { if (myDataReader.GetFieldType(i).ToString() == "System.Data.IDataReader") { OleDbDataReader Reader = myDataReader.GetValue(i) as OleDbDataReader; DisplayReader(Reader, ref count, alignment + 8, chapterDepth - 1); } } } } finally { myDataReader.Close(); myDataReader.Dispose(); } }
public Element(OleDbDataReader reader) { this._strName = reader.GetString(1); if (!reader.IsDBNull(2)) this._strLocation = reader.GetString(2); else this._strLocation = ""; if (!reader.IsDBNull(3)) this._strSize = reader.GetString(3); else this._strSize = ""; if (!reader.IsDBNull(4)) this._strBgImage = reader.GetString(4); else this._strBgImage = ""; if (!reader.IsDBNull(5)) this._strFontFamily = reader.GetString(5); else this._strFontFamily = ""; if (!reader.IsDBNull(6)) this._strContent = reader.GetString(6); else this._strContent = ""; if (!reader.IsDBNull(7)) this._intFontSize = reader.GetInt16(7); else this._intFontSize = 0; if (!reader.IsDBNull(8)) this._strFontColor = reader.GetString(8); else this._strFontColor = ""; if (!reader.IsDBNull(9)) this._strCtlName = reader.GetString(9); else this._strCtlName = ""; }
public Shop(OleDbDataReader reader) { this.StrId = reader.GetString(0); if (!reader.IsDBNull(1)) this.StrSmallImg = reader.GetString(1); else this.StrSmallImg = ""; if (!reader.IsDBNull(2)) this.StrLargeImg = reader.GetString(2); else this.StrLargeImg = ""; }
public void LoadPatient(string patientID) { string strSQL;OleDbCommand myCom; OleDbDataReader myReader; int i, n, c; this.isEditPatient =true; strSQL = "SELECT Patient_Name, Patient_Address, Patient_Age, Patient_Gender, Patient_Tel, Patient_Career FROM tblPatient WHERE Patient_ID=" + patientID + ";"; myCom = refConn.CreateCommand(); myCom.CommandText = strSQL; myReader = myCom.ExecuteReader(); if (myReader.HasRows) { myReader.Read(); strPatientID = patientID; txtPatientName.Text = myReader.GetString(0); txtPatientAddress.Text = myReader.IsDBNull(1)?"":myReader.GetString(1); txtPatientAge.Text = myReader.GetByte(2).ToString(); cboPatientGender.SelectedIndex = myReader.GetByte(3); txtPatientPhone.Text = myReader.IsDBNull(4)?"":myReader.GetString(4); if (!myReader.IsDBNull(5)) { n = lstCareerID.Items.Count-1; c = myReader.GetInt32(5); for(i=0; i<n; i++) { if (int.Parse(lstCareerID.Items[i].ToString())==c) { cboPatientCareer.SelectedIndex =i; break; } } }else cboPatientCareer.SelectedIndex =-1; strPatientID = patientID; } }
public void AddFromReader(OleDbDataReader reader, bool addSpace) { do { if (reader.HasRows) { HtmlGenericControl resultSetDiv = CreateDiv("ResultSet"); _container.Controls.Add(resultSetDiv); int headerColumn = reader.GetColumnIndex("Header"); string lastHeader = null; int subheaderColumn = reader.GetColumnIndex("Subheader"); string lastSubHeader = null; int lastColumn = reader.FieldCount - 1; for (int i = 0; i < 2; ++i) { if (lastColumn == headerColumn || lastColumn == subheaderColumn) { lastColumn -= 1; } } while (reader.Read()) { HtmlGenericControl rowSetDiv = CreateDiv("RowSet"); resultSetDiv.Controls.Add(rowSetDiv); bool headerAdded = false; bool subheaderAdded = false; if (headerColumn >= 0 && !reader.IsDBNull(headerColumn)) { string header = reader.GetValue(headerColumn).ToString(); headerAdded = header != lastHeader; if (headerAdded) { HtmlGenericControl headerDiv = CreateDiv("RowSetHeader", header); rowSetDiv.Controls.Add(headerDiv); lastHeader = header; } } if (subheaderColumn >= 0 && !reader.IsDBNull(subheaderColumn)) { string subheader = reader.GetValue(subheaderColumn).ToString(); subheaderAdded = subheader != lastSubHeader; if (subheaderAdded) { if (headerAdded && addSpace) { AddSpace(rowSetDiv, "Space2"); } HtmlGenericControl subheaderDiv = CreateDiv("RowSetSubheader", subheader); rowSetDiv.Controls.Add(subheaderDiv); lastSubHeader = subheader; } } if (lastColumn < 0) { if (addSpace) { AddSpace(rowSetDiv, "Space2"); } } else { if ((headerAdded || subheaderAdded) && addSpace) { AddSpace(rowSetDiv, "Space2"); } for (int i = 0; i < reader.FieldCount; ++i) { if (i != headerColumn && i != subheaderColumn) { HtmlGenericControl valueSetDiv = CreateDiv("ValueSet"); rowSetDiv.Controls.Add(valueSetDiv); HtmlGenericControl labelDiv = CreateDiv("Label", reader.GetName(i)); valueSetDiv.Controls.Add(labelDiv); if (addSpace) { HtmlGenericControl separatorDiv = CreateDiv("Separator", ""); valueSetDiv.Controls.Add(separatorDiv); } HtmlGenericControl valueDiv = CreateValueDiv(!reader.IsDBNull(i) ? reader.GetValue(i) : null); valueSetDiv.Controls.Add(valueDiv); if (i < lastColumn && addSpace) { AddSpace(rowSetDiv, "Space1"); } } } if (addSpace) { AddSpace(rowSetDiv, "Space4"); } } } } } while (reader.NextResult()); }
void GenerateRecordID() { string strSQL; OleDbDataReader myReader; OleDbCommand myCom; strSQL = "SELECT MAX(tblProfile.PROFILE_ID) FROM tblProfile;"; myCom = this.refConn.CreateCommand(); myCom.CommandText = strSQL; myReader = myCom.ExecuteReader(); if (myReader.HasRows) { while (myReader.Read()) { if ( myReader.IsDBNull(0) ) txtRecordID.Text = "1"; else txtRecordID.Text= (myReader.GetInt32(0)+1).ToString(); } }else txtRecordID.Text = "1"; myReader.Close(); }
public void setReferenceConnectNLoadData(ref OleDbConnection refParent, ref MemoryStream ReportDefinition, ref Image imgHeader, string ReportTitle) { string strSQL; int pType, cType; int YPoint, i; Button btnRefTmp; ComboBox cboShow_Diag = new ComboBox(); cboShow_Treatment = new ComboBox(); Label lblShow_Diag; OleDbCommand myCom = new OleDbCommand(); OleDbDataReader myReader; pType = -1; this.refConn = refParent; this.refImageHeader = CopyImage(imgHeader); this.ReportTitle = ReportTitle; strSQL = "SELECT tblMasterInfor.M_ID, tblMasterInfor.M_Type, tblMasterInfor.M_Name, tblDetailsInfor.Details_ID, tblDetailsInfor.Details_Content FROM tblMasterInfor LEFT JOIN tblDetailsInfor ON tblMasterInfor.M_ID = tblDetailsInfor.Mas_ID WHERE tblMasterInfor.M_Type=" + frmAddNewMasterItem.ENUM_INTEGER_CATOGERY_DIAGNOSIS.ToString() + ";"; myCom.CommandText = strSQL; myCom.Connection = refParent; myReader = myCom.ExecuteReader(); YPoint = 453;nDiagType=0; lstComboName.Items.Clear(); txtExtraDiagnosis = new TextBox(); cboExtraNote = new ComboBox(); txtExtraTreatment = new TextBox(); if (myReader.HasRows) { while (myReader.Read()) { cType = myReader.GetInt32(0); if (cType!=pType) {//new combo cboShow_Diag = new ComboBox(); cboShow_Diag.Cursor = Cursors.Hand; cboShow_Diag.FlatStyle = FlatStyle.Popup; cboShow_Diag.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); cboShow_Diag.FormattingEnabled = true; cboShow_Diag.Name = cType.ToString(); cboShow_Diag.Location = new System.Drawing.Point(180, YPoint); lstComboName.Items.Add(COMBO_DIAGNOSIS_NAME + myReader.GetInt32(0).ToString()); cboShow_Diag.Name = COMBO_DIAGNOSIS_NAME + myReader.GetInt32(0).ToString(); cboShow_Diag.Size = new System.Drawing.Size(430, 28); lblShow_Diag = new Label(); lblShow_Diag.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); lblShow_Diag.Location = new System.Drawing.Point(99, YPoint); lblShow_Diag.Name = "lbl"+COMBO_DIAGNOSIS_NAME + nDiagType.ToString(); lblShow_Diag.Size = new System.Drawing.Size(100, 23); lblShow_Diag.Text = myReader.GetString(2); pType = cType; YPoint += 30; nDiagType++; this.Controls.Add(cboShow_Diag); this.Controls.Add(lblShow_Diag); }//new item if (cboShow_Diag!=null) { //tblDetailsInfor.Details_ID, tblDetailsInfor.Details_Content if (!myReader.IsDBNull(3)) { cboShow_Diag.Items.Add(myReader.GetValue(3).ToString() + FRM_SEPPERATE_ID_NAME + myReader.GetValue(4).ToString()); } } }//read one record }//has rows txtExtraDiagnosis.Location= new System.Drawing.Point(180, YPoint); txtExtraDiagnosis.Size = new System.Drawing.Size(430, 46); txtExtraDiagnosis.Multiline =true; //txtExtraDiagnosis.BorderStyle YPoint += 52; this.cboShow_Diagnosis = new ComboBox[nDiagType]; for (i=0; i<nDiagType; i++) { this.cboShow_Diagnosis[i] = (ComboBox)this.Controls[lstComboName.Items[i].ToString()]; } myReader.Close(); strSQL = "SELECT tblMasterInfor.M_ID, tblMasterInfor.M_Type, tblMasterInfor.M_Name, tblDetailsInfor.Details_ID, tblDetailsInfor.Details_Content FROM tblMasterInfor LEFT JOIN tblDetailsInfor ON tblMasterInfor.M_ID = tblDetailsInfor.Mas_ID WHERE tblMasterInfor.M_Type=" + frmAddNewMasterItem.ENUM_INTEGER_CATOGERY_TREATMENT.ToString() + ";"; myCom.CommandText = strSQL; myCom.Connection = refParent; myReader = myCom.ExecuteReader(); lblLastTreatment.Location= new System.Drawing.Point(1, YPoint); cboShow_Treatment = new ComboBox(); cboShow_Treatment.Cursor = Cursors.Hand; cboShow_Treatment.FlatStyle = FlatStyle.Popup; cboShow_Treatment.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); cboShow_Treatment.FormattingEnabled = true; cboShow_Treatment.Location = new System.Drawing.Point(180, YPoint); cboShow_Treatment.Name = "cboShow_Treatment"; cboShow_Treatment.Size = new System.Drawing.Size(430, 28); nDiagType ++; this.Controls.Add(cboShow_Treatment); cboShow_Treatment.Items.Clear(); if (myReader.HasRows) { while (myReader.Read()) { if (!myReader.IsDBNull(3)) { cboShow_Treatment.Items.Add(myReader.GetValue(3).ToString() + FRM_SEPPERATE_ID_NAME + myReader.GetValue(4).ToString()); } } } myReader.Close(); YPoint += 30; txtExtraTreatment.Size = new System.Drawing.Size(430, 46); txtExtraTreatment.Location= new System.Drawing.Point(180, YPoint); txtExtraTreatment.Multiline = true; YPoint+=48; strSQL = "SELECT tblMasterInfor.M_ID, tblMasterInfor.M_Type, tblMasterInfor.M_Name, tblDetailsInfor.Details_ID, tblDetailsInfor.Details_Content FROM tblMasterInfor LEFT JOIN tblDetailsInfor ON tblMasterInfor.M_ID = tblDetailsInfor.Mas_ID WHERE tblMasterInfor.M_Type=" + frmAddNewMasterItem.ENUM_INTEGER_CATOGERY_CAREER.ToString() + ";"; myCom.CommandText = strSQL; myReader = myCom.ExecuteReader(); cboPatientCareer.Items.Clear(); lstCareerID.Items.Clear(); lblDoctorNote.Location = new System.Drawing.Point(1, YPoint); cboExtraNote.Size = new System.Drawing.Size(430, 46); cboExtraNote.Location= new System.Drawing.Point(180, YPoint); //txtPatientName.Text = strSQL; if (myReader.HasRows) { while (myReader.Read()) { if (!myReader.IsDBNull(3)) { cboPatientCareer.Items.Add(myReader.GetValue(4).ToString()); lstCareerID.Items.Add(myReader.GetValue(3).ToString()); } } } myReader.Close(); GenerateRecordID(); myCom.CommandText = "SELECT Details_ID, Details_Content FROM tblDetailsInfor WHERE Mas_ID=13;" ; myReader = myCom.ExecuteReader(); if (myReader.HasRows) { while (myReader.Read()) { lstDrID.Add(myReader.GetInt32(0)); cboDrName.Items.Add (myReader.GetString(1)); } }; myReader.Close(); for (i=1; i<5; i++) { btnRefTmp = (Button)this.Controls["btn_pic_Frame" + i.ToString()]; btnRefTmp.Click += new EventHandler(btnBrowse4Image_Click); } myCom.CommandText = "SELECT Details_ID, Details_Content FROM tblDetailsInfor WHERE Mas_ID=15;"; myReader = myCom.ExecuteReader(); cboExtraNote.Items.Clear(); if (myReader.HasRows) { while (myReader.Read()) { cboExtraNote.Items.Add(myReader.GetString(1)); } }; myReader.Close(); this.Controls.Add(txtExtraDiagnosis); this.Controls.Add(txtExtraTreatment); this.Controls.Add(cboExtraNote); this.ReportDefinition = ReportDefinition; this.Height = this.cboExtraNote.Top+this.cboExtraNote.Height + 40; }
public void LoadProfile(string ProfileID) { OleDbCommand myCom; OleDbDataReader myReader; string[] strOther; string strTmp, strOneItem; int i, intCombo, n, noOfComboBox, noOfImages, x; bool isContinue; myCom = refConn.CreateCommand(); myCom.CommandText ="SELECT Pro_PatientID, Pro_Date, Pro_Image1, Pro_Image2, Pro_Image3, Pro_Image4, Pro_Image5, Pro_Image6, Pro_Comment1, Pro_Comment2, Pro_Comment3, Pro_Comment4, Pro_Comment5, Pro_Comment6, Pro_Other, Pro_ExtraDiagnosis, Pro_ExtraTreatment, Pro_DoctorNote FROM tblProfile WHERE PROFILE_ID=" + ProfileID + ";"; myReader = myCom.ExecuteReader(); if (myReader.HasRows) { myReader.Read(); LoadPatient(myReader.GetInt32(0).ToString()); noOfImages = 0; for (i=2; i<8; i++) { if (!myReader.IsDBNull(i)) { noOfImages ++; LoadImage(myReader.GetString(i), i-1); } } nudNoOfPicture.Value = noOfImages; NudNoOfPictureValueChanged(null, null); for (i=8;i<14 ;i++ ) if (!myReader.IsDBNull(i)) ((TextBox)this.Controls["txtNote_" + (i-5).ToString()]).Text = myReader.GetString(i); noOfComboBox = cboShow_Diagnosis.Length; if (!myReader.IsDBNull(14)) { string [] strXXX; strXXX = new string[]{OTHER_DIAGNOSIS_SEPERATE}; strTmp = myReader.GetValue(14).ToString(); strOther = strTmp.Split(strXXX, StringSplitOptions.RemoveEmptyEntries); n = strOther.Length; for (i=0; i<n; i++) { for (intCombo =0; intCombo<noOfComboBox; intCombo++) { strTmp = cboShow_Diagnosis[intCombo].Name.Substring(COMBO_DIAGNOSIS_NAME.Length); if (strOther[i].StartsWith(strTmp)) { x = strOther[i].IndexOf(FRM_SEPPERATE_ID_NAME) + FRM_SEPPERATE_ID_NAME.Length; cboShow_Diagnosis[intCombo].Text = strOther[i].Substring(x); } }//Visit all diag strTmp = cboShow_Treatment.Name.Substring(COMBO_DIAGNOSIS_NAME.Length); if (strOther[i].StartsWith(strTmp)) { x = strOther[i].IndexOf(FRM_SEPPERATE_ID_NAME) + FRM_SEPPERATE_ID_NAME.Length; cboShow_Treatment.Text = strOther[i].Substring(x); } //Get treatment } }//Composite field //Extra diagnosis if (!myReader.IsDBNull(15)) txtExtraDiagnosis.Text = myReader.GetString(15); else txtExtraDiagnosis.Text= ""; if (!myReader.IsDBNull(16)) txtExtraTreatment.Text = myReader.GetString(16); else txtExtraTreatment.Text= ""; if (!myReader.IsDBNull(17)) cboExtraNote.Text = myReader.GetString(17); else cboExtraNote.Text= ""; }else { return; } myReader.Close(); myCom.CommandText = "SELECT Profile_Related FROM tblProfileDetails WHERE Profile_ID =" + ProfileID + ";"; myReader = myCom.ExecuteReader(); noOfComboBox = cboShow_Diagnosis.Length; if (myReader.HasRows) { while (myReader.Read()) { strTmp = myReader.GetInt32(0).ToString() + FRM_SEPPERATE_ID_NAME; isContinue = true; for (intCombo =0; intCombo<noOfComboBox; intCombo++) { n = cboShow_Diagnosis[intCombo].Items.Count; for (i=0; i<n; i++) { strOneItem = cboShow_Diagnosis[intCombo].Items[i].ToString(); if (strOneItem.StartsWith(strTmp)) { cboShow_Diagnosis[intCombo].SelectedIndex = i; intCombo = noOfComboBox; isContinue =false; i=n; } } }//Visit all diag //Get treatment if (isContinue) { n = cboShow_Treatment.Items.Count; for (i=0; i<n; i++) { strOneItem = cboShow_Treatment.Items[i].ToString(); if (strOneItem.StartsWith(strTmp)) { cboShow_Treatment.SelectedIndex = i; i=n; isContinue =false; } } }//end if if (isContinue) { n = lstDrID.Count; for (i=0; i<n; i++) { if (lstDrID[i]==myReader.GetInt32(0)) { cboDrName.SelectedIndex = i; i=n; //isContinue =false; } } } } }//HasRows txtRecordID.Text = ProfileID; myReader.Close(); myCom.Dispose(); tsbtnSave.Enabled =false; lblCapture.Enabled=false; tsbtnPrint.Enabled =true; tsbtnPreview.Enabled=true; this.btsDeleteProfile.Enabled =true; LockPatientInformation(true); }
private PivotItem ReadItem(OleDbDataReader dataReader, int rowId) { PivotItem item = new PivotItem(rowId.ToString(), this); for (int column = 0; column < dataReader.FieldCount; column++) { if (dataReader.IsDBNull(column)) continue; String columnName = dataReader.GetName(column).ToLowerInvariant(); String value = dataReader.GetValue(column).ToString(); if (String.IsNullOrEmpty(value)) continue; if (columnName == OleDbSchemaConstants.Item.Name) { item.Name = value; } else if (columnName == OleDbSchemaConstants.Item.Image) { String imagePath = UriUtility.ExpandRelativeUri(this.BasePath, value); item.Image = new PivotImage(imagePath); } else if (columnName == OleDbSchemaConstants.Item.Description) { item.Description = value; } else if (columnName == OleDbSchemaConstants.Item.Href) { item.Href = value; } else if (columnName == OleDbSchemaConstants.Item.RelatedLinks) { StringReader valueReader = new StringReader(value); String singleValue = null; while ((singleValue = valueReader.ReadLine()) != null) { String[] parts = singleValue.Split( new String[] { OleDbSchemaConstants.LinkPartDelimiter }, StringSplitOptions.None); if (parts.Length > 0) { String name = null, url = null; if (parts.Length == 1) { url = parts[0]; } else if (parts.Length >= 2) { name = parts[0]; url = parts[1]; } item.AddRelatedLink(new PivotLink(name, url)); } } } else { PivotFacetCategory facetCategory = null; foreach (PivotFacetCategory currentFacetCategory in m_facetCategoryMap.Values) { if (columnName == currentFacetCategory.Name.Replace('.', '#').ToLowerInvariant()) { facetCategory = currentFacetCategory; break; } } if (facetCategory != null) { item.AddFacetValues(facetCategory.Name, this.SplitJoinedStrings(value).ToArray()); } } } return item; }
// Display the result set recursively expanding chapterDepth deep static void DisplayReader(OleDbDataReader myDataReader, ref uint count, uint alignment, int chapterDepth) { try { // compute alignment StringBuilder indent = new StringBuilder((int)alignment); indent.Append(' ', (int)alignment); while (myDataReader.Read()) { // add alignment StringBuilder row = new StringBuilder(indent.ToString()); // for all columns for (int i = 0; i < myDataReader.FieldCount; i++) { // null columns if (myDataReader.IsDBNull(i)) { row.Append("NULL\t"); } else { //vector columns object[] myArray = myDataReader.GetValue(i) as object[]; if (myArray != null) { DisplayValue(myArray, row); } else { //check for chapter columns from "group on" queries if (myDataReader.GetFieldType(i).ToString() != "System.Data.IDataReader") { //regular columns are displayed here //If (OptPath == false) and colName is System.ItemPathDisplay //We want to skip Display of this Column if (!(OptPath == false && myDataReader.GetName(i) == "System.ItemPathDisplay")) row.Append(myDataReader.GetValue(i)); } else { //for a chapter column type just display the colum name row.Append(myDataReader.GetName(i)); } } row.Append('\t'); } } if (chapterDepth >= 0) { Console.WriteLine(row.ToString()); count++; } // for each chapter column for (int i = 0; i < myDataReader.FieldCount; i++) { if (myDataReader.GetFieldType(i).ToString() == "System.Data.IDataReader") { OleDbDataReader Reader = myDataReader.GetValue(i) as OleDbDataReader; DisplayReader(Reader, ref count, alignment + 8, chapterDepth - 1); } } } } finally { myDataReader.Close(); myDataReader.Dispose(); } }
///////////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////////////// private string GetNullableString(OleDbDataReader reader, int col) { if (reader.IsDBNull(col) == false) { return reader.GetString(col); } return null; }
int InsertPatient(OleDbCommand myComm) { string strSQL; int intLastID; strSQL = "SELECT MAX(Patient_ID) FROM tblPatient"; myComm.CommandText = strSQL; myReader = myComm.ExecuteReader(); if (myReader.HasRows) { myReader.Read(); if ( myReader.IsDBNull(0) ) intLastID=1; else intLastID = myReader.GetInt32(0)+1; }else intLastID = 1; myReader.Close(); strSQL = "INSERT INTO tblPatient (Patient_ID, Patient_Name, Patient_Address, Patient_Age, Patient_Gender, Patient_Tel, Patient_Career) VALUES(" + intLastID.ToString() +", '" + txtPatientName.Text + "', "; if (txtPatientAddress.Text.Length<=0) { strSQL += "NULL, " + txtPatientAge.Text + ", "; } else { strSQL += "'" + txtPatientAddress.Text + "', " + txtPatientAge.Text +", "; } strSQL += cboPatientGender.SelectedIndex.ToString() + ", "; if (txtPatientPhone.Text.Length<0) { strSQL += "NULL, "; } else { strSQL += "'" + txtPatientPhone.Text + "', "; } if (cboPatientCareer.SelectedIndex<0) { strSQL += "NULL);"; } else { strSQL += lstCareerID.Items[cboPatientCareer.SelectedIndex].ToString() + ");"; } myComm.CommandText = strSQL; //cboShow_Treatment.Text = strSQL; myComm.Connection = refConn; try{ myComm.ExecuteNonQuery(); }catch (Exception e) { MessageBox.Show (e.Message.ToString()); return -1; } return intLastID; }