|
Hi,
I am using visual studio 2008 vb.net and msexcel 2010. am continuously pass data to ms excel it will generate a xlLine Chart. It is working fine in my PC but not working in clinet pc. they also using excel 2010.
below see my code
chartPage.SetSourceData(Source:=chartRange)
chartPage.ChartType = Excel.XlChartType.xlLine
pleae help me
|
|
|
|
|
D.Manivelan wrote: It is working fine in my PC but not working in clinet pc.
That's not enough information to go on. Did your application show an error-message? What did it say?
Did you install the InterOp assemblies on the clients PC? Does the client have MS Excel 2010 installed?
|
|
|
|
|
I've been at this on/off for about a week now. I put it to the side & move onto other things and now I'm back to it.
I have a datagridview (dgvScheduleInfo). In its properties I have the "ReadOnly" set to true. I have 6 columns (0-5). The last column ("Notes") I want to make editable if someone clicks on a "Edit Notes" button. Sounds simple enough.
I've used the following code to no avail:
dgvScheduleInfo.Columns(5).ReadOnly = False
I've tried:
dgvScheduleInfo.Columns("Notes").ReadOnly = False
The code above errors out with a "Object reference not set to an instance of an object." even though when I step through the code it shows "Notes" as the name.
I've tried hard-coding a value for testing purposes:
dgvScheduleInfo.Rows(3).Cells(5).ReadOnly = False
and that hasn't worked.
And this is ultimately what I want to work:
dgvScheduleInfo.Rows(dgvScheduleInfo.CurrentRow.Index).Cells(5).ReadOnly = False
When I step through the code, I only get an error on the one I specified. Other then that though the code steps through fine but does not set the column I'm requesting to be editable.
Now yet another curveball...
If I use:
dgvScheduleInfo.ReadOnly = False
It works fine but turns ALL the cells on which I don't want. I only want the "Notes" (or column 5) to be editable.
I've changed the "EditMode" to a couple of different things as well. Nothing.
Hopefully it's something very easy I'm missing.
I haven't changed any of the properties on the datagridview control when I dropped it on my form either. Also I'm using a tableadapter and dataset to populate my datagridview.
The only code in my command button is what I've stated above.
Thanks for any help on this.
|
|
|
|
|
John Waclawski wrote: I haven't changed any of the properties on the datagridview control when I dropped it on my form either.
That's a shortcut that "generates" code in the background, and it might seem like everything works as if by magic; but as you noticed, it takes a bit more than dragging & dropping.
The update-procedure is described here[^].
Most of us will be loading data "by hand", not using the generated code from the designer.
|
|
|
|
|
Hello: I'm working on a large database project that I currently have in VBA/Access 2007 and intend to put into VB.Net/Access 2007 as I think it might be a better idea but I'm not sure. This program is for a large law case where I will be required to deploy it by sending it out on disks to various other firms across the country. I'm a bit rusty with this so I want to know the best way to handle the solution. If all these other firms don't have Access, what other type of database should I use? What is the best practice for deployment?
|
|
|
|
|
Your users do not need to have Access installed; you'll need the JET/MDAC libraries, that's what VB needs to read/write Access-databases. If you need some of the functionality from Access, you could distribute the Access Runtime[^].
I'd recommend against using Access, unless it's a single-user database. Sql Server (Express) would be a more reliable way.
|
|
|
|
|
Terrific.. Thanks so much!
|
|
|
|
|
Hello I'm a newbie at programming and I've taken on my biggest challenge and that is to communicate to my iPhone through the USB serial...I understand that the iPhone communicate via usbmuxd. I've downloaded the software and converted it to vb, but I don't know where to start as far as opening up the ports and getting the coding right. Any help would be appreciated.
|
|
|
|
|
AFAIK, there's no .NET bindings for that library.
|
|
|
|
|
hey everyone i wont to do simple document management system in vb.net 2010 and ms access database back-end. the program will have the following features,
----create folders as the database table fields.
----upload and save PDFs files to the folder in the category created above
--- retrieve the documents
fields on the table are
letter no
received from
sent to
date received
sent date
document description
document path
thank you
|
|
|
|
|
and the question would be ..... ??
|
|
|
|
|
Gimme Codez, its Urgentz..
Sorry couldn't resist 
Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch
|
|
|
|
|
Okay, and your issue is? Do you have a question or are you just lazy and want someone to do all the work for you?
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
I am sure that you could hire any one of us. 
(I could not resist, LOL)
|
|
|
|
|
Parent = context.table
child = From t in parent where ...
In properties, the datasource is set to parent as well.
The bindingnavigators.bindingsource are set to child, all controls and datagrids are bound to the child bindingsoure.
Add new will instaniate a new row. It displays in the datagrids; however, it will not save. The primary key field maintains 0. As soon as I sort or call a new query the row is gone. On reload the row is gone.
Is there a problem with a child binding source?
me.validate()
me.parentsource.endedit()
me.child.endedit()
parent.resetcurrentitem()
me.context.submitchanges()
I have tried ending edit in reverse order and not reseting the current item (needed to update the changes, which works correctly for some strange crazy reason). The problem exists solely with saving a new row.
Does it make a difference that there are two binding navigators? Due to space and design, I opted for 2, but I have tried the addnew on the second.
Hmmm ... Ideas? 
|
|
|
|
|
PrissySC wrote: I have tried ending edit in reverse order and not reseting the current item (needed to update the changes, which works correctly for some strange crazy reason). The problem exists solely with saving a new row.
..when there's no parent to link the children to. Save the parent first, without any children.
|
|
|
|
|
After fighting with this and reading your comment ...
I finally figured out the connection with the new to the relationship of the parent. It was not the actual save for the context that caused the problem, but rather how I was initiating the "new".
parent.add(child.add) solved the problem. Now, when saving the changes to the context, no error and I get validation.
Off to fight with excel export ... 
Thanks for your comment!
|
|
|
|
|
how to read email in yahoo inbox using vb.net and yahoo api
|
|
|
|
|
Start reading here[^], and download the clientlibraries for VB as mentioned on the page.
|
|
|
|
|
I have a form that had a tool bar on it with a few buttons. I do not know what I did but now I can not see the toolbar at all. I can still select in the properties list and change settings on it, such as size, location, width and all that stuff but no matter what I do I still do not see the toolbar.
This is visual studio 2012, I have a backup copy of the application (before I converted it to 2012) in visual studio 2008, when I open it I see the toolbar just fine. I compare every single property of this toolbar on the old and the new and they are the same.
Any ideas what I can do to make it visible again?
no-e
|
|
|
|
|
Long shot. Something else on top of it in z-order?
Cheers,
Peter
Software rusts. Simon Stephenson, ca 1994. So does this signature. me, 2012
|
|
|
|
|
Install "WinDiff" and compare the two .Designer.vb files.
|
|
|
|
|
this is my Problem:
I created a dataset xsd called dataset1.xsd,and xml schema called transaksi.xml
transaksi.xml:
="1.0"="Windows-1252"
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="DataSet1">
<xs:complexType>
<xs:sequence>
<xs:element name="transaksi">
<xs:complexType>
<xs:sequence>
<xs:element name="kd_trans" type="xs:string" />
<xs:element name="tgl" type="xs:string" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>
dataset1.xsd:
transaksi |
------------
kd_trans |
tgl |
And this is my code :
Sub new()
Dim stream As System.IO.Stream = System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("transaksi.xml")
dataset11.ReadXml(stream, XmlReadMode.IgnoreSchema)
MsgBox(dataset11.transaksi.Rows.Count)
End sub
Problem:
Why the value is always 0 ?
|
|
|
|
|
I am having problems exporting a form and all its contents as an image. I just get a picture of the form and nothing of its contents. If I print the form, everything is there, but is i save as jpg, nothing. I have been told to use the draw command but all I can see is how to draw lines and circles etc. Is it possible for me to draw an imported jpg image onto a form. Currently I have 4 portrait pictures all added into individual picture boxes.
Thanks for any help.....
|
|
|
|
|
Set the form to owner-drawing, and check out the Paint event of the form; You can draw your bitmap on the Graphics object.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
