|
Your SQL string is probably being built incorrectly.
You should run the debugger and take a look at the SQL string before it gets sent to the database. It's the only way you're going to find out what's wrong.
Also, if you have any apostrophes ['] in your fields, then you need to properly escape them.
|
|
|
|
|
I am using dot.Net
I have a control table with Menu group and Group Items. I display the Menugroups on a treeview control. For each item on the group tree, there are corresponding items that is displayed in the listview. There is no problem with the treeview items. My problem is how to know a the particular listview items selected or clicked by the user.
There is nothing like Key property or index property to track the listview items in dot Net
Please assist
Tunde Aransiola
|
|
|
|
|
You can store information in the ListViewItem.Tag property.
|
|
|
|
|
After doing a lot of searches on many many forum, i feel that this one is closest to the help lvl i need...
Introduction:"
*Lift your hand and put it on top of any key on your keyboard. example [F]*
*Put down you finger and press this key [F] ... as a result you will see the character "F" writen on your screen.
*From what ive seen sendkeys.send("f") or sendkeys.send("F") i belive it only sends a msg of the character "F"\"f" instead of reproducing the signals the keyboard makes.
My Problem:"
*** I need an program that each 'x' seconds will press the keys "space bar"\"q"\"w"\"e" ... i dont know if my solution is setting something like hook.dll and control it thru there . And after that, i need the program i made to control my mouse to be able to move the mouse & preform clicks, within any game (ex:liniage\mu-online\World of warcraft...etc)
Basically i need a program that mimics the functions of the mouse & keyboard. I trust you gurus will help me on this... cause im allmost getting a nervius tick
|
|
|
|
|
Dim AbortSending As Boolean = True
Dim Keyboard As SendKeys
Do While Not AbortSending
Keyboard.Send(" qwe")
'Or
Keyboard.SendWait(" qwe")
Threading.Thread.Sleep(500) ' This will delay for 500ms before next send
Loop
|
|
|
|
|
If you are not simply looking for code to do this yourself, i.e. you only want to simulate mouse and keystrokes, then there is an excellent BASIC like scripting language called AutoIt which even compiles to standalone exe's.
goto http://www.autoitscript.com/autoit3/index.php for details and downloads (its FREEWARE).
Hope that helps.;)
Tremonde.
|
|
|
|
|
I have been looking for a control like Flexgrid in dotNET but could not see any. I need a grid that is not attached to any datatable. I want to programatically control the grid. Any help will be appreciated.
I am using .Net 2003
Tunde Aransiola
|
|
|
|
|
aransiola wrote: I have been looking for a control like Flexgrid in dotNET but could not see any. I need a grid that is not attached to any datatable. I want to programatically control the grid. Any help will be appreciated.
I like this one[^]
Michael
CP Blog [^] Development Blog [^]
|
|
|
|
|
i saw the C# Grid by Davide Icardi. i am using vb.Net how can i use this with VB.Net codes
thanks
tunde aransiola
|
|
|
|
|
|
I know in visual studios before 2005 you could make a database connection in server explorer then simply drag and drop the connection path to the form and it would make the connection strings and all for you. It doesn't appear to work in 2005 this way.
Basically I wanted it to make the oledbconnection and all for me like in the old days. Sure I can code it manually but it would be more convenient the old way. Is there something I'm doing in correctly cause honestly I don't even see the old oledbconnection dataset and so on controls in the tool box like they use to be.
Just started playing 2005 version so please pardon my ignorance.
Win32newb
"If I wrote a book like I code. It would be one page thick and contain only one word (DUH!)"
|
|
|
|
|
win32newb wrote: I know in visual studios before 2005 you could make a database connection in server explorer then simply drag and drop the connection path to the form
Mixing the UI and the data layers? Uugh... This whole dragging and dropping database connections on to the form encourages some of the worst designs for software. You really ought to try and get out of the habit of doing that.
win32newb wrote: Basically I wanted it to make the oledbconnection and all for me like in the old days. Sure I can code it manually but it would be more convenient the old way.
Sure, it's convenient. But it make the software a maintenance nightmare.
Sorry that I am not more sympathetic to your plight, but you should really consider creating some sort of DAO (Data Access Object) of your own to manage all database connectivity within your application. Then you don't have to worry about dragging and dropping connections all over the place, because you already have a class that does all that for you.
ColinMackay.net
Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?
|
|
|
|
|
You wouldn't happen to have a good url that would explain how to do this in code would you. Its been a while since I have coded using visual studios and things have obviously changed.
Please give me a url other than a generic google.com or msdn.com.
Also, what happen to the code that windows compiler generates? What I mean is in 2002/2003 version you could click on the designer and you would see a region that says windows generated code so you could find things that the compiler made for you and modify them if needed. I don't see that anywhere now when I click on the designer in 2005.
Sorry to be a pest and hope I'm not just getting back into the game and I'm lost
Win32newb
"If I wrote a book like I code. It would be one page thick and contain only one word (DUH!)"
|
|
|
|
|
win32newb wrote: You wouldn't happen to have a good url that would explain how to do this in code would you. Its been a while since I have coded using visual studios and things have obviously changed.
Do what in code? Create a DAO? That has never changed as it wasn't a function of VS in the first place. You should do a search on "Layering Pattern", "Data Access Layer" or "Data Provider" - I know you didn't want a generic search engine link, but I don't have the time to look for every document that might help you. It really is a skill you ought to learn if you don't already know how to use internet search engines.
win32newb wrote: Also, what happen to the code that windows compiler generates? What I mean is in 2002/2003 version you could click on the designer and you would see a region that says windows generated code so you could find things that the compiler made for you and modify them if needed.
.NET 2.0 supports a concept called partial classes. That means the class is split over two or more files. In the solution explorer you can expand the form class and see more files underneath it. The windows designer code is in there. This is not the compiler that generates this code, it is the visual studio designer. You should never edit code created by the code generator, this is increasingly true in VS2005 because VS regards the designer file to be its own that no one else will touch.
ColinMackay.net
Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?
|
|
|
|
|
Hi!!
I'm just beginning to learn vb.net. I'm trying to implement sobel and canny edgedetection in vb.net.I have some set backs in it.I would greatly appreciate if any one can give me working source code in vb.net or give a link to pages containing it.please!!
signing off is preci
|
|
|
|
|
I made the vb.net and sql server connection programically. Now the problem is I want to add, delete the records in sql server by vb.net front end programically.
Please help me
Thanks and Regards
Pankaj Garg
-- modified at 5:46 Sunday 26th February, 2006
|
|
|
|
|
You can issue any SQL commands throught the SqlCommand object. If you don't know SQL already, now would be a good time to learn.
ColinMackay.net
Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?
|
|
|
|
|
In treeview I populated all the drives with their files and folders programically . Now the problem is I got stuck in attaching their icon with their files and folder programically (at run time).
Please help me.
Thanks and Regards
Pankaj Garg
|
|
|
|
|
pankajgarg12 wrote: Now the problem is I got stuck in attaching their icon with their files and folder programically (at run time)
If your asking how to attach an icon to a particular item, Joshua already gave you the answer[^].
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
-- modified at 12:18 Sunday 26th February, 2006
|
|
|
|
|
I have a tree control and a combo box in the form.Whenever I select the particular node the full path of the node gets added in the combobox.
Now the problem is , When I select the particular item in the combo box , the concerned node does not get selected in the tree control.So what is the code to select the tree control node programically through the combo box.
Thanks and Regards
Pankaj Garg
|
|
|
|
|
What I recommend that you do is store each node's path into its TreeNode.Tag property.
When a ComboBox item has been selected, do a recursive search for that path starting at TreeView.Nodes.
Once you've found the right node, assign it to the TreeView.SelectedNode property.
|
|
|
|
|
I have a simple applicqation that ued about 45 tables, sored in Win-20043 server. I have to do some report design for the Database.
To solve the problem , I downloaed the table and frontend to my laptop and used the linked table mager to linke the front end and the tables.
Now tthe trouble starts; I update 4 report tables from querying some other tbales in VBA- access 2002.
IF I stop the application in dubug mode and examine the Tables- they have same data. Even more so IF I edit a row in one table other tables change values in the same row and column.
However the Data in the tables are different, If I examine the back end. I have tried to understand if thyere is any relationsip- it appers to be none.
Any ideas will be appreciated.
Tapas Shome
System Software Engineer
Keen Computer Solutions
1408 Erin Street
Winnipeg, Manitoba
Canada R3E 2S8
www.keencomputer.com
-- modified at 3:21 Sunday 26th February, 2006
|
|
|
|
|
Hi,
I have an application in vb.net that produces a report using ReportViewer (visual studio 2005). What would be the best method to convert the text on my reports from english to french for french speaking end users?
Thank you,
Rashar
-- modified at 22:18 Saturday 25th February, 2006
|
|
|
|
|
Rashar,
Deploying Reports and ReportViewer Controls
Deploying Localized Versions of ReportViewer Controls
The ReportViewer control includes language packs for eight languages: Chinese-Simplified, Chinese-Traditional, French, German, Italian, Japanese, Korean, and Spanish. To use a localized version of the control, you must do the following....
http://msdn2.microsoft.com/en-us/library/ms251723.aspx[^]
hope this helps.
progload
|
|
|
|
|
Oh Perfect!
Thanks so much.
|
|
|
|