|
Hi all,
I need to draw a chart using VB with data from an excel sheet . How should the code be like if I want to have column A to be in the x-Axis and column B data to be the y axis. Please Help. Thanks
Below is my code that charts, but the data info is not what i want
oSheet3.Range("A1").Resize(51, 1).Value = ChartXDataArray
oSheet3.Range("B1").Resize(51, 1).Value = ChartYDataArray
Dim ch As Object
Dim chart1 As Object
Set ch = oSheet3.ChartObjects.Add(100, 30, 350, 270)
Set chart1 = ch.Chart
' chart1.Name = "NAme"
chart1.ChartType = xlColumnStacked
chart1.SetSourceData Source:=oSheet3.Range("B1:B51"), _
PlotBy:=xlColumns
chart1.SetSourceData Source:=oSheet3.Range("A1:A51"), _
PlotBy:=ylColumns
chart1.HasLegend = False
|
|
|
|
|
Hi,
Anyone know a way to allow editing cells in a .net datagrid, while preventing an insert? I wish to avoid having the "add" line appear with the telltale asterisk. The data needs to be editable, but users can not be allowed to add new recs.
Thanks in advance.
cheers,
Bill
Bill Polewchak
Team Leader
Software Development/Architecture
Avery Dennison Corp.
|
|
|
|
|
|
Hello everyone!
I am new to this site & to VB.NET.
I have got following problem.
I have 3 listbox and one datagrid control on my form.
I have 4 tables like-> Customer,City,Area,Country
Relation between these tables is like so:
1 Country --> Many Cities
1 city --> Many Areas
1 Area --> Many Customers
Now what I want to do is that when form is loaded then country names are displayed in listbox1, when user selects a country, all cities of that country are displayed in listbox 2, and when user selects a city then its areas are displayed, and finally when user selects an area then customers of that area are displayed in datagrid.
I have tried selectedindex property of listbox to solve this problem.
Can anyone give me a better suggestion.
I'll be thankful if you can help me by providing an example for it, it'll be easier for me to understand it then.
Thanx.
want to learn.
|
|
|
|
|
Try this.
Public Structure uListElement
Public ID as integer
Public Name as string
Public Override Function ToString() as String
Return Name
End Function
End Structure
Now, fill the listbox1 with this structure, where each element in the structure is a ListElement, e.g.
Dim vElement as uListElement
vElement.ID=CountryCode
vElement.Name=CountryName
ListBox1.Items.Add(uListElement)
In the ListBox1 SelectedIndexChanged event, cast the SelectedItem into a uListItem and you can get the ID of the selected country. Once you have the element, you can execute a select on the datatable of the cities that belongs to the country you just selected. Then you can repeat the same for the Areas and Customers... Got the idea ?
Free your mind...
|
|
|
|
|
In order to solve your problem you need to do the following steps.
try to use procedures always
1)write a code for filiing countries name and can be placed in form load event.
2)write a code in that pass sql query as <select cityID,city from city where cityID=cmbcountryfilled.selectedvalue> and place this code in selection change commited event of country combo.and do the same for area.i ohope it will work.
before that it depends how you are filling the combo.try to use dataset and fill the combo.
please get back to me if you have any doubt...
|
|
|
|
|
Is there any way by which i can find out the name of the current running schedule task.
[consider multiple schedule tasks running at a time.]
For more info on scheduler task component please refer following links;
http://www.codeproject.com/csharp/taskschedulerlibrary.asp
http://www.codeproject.com/csharp/TSNewLib.asp
|
|
|
|
|
|
Use GetTaskNames() to get a list of all the task names. Iterate through the list, using the name to access each task. Ask each task for its Status . If the status is Running then you have a running task. Do with this what you want.
--Colin Mackay--
|
|
|
|
|
I am creating an new scheduled task using vb.net.
I need to pass a parameter to it.
Can it be done in name=value format.
Also how can i read it in other vb.net program which is scheduled.
For e.g., If I pass parameter as follows:
t.Parameters = "name=" & name
then
how can i read this parameter from the scheduled program.
For more info on scheduler task component please refer following links;
http://www.codeproject.com/csharp/taskschedulerlibrary.asp
http://www.codeproject.com/csharp/TSNewLib.asp
Thanks for obliging.
|
|
|
|
|
|
Use Environment.GetCommandLineArgs() to retrieve the parameters passed into your application. This will return a string array each element containing an argument.
You have to define a way to work with these arguments, so if you prefer you can of course use a name=value format. However it is completely up to you.
--Colin Mackay--
|
|
|
|
|
Can anyone tell me how to recursively copy/delete files in VB.NET?
|
|
|
|
|
Send me you email address and I'll send you sample.
BenBadger@Comcast.net
|
|
|
|
|
Why don't you publish the example here ?
That's the idea of the forum, everybody learns...
Free your mind...
|
|
|
|
|
I have already done it.
Besides, you come from comcast.net, which is one of the biggest SPAM senders on the Internet.
Never will you get my e-mail address
|
|
|
|
|
Anonymous wrote:
Besides, you come from comcast.net, which is one of the biggest SPAM senders on the Internet.
How odd that I've never gotten a SPAM originating from a Comcast IP. But I know what your talking about. Machines on Comcast's network, as well as others, have been hijacked by trojan horses to send out a few hundred SPAM's at a time, here and there, so the users won't notice the extra traffic on their connections. It's s a very sneaky way to get around SPAM blockers that block by source domain.
Comcast is pretty strict about not running servers on your connection. Believe me, I've been hassled more than a few times about the web/ftp servers I run for my own private use. In my experience, someone sending out millions, if not thousands of SPAM's would get disconnected pretty quick for violating the TOS.
RageInTheMachine9532
|
|
|
|
|
Hi!
I am new to VB, and have a project for our library that requires some VB programming to compare two excel wbooks. The idea is to compare two alphabetical lists of journals, and combine the records, where they are repeated in both lists, to a third list that weeds out duplicates, and records only the most complete record.
Do any of you have suggestions on how this code should look?
Thanks tons.
|
|
|
|
|
I'm also new to VB.. relatively. Anyway, if you are dealing with Excel, u can use VBA( Visual Basic Application) to do that. That's what i'm using now for VB6 developer. But I think it still works for VB.NET ,... not too sure.
That's for the code language to look out for. As for the design, Have to think about it... but shoul be easy once you got hold of the language. (At least I feel its easier than the language itself for beginners)
|
|
|
|
|
1. How to show the calender dropdown on DateTimePicker control using the keyboard? (Is there a command like the combobox control - combo.droppeddown=true - to show the dropdown list)
2. How can I make DateTimePicker control to have flat appearence?
3. How to make DateTimepicker Control to accept Null/empty Value?
4. Can I make the DataGridBoolColumn to have flat apperance?
Thanks
|
|
|
|
|
Hi, I'm having the same problem. Did you solve this?
/=/=/=/= Sagmam =\=\=\=\
|
|
|
|
|
I am trying to pass data between text boxes and can only get it to happen one-way. I have formA and open formB. Both forms are open and have textboxes on both. I can create a command button on formA to get the text from a text box on formB, but when I create a command button on formB to push the text back to formA it error out with no instance of object.
I dim frm as formA and get to see the properties and controls of formA. Using a statement like
me.frm.textbox1.text = me.formB.textbox2.text
Any suggestions??
Rob
|
|
|
|
|
You need to give formB a way to reference formA. One way of going about this is to add a private field of type formA to formB and then pass the calling instance of formA to formB in its constructor:
(In formA...)
<br />
dim frmB as new formB(Me)
(In formB...)
<br />
Private frm as formA<br />
Public Sub New(ByVal frmRef as formA)<br />
frm = frmRef<br />
End Sub
Then, in formB you can say frm.TextBox1.Text = "Howdy from formB!"
As an aside, you may want to reconsider the way you are designing your app. It might be a better idea to add public properties to your forms and update the display with these properties than to allow direct access to the controls from other classes. This would make it a lot easier to alter your classes in the future.
For example, as it stands now, if you decide that you want to use a combo box instead of a text box you will have to change the code in both forms instead of just the form that is implementing the change.
Charlie
if(!curlies){ return; }
|
|
|
|
|
Thanks Charlie. I made the Dims Public and it works that much better.
Bob
|
|
|
|
|
I'm glad you got it working, but unless this is a throw away app, you may end up kicking yourself later when you decide to change the layout of your UI. A little extra coding now to encapsulate your classes will save you a lot of coding later.
However, if you expect never to touch it again once it's done, public fields will work fine.
Charlie
if(!curlies){ return; }
|
|
|
|