Jump to content
Please Use CODE Tags

Print Function in Windows Form C#. Desperate for Help.

vern021
By vern021
in Programming
 Share
Posted

Hey guys I want to ask if you can help me with this one:

 

"Print Button –This button should be able to display the selected records currently displayed in the data grid."

 

I want to ask if how can I display my results in my search form through the crystal report viewer. I can display all of the data no problem although I can't seem to display those data that was a result of my search. If it isn't clear just leave a comment. Posted below are the codes of my search form, customer list form(if it helps) and my variables. :)

Variables: http://pastie.org/private/8bze3yuvd7jgqavlmkqr3g

Search Form(Note: it has 1172 lines, currently changing if statements to switch): http://pastie.org/private/dxlghejov0wflvtqaikxq

Customer List Form: http://pastie.org/private/upxk7ro5nqfndlcfnabt7q

 

 

Hope you guys can help me on this one. I've already been working on this project for nearly a week now and this is my last problem. It just so happened that I literally don't know how to solve this one. :(

My Current PC Codename: Scrapper

Spoiler

Intel i5-3570 | Some LGA 1155 MOBO | Some Generic DDR3 8GB 1600Mhz | PowerColor RX 560 2GB | Recycled HP Case | Crucial MX100 128GB | 1TB WD Blue 7200RPM | Some Generic 500w PSU | Intel Stock Cooler

Link to post
Share on other sites
Posted

I  am not exactly sure what you question is.

Try downloading the sheets then  printing them?

Spoiler
Spoiler

Obligatory PC specs

CPU: Intel Core i5-6600K 3.5GHz
CPU Cooler: Corsair H50
Motherboard: Asus Z170-E ATX LGA1151
Memory: G.Skill Ripjaws 4 Series 16GB (2 x 8GB)
Storage: ADATA Premier SP550 240GB
Storage: Western Digital Blue 500GB
Storage: Western Digital BLACK SERIES 1TB
Video Card: Gigabyte GeForce GTX 1060 6GB 6GB G1
Case: Fractal Design Define S
Power Supply: Corsair CSM 550W

Spoiler
If you are new please read the CoC!

 Please FOLLOW YOUR OWN THREADS!

 Quote people when replying to them.

PLEASE SELECT 'AUTOMATIC' FOR FONT COLOR FOR DARK THEME USERS.

 Mark your problem as solved if answered and like all helpful information.

 DO NOT QUOTE IMAGES(!) just type -pic- or tag them as spoiler.

Don't criticize people for asking "stupid question".

There is actually a hidden search feature on the forums here: Search 

IT DOESN'T MATTER IF YOU'RE A FANBOY/FANGIRL. WHAT MATTERS IS THAT YOU DON'T LET THAT EFFECT YOUR HARDWARE RECOMMENDATIONS.

DO NOT POST SPAM!

Link to post
Share on other sites
Posted
  • Author

I  am not exactly sure what you question is.

Try downloading the sheets then  printing them?

My question is how can you display the results of the search form to a report viewer? I don't need it to literally function and print the results. xD

My Current PC Codename: Scrapper

Spoiler

Intel i5-3570 | Some LGA 1155 MOBO | Some Generic DDR3 8GB 1600Mhz | PowerColor RX 560 2GB | Recycled HP Case | Crucial MX100 128GB | 1TB WD Blue 7200RPM | Some Generic 500w PSU | Intel Stock Cooler

Link to post
Share on other sites
Posted

Like this?

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

using System.IO;

namespace SalesInv
{
public partial class frmSearch : Form
{
public frmSearch()
{
InitializeComponent();
}
#region "Variables"


public DataSet myDataSet = new DataSet();

private DataView dv = new DataView();

public int myRowPosition = -1;

public string Filter, txtAdd;

public string Field, Search;

#endregion



#region "Private Functions"


private void ListFilterOption()
{
cboFilterOption1.Items.Clear();
cboFilterOption1.Items.Add("equals");
cboFilterOption1.Items.Add("does not equal");

cboFilterOption1.Items.Add("is greater than");
cboFilterOption1.Items.Add("is greater than or equal to");

cboFilterOption1.Items.Add("is less than");
cboFilterOption1.Items.Add("is less than or equal to");

cboFilterOption1.Items.Add("begins with");
cboFilterOption1.Items.Add("does not begin with");

cboFilterOption1.Items.Add("ends with");
cboFilterOption1.Items.Add("does not end with");

cboFilterOption1.Items.Add("contains");
cboFilterOption1.Items.Add("does not contain");
cboFilterOption1.SelectedIndex = 0;



cboFilterOption2.Items.Clear();
cboFilterOption2.Items.Add("equals");
cboFilterOption2.Items.Add("does not equal");

cboFilterOption2.Items.Add("is greater than");
cboFilterOption2.Items.Add("is greater than or equal to");

cboFilterOption2.Items.Add("is less than");
cboFilterOption2.Items.Add("is less than or equal to");

cboFilterOption2.Items.Add("begins with");
cboFilterOption2.Items.Add("does not begin with");

cboFilterOption2.Items.Add("ends with");
cboFilterOption2.Items.Add("does not end with");

cboFilterOption2.Items.Add("contains");
cboFilterOption2.Items.Add("does not contain");
cboFilterOption2.SelectedIndex = 0;




}

private void ListFields()
{
cboField1.Items.Clear();
for (int i = 0; i <= myDataSet.Tables[0].Columns.Count - 1; i++)
{
cboField1.Items.Add(myDataSet.Tables[0].Columns.ColumnName.ToString());
}
cboField1.SelectedIndex = 0;

cboField2.Items.Clear();
for (int i = 0; i <= myDataSet.Tables[0].Columns.Count - 1; i++)
{
cboField2.Items.Add(myDataSet.Tables[0].Columns.ColumnName.ToString());
}
cboField2.SelectedIndex = 0;
}

private void RecordCount()
{
lblRecCount.Text = "Record Count: " + grdSearch.RowCount.ToString();
}

private void SearchNow(string fieldName, string filterOption, string searchText)
{
dv.Table = myDataSet.Tables[0];
dv.AllowEdit.Equals(false);
dv.AllowDelete.Equals(false);
dv.AllowNew.Equals(false);
try
{
dv.RowFilter = fieldName + " " + filterOption + searchText;
grdSearch.DataSource = dv;
grdSearch.Refresh();
}
catch (Exception msg)
{
grdSearch.DataSource = null;
MessageBox.Show(msg.Message);
}

RecordCount();
}

private void SearchNow2(string fieldName1, string fieldname2, string filterOption1, string filterOption2, string searchText1, string searchText2)
{
dv.Table = myDataSet.Tables[0];
dv.AllowEdit.Equals(false);
dv.AllowDelete.Equals(false);
dv.AllowNew.Equals(false);
try
{

grdSearch.DataSource = dv;
grdSearch.Refresh();

if (btnAnd.Checked)
{
if (txtSearchString2.Text != "")
{
dv.RowFilter = (fieldName1 + " " + filterOption1 + searchText1) + "AND " + (fieldname2 + " " + filterOption2 + searchText2);
}


grdSearch.DataSource = dv;
grdSearch.Refresh();
}


if (btnOr.Checked)
{
if (txtSearchString2.Text != "")
{
dv.RowFilter = (fieldName1 + " " + filterOption1 + searchText1) + "OR " + (fieldname2 + " " + filterOption2 + searchText2);

}

grdSearch.DataSource = dv;
grdSearch.Refresh();
}

grdSearch.DataSource = dv;
grdSearch.Refresh();

}
catch (Exception msg)
{
grdSearch.DataSource = null;
MessageBox.Show(msg.Message);
}

RecordCount();
}

private void SearchRecord()
{
if (cboFilterOption1.SelectedIndex == 0)
{
if (myDataSet.Tables[0].Columns[cboField1.SelectedIndex].DataType.ToString() == "System.String")
{
Filter = "= '";
txtAdd = txtSearchString1.Text + "'";
SearchNow(cboField1.SelectedItem.ToString(), "= '", txtSearchString1.Text + "'");
GetConstraint(cboField1.SelectedItem.ToString(), "= '", txtSearchString1.Text + "'");
}

else if ((myDataSet.Tables[0].Columns[cboField1.SelectedIndex].DataType.ToString() == "System.Int32") ||
(myDataSet.Tables[0].Columns[cboField1.SelectedIndex].DataType.ToString() == "System.Decimal"))
{
Filter = "= ";
txtAdd = txtSearchString1.Text;
SearchNow(cboField1.SelectedItem.ToString(), "= ", txtSearchString1.Text);
GetConstraint(cboField1.SelectedItem.ToString(), "= ", txtSearchString1.Text);
}

else if (myDataSet.Tables[0].Columns[cboField1.SelectedIndex].DataType.ToString() == "System.DateTime")
{
Filter = "#";
txtAdd = txtSearchString1.Text + "#";
SearchNow(cboField1.SelectedItem.ToString(), "= #", txtSearchString1.Text + "#");
GetConstraint(cboField1.SelectedItem.ToString(), "= #", txtSearchString1.Text + "#");
}
}

else if (cboFilterOption1.SelectedIndex == 1)
{
if (myDataSet.Tables[0].Columns[cboField1.SelectedIndex].DataType.ToString() == "System.String")
{
Filter = "<> '";
txtAdd = txtSearchString1.Text + "'";
SearchNow(cboField1.SelectedItem.ToString(), "<> '", txtSearchString1.Text + "'");
GetConstraint(cboField1.SelectedItem.ToString(), "<> '", txtSearchString1.Text + "'");
}

else if ((myDataSet.Tables[0].Columns[cboField1.SelectedIndex].DataType.ToString() == "System.Int32") ||
(myDataSet.Tables[0].Columns[cboField1.SelectedIndex].DataType.ToString() == "System.Decimal"))
{
Filter = "<> ";
txtAdd = txtSearchString1.Text;
SearchNow(cboField1.SelectedItem.ToString(), "<> ", txtSearchString1.Text);
GetConstraint(cboField1.SelectedItem.ToString(), "<> ", txtSearchString1.Text);
}

else if (myDataSet.Tables[0].Columns[cboField1.SelectedIndex].DataType.ToString() == "System.DateTime")
{
Filter = "<> #";
txtAdd = txtSearchString1.Text + "#";
SearchNow(cboField1.SelectedItem.ToString(), "<> #", txtSearchString1.Text + "#");
GetConstraint(cboField1.SelectedItem.ToString(), "<> #", txtSearchString1.Text + "#");
}
}

else if (cboFilterOption1.SelectedIndex == 2)
{
if (myDataSet.Tables[0].Columns[cboField1.SelectedIndex].DataType.ToString() == "System.String")
{
Filter = "> '";
txtAdd = txtSearchString1.Text + "'";
SearchNow(cboField1.SelectedItem.ToString(), "> '", txtSearchString1.Text + "'");
GetConstraint(cboField1.SelectedItem.ToString(), "> '", txtSearchString1.Text + "'");
}

else if ((myDataSet.Tables[0].Columns[cboField1.SelectedIndex].DataType.ToString() == "System.Int32") ||
(myDataSet.Tables[0].Columns[cboField1.SelectedIndex].DataType.ToString() == "System.Decimal"))
{
Filter = "> ";
txtAdd = txtSearchString1.Text;
SearchNow(cboField1.SelectedItem.ToString(), "> ", txtSearchString1.Text);
GetConstraint(cboField1.SelectedItem.ToString(), "> ", txtSearchString1.Text);
}

else if (myDataSet.Tables[0].Columns[cboField1.SelectedIndex].DataType.ToString() == "System.DateTime")
{
Filter = "> #";
txtAdd = txtSearchString1.Text + "#";
SearchNow(cboField1.SelectedItem.ToString(), "> #", txtSearchString1.Text + "#");
GetConstraint(cboField1.SelectedItem.ToString(), "> #", txtSearchString1.Text + "#");
}
}

else if (cboFilterOption1.SelectedIndex == 3)
{
if (myDataSet.Tables[0].Columns[cboField1.SelectedIndex].DataType.ToString() == "System.String")
{
Filter = ">= '";
txtAdd = txtSearchString1.Text + "'";
SearchNow(cboField1.SelectedItem.ToString(), ">= '", txtSearchString1.Text + "'");
GetConstraint(cboField1.SelectedItem.ToString(), ">= '", txtSearchString1.Text + "'");
}

else if ((myDataSet.Tables[0].Columns[cboField1.SelectedIndex].DataType.ToString() == "System.Int32") ||
(myDataSet.Tables[0].Columns[cboField1.SelectedIndex].DataType.ToString() == "System.Decimal"))
{
Filter = ">= ";
txtAdd = txtSearchString1.Text;
SearchNow(cboField1.SelectedItem.ToString(), ">= ", txtSearchString1.Text);
GetConstraint(cboField1.SelectedItem.ToString(), ">= ", txtSearchString1.Text);
}

else if (myDataSet.Tables[0].Columns[cboField1.SelectedIndex].DataType.ToString() == "System.DateTime")
{
Filter = ">= #";
txtAdd = txtSearchString1.Text + "#";
SearchNow(cboField1.SelectedItem.ToString(), ">= #", txtSearchString1.Text + "#");
GetConstraint(cboField1.SelectedItem.ToString(), ">= #", txtSearchString1.Text + "#");
}
}


else if (cboFilterOption1.SelectedIndex == 4)
{
if (myDataSet.Tables[0].Columns[cboField1.SelectedIndex].DataType.ToString() == "System.String")
{
Filter = "< '";
txtAdd = txtSearchString1.Text + "'";
SearchNow(cboField1.SelectedItem.ToString(), "< '", txtSearchString1.Text + "'");
GetConstraint(cboField1.SelectedItem.ToString(), "< '", txtSearchString1.Text + "'");
}

else if ((myDataSet.Tables[0].Columns[cboField1.SelectedIndex].DataType.ToString() == "System.Int32") ||
(myDataSet.Tables[0].Columns[cboField1.SelectedIndex].DataType.ToString() == "System.Decimal"))
{
Filter = "< ";
txtAdd = txtSearchString1.Text;
SearchNow(cboField1.SelectedItem.ToString(), "< ", txtSearchString1.Text);
GetConstraint(cboField1.SelectedItem.ToString(), "< ", txtSearchString1.Text);
}

else if (myDataSet.Tables[0].Columns[cboField1.SelectedIndex].DataType.ToString() == "System.DateTime")
{
Filter = "< #";
txtAdd = txtSearchString1.Text + "#";
SearchNow(cboField1.SelectedItem.ToString(), "< #", txtSearchString1.Text + "#");
GetConstraint(cboField1.SelectedItem.ToString(), "< #", txtSearchString1.Text + "#");
}
}

else if (cboFilterOption1.SelectedIndex == 5)
{
if (myDataSet.Tables[0].Columns[cboField1.SelectedIndex].DataType.ToString() == "System.String")
{
Filter = "<= '";
txtAdd = txtSearchString1.Text + "'";
SearchNow(cboField1.SelectedItem.ToString(), "<= '", txtSearchString1.Text + "'");
GetConstraint(cboField1.SelectedItem.ToString(), "<= '", txtSearchString1.Text + "'");
}

else if ((myDataSet.Tables[0].Columns[cboField1.SelectedIndex].DataType.ToString() == "System.Int32") ||
(myDataSet.Tables[0].Columns[cboField1.SelectedIndex].DataType.ToString() == "System.Decimal"))
{
Filter = "<= ";
txtAdd = txtSearchString1.Text;
SearchNow(cboField1.SelectedItem.ToString(), "<= ", txtSearchString1.Text);
GetConstraint(cboField1.SelectedItem.ToString(), "<= ", txtSearchString1.Text);
}

else if (myDataSet.Tables[0].Columns[cboField1.SelectedIndex].DataType.ToString() == "System.DateTime")
{
Filter = "<= #";
txtAdd = txtSearchString1.Text + "#";
SearchNow(cboField1.SelectedItem.ToString(), "<= #", txtSearchString1.Text + "#");
GetConstraint(cboField1.SelectedItem.ToString(), "<= #", txtSearchString1.Text + "#");
}
}

else if (cboFilterOption1.SelectedIndex == 6)
{
if (myDataSet.Tables[0].Columns[cboField1.SelectedIndex].DataType.ToString() == "System.String")
{
Filter = "LIKE '";
txtAdd = txtSearchString1.Text + "%'";
SearchNow(cboField1.SelectedItem.ToString(), "LIKE '", txtSearchString1.Text + "%'");
GetConstraint(cboField1.SelectedItem.ToString(), "LIKE '", txtSearchString1.Text + "%'");
}
else
{
MessageBox.Show(cboField1.SelectedItem + " is not compatible with \"" + cboFilterOption1.SelectedItem + "\"");
}

}

else if (cboFilterOption1.SelectedIndex == 7)
{
if (myDataSet.Tables[0].Columns[cboField1.SelectedIndex].DataType.ToString() == "System.String")
{
Filter = "NOT LIKE ";
txtAdd = txtSearchString1.Text + "%'";
SearchNow(cboField1.SelectedItem.ToString(), "NOT LIKE ", txtSearchString1.Text + "%'");
GetConstraint(cboField1.SelectedItem.ToString(), "NOT LIKE ", txtSearchString1.Text + "%'");
}
else
{
MessageBox.Show(cboField1.SelectedItem + " is not compatible with \"" + cboFilterOption1.SelectedItem + "\"");
}
}

else if (cboFilterOption1.SelectedIndex == 8)
{
if (myDataSet.Tables[0].Columns[cboField1.SelectedIndex].DataType.ToString() == "System.String")
{
Filter = "LIKE '%";
txtAdd = txtSearchString1.Text + "'";
SearchNow(cboField1.SelectedItem.ToString(), "LIKE '%", txtSearchString1.Text + "'");
GetConstraint(cboField1.SelectedItem.ToString(), "LIKE '%", txtSearchString1.Text + "'");
}
else
{
MessageBox.Show(cboField1.SelectedItem + " is not compatible with \"" + cboFilterOption1.SelectedItem + "\"");
}
}

else if (cboFilterOption1.SelectedIndex == 9)
{
if (myDataSet.Tables[0].Columns[cboField1.SelectedIndex].DataType.ToString() == "System.String")
{
Filter = "NOT LIKE '%";
txtAdd = txtSearchString1.Text + "'";
SearchNow(cboField1.SelectedItem.ToString(), "NOT LIKE '%", txtSearchString1.Text + "'");
GetConstraint(cboField1.SelectedItem.ToString(), "NOT LIKE '%", txtSearchString1.Text + "'");
}
else
{
MessageBox.Show(cboField1.SelectedItem + " is not compatible with \"" + cboFilterOption1.SelectedItem + "\"");
}
}

else if (cboFilterOption1.SelectedIndex == 10)
{
if (myDataSet.Tables[0].Columns[cboField1.SelectedIndex].DataType.ToString() == "System.String")
{
Filter = "LIKE '%";
txtAdd = txtSearchString1.Text + "%'";
SearchNow(cboField1.SelectedItem.ToString(), "LIKE '%", txtSearchString1.Text + "%'");
GetConstraint(cboField1.SelectedItem.ToString(), "LIKE '%", txtSearchString1.Text + "%'");
}
else
{
MessageBox.Show(cboField1.SelectedItem + " is not compatible with \"" + cboFilterOption1.SelectedItem + "\"");
}
}

else if (cboFilterOption1.SelectedIndex == 11)
{
if (myDataSet.Tables[0].Columns[cboField1.SelectedIndex].DataType.ToString() == "System.String")
{
Filter = "NOT LIKE '%";
txtAdd = txtSearchString1.Text + "%'";
SearchNow(cboField1.SelectedItem.ToString(), "NOT LIKE '%", txtSearchString1.Text + "%'");
GetConstraint(cboField1.SelectedItem.ToString(), "NOT LIKE '%", txtSearchString1.Text + "%'");
}
else
{
MessageBox.Show(cboField1.SelectedItem + " is not compatible with \"" + cboFilterOption1.SelectedItem + "\"");
}
}

if ((btnAnd.Checked || btnOr.Checked) && txtSearchString2.Text != "")
{
SearchRecord2();
}
} // private

private void SearchRecord2()
{
if (cboFilterOption2.SelectedIndex == 0)
{
if (myDataSet.Tables[0].Columns[cboField2.SelectedIndex].DataType.ToString() == "System.String")
{
SearchNow2(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "= '", txtAdd, txtSearchString2.Text + "'");
GetDoubleConstraint(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "= '", txtAdd, txtSearchString2.Text + "'");
}

else if ((myDataSet.Tables[0].Columns[cboField2.SelectedIndex].DataType.ToString() == "System.Int32") ||
(myDataSet.Tables[0].Columns[cboField2.SelectedIndex].DataType.ToString() == "System.Decimal"))
{


SearchNow2(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "= ", txtAdd, txtSearchString2.Text);
GetDoubleConstraint(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "= ", txtAdd, txtSearchString2.Text);

}

else if (myDataSet.Tables[0].Columns[cboField2.SelectedIndex].DataType.ToString() == "System.DateTime")
{

SearchNow2(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "= #", txtAdd, txtSearchString2.Text + "= #");
GetDoubleConstraint(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "= #", txtAdd, txtSearchString2.Text + "= #");

}
}

else if (cboFilterOption2.SelectedIndex == 1)
{
if (myDataSet.Tables[0].Columns[cboField2.SelectedIndex].DataType.ToString() == "System.String")
{
SearchNow2(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "<> '", txtAdd, txtSearchString2.Text + "'");
GetDoubleConstraint(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "<> '", txtAdd, txtSearchString2.Text + "'");

}

else if ((myDataSet.Tables[0].Columns[cboField2.SelectedIndex].DataType.ToString() == "System.Int32") ||
(myDataSet.Tables[0].Columns[cboField2.SelectedIndex].DataType.ToString() == "System.Decimal"))
{
SearchNow2(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "<> ", txtAdd, txtSearchString2.Text);
GetDoubleConstraint(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "<> ", txtAdd, txtSearchString2.Text);

}

else if (myDataSet.Tables[0].Columns[cboField2.SelectedIndex].DataType.ToString() == "System.DateTime")
{
SearchNow2(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "<> #", txtAdd, txtSearchString2.Text + "#");
GetDoubleConstraint(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "<> #", txtAdd, txtSearchString2.Text + "#");
}
}

else if (cboFilterOption2.SelectedIndex == 2)
{
if (myDataSet.Tables[0].Columns[cboField2.SelectedIndex].DataType.ToString() == "System.String")
{
SearchNow2(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "> '", txtAdd, txtSearchString2.Text + "'");
GetDoubleConstraint(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "> '", txtAdd, txtSearchString2.Text + "'");

}

else if ((myDataSet.Tables[0].Columns[cboField2.SelectedIndex].DataType.ToString() == "System.Int32") ||
(myDataSet.Tables[0].Columns[cboField2.SelectedIndex].DataType.ToString() == "System.Decimal"))
{
SearchNow2(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "> ", txtAdd, txtSearchString2.Text);
GetDoubleConstraint(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "> ", txtAdd, txtSearchString2.Text);

}

else if (myDataSet.Tables[0].Columns[cboField2.SelectedIndex].DataType.ToString() == "System.DateTime")
{
SearchNow2(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "> #", txtAdd, txtSearchString2.Text + "#");
GetDoubleConstraint(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "> #", txtAdd, txtSearchString2.Text + "#");

}
}

else if (cboFilterOption2.SelectedIndex == 3)
{
if (myDataSet.Tables[0].Columns[cboField1.SelectedIndex].DataType.ToString() == "System.String")
{
SearchNow2(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "= '", txtAdd, txtSearchString2.Text + "'");
GetDoubleConstraint(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "= '", txtAdd, txtSearchString2.Text + "'");

}

else if ((myDataSet.Tables[0].Columns[cboField2.SelectedIndex].DataType.ToString() == "System.Int32") ||
(myDataSet.Tables[0].Columns[cboField2.SelectedIndex].DataType.ToString() == "System.Decimal"))
{
SearchNow2(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, ">= ", txtAdd, txtSearchString2.Text);
GetDoubleConstraint(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, ">= ", txtAdd, txtSearchString2.Text);


}

else if (myDataSet.Tables[0].Columns[cboField2.SelectedIndex].DataType.ToString() == "System.DateTime")
{
SearchNow2(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, ">= #", txtAdd, txtSearchString2.Text + "#");
GetDoubleConstraint(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, ">= #", txtAdd, txtSearchString2.Text + "#");

}
}


else if (cboFilterOption2.SelectedIndex == 4)
{
if (myDataSet.Tables[0].Columns[cboField2.SelectedIndex].DataType.ToString() == "System.String")
{
SearchNow2(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "< '", txtAdd, txtSearchString2.Text + "'");
GetDoubleConstraint(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "< '", txtAdd, txtSearchString2.Text + "'");

}

else if ((myDataSet.Tables[0].Columns[cboField2.SelectedIndex].DataType.ToString() == "System.Int32") ||
(myDataSet.Tables[0].Columns[cboField2.SelectedIndex].DataType.ToString() == "System.Decimal"))
{
SearchNow2(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "< ", txtAdd, txtSearchString2.Text);
GetDoubleConstraint(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "< ", txtAdd, txtSearchString2.Text);

}

else if (myDataSet.Tables[0].Columns[cboField2.SelectedIndex].DataType.ToString() == "System.DateTime")
{
SearchNow2(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "< #", txtAdd, txtSearchString2.Text + "#");
GetDoubleConstraint(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "< #", txtAdd, txtSearchString2.Text + "#");
}
}

else if (cboFilterOption2.SelectedIndex == 5)
{
if (myDataSet.Tables[0].Columns[cboField2.SelectedIndex].DataType.ToString() == "System.String")
{
SearchNow2(cboField2.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "<= '", txtAdd, txtSearchString2.Text + "'");
GetDoubleConstraint(cboField2.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "<= '", txtAdd, txtSearchString2.Text + "'");

}

else if ((myDataSet.Tables[0].Columns[cboField2.SelectedIndex].DataType.ToString() == "System.Int32") ||
(myDataSet.Tables[0].Columns[cboField2.SelectedIndex].DataType.ToString() == "System.Decimal"))
{
SearchNow2(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "<= ", txtAdd, txtSearchString2.Text);
GetDoubleConstraint(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "<= ", txtAdd, txtSearchString2.Text);

}

else if (myDataSet.Tables[0].Columns[cboField2.SelectedIndex].DataType.ToString() == "System.DateTime")
{
SearchNow2(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "<= #", txtAdd, txtSearchString2.Text + "#");
GetDoubleConstraint(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "<= #", txtAdd, txtSearchString2.Text + "#");

}
}

else if (cboFilterOption2.SelectedIndex == 6)
{
if (myDataSet.Tables[0].Columns[cboField2.SelectedIndex].DataType.ToString() == "System.String")
{
SearchNow2(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "LIKE '", txtAdd, txtSearchString2.Text + "%'");
GetDoubleConstraint(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "LIKE '", txtAdd, txtSearchString2.Text + "%'");

}
else
{
MessageBox.Show(cboField2.SelectedItem + " is not compatible with \"" + cboFilterOption2.SelectedItem + "\"");
}

}

else if (cboFilterOption2.SelectedIndex == 7)
{
if (myDataSet.Tables[0].Columns[cboField2.SelectedIndex].DataType.ToString() == "System.String")
{
SearchNow2(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "NOT LIKE '", txtAdd, txtSearchString2.Text + "%'");
GetDoubleConstraint(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "NOT LIKE '", txtAdd, txtSearchString2.Text + "%'");


}
else
{
MessageBox.Show(cboField2.SelectedItem + " is not compatible with \"" + cboFilterOption2.SelectedItem + "\"");
}
}

else if (cboFilterOption2.SelectedIndex == 8)
{
if (myDataSet.Tables[0].Columns[cboField2.SelectedIndex].DataType.ToString() == "System.String")
{
SearchNow2(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "LIKE '%", txtAdd, txtSearchString2.Text + "'");
GetDoubleConstraint(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "LIKE '%", txtAdd, txtSearchString2.Text + "'");

}
else
{
MessageBox.Show(cboField2.SelectedItem + " is not compatible with \"" + cboFilterOption2.SelectedItem + "\"");
}
}

else if (cboFilterOption2.SelectedIndex == 9)
{
if (myDataSet.Tables[0].Columns[cboField2.SelectedIndex].DataType.ToString() == "System.String")
{
SearchNow2(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "NOT LIKE '%", txtAdd, txtSearchString2.Text + "'");
GetDoubleConstraint(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "NOT LIKE '%", txtAdd, txtSearchString2.Text + "'");


}
else
{
MessageBox.Show(cboField2.SelectedItem + " is not compatible with \"" + cboFilterOption2.SelectedItem + "\"");
}
}

else if (cboFilterOption2.SelectedIndex == 10)
{
if (myDataSet.Tables[0].Columns[cboField2.SelectedIndex].DataType.ToString() == "System.String")
{
SearchNow2(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "LIKE '%", txtAdd, txtSearchString2.Text + "%'");
GetDoubleConstraint(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "LIKE '%", txtAdd, txtSearchString2.Text + "%'");

}
else
{
MessageBox.Show(cboField2.SelectedItem + " is not compatible with \"" + cboFilterOption2.SelectedItem + "\"");
}
}

else if (cboFilterOption2.SelectedIndex == 11)
{
if (myDataSet.Tables[0].Columns[cboField2.SelectedIndex].DataType.ToString() == "System.String")
{
SearchNow2(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "NOT LIKE '%", txtAdd, txtSearchString2.Text + "%'");
GetDoubleConstraint(cboField1.SelectedItem.ToString(), cboField2.SelectedItem.ToString(),
Filter, "NOT LIKE '%", txtAdd, txtSearchString2.Text + "%'");
}
else
{
MessageBox.Show(cboField2.SelectedItem + " is not compatible with \"" + cboFilterOption2.SelectedItem + "\"");
}
}//switch
} // private
#endregion

private void frmSearch_Load(object sender, EventArgs e)
{

stcSalesInv.SearchSource = myDataSet.Tables[0].ToString();
cboField2.Enabled = false;
cboFilterOption2.Enabled = false;
txtSearchString2.Enabled = false;
txtSearchString1.Clear();
txtSearchString2.Clear();
ListFilterOption();
ListFields();
RecordCount();


btnPrint.Image = Properties.Resources.printer1.ToBitmap();


if (!File.Exists(Application.StartupPath + @"\search.txt"))
{
File.WriteAllText(Application.StartupPath + @"\search.txt", "false");
}
using (StreamReader sr = File.OpenText(Application.StartupPath + @"\search.txt"))
{
string s = "", result = "";
while ((s = sr.ReadLine()) != null)
{
result = s;
}
sr.Close();
chkShowAll.Checked = Convert.ToBoolean(result);

if (chkShowAll.Checked == true)
{

if (myDataSet.Tables[0].Columns[0].DataType.ToString() == "System.Int32")
{
SearchNow(myDataSet.Tables[0].Columns[0].ToString(), ">", "0");
}
else
{
SearchNow(myDataSet.Tables[0].Columns[0].ToString(), "LIKE", "'*'");
}
}
else
{ //clear the data source
grdSearch.DataSource = null;
}
RecordCount();
}
}

#region "Validations"

private void txtSearchString1_TextChanged(object sender, EventArgs e)
{
if (txtSearchString1.Text != "")
{
if (myDataSet.Tables[0].Columns[cboField1.SelectedIndex].DataType.ToString() == "System.DateTime")
{
if (txtSearchString1.Text.Length > 7)
{
SearchRecord();
} //end of length > 5
}//end of datetime
else if
(myDataSet.Tables[0].Columns[cboField1.SelectedIndex].DataType.ToString() == @"System.Byte[]")
{
MessageBox.Show(cboField1.SelectedItem + " is not compatible with\"" + cboFilterOption1.SelectedItem + "\"");
}//end of system.btye
else
{
SearchRecord();
}//end of else
}//end of txtsearchstring
else
{
if
((myDataSet.Tables[0].Columns[0].DataType.ToString() == "System.Int32") ||
(myDataSet.Tables[0].Columns[0].DataType.ToString() == "System.Decimal"))
{
SearchNow(myDataSet.Tables[0].Columns[0].ToString(), ">", "0");
}//end of decimal
else if (myDataSet.Tables[0].Columns[0].DataType.ToString() == "System.String")
{
SearchNow(myDataSet.Tables[0].Columns[0].ToString(), "LIKE", "'*'");
}//end of string
else if (myDataSet.Tables[0].Columns[0].DataType.ToString() == "System.DateTime")
{
SearchNow(myDataSet.Tables[0].Columns[0].ToString(), ">", "#1/1/1800#");
}//end of datetime
}//end of else
}

private void grdSearch_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
object primaryKey;

if (myDataSet.Tables[0].Columns[0].DataType.ToString() == "System.Int32")
{
primaryKey = Convert.ToInt32(grdSearch.CurrentRow.Cells[0].Value.ToString());
}
else
{
primaryKey = Convert.ToString(grdSearch.CurrentRow.Cells[0].Value.ToString());
}
for (int ctr = 0; ctr <= myDataSet.Tables[0].Rows.Count - 1; ctr++)
{
if (myDataSet.Tables[0].Rows[ctr][0].ToString() == primaryKey.ToString())
{
myRowPosition = ctr;
break;
}
}
this.Close();
}

private void cboField1_SelectedIndexChanged(object sender, EventArgs e)
{
if (txtSearchString1.Text != "")
{
SearchRecord();
}
}

private void cboFilterOption1_SelectedIndexChanged(object sender, EventArgs e)
{
if (txtSearchString1.Text != "")
{
SearchRecord();
}
}

private void txtSearchString1_KeyPress(object sender, KeyPressEventArgs e)
{
if ((myDataSet.Tables[0].Columns[cboField1.SelectedIndex].DataType.ToString() == "System.Int32"))
{
byte num = Convert.ToByte(e.KeyChar);
if ((num >= 48 && num <= 57) || (num == 8))
{
e.Handled = false;
}
else
{
e.Handled = true;
}
}//end of int32
else if ((myDataSet.Tables[0].Columns[cboField1.SelectedIndex].DataType.ToString() == "System.Decimal"))
{
byte num = Convert.ToByte(e.KeyChar);
if ((num >= 48 && num <= 57) || (num == 8) || (num == 46))
{
if (num == 46)
{
if (txtSearchString1.Text.IndexOf(".", 0) != -1)
{
e.Handled = true;
}
}
else
{
e.Handled = false;
}
}
else
{
e.Handled = true;
}
}//end of decimal
else if (myDataSet.Tables[0].Columns[cboField1.SelectedIndex].DataType.ToString() == "System.String")
{
byte num = Convert.ToByte(e.KeyChar);
if (cboField1.SelectedItem.ToString() == "TelNo")
{
if ((num >= 48 && num <= 57) || (num == 8))
{
e.Handled = false;
}
else
{
e.Handled = true;
}
}
else
{
e.Handled = false;
}
}//end of string
else if (myDataSet.Tables[0].Columns[cboField1.SelectedIndex].DataType.ToString() == "System.DateTime")
{
byte num = Convert.ToByte(e.KeyChar);
if ((num >= 48 && num <= 57) || (num == 8) || (num == 47))
{
e.Handled = false;
}
else
{
e.Handled = true;
}
}//end of datetime
}

private void groupBox1_Enter(object sender, EventArgs e)
{

}

private void txtSearchString2_TextChanged(object sender, EventArgs e)
{
if (txtSearchString2.Text != "")
{
if (myDataSet.Tables[0].Columns[cboField2.SelectedIndex].DataType.ToString() == "System.DateTime")
{
if (txtSearchString2.Text.Length > 7)
{
SearchRecord();
}
}
else if (myDataSet.Tables[0].Columns[cboField2.SelectedIndex].DataType.ToString() == @"System.Byte[]")
{
MessageBox.Show(cboField2.SelectedItem + " is not compatible with \"" + cboFilterOption2.SelectedItem + "\"");
}
else
{
SearchRecord();
}
}
else
{
SearchRecord();
}

}

private void cboField2_SelectedIndexChanged(object sender, EventArgs e)
{
if (txtSearchString2.Text != "")
{
SearchRecord();
}
}

private void cboFilterOption2_SelectedIndexChanged(object sender, EventArgs e)
{
if (txtSearchString2.Text != "")
{
SearchRecord();
}
}

public void GetConstraint(string fieldname, string filteroption, string searchText)
{
string constraint;
constraint = "WHERE " + fieldname + " " + filteroption + searchText;
}

public void GetDoubleConstraint(string fieldname1, string fieldname2, string filteroption1, string filteroption2, string searchText1, string searchText2)
{
string constraint = "";

if (btnAnd.Checked)
{
constraint = "WHERE " + (fieldname1 + " " + filteroption1 + searchText1) + " AND " + (fieldname2 + " " + filteroption2 + searchText2);
}
else if (btnOr.Checked)
{
constraint = "WHERE " + (fieldname1 + " " + filteroption1 + searchText1) + " OR " + (fieldname2 + " " + filteroption2 + searchText2);
}
}

private void txtSearchString2_KeyPress(object sender, KeyPressEventArgs e)
{
if ((myDataSet.Tables[0].Columns[cboField2.SelectedIndex].DataType.ToString() == "System.Int32"))
{
byte num = Convert.ToByte(e.KeyChar);
if ((num >= 48 && num <= 57) || (num == 8))
{
e.Handled = false;
}
else
{
e.Handled = true;
}
}
else if ((myDataSet.Tables[0].Columns[cboField2.SelectedIndex].DataType.ToString() == "System.Decimal"))
{
byte num = Convert.ToByte(e.KeyChar);
if ((num >= 48 && num <= 57) || (num == 8) || (num == 46))
{
if (num == 46)
{
if (txtSearchString1.Text.IndexOf(".", 0) != -1)
{
e.Handled = true;
}
}
else
{
e.Handled = false;
}
}
else
{
e.Handled = true;
}
}
else if (myDataSet.Tables[0].Columns[cboField2.SelectedIndex].DataType.ToString() == "System.String")
{
byte num = Convert.ToByte(e.KeyChar);
if (cboField2.SelectedItem.ToString() == "TelNo")
{
if ((num >= 48 && num <= 57) || (num == 8))
{
e.Handled = false;
}
else
{
e.Handled = true;
}
}
else
{
e.Handled = false;
}
}
else if (myDataSet.Tables[0].Columns[cboField2.SelectedIndex].DataType.ToString() == "System.DateTime")
{
byte num = Convert.ToByte(e.KeyChar);
if ((num >= 48 && num <= 57) || (num == 8) || (num == 47))
{
e.Handled = false;
}
else
{
e.Handled = true;
}
}
}

#endregion

#region "Buttons"

private void btnAnd_CheckedChanged_1(object sender, EventArgs e)
{
cboField2.Enabled = true;
cboFilterOption2.Enabled = true;
txtSearchString2.Enabled = true;

if (txtSearchString2.Text != "" && txtSearchString1.Text != "")
{
SearchRecord();
}

}

private void btnOr_CheckedChanged(object sender, EventArgs e)
{
cboField2.Enabled = true;
cboFilterOption2.Enabled = true;
txtSearchString2.Enabled = true;

if (txtSearchString2.Text != "" && txtSearchString1.Text != "")
{
SearchRecord();
}
}

private void chkShowAll_Click(object sender, EventArgs e)
{
File.WriteAllText(Application.StartupPath + @"\search.txt",
chkShowAll.Checked.ToString());
}

private void btnAnd_CheckedChanged(object sender, EventArgs e)
{
cboField2.Enabled = true;
cboFilterOption2.Enabled = true;
txtSearchString2.Enabled = true;

if (txtSearchString2.Text != "" && txtSearchString1.Text != "")
{
SearchRecord();
}
}

private void btnPrint_Click(object sender, EventArgs e)
{
if (grdSearch.Rows.Count == 0)
{
Field = cboField1.SelectedItem.ToString();
txtAdd = " 0 ";
Filter = "= ";
GetConstraint(Field, Filter, txtAdd);
if (stcSalesInv.SearchSource == "Customers2")
{
frmCustomerList nf = new frmCustomerList();
rptProductList newRep = new rptProductList();
nf.Show();
}
else if (stcSalesInv.SearchSource == "Products2")
{
frmProductList nf = new frmProductList();
nf.Show();
}
else if (stcSalesInv.SearchSource == "Suppliers2")
{
frmSupplierList nf = new frmSupplierList();
nf.Show();
}
}
else
{
if (stcSalesInv.SearchSource == "Customers2")
{
frmCustomerList nf = new frmCustomerList();
nf.Show();
}
else if (stcSalesInv.SearchSource == "Products2")
{
frmProductList nf = new frmProductList();
nf.Show();
}
else if (stcSalesInv.SearchSource == "Suppliers2")
{
frmSupplierList nf = new frmSupplierList();
nf.Show();
}
}
}

#endregion
}
}

If not I don't know what you mean I am sorry...  :(

Spoiler
Spoiler

Obligatory PC specs

CPU: Intel Core i5-6600K 3.5GHz
CPU Cooler: Corsair H50
Motherboard: Asus Z170-E ATX LGA1151
Memory: G.Skill Ripjaws 4 Series 16GB (2 x 8GB)
Storage: ADATA Premier SP550 240GB
Storage: Western Digital Blue 500GB
Storage: Western Digital BLACK SERIES 1TB
Video Card: Gigabyte GeForce GTX 1060 6GB 6GB G1
Case: Fractal Design Define S
Power Supply: Corsair CSM 550W

Spoiler
If you are new please read the CoC!

 Please FOLLOW YOUR OWN THREADS!

 Quote people when replying to them.

PLEASE SELECT 'AUTOMATIC' FOR FONT COLOR FOR DARK THEME USERS.

 Mark your problem as solved if answered and like all helpful information.

 DO NOT QUOTE IMAGES(!) just type -pic- or tag them as spoiler.

Don't criticize people for asking "stupid question".

There is actually a hidden search feature on the forums here: Search 

IT DOESN'T MATTER IF YOU'RE A FANBOY/FANGIRL. WHAT MATTERS IS THAT YOU DON'T LET THAT EFFECT YOUR HARDWARE RECOMMENDATIONS.

DO NOT POST SPAM!

Link to post
Share on other sites
Posted
  • Author
I mostly need to change this one so that I can display the results on the search function.
 
private void btnPrint_Click(object sender, EventArgs e)
        {
            if (grdSearch.Rows.Count == 0)
            {
                Field = cboField1.SelectedItem.ToString();
                txtAdd = " 0 ";
                Filter = "= ";
                GetConstraint(Field, Filter, txtAdd);
                if (stcSalesInv.SearchSource == "Customers2")
                {
                    frmCustomerList nf = new frmCustomerList();
                    rptProductList newRep = new rptProductList();
                    nf.Show();
                }
                else if (stcSalesInv.SearchSource == "Products2")
                {
                    frmProductList nf = new frmProductList();
                    nf.Show();
                }
                else if (stcSalesInv.SearchSource == "Suppliers2")
                {
                    frmSupplierList nf = new frmSupplierList();
                    nf.Show();
                }
            }
            else
            {
                if (stcSalesInv.SearchSource == "Customers2")
                {
                    frmCustomerList nf = new frmCustomerList();
                    nf.Show();
                }
                else if (stcSalesInv.SearchSource == "Products2")
                {
                    frmProductList nf = new frmProductList();
                    nf.Show();
                }
                else if (stcSalesInv.SearchSource == "Suppliers2")
                {
                    frmSupplierList nf = new frmSupplierList();
                    nf.Show();
                }
            }
        }

My Current PC Codename: Scrapper

Spoiler

Intel i5-3570 | Some LGA 1155 MOBO | Some Generic DDR3 8GB 1600Mhz | PowerColor RX 560 2GB | Recycled HP Case | Crucial MX100 128GB | 1TB WD Blue 7200RPM | Some Generic 500w PSU | Intel Stock Cooler

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing Programming

×