|
put your query string in a local variable and display it. you will see that there are missing quotes. it looks like you mixed quote and apostrophe up.
try this (untested; im not sure about the date format):
"Insert INTO " + tableName + " (
id,
name,
client,
expstartdate,
expenddate,
cost,
description) Values( " +
createpro.propertyPId + ", " +
"'" + createpro.propertyPname + "', " +
createpro.propertyClient + ", " +
"'" + createpro.propertyExpStDate + "', " +
"'" + createpro.propertyExpEndDate+ "', " +
"'" + createpro.propertycost + "', " +
"'" + createpro.propertydescription + "'" +
")"
|
|
|
|
|
|
hi try this one:-
"Insert INTO "+tableName+" (id,name,client,expstartdate,expenddate,cost,description)Values('+createpro.propertyPId+',' "+createpro.propertyPname+" ',' "+createpro.propertyClient+" ',' "+createpro.propertyExpStDate+" ',' "+createpro.propertyExpEndDate+" ','+createpro.propertycost+',' "+createpro.propertydescription" ')";
|
|
|
|
|
|
thank you every one for taking interest in my query
muhammad mahmood ilyas
|
|
|
|
|
Hi all,
greetings.can any one give me the coding for searcha customer details in a web page by giving any of the details of a customer like customer id,or city,or country, like that.since i'm new new to C# kindly any one tell me the coding for the mentioned above in C#.
Babu
|
|
|
|
|
This problem has little to do with web programming. Once you have the result of your search, you can assign it to a datagrid and you'll be able to see it. What matters is, where is the data coming from, and how do you hope to gain access to it ?
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
I have a picture box designated as the one of the designs of my form, the problem is, when i assign an mdichild to my form, that mdichild is always at the back(behind) of my picturebox and i can't find any solution to put it in front of my picturebox... i need your help.. thanks a lot!
|
|
|
|
|
It should be possible to change the Z-Order, by calling MoveToBack() or something like that. I don't know the exact name of the method, since I dont have C# here right now.
WM.
What about weapons of mass-construction?
|
|
|
|
|
Hello
After instantiating the mdichild call the BringToFront() method.
|
|
|
|
|
Hi
first put the picture box in a frame or in the group box then create mdichild
|
|
|
|
|
Hello,
Can you please tell me how can I show an icon on a listView control?
Thank you.
|
|
|
|
|
1. Add two image lists to the form.
2. Fill one image list with the small icons for detail view and the other one with the large icons (if you want to use large view).
3. Assign the image lists toe the properties SmallImageList and LargeImageList of you ListView.
4. When adding list items, give each item an ImageIndex.
_____________________________________________________________________________
I don't expect too much, all I want is your vote for Halbsichtigkeit.
|
|
|
|
|
Thank you very much!
I thought I had to use API 
|
|
|
|
|
Hi,
I am working on compiling java code from C#. But I am not getting the exact way, how can I compile it. Here I should not use J# compiler for compiling java code and I should not use any classes and methods in System.diagnostic namespace.
Here I am developing C# winforms application which contains text area and compile button. The user is going to write, compile and execute code for C# or VB.Net or Java. For C# and VB.Net, we have CSharpCodeProvider and VBCodeProvider. But for java we do not have any compiler for compiling java code from c#.Here i should not use any file concept. Simply I am writing java code in text area and whenever I click compile button, it need compile and if any errors it need to show.
Please give me a solution ASAP.
Thanks & Regards,
Hanumanth Reddy.K
|
|
|
|
|
I have an application in VS2005 .Net but i don't have VS2005
Can i open an run the application in VS2003.
If "yes" then how to do that.
Thanks in advance.
Rahul Kulkarni
|
|
|
|
|
You could create an empty solution/project and add all the files.
But it probably won't compile, because VS2005 creates C# 2.0 code and VS2003 only knows C# 1.x.
Why don't you install SharpDevelop?
_____________________________________________________________________________
I don't expect too much, all I want is your vote for Halbsichtigkeit.
|
|
|
|
|
|
|
|
I wrote this simple (VS.NET2005 ? C#) performance test program
http://www.galador.net/stuff/PerfTest.zip[^]
which could draw with either:
- "Default Method"
- "Method 1"
Now if I select "Method 1" nothing at all is drawn   
I can't get it.....
Is it a weird GDI+ bug? or am missing some obvious error?
|
|
|
|
|
My bug 
0xFFDEAD is tranpsarent
instead 0xFFFFDEAD should be used!
|
|
|
|
|
There is any way to make a control invisible at design time when "Visible" property changed to false?
|
|
|
|
|
No, because you need to be able to see it in order to work with it.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Hi!
I'm using the colorDialog to let the user select a color, then I save it to the registry. Everything is fine except with the user doesn't select a named color. What I am getting save to the registry is something like:
ffff8000
I tried the following:
ColorConverter colConvert = new ColorConverter();
treeview1.ForeColor = (Color)colConvert.ConvertFromString(regkey.GetValue("ColorName").ToString());
But it's not working when the color is not named, e.g. Yellow.
I'm getting:
ffff8000 is not a valid value for Int32.
Please help. Thanks.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
