C#

FirstPrevNext

C# Excel RTD server hirenkshah5-Feb-09 23:57 hirenkshah 5-Feb-09 23:57  hi, I have created Excel-RTD server in C#. like this article http://weblogs.asp.net/kennykerr/archive/2008/11/13/Rtd3.aspx[^] Here data is populating randomly in excel file. I will start RTD Server from different project (like button clik) :- able to start successfully and i want to send/update data to rtd server from other project. :- object used by RTD sever has no value, it is worked altogether in different thread. Thanks hiren shah hirenkshah@gmail.com Re: C# Excel RTD server Rob Philpott6-Feb-09 0:18 Rob Philpott 6-Feb-09 0:18  That's great. Regards, Rob Philpott. Data grid combo box items in windows application pavanip5-Feb-09 23:35 pavanip 5-Feb-09 23:35  Hi, I have a data grid control and I placed one combo box in that data grid and I am binding data to data grid combo box.When i run the application by default the combo box is not showing anything if i double click on combo box then only it is displaying the items. Can anybody please help me to resolve the problem showing combo box items in data grid control by default when i run the application. Thanks in Advance Pavani tab key in a textbox felixdisc5-Feb-09 23:15 felixdisc 5-Feb-09 23:15  Hi, I want to give a value in a textbox when the 'tab' key is pressed in another textbox. My code is this: private void textBox1_KeyPress(object sender, KeyPressEventArgs e) { if ( (e.KeyChar.Equals(('\t'))) || (e.KeyChar.Equals(Keys.Tab)) ){ this.textBox2.Text = "hola"; } } But the only way that it works is to set the 'Multiline' and 'AcceptsTab' properties to be true (both properties at the same time, unless it not works). And the problem is that on this way, to press the tab key the focus not change to another textbox. Anybody knows a better way? Re: tab key in a textbox OkkiePepernoot5-Feb-09 23:25 OkkiePepernoot 5-Feb-09 23:25  Why not use the Leave or Validated event for this ? Re: tab key in a textbox felixdisc5-Feb-09 23:30 felixdisc 5-Feb-09 23:30  It is a good alternative. I can use the keyPress event for the intro key, and the Leave event for the tab key. Ok, thanks windows service created in 2005 .net is not running in vista arun_pk5-Feb-09 23:00 arun_pk 5-Feb-09 23:00  2869 is the error code which is shown while installing the service setup .The service is working good in XP. is there any thing which i should add while creating service to run in vista Re: windows service created in 2005 .net is not running in vista musefan6-Feb-09 0:31 musefan 6-Feb-09 0:31  dont know the error code but when i had a vista issue, it was to do with the project manifest, maybe you could look at that. Its to do with trusting the application or something My opinion is... If someone has already posted an answer, dont post the SAME answer Re: windows service created in 2005 .net is not running in vista arun_pk6-Feb-09 0:34 arun_pk 6-Feb-09 0:34  thanks but what is this project manifest Re: windows service created in 2005 .net is not running in vista musefan6-Feb-09 0:37 musefan 6-Feb-09 0:37  something to do with security, somes vista apps seem to want it to run. Its somesort of xml coded file that determines how the application should run, i.e. as administrator or user etc. I cant remember in detail have a look at this or search c# manifest or something http://support.microsoft.com/kb/944276[^] My opinion is... If someone has already posted an answer, dont post the SAME answer Lock ComboBox VB 8.05-Feb-09 22:30 VB 8.0 5-Feb-09 22:30  Hi CP, I am desiging a custom control combobox that looks like combobox at design time in VS 2005 . I am left with one thing. I dont want to use dropdownstyle but i want the user cannot write any text at runtime in the combobox. i suppressed the combobox & removed the caret.' ReQ : i want the user cannot write anything in the combobox if the caret is not preset also. Regards vb8.0 Re: Lock ComboBox Christian Graus5-Feb-09 22:46 Christian Graus 5-Feb-09 22:46  Sonds like a disaster. Why have a combobox at all ? Christian Graus Driven to the arms of OSX by Vista. Re: Lock ComboBox VB 8.06-Feb-09 0:10 VB 8.0 6-Feb-09 0:10  Hi Graus , Thanks for responding.This is for the end user. I am creating a custom ComboBox which doesnt accept the caret , text and doesn't show the list . Now i required is how to hide the focus when the cursor is on the combobox button to show as disable. 1 ) how to hide the focus when the cursor is on the combobox button at runtime ? Any ideas ? Any views regarding this ? Regards, VB 8.0 Re: Lock ComboBox musefan6-Feb-09 0:15 musefan 6-Feb-09 0:15  VB 8.0 wrote: a custom ComboBox which doesnt accept the caret , text and doesn't show the list . You mean a 'Label'??? My opinion is... If someone has already posted an answer, dont post the SAME answer Re: Lock ComboBox Henry Minute6-Feb-09 2:28 Henry Minute 6-Feb-09 2:28  Why on earth would you want to design a combobox with no dropdown? Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.” Re: Lock ComboBox MatthysDT7-Apr-10 5:11 MatthysDT 7-Apr-10 5:11  I hate it when people respond with "WHY DO YOU WANT TO DO THAT?" The OP asked HOW, not WHY!!! Regardless of your reasoning! Re: Lock ComboBox Henry Minute7-Apr-10 5:17 Henry Minute 7-Apr-10 5:17  I've heard of being a dollar short and a day late but you're 14 months late and I'm definitely a dollar short. Not that it matters now but the reason that I asked why was so that I could get a better handle on what the OP was really trying to do, the better to formulate a sensible reply. Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.” My SQL Import xls files Burim Rama5-Feb-09 22:14 Burim Rama 5-Feb-09 22:14  Hello everybody First sorry my english but i need som help. I have a website where i sal computer and other stof, every day i get i xls. file from one company with price list model number, description and other thing. Every product in my website has parnumber: thats unik. So i want to make a function in c# to update the price in mysql database because the price changes every day. How can i make a function like update table_name from c:\test.xls (take just price and partnumber from xls file ) where partnumber=(partnumber from xls) ? I hope really much you can help me. Re: My SQL Import xls files Christian Graus5-Feb-09 22:21 Christian Graus 5-Feb-09 22:21  You will need to write code to parse the Excel file ( either export as csv, or use the Office interop stuff ), then write your SQL. Christian Graus Driven to the arms of OSX by Vista. Re: My SQL Import xls files Burim Rama5-Feb-09 22:23 Burim Rama 5-Feb-09 22:23  Thanks but do you have som code in c# i can use ? Re: My SQL Import xls files Christian Graus5-Feb-09 22:45 Christian Graus 5-Feb-09 22:45  Not really, no. Connecting to a db is trivial, and widely documented. Parsing a CSV is trivial, use File.ReadAllLines and the Split method on the string class to break each line into discreet items. Controlling Excel is also well documented. Christian Graus Driven to the arms of OSX by Vista. Re: My SQL Import xls files MacSpudster6-Feb-09 9:57 MacSpudster 6-Feb-09 9:57  Burim, I had written an app to import excel files. That was some 3 years ago, so I no longer have the code. I did a google search for "C# import excel file into sql" and I found the same link I had used to write the code some 3 years ago. The link: http://davidhayden.com/blog/dave/archive/2006/05/31/2976.aspx[^] I recommend you use this link to do the following: 1) SQLBulkImport the Excel file into an import table (a table in the same database but that is only used for this purpose) 2) Call stored procedure that grabs the needed data from the import table and updates whatever table(s) you need to update. In my case, I had a Unique partNumber, too, so I would A) Mark records in my primary table as "inactive" (I use a tinyint with 1=inactive and 2=active) that were no longer in the import table B) Add new records from the import table into the primary table. C) Update records in the primary table with changed values in the import table (usually the description and price). Hope this helps. ASP ~ Apple Simply Performs How to make real time progress bar in winform azad yadav5-Feb-09 21:43 azad yadav 5-Feb-09 21:43  Dear users I want to know how to make real time progress bar in winform, using thread or without thread. Regrads Azad yadav Re: How to make real time progress bar in winform Harvey Saayman5-Feb-09 21:57 Harvey Saayman 5-Feb-09 21:57  You'll have to use a separate thread, otherwise you wont see the progress bar being redrawn and updated. Have a look at this[^] article Harvey Saayman - South Africa Software Developer .Net, C#, SQL you.suck = (you.Passion != Programming & you.Occupation == jobTitles.Programmer) 1000100 1101111 1100101 1110011 100000 1110100 1101000 1101001 1110011 100000 1101101 1100101 1100001 1101110 100000 1101001 1101101 100000 1100001 100000 1100111 1100101 1100101 1101011 111111 Re: How to make real time progress bar in winform musefan5-Feb-09 22:12 musefan 5-Feb-09 22:12  you dont 'need' another thread, you can just call Update() whenever you want, but you should use another thread else you will lose UI of your form My opinion is... If someone has already posted an answer, dont post the SAME answer

Last Visit: 31-Dec-99 18:00     Last Update: 5-Jun-24 21:18 Refresh ᐊ Prev1...5716571757185719572057215722572357245725 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.