About my name: I made it years ago and when all that stuff was cool. I kind of regret that now. I'm changing my username :)

The first rule of CListCtrl is you do not talk about CListCtrl - kornman

There is a lot of truth in that. I can do OOP but I can't always explain it to someone who barely knows the subject. Teaching is the best way to understand the matter, that much is true, but I don't have the time to do it. This gets frustrating when the person doesn't see the difference between casting to a string and use the toString() method (which is the case). That difference tells me that almost nothing of the classes he's taken have stuck with him.

The first rule of CListCtrl is you do not talk about CListCtrl - kornman

You're right, I could take it as a compliment... if he knew me at all (he doesn't know my background/skill). In the real life scenario, can't you 'expose' him to your boss by performing code review with some of your peers (assuming he's not the only peer you have)? In my situation, that would be showing the line where he tries to cast an int to a string when he should be using toString().

The first rule of CListCtrl is you do not talk about CListCtrl - kornman

A little rant against my school's policy on failing students (and pairing them with good ones). I'm currently studying software engineering, I'm in my second year, and now we've got to do a project. There's nothing wrong with the project itself but there is with the person I'm doing the project with. The programming language is Java, which we learned in our first year, and he failed his exams twice. You're allowed to fail for a few subjects if you pass them in your second year and he's doing them at the end of the second year. This is my problem. I have to complete a project with a team member that lacks the necessary skills. He's not great with UML (the second thing he failed for) and he's dyslexic which means I can't put him on documentation duty. The teacher (which is supposed to guide us)a said I'll just have to teach him because such situations also happen in 'real life'. Isn't teaching their job? Nonetheless, I have tried to take his advice but I can't get my team mate to understand OOP concepts. This isn't the first time I've been in this situation but I do want it to be the last. So, what should I do? Ask another teacher's opinion? Make the project alone and hope for the best?

I'm half scared, half excited. His name is one of the biggest mysteries and I want to keep calling him 'The Doctor', not 'John Smith' or something unpronounceable due to a million apostrophe's. The poster for the episode says 'his secret revealed' but there's still a (childish) cop-out. It could be about how he acquired the name of 'the Doctor' only I fear it's not. Oh well, we'll just have to wait and see.

The first rule of CListCtrl is you do not talk about CListCtrl - kornman

I went a whole lot simpler and it's still throwing exceptions.

private void frm_Shown(object sender, EventArgs e)
{
DataTable t = new DataTable();
t.Columns.Add("a");
t.Columns.Add("b");
t.Rows.Add("a","b");
System.Diagnostics.Debug.Assert(t.IsInitialized == true);
dataGridView1.DataSource = t;
}

I have no idea why this is bugging.

The first rule of CListCtrl is you do not talk about CListCtrl - kornman

Hello CP, I've run into a problem while working on an interface for the result of raw SQL. The user inputs the raw SQL code and the form renders a result, it's an educational piece of software so nothing too fancy. Now, the problem I have is that after putting the result into a DataTable, it crashes when I pass it as a DataSource for the DataGridView. The database I'm querying is an MSAccess (2003, mdb) database. Oddly enough, it doesn't misbehave (crash) when I'm using an SQLite database. I would like some help since the stacktrace isn't making sense to me.

Quote:

A first chance exception of type 'System.ArgumentException' occurred in System.Drawing.dll System.Transactions Critical: 0 : http://msdn.microsoft.com/TraceCodes/System/ActivityTracing/2004/07/Reliability/Exception/UnhandledUnhandled exceptionSimpelQL.Net.vshost.exeSystem.ArgumentException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089Parameter is not valid. at System.Drawing.Font.GetHeight(Graphics graphics) at System.Drawing.Font.GetHeight() at System.Drawing.Font.get_Height() at System.Windows.Forms.DataGridViewRow..ctor() at System.Windows.Forms.DataGridView.get_RowTemplateClone() at System.Windows.Forms.DataGridView.RefreshRows(Boolean scrollIntoView) at System.Windows.Forms.DataGridView.RefreshColumnsAndRows() at System.Windows.Forms.DataGridView.OnDataSourceChanged(EventArgs e) at System.Windows.Forms.DataGridView.set_DataSource(Object value) at Proj.Net.MainForm.evt_Exec(Object sender, EventArgs e) in L:\Dev\Proj.Net\MainForm.cs:line 139

The first rule of CListCtrl is you do not talk about CListCtrl - kornman

I was messing around with resource files and such in C#. I found out that with a Compiled Resource Script you can add multiple icons to your applications. Then I found out that a manifest file allows you to force it to be run as admin. But a choice has to be made between the two (in c#). I came to the conclusion that the Compiled Resource Script must contain a manifest.(if this is faulty, please correct me.) I took a quick look into Resource Scripts (RC) C++ and saw something of a structure. IDI_ICON1 ICON "file.ico" IDB_BITMAP1 BITMAP "file.bmp" Taking a peek in the Resource.h file that was generated I noticed the definition for IDI_ICON1, same goes for IDB_BITMAP1. ICON and BITMAP seem keywords for the Resource Compiler (can't find their definitions in #includes). But what if I want to add a manifest? IDM_MAN MANIFEST "file.manifest" ends up with a folder called "Manifest" (including quotes, which does not happen with ICON and BITMAP). I've seen MSDN saying that a manifest can be to an existing (post-compile) binary file, but can it be done with Resource Script, compiled with RC.exe?

The first rule of CListCtrl is you do not talk about CListCtrl - kornman

Hello CP, I'm currently messing around to build a plugin system and want to use subfolders. After a bit of searching I found that adding a <probing privatepath=""/> element to app.config allowed subfolder usage.

My only objection to this is that it is yet another file (one the user can edit :s) , my question is: Can I merge this configuration file with the exe or is there another way to do this? It would be preferable to put this in the manifest or something.

The first rule of CListCtrl is you do not talk about CListCtrl - kornman

modified on Sunday, August 28, 2011 11:13 AM

So I've built a nice big Stored Procedure and call it from my SSIS package. My SP uses a temp table since it uses nestes SP's. Here's what I tries:

+------+-Table variable-+-Temp Table-+--Temp Table from SQL Server Management Studio--+
|Result|Failure | Failure | Success

It always fails unless I force a 'create table' from SQLSMS and keep SQLSMS open, the moment I close it the temp table gets dropped. What on earth is going on? I can only guess it's got to do with permission but I wouldn't really know where to look.

The first rule of CListCtrl is you do not talk about CListCtrl - kornman

A tool you say? "You have reached the code limit. Please insert more BACON."

The first rule of CListCtrl is you do not talk about CListCtrl - kornman

(global) text editors aren't very advanced, it isn't meant to be. I'm using Notepad++ for my text files and coding snippets. When programming an actual application (.Net), I use VS2010 on my desktop and SharpDevelop for my laptop.

The first rule of CListCtrl is you do not talk about CListCtrl - kornman

Hello CP, I've got a package in Sql Server 2005 (Integrated Services) and had a question about the useage of parameters. I perform a right click on my package and pick 'Run Package'. I go to the Set Values tab and put in my parameters like this:

Property path | Value
\package.variables[Dir].Value | C:\DBExports\
\package.variables[Month].Value | 4

Here's my problem: I want to use a single package to export the current and past month. Is there a datetime function or macro I can call in the Value field?

The first rule of CListCtrl is you do not talk about CListCtrl - kornman

It works fine in the Server manager. I've got a workaround though, create the temp table once (outside of the query) and truncate it at the start of the query. This also means I'm no longer dropping it. It's a strange little bug though.

The first rule of CListCtrl is you do not talk about CListCtrl - kornman

Hello CP, I'm messing around with SSIS and have run into a problem when trying to get the DataReader Source to work. The problem is simple; I'm trying to set the SqlCommand property to point to a stored procedure: EXECUTE [dbo].[spMyProc] '20110101', '20110131' The problem does not lie in calling the SP but rather with something in the SP. My SP makes use of Temp table and it seems it cannot find it:

Error at Data Flow Taks[DataReader Source[1]]: System.Data.SqlClient.SqlException: Invalid object name '#tmpCalcTable'.
at System.Data.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

The Stored Procedure creates a temporary table and later deletes it, but it seems it's either not doing that or can't access the it. I've tried making the temp table global by using a double hash (##) instead of one but without luck. Does anyone have an idea how I can fix this?

Just use the mmb for a new tab, that way you got an arm left to eat bacon.

You understood it perfectly. I had been looking at BCP and tried to format it correctly (from the command prompt, not sqlcmd), but it bugged on my nested stored procedures. Haven't looked at SSIS yet, gonna do that now. But I'm getting off-topic. You answered my question.

Hello CP, I've set up a job to perform a stored procedure at a given time, nothing special. In the step (which triggers the SP) I've specified the output file in the 'advanced' section. The output in the file is the execution time (moment) and the 'select' form the SP. My problem is the output file format. Does anyone know how to set it to CSV or perhaps another solution?

The .Replace is bothering me because "\\" is the same as @"\". Maybe you meant @"\\" instead of "\\".

Have you looked into Mono[^] yet? Mono is .Net for Linux but I believe it's limited to .Net 2.0. Developing Mono (.Net) for Linux can be done with a Visual Studio plugin for Windows or MonoDevelop which also runs in Linux.