|
I am running the following code. It executes when the value of variable i is 1 and when the loop continues and value of i becomes 2 i am getting error "Object reference not set to an instance of an object" in the cmdSearch.CommandText line in the code. . There is no problem with connection string. It successfully retrieves when i = 1. Can anybody help me out what is the problem. Please post with corrected code if anybody can help.
===========================================
for (int i=1; i <= objFolder.Items.Count; i++)
{
System.Data.OleDb.OleDbConnection odbSearch = new System.Data.OleDb.OleDbConnection();
System.Data.OleDb.OleDbCommand cmdSearch = new System.Data.OleDb.OleDbCommand();
odbSearch.ConnectionString = strConn;
cmdSearch.Connection = odbSearch;
item = (Outlook.ContactItem) objFolder.Items.Item(i);
string em = item.Email1Address;
cmdSearch.CommandText = "select * from Outlook_Contacts where FirstName='"+fn.ToString().Trim()+"' and LastName='"+ln.ToString().Trim()+"'";
odbSearch.Open();
OleDbDataReader rdrSearch = cmdSearch.ExecuteReader();
while( rdrSearch.Read())
{
RecordFlag = true;
}
odbSearch.Close();
}
===========================================
|
|
|
|
|
What are fn and ln? Where are they defined?
|
|
|
|
|
fn and ln are declared outside and the values are properly getting passed to those variables. The code executes when i=1 and when the value of i becomes 2 the error occurs. There is no problem with connection string also. only when the code executes to the commandtext line it shows the error. that too i am getting one record successfully(when i = 1). hope this helps
|
|
|
|
|
well, some thing is null. It is either item, cmdSearch, fn or ln.
can you step through it in VS and check?
|
|
|
|
|
I have done that. I am getting one record ie. when the value of i = 1. When the value of i increases to 2 then in the commandtext line this error occurs. And also fn and ln are fine. Can you please tell me how to solve it?
|
|
|
|
|
Like bigtrev said, just step through and check fn and ln.
Or perhaps you got the line number wrong and item is null.
Anyway, just step through and check.
Btw. you know that building SQL commands the way you do is highly vulnerable to SQL injection?
You should use parameterized queries instead.
Regards,
mav
|
|
|
|
|
hi,
when enabling visual style in an application ,tool bar button disappear , how to cater it so that visual style and tool bar button can be enable at the same time.
|
|
|
|
|
Don't forget the call to Application.DoEvents();
Application.EnableVisualStyles();
Application.DoEvents();
Application.Run(new AgilePlannerMainForm());
Maybe that solves your problem.
Claudio
Claudio's Website
|
|
|
|
|
Please tell me the way to build a "Add-in" in .Net. I also need some documents and articles about this detail.
You can mail me at: vonhattruong@yahoo.com.hk
Thank you very much
|
|
|
|
|
What do you mean by Add-in in .NET? An Add-in for Visual Studio .NET? Or an Add-in architecture for your own application?
Anyway: Why don't you search here on codeproject? There are several articles about Add-Ins for Visual Studio as well as complete Add-in architectures for your own applications.
Claudio
Claudio's Website
|
|
|
|
|
It's "Add-ins for Visual Studio .Net" . Thank you for your information. It helps me a lot in my project.
|
|
|
|
|
In my setup project (for Windows application), a dependency is shown for the dotNETFXRedist_x86_enu.msm. However when i try to include this in my setup file (by removing the checkbox on Exclude button on this file)
"dotNETFXRedist_x86_enu.msm must not be used to redistribute the .NET Framework. Please exclude this merge module."
What can be the reason? Do i have to include some other file for including the .NET framework in my setup program?
|
|
|
|
|
The merge module is there for VS.NET to check the dependencies of your program.
The Exclude flag is set by default because M$ doesn't allow distribution of the .NET framework this way.
You have to install .NET prior to installing your app.
MSDN[^] describes the different ways you can go.
Regards,
mav
|
|
|
|
|
When i prepare a setup project and do not include .NET runtime (redistributable) framework in setup project, will the setup program automatically give an error message to user (on whose machine .NET fw does not exist) at the time of installation indicating that first he should install the .NET fw and then gracefully exit the installation? Or I have to test myself in the code whether the .NET exists on user's machine? (My test on one or two such machines showed that such an error is automatically displayed - but does it happen always?)
Secondly, can anyone suggest from practical experience as to roughly how many machines running windows (irrespective of versions) would have .NET framework already installed? I will appreciate even a wild guess ( say about 25% machines, 50% or 90%). This will help me in deciding whether to include .NET fw (a heavy size) in my shareware application setup program or to take the risk of a few machines being told by setup to download the same from the Internet instead of i carrying such heavy beggage in my setup program.
|
|
|
|
|
If your setup project was created using the one that comes with Visual Studio, and not using something like Wise for Windows Installer, then yes, the installation will not launch if the .NET Framework is not installed already.
As for the number of machines that have the framework installed? Who cares. A better question would be how many of your customers run on broadband as opposed to dial-up. Also, a user might have the .NET Framework installed, but not the version that your application requires. Instead of trying to decide if you should supply the .NET Framework redis with your app, supply it as a seperate download! Supply a link to Microsoft's download site if you have to. Make sure it's for the version of the .NET Framework that your application requires. They can be installed side-by-side without any side effects.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
hello world
can you helpe me
ang get me source code
tankyou
|
|
|
|
|
If you're looking for source code, try Google.
If you're looking for help with YOUR source code, then ask a specific question about it.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hello,
I'm trying to use late binding for office automation with the following code example from microsoft:
http://support.microsoft.com/?scid=kb%3Ben-us%3B302902&x=2&y=7#5
Compiling the application is no problem.
But when starting it i get an exception which tells me that something is wrong with mscorlib.dll.
I tried this code example on 2 Windows 2000 maschines and a XP maschine, all with visual studio.net 2003, but always the same exception.
Has anybody an idea?
Regards
|
|
|
|
|
Is it possible to use another method than ToString to display directly contents of objects.
Thx.
Andri Mar Jónsson
|
|
|
|
|
|
Hello
I need a little help in C#. I'm using the webbrowser component to have a browser on my application. I need to send a postdata to a https page.
I know that I can use the method Navigate and specicy the url where I want to pass the values.
What I don't know is how can I use the postdata in the navigate method.
|
|
|
|
|
Hi there:
I strongly beleive there is a strange logical problem with the overall docking behavior of the dotnet controls. What a developer needs is that what control he docks first, gets docked first regardless of in what order the controls were added to the container. But dotnet IDE docks the controls in a specific order that somehow depends upon in what order the controls were added to the container. The worst is dotnet doesn't explains what is that specific order. Let me xplain the problem by an xample:
1) In any form, add a panel.
2) Create 2 label controls on the form called label1 and label2.
3) Drag label1 to the panel.
4) Drag label2 to the panel.
5) Set the Dock property of both to bottom.
6) Doesn't matter, in what order u perform the step 5, label2 will always be at the bottommost position.
Now repeat the same procedure as above, but change the following steps.
2) Create 2 label controls directly on the panel called label1 and label2.
6) Doesn't matter, in what order u perform the step 5, label1 will always be at the bottommost position.
SO u can clearly see that docking behavior is changed in both cases. In step6 of first one, label2 will always be docked at the bottommost position, while in 2nd case, label1 will always be docked at the bottommost position. Is this behavior justified and can developers rely on this type of uncertain behavior. Plz. comment on that.
The practical problem, i'm facing due to this uncertain and unjustified behavior is that:
1) I have made a custom container control, which has a label(acting as a caption). This label must always be docked to the topmost position in this control, so i have set Dock=Top for this label.
2) But due to dotnet docking behavior, when a user adds another control to this custom container and sets the dock property of that control to top, it gets docked at the topmost position and the caption label gets one level down, while it is not expected to change the position inside the control.
Is there another solution available, so that my label always stays at the topmost docking position.
There is anoher issue, at which i need ur comments, although i'm not sure whether its really an issue or not. The issue is based on the basic OOP principle of Composition. In original C++ or Java, when ur class(say ClassA is composed of two or more classes(assume its two classes named ClassP, ClassQ), then none of the classes ClassP or ClassQ is supposed to lose any of its functionality in any way when contained within ClassA. But in dotnet it happens. How?
1) Start a new Cutom Control Project.
2) To ur custom control add a label, that is supposed to act as a caption. Dock it to top.
3) Add a panel to ur custom control and Dock it to "Fill".
4) Build the project.
5) Add a new windows application project as the testing project to ur solution and to the form in that project,add an instance of ur custom control.
6) Run the project and u see the panel has lost its functionality as a container.Y??
In answer u may tell me that if i want my custom control to be a container, i should inherit it from ContainerControl Class. But no, the whole of the control is not supposed to be a container in my case, only the area that contains the panel, need to act as a container. So while talking about the basic Composition principles of OOP, the ClassP and ClassQ should not lose their functionality, but in dotnet panel loses its main functionality as a container.
If u feel these are the problems, plz. tell me how can i notify microsoft about that so that they corret these bugs in their next .net release.
PLZ. HELP ME OUT
ZAM
|
|
|
|
|
I want to know how to write a xp style toolbar , Is there some Sorce Code?
|
|
|
|
|
Are you referring to Windows XP, or Office XP style toolbars? In any case you will need to obtain some third party package to accomplishw what you want, whether it be here in CP or available through purchase. You can always enable the XP themes using a manifest file, but this may not be what you want.
Some examples of good third party UI kits:
http://www.xceedsoft.com/[^]
http://www.janusys.com/[^]
-
Drew
|
|
|
|
|
Hi
I have created and deployed my C# Winform project.
Now I want to add Source Control for a new version of my app so that new users can use the new version.
Is it built in into VS.net or i need to install something before i can get this.
Also when i go to Source Control I see everything greyed out.
thanks..
rt7
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
