Possible reasons for "Object reference not set to an instance of an object." on that line are: - this = null (not likely) - this.tableAdapter = null, is it? - txtToolNumber = null, is it? - return value of (this.presetTableAdapter.ExistPreset(txtToolNumber.Text)) = null (you can see this by debugging inside the method). If none of those are null the problem is in my understanding inside ExistPreset-method, which (I presume) is genereted by VS, but still debuggable and observable (you can see this by right clicking on the method and selecting go to definition).

Anything dealing with streams is, imo, not "easy". "Possible" would be more appropriate. To me, easy would be: ResourceManager.CopyToFile( filePath ); But I guess you meant easy for you. “Time and space can be a bitch.” –Gushie, Quantum Leap {o,o}.oO( Looking for a great RSS reader? Try FeedBeast! ) |)””’)            Built with home-grown CodeProject components! -”-”-

I copied that from the 5th line of his code :) Mark Salsbery Microsoft MVP - Visual C++ :java:

Hi Use the LocalReport object's Render-method to save the report to PDF-format. After the file is created, print the file for example using Process-class for invoking Adobe Reader with print option. So when only printing you don't actually need the ReportViewer at all. Hope this helps, Mika

I grabbed the error from the data grid and just canceled the exception. e.Cancel = true worked great! Probably not the best way to deal with it but I was reading something that I believe is the source of the issue here, http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=136972&SiteID=1[^]

The database connections are created using DataSets that are bound to controls to those tables and tableadapters within the dataset. Generally using a binding navigator to cycle through the records where needed.

Dalek Dave wrote: Wandering around with a 5.25" made me feel special! I know it's an old post, but I only just saw it, and simply had to reply. I don't hink any comment is necessary. :laugh: ___________________________________________ .\\axxx (That's an 'M')

Do you want to get data from a database and display in your application datagridview? // this is a routine i wrote public static void SP_WITH_DATAGRIDVIEW(string SP, DataGridView DATAGRIDVIEW_X, string PARAMETER_NAME1, SqlDbType SQLDBTYPE1, object OBJECT1, string PARAMETER_NAME2, SqlDbType SQLDBTYPE2, object OBJECT2) { SqlConnection conn = new SqlConnection(your_connection_string); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = SP; cmd.CommandType = CommandType.StoredProcedure; // how many parameters to you have? here is 2, and of what kind? cmd.Parameters.Add(PARAMETER_NAME1, SQLDBTYPE1).Value = OBJECT1; cmd.Parameters.Add(PARAMETER_NAME2, SQLDBTYPE2).Value = OBJECT2; conn.Open(); SqlDataAdapter sql_da = new SqlDataAdapter(); sql_da.SelectCommand = cmd; DataTable dt = new DataTable(); sql_da.Fill(dt); conn.Close(); DATAGRIDVIEW_X.DataSource = dt; } Good luck!!!:cool:

you could use regular expressions to filter the output for testing(until you figure out whats wrong) and only allow certain characters or classes of characters and see what fixes your problem, it isnt a very good permanent solution but it should let you quickly see what is causing the problem and figure out a way to prevent it from bieng loaded into the db or find a way to quickly get rid of it. Ive found this useful[^] Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Here's one way, create a test project with:- 2 Forms (Form1 and DebugWindow) 1 "Logger" class. Form1 just has 2 buttons on it, 1 to write an entry to the "Logger" class, the other to "Show" the Debug form. The DebugWindow form just has a Listbox on it. The Logger class has a static method which can be called from any class in your project, which in turn writes an entry in your DebugWindow listbox. Here's the Form1 class. <<< public partial class Form1 : Form { DebugWindow dbug; public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { dbug = new DebugWindow(); dbug.Show(); Logger.DebugWindow = dbug.DebugListBox; } private void button1_Click(object sender, EventArgs e) { Logger.LogIt(DateTime.Now.ToString("dd MM yyyy HH:mm:ss.fff")); } private void button2_Click(object sender, EventArgs e) { dbug.Show(); } } >>> Here's the DebugWindow class. <<< public partial class DebugWindow : Form { private ListBox _debugListbox; public DebugWindow() { InitializeComponent(); } // // hide form // private void hideToolStripMenuItem_Click(object sender, EventArgs e) { this.Hide(); } // // Properties // public ListBox DebugListBox { get { return _debugListbox; } set { _debugListbox = value; } } private void DebugWindow_Load(object sender, EventArgs e) { DebugListBox = listBox1; } } >>> Here's the Logger class. <<< class Logger { private static ListBox _debugWindow; // // Log Message // public static void LogIt(string sData) { sData = sData.Trim(); UpdateListBox(sData); } // // output to listbox // delegate void ListBoxStringAdder(string sInfp); private static void UpdateListBox(string sInfo) { int iLines = 999; if (DebugWindow.InvokeRequired) { ListBoxStringAdder lsa = new ListBoxStringAdder(UpdateListBox); DebugWind

Hi, Two comments: 1. I suggest you have a look at String.StartsWith() 2. You might want to store the results of cachedPartNumbers[i].ToString() rather than calling it all the time :) Luc Pattyn [Forum Guidelines] [My Articles] Voting for dummies? No thanks. X|