Comments by Ryan Zahra (Top 164 by date)

From experience, I would create a log file and dump all variables there to make sure that all variables contain the desired values.

Thanks for the detailed explanation. I know that I need to dispose of all resources however I believe that I'm still missing something here but I don't know what I'm missing. I used the handle.exe tool and sure enough, the process that is locking my file is iisexpress.exe, since I'm testing this on my local machine. At this point, I suspect that it could be something that I'm not disposing from the itextsharp library, however, I don't know what. Any pointers would be really helpful! Thanks!

Ok, I updated the question to include the full code listing.

The file is just 75KB. Regarding flushing the stream to disk, I did a quick test and included a memory stream flush before closing the PdfReader. However, this still resulted in the same problem. Regarding the filename, I just a different filename each time. The code I pasted here is trimmed down to show only the required code.

I'm sure that the method is being called only once because this method will fire on a button click event. I check again by adding a breakpoint at this code and the execution enters this piece of code only once.

As far as I know I believe that I'm closing all streams in the correct order.

Thanks again :)

Sorry for the long delay but I couldn't test this out earlier. Clearly, you were 100% correct. I just needed to include the namespace before the class name and worked like a charm. If you want, add your reply as a solution so that I can mark it as an answer. Thanks again!!

In my case, even the namespace is incorrect. It's like the website is looking for the class in a wrong namespace.

Thanks for your reply.

Sorry, didn't know this. So, I can't ask hardware details in code project?

Can't do that because cmd.ExecuteScalar() is returning a DBNull value. Therefore, it will give me an invalid cast exception.

Hi Prasad,

Thanks for your reply.

1. The expected result should be a date and time, however, I'm receiving an empty result (DBNULL)
2. I've already did that, and replaced the ?s with actual values and it worked fine in MSACCESS

You should search for ajax in asp.net...there are loads of tutorials online

Can you please explain more exactly what you're trying to do?

Ok then, what about doing it server side, through ajax?

You can still use the same javascript on the fileupload control.

Why aren't you using a FileUpload control?
<asp:FileUpload ID="FileUpload1" runat="server" />

The rowguid is mainly used to solve page-split clustered indexes

Thanks :)

Welcome :)
Please mark your question as solved if I solved your answer. Thanks!

Check the answer given here: http://stackoverflow.com/questions/1001973/how-to-tell-if-a-thread-has-exited-successfully
It states exactly how and when a thread is stopped.

If you still want to use the thread, why not just set the text of the label directly from the thread?

Are you sure that the database column is set to an integer?

Could you debug your code and check the returned value of HowzeEducationId?

When I tried this, I got the following error:
JOIN expression not supported.

Remember that I am using Microsoft Access

When I tried this, I got the following error:
Syntax error (missing operator) in query expression 'tblDJs.ID = tblEventDJs.djID
LEFT JOIN tblVenueDJs ON tblDJs.ID = tblVenueDJs.djID
LEFT JOIN tblEvents ON tblEvents.ID = tblEventDJs.eventID
LEFT JOIN tblEvents ON tblEvents.ID = tblVenueDJs.eventID
LEFT JOIN tblVenue'.

Exactly. The first time is always the most difficult until you get the hang of it. Once you do it at least once, it's pretty straight forward.

Thanks a lot :)

Just one more question though...
In your example, you're using the interface IMPILayer. What should you include? I'm trying to include the .tlb file in my solution but still not having access to the interface. I could not even be able to find the namespace.

Thanks! So this is exactly just like calling a normal COM object.

Thanks for your reply. Do you have any examples please?

Thanks for your reply. I know how to use COM object in C++ using the CoCreateInstance function, however I'm still lost as how to use the COM+ object in C++.

What are you trying to do? do you have any code to show?

http://forge.mysql.com/wiki/MySQL_Internals_File_Formats

Can we see the code for the derived form where you are adding the controls?

Same thoughts. My 5.

Thanks :)

Perfect answer! My 5

My 5! Good as well!

In my case, support is not a problem as I'm using this for Windows Server 2003 SP2 and over. In your opinion, which function should I use and why?

Agreed, but which should I use? Which one is the best?

According to MSDN both functions are secure. See http://msdn.microsoft.com/en-us/library/ms647466(v=VS.85).aspx

Debug your code! Check the values that are passed to the business logic and the values that are loaded from the database.

Before starting any code, you should learn to use google first. Good luck :)

Make sure that the database cannot accept null values. Also, before adding the row to the dataset, make sure the newRow does not contain null values.

My 5

It means that there is a null value in oldRow which is being assigned to the newRow. This means that in your database you have a null value.

I'm sorry but I can't help you more than I've already did. I mean I don't have all your tables and all your source code in order to keep helping you. I'm sorry...

What do you mean by "show error in other tables"?

Use the below code with caution! Make sure that the columns are the same when filling in the newRow object!

if (!found)
{
DataSet ds = ((System.Data.DataSet)(((System.Windows.Forms.BindingSource)listBox2.DataSource)).DataSource));
object[] oldRow = drv1.Row.ItemArray;
object[] newRow = new object[3];
newRow[0] = oldRow[0];
newRow[1] = oldRow[0];
newRow[2] = oldRow[1];
dt.Rows.Add(newRow);
listBox2.DataSource = ds;
}

Can you change the column type to string at least until you fetch the dates from the database and then change it back to DateTime?

Did you include #pragma once in stdafx.h?

What are the columns and data types of the stopBindingSource and RouteBindingSource?

You should get those dates as strings and then convert it to a date. You should then split the date to get the hours, divide that by 24 and you'll have the days, hours minutes and seconds.

Is the binding for id and value of both listboxes the same?

Yes you need to include it. But you need to include it only once in the whole project!

Replace that line of code with this one:
DataSet ds = ((System.Data.DataSet)(((System.Windows.Forms.BindingSource)listBox2.DataSource)).DataSource));

What have you done so far? Please first try to do some research and then come here with code and the error that you have.

Please show me the code that you're using where this error is showing

If I understood you correctly, do following modifications:

if (!found)
{
DataSet ds = (DataSet)listBox2.DataSource;
ds.Tables[0].Rows.Add((drv1.Row.ItemArray);
listBox2.DataSource = ds;
}

How do you expect the DateTime variable to store those times? The hour variable cannot be greater than 24 hours because that would make a whole day. Thus those time values are incorrect. Anyway, what are you trying to do with those "times"? You should convert your "hours" into days in order to have that value. Or if you still want to have those "time" values, consider storing them in a string.

You must help me to understand your code in order for me to help you. How are you binding the data source? What is the data type of your data source?

What did you try? Where do you have the exception?

Ok, but how are you doing the binding?

What is the data source that you're using to bind with the list box?

you must replace 'myDiv' with the id of the div that you are using

You're welcome :)

Thanks :)

What have you done so far?

Instead of hiding the tab, you can change the tabcontrol.SelectedIndex to a tabpage of your liking.

Preferably you use the IDE in which you will be developing your project. This way, you would find them ready when you start coding.

Please explain exactly what you want to do. Is the "other" website your website or a third party website? Also what have you done so far? do you have any code?

Cheers :) You still got my 5 as you were spot on!

Put a try catch block. See the error message and reply back.

IDE examples:
Visual Studio for C# and VB.Net
Eclipse and Net Beans for Java

You should have asked all that from the start...

Anyway, I myself, use the following method:
-> When the client clicks on the image, I would show a hidden div.
-> This div contains the required question and two buttons (Yes/No)
-> If the user clicks 'No', I would hide the div.
-> If the user clicks 'Yes' I would call the delete function.

This should help you more:
http://www.tizag.com/javascriptT/javascriptconfirm.php

What do you want to do exactly?

My bad...use wsprintfA instead of sprintfA

Write a cookie: http://msdn.microsoft.com/en-us/library/aa287547(v=VS.71).aspx
Read a cookie: http://msdn.microsoft.com/en-us/library/aa287533(v=VS.71).aspx

Before launching the webpage, create the cookies.
When the webpage is being loaded, search for the cookies.

Your problem was that you defined it twice. I'm glad that you solved the problem.

Also if my answer solved your question, please mark my answer as the solution. Thanks :)

Glad you found your mistake :)
Since you're initializing your font on the load event, it would be safer to have your font in the website itself. Thus when loading the font, make sure that the path is found in a folder in the website itself.

I'm against having clients install the font themselves. Its a bit of hassle for a normal user to install a font just to view one particular website. Make sure to avoid it!!

Modify your stdafx.h:


// include file for standard system include files,
// or project specific include files that are used frequently,
// but are changed infrequently
#ifndef _WIN32_WINNT // Allow use of features specific to Windows NT 4 or later.
#define _WIN32_WINNT 0x0501 // Change this to the appropriate value to target Windows 98 and Windows 2000 or later.
#endif
#pragma once

#ifndef VC_EXTRALEAN
#define VC_EXTRALEAN // Exclude rarely-used stuff from Windows headers
#endif

//Do you really need your dll to use IE features?
//If no, remove the below 3 lines.

#ifndef _WIN32_IE // Allow use of features specific to IE 4.0 or later.
#define _WIN32_IE 0x0400 // Change this to the appropriate value to target IE 5.0 or later.
#endif

#define _ATL_CSTRING_EXPLICIT_CONSTRUCTORS // some CString constructors will be explicit

// turns off MFC's hiding of some common and often safely ignored warning messages
#define _AFX_ALL_WARNINGS

#include <afxwin.h> // MFC core and standard components
#include <afxext.h> // MFC extensions
#include <afxdisp.h> // MFC Automation classes

#include <afxdtctl.h> // MFC support for Internet Explorer 4 Common Controls
#ifndef _AFX_NO_AFXCMN_SUPPORT
#include <afxcmn.h> // MFC support for Windows Common Controls
#endif // _AFX_NO_AFXCMN_SUPPORT</pre>

can i see the file stdafx.h? you definitely have something wrong in there.

How do you know that its working when your code is not even compiling? Please try my suggestions and reply with the result.

Can you give the link to the previous question to get a better idea of the problem?

"windows.h" and "commctrl.h"

Did you "#include <commctrl.h>"

What's not working? Do you an error message?

Thanks! I appreciate it a lot!!!

When you create a folder in your solution, you can see it immediate after being created by using the windows explorer. More than that I cannot help sorry.

I'm not 100% sure. However you can create the folder with the above code. Then in the solution explorer you must press the button to "Show All Files". This will show you all the files in the solution. You must then manually right click on the file and select "Include In Project". May I ask why you want such functionality?

The add a file to the solution, right click your solution, point to add, and click add folder.

What have you done so far?

What have you done so far? Do you have any code to show?

Excellent explanation. You have my 5. Also thanks for following up my answer as yesterday I lost my connection to the internet. Had a problem with the ISP.

What code have you done so far?

Thanks :)

That code is getting the installed software, however its not getting the file version...

I think you forgot the link :p

You're right. Thanks for clearing it up :)

I tested with "TabStop" and "False" and it worked fine...

Some questions:
Is pParamUTF16Str a wide string?
Are you compiling your code in UNICODE?
Can you debug your code and check the value stored in shellExecuteInfo.lpParameters?
Are you sure that javaw.exe accepts UNICODE characters?

raw_OpenRecordset = executes the sql select statement and stores the retrieved data into the record set rs
fs->get_item = gets the selected column
in the while loop, while not End Of File (EOF) and not Begin Of File(BOF), the rows are retrieved in valx and valy. These are then printed on screen and the record set is moved to the next record.

Which part exactly you want further explanation?

Maybe this could help you out:
http://www.codeproject.com/KB/miscctrl/touchscreenkeyboard.aspx

Do you really need to convert the dll from vc 6 to vs 2008?
What I mean is that you could still use the dll from vs 2008 :)

Debug your program and add a watch to the dataset. check if there is a table in the dataset and also check if the table contains any rows.

Do you expect other people to do the work for you? What have done so far? Have even started? Should what you've done so far in order to help you and not to do your work.

You have to replace:
#import "G:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll"

with:
#import "G:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll" rename("EOF", "EndOfFile")

You should try renaming the EOF by doing the following:
#import "G:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll" rename("EOF", "EndOfFile")

Can you give me the exact error code?
Also make sure that the path to the dll and the path to the tlh are correct

Did you try different versions of IE? That is did you try IE6, IE7, IE8 ?
However, if you want a really good menu, go for a CSS menu which will always display correctly whatever the browser.

Please explain further what you're trying to do. Also post your code so far.

You're welcome :)

Good to hear :)

Could you post the error message that you got both from the C++ and C# environments?

From the code that you gave me, there is no code that saves any data to the database.

I want the vb code not the asp.net code

I can't understand what you really need to know...maybe you could explain a bit better please.

Hi Ubaidh Sayed,

You must call the Check Changed event of the radio buttons. Then check if the radio button is checked, and then execute your code.

protected void rbDelete_CheckedChanged(object sender, EventArgs e)
{
if (rbDelete.Checked == true)
{
System.IO.File.Delete("ImagePath");
}
}

protected void rbCover_CheckedChanged(object sender, EventArgs e)
{
if (rbCover.Checked == true)
{
//don't know what you mean by setting image as cover page but this is where you code must be placed
}
}

I cannot tell you why because I dont have all your code. Please post your code in order to help you out.

Dim ts is holding the date and time difference. This means that ts can hold a difference of less than a day. This means that ts can even hold a number of hours.

In your first if statement, this first condition is to check if the number of days is 1 or less. Thus having between 0 and 24 hours. In the else if statement, you are checking if the number of days is greater than or equals to 30 days.

I'm asking you to debug you code in order to know the value of ts and which if statement the program will execute.

Are you debugging your code? Where is the problem with your data?

Now its obvious, but it was never specified...

Totally agree with you!!

Are you working on a windows application or a web application? Please provide more information!!

Dim txtFDate = CType(DetailsView1.FindControl("fdate2"), TextBox)
Dim txtTDate = CType(DetailsView1.FindControl("tdate1"), TextBox)

Dim fDate As Date = CDate(txtTDate.Text)
Dim tDate As Date = CDate(txtTDate.Text)

Dim ts As TimeSpan = tDate.Subtract(tDate)
Dim days As Integer = ts.Days

As Minute said, DataGridView is in the Windows.Forms namespace, so you should try Imports System.Windows.Forms

My mistake, confused it with DataTable...sorry

I must ask why you are opening the connection and not always closing it, apart from not being in a try catch finally block.

Also try to debug your code and watch the variables value. What are the values of tdate and fdate? Are you sure they are storing the date correctly? Also what is the value of days?

Where's you code? What have you done so far?

Can I see the whole method instead?

You made my day lol

Does the user exist in the client's database?

It's difficult to explain COM in a few lines. Here's a good tutorial to get you started:
http://www.codeproject.com/kb/com/CCOMThread.aspx#COM_APARTMENTS
http://www.codeproject.com/KB/COM/CCOMThread2.aspx

Also I recommend reading the book Inside COM by Dale Rogerson which is very simple to read and understand. I've learned COM from that book.

Worked for me.
Please make sure that the cell index is pointing to the correct column. That is if the lblCategory is found in the first column, the cell index is 0, if the lblCategory is found in the second column, the cell index is 1 and so on.

This might help you with the saving to excel
http://social.msdn.microsoft.com/Forums/en/csharpgeneral/thread/ef11a193-54f3-407b-9374-9f5770fd9fd7

Excellent reply! 5+ from me

Is IGreet registered correctly? How are you registering it?
Is IGreet2 inheriting from IGreet?

Thats they way to go ;)

Thanks :)

I agree 100% with Dalek. Unless you know the gender, you'll never be 100% accurate.

Thanks ;)

Can you please add more detail as to what you want to accomplish?

Frame 10 and Frame 11 are trying to load an htm web page.

Depends on the contents of the page and what you're actually trying to load. Keep user experience of the website in mind.

Thanks :)

Your user control must inherit all the methods available for the ajax ComboBox

That's very strange indeed. At least you've got it working :)

In the following code, you are creating a new instance of ImageButton. The ID of the button definitely doesn't hold your file extension.
"ImageButton btnObj = new ImageButton();
string FileExt = btnObj.ID.ToString();"

Can you please specify where you are storing the file extention?

What browser are you using? Have you tried different browsers?

Sorry...my mistake

what do you see when you type "http://localhost" in your browser?
Also, if you navigate to "http://0.0.0.0/WebApplication/Default2.aspx?accNo=3333333333333" does the web page load?

I'm using the following code:

string url = System.Web.HttpContext.Current.Request.Url.Authority;
After the line of code executes, the variable url holds the following: "localhost:64848"

string host = System.Web.HttpContext.Current.Request.Url.Host;
After the line of code executes, the variable host holds the following: "localhost"

Can you please show me your code.

First of all, are you using a button or an image button?
Also, what are you trying to do here? "string FileExt = btnObj.ID.ToString();"

Each button click event must call a function where the processing should be done. Your code should look something like this:

void MyFunc(string buttonID)
{
//insert function code here
}

private void btnOne_Click(object sender, EventArgs e)
{
Button b = (Button)sender;
MyFunc(b.Name);
}

private void btnTwo_Click(object sender, EventArgs e)
{
Button b = (Button)sender;
MyFunc(b.Name);
}

private void btnThree_Click(object sender, EventArgs e)
{
Button b = (Button)sender;
MyFunc(b.Name);
}

Can I see your code please?

Quite an easy question to reply to :)
Your answer is good too..everyone has his/her approaches.