Answer Questions
Puspak Create 300 excel worksheets
I have to create a little over 300 worksheets (this is a common task and I want to make it some want automated). I have an excel workbook that contains the names of each tab(worksheet) A1-A304 (in this case). I want to be able to first open that workbook and pull that data out into an array or whatever you suggest and then run a loop to create new worksheets in a new workbook for each cell (A1-A304). Thanks Dim XL As New Excel.Application Dim xlwb As Excel.Workbook = XL.Workbooks.Open( "C:\pile-excel\pilegroups.xls" ) Dim xlsheet As Excel.Worksheet Dim SheetNames As New List( Of String ) For Each xlsheet In xlwb.Worksheets SheetNames.Add(xlsheet.Name) Next For ...Show All
Vivek Thakur Putting a byte in to a text box
Hi, Please can someone paste some code for me, I am trying to put a byte in to a text box but have no iead how. I'm pulling my hair out with VB 2005 express and have no idea how to do anything. Thanks In which code - mine or yours As described before by me in one of your threads, SerialPort is not something, which should be defined. It is a method of System.IO.Ports and SerialPortReceivedEventArgs is an argument you can forget all about. Why not read the answers we have posted before We try to help you here, but you don't even bother to read the answers and at least try to understand them, and you do not answer our questions. For example, I asked you how you want your byte to be displayed. ...Show All
KaiZHOU Build.Tasks.Get excluding certain directories?
Is there a way to customize the <Get> task of TFS so that I can say exclude getting certain directories under the source folder Thanks! The easiest way is just to modify the WorkspaceMapping.xml file (checked into the same directory as TfsBuild.proj). Check out the following post for more info: http://blogs.msdn.com/manishagarwal/archive/2005/10/13/480584.aspx . -Aaron Take a look at this blog, maybe it can helps you, another option could be create your own custom task. Sorry I forgot to put the link, take also a look to this another blog which has some info about build on specified labels and so on http://blogs.msdn.com/nagarajp/archive/2005/10/21/483590.aspx ...Show All
&#290;&#38;&#35;174&#59;&#8364;&#287;&#38;&#35;167&#59;Q&#315; Disable F1....F12 buttons in c# browser application.
I am writting XAML web application, in which i want to capture all key events, I am able to capture all keys, but the problem is with function Keys, from F1 to F12, When i press such keys, it also takes action on browser, which i dont want, Can any one help me for this problem. Thanks in advance. Nisarg ok, well it seemed you were using a webbrowser control until you edited your original post :-) In my code the webbrowser control name is Page1.xaml. and there is no such type of method named "WebBrowserShortcuts". I try to looking for this.page1 but i am not getting event Page1 after this.... you can disable the actions o ...Show All
TA123 Paper source and printer settings
For those who keep struggling with these printer issues.... The following code might be worth playing around with. (GrandpaB, Wake Up!) (It definately works on my PC where all values are know. Might not be useful in projects to publish to unknown PCs.) Public Class Form1 Private Sub Setup_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click ' Get dialog that can access paper source and other printer info ' Set and apply needed changes Dim p As New Process p.StartInfo.FileName = "rundll32.exe" ' Change below to YOUR PRINTER NAME. (Next two subs also) ' If you present it as a variable it still needs quotes around it p.StartInfo.Argu ...Show All
Al33327 I can't believe I miss SourceSafe!
Ok, I'm late to TFS. This is my first contract with it. I can't think of a Microsoft release I've been more disappointed by. I'm stunned they've stuffed up Source Control again (ah well, v3 rule again lol!). Yes shelving is fantastic. It really is. BUT: - Get Latest doesn't always Get Latest. Now this is as bad as it gets in terms of an SDE. I've seen it time and again (guys on the project now ONLY Get Specfiic Version, Select latest and Overwrite). - Add files is a pain (no context menu ). Doesn't seem to be a smooth way to incorperate added files to a changeset - You cannot simply Move a Folder (I mean come on. We've lost histories because of this, and if the serious response is to write an add-in to it I'd consider TFS feature incomple ...Show All
Yaakov Ellis Create New Team Projects from Clients fails
Hi, We have a problem.... We have installed TFS on our Server which is a TFS only server. We have followed each step from the the manual. We have setup some users to be administrators on the TFS. We have also added them as Content Managers in the reporting services. The admin right is also set on Sharepoint. Now to the funny part when we are logged on the TFS server we can create team projects. If we login on a workstation with the Team Explorer installed it crashes. We have figured out the this happens when the wizard tries to setup the Reporing services. If anyone can give us some tips on how to solve this it would be very appriciated. BR Magnus Muller It would be good to post the snippit of project creation log where it ...Show All
JesseD70 Nice tool but small annoyances
Almost beats Subversion but merging tool needs one small detail - when you have two upper windows with original and new source code and you scroll one of the windows left or down - Subversion automatically scrolls the another. That's very useful. If TFS team will fix this small thing - Team System will tie again vs Subversion... Thanks for the feedback. You might try a 3rd-party merge tool: http://blogs.msdn.com/jmanning/articles/535573.aspx ...Show All
Tryst Need help with Datagridview
need help creating several lines of code for my program. I current have used the code below to insert a column into my datagridview. Now after Insert this column I go through each row and insert a numeric value. My first issue is that I need to be able to modify this code to ask me if this is a regular or discontined item. Then I need to have three contant columns in my datagridview. One column will average all of the regular items and the next will average all of the discounted items and the third will average the discounted and regular items together to give me a total. So I need help modifing my existing code to ask me if this is a discounted or regular item. Then I need code for my datagridview that will allow me to put in thre ...Show All
Shadoware Technologies How to get Table Name from Dataset
Hi, I'm using a stored procedure to populate the dataset I want the tables name from the dataset I'm using this code private void button1_Click( object sender, EventArgs e) { SqlCommand cmd = new SqlCommand ( "GetGroupBusinessRules" ,con); cmd.CommandType = CommandType .StoredProcedure; SqlDataAdapter da = new SqlDataAdapter (cmd); con.Open(); DataSet ds = new DataSet (); da.Fill(ds); con.Close(); //string a = ds.Tables[0].TableName.ToString(); //MessageBox.Show(a); GetTableNames(ds); } private void GetTableNames( DataSet dataSet) { // Print each table's TableName. foreach ( DataTable table in dataSet.Tables) { MessageBox .Show(table.TableName. ...Show All
MGunes progress bar to load data
i have a form (connected to a database) and a button to load that data using code. now i want to use a pogress bar inside the form to load data whilsts it connecting. how is it possible to do this using code there are two points i need to make: point1: what should the variable types be for the variables "DoEvents", "vbHourglass" and "MousePointer" point2: i have a button which loads the data connection called btnLoadData and it does the following: Dim con As New OleDb.OleDbConnection con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = C:\Documents and Settings\David Morgan\Desktop\soccerdb\soccerdb.mdb" con.Open() sql = "SEL ...Show All
cdolor A Few Questions
Ok, I have a few questions for coding: 1.) How can I make a button on one form, pop-up another designed Windows form 2.) How do I make people open a browser when using a LinkLabel 3.) How do I make it possible when people click on a LinkLabel, that it sends a e-mail request (like mailto:name@site.com ) if you known I mean I'm using - Microsoft Visual C# 2005 Express edition Hi, Alex As admedilyas described, To let form1 closed while open the second form, you can close the first Form1 use this.Close() in form1.cs. And code form2 = new Form2(); form2.show() in program.cs but not in form1.cs. BTW, I recommend you to seperate the list of questions into several threads& ...Show All
Tim Tyhurst WorkItemFormControl hanging on .Item assignment
Hello All, I am seeing the WorkItemFormControl form hanging while I initialize it with the following code: m_wifc = new WorkItemFormControl (); m_wifc.Item = paramWI; m_wifc.Dock = DockStyle .Fill; m_wifc.Name = "WIFC" ; When the .Item property is assigned, the control seems to hang and never return. Here is the callstack from the debugger: [Managed to Native Transition] Microsoft.TeamFoundation.WorkItemTracking.Client.DataStore.dll!<Module>.CLocker.Enter() + 0x19 bytes Microsoft.TeamFoundation.WorkItemTracking.Client.DataStore.dll!Microsoft.TeamFoundation.WorkItemTracking.Client.DataStore.FieldClass.IsReadOnly.get() + 0x69 bytes Microsoft.TeamFoundation.WorkItemTracking.Client.dll!Microsoft.Tea ...Show All
Jassim Rahma Binary File Encryption
hello, hi coders... i have been searching the help and msdn site for hours now but could not come up with a complete solution. by the way i am using vbexpress2005 for my coding. i have several binary files (like dbf,idx,etc) that i want to encrypt using vbexpress2005 cbuilt-in lcasses. there are some example for encrypting text files but i could not get a complete code snippet for encrypting/decrypting binary files. could somehow paste these sample codes if they have them thanks. also how to you decrypt a binary file "to memory" it is a bit useless to have a strong encryption if you will just decrypt the binary file to hard drive right anyone could then just locate the decrypted file using simple dir listing ...Show All
Eragon. Set and Run chosen [external] files?
First off, I'm very sorry if this isn't where I am meant to post this, this has so many subforums I'm a bit new so please don't fall off your chair laughing if this is a bit obvious to you, because it isn't for me. I don't want to hear "you're stupid haha!". I did search for answers before posting this but none of them are like what I'm asking... ...::: I have 2 controls, they sit next to each other. One I call "set1" which is a CommandButton, and the other I call "run1" which I don't know what it should be but right now it's a LinkLabel. When I click set, an OpenFileDialog pops up, you pick a file and you are asked what you wish to label it as. What I want is when you set the file with set1, ru ...Show All