|
Below is the query
SELECT AccountNum, LastName, FirstName, PolicyNumber, Premium
FROM INSURE_TABLE
This is query in the Data Adapter Configuration Wizard.
|
|
|
|
|
OK. That leaves the code you have to setup and execute the query. Something isn't right, either from how you setup the connection, like connection string and SqlConnection objects, down to setting up the SqlDataAdapter. Without seeing that code, there isn't much we can tell you.
|
|
|
|
|
Which other code are you requesting?
The only code i have is the one in the Form_Load with reads:
jesSqlDataAdapter.Fill(jesDataSet1)
or
jesSqlDataAdapter.Fill(jesDataSet1, "Table_Name")
I used the data wizards to configure the dataadapter and dataset.
I chose the Microsoft OLE DB Provider for SQL Server at the Data Link Properties.
|
|
|
|
|
Hi,
Thanks to Dave Kreskowiak who guided me to use Backgroundworker. It is a fantastic feauture. However I have experienced a difficulty to run the class what handles the background processing via backgroundworker control. I have received the following error message. If you know the solution, I would like to know also.
Thanks.
Cross-thread operation not valid: Control 'Archive' accessed from a thread other than the thread it was created on.
The scenerio is a simple task as described here: I created a class. The class inherits from a form and produces a listview and then assigns it to a property variable. There is two progress bar which are used to show the progress while reading the records. This class is called by the application inside a sub procedure. The main form is calling the class.
'APPLICATION FORM1
<STAThread()> _
Public Sub LoadArchiveFiles()
Dim myApp As New Loadarchive
myApp.FileName = ArchiveDirectory
'
ListView1 = myApp.NewListview
ToolStripStatusLabel1.Text = myApp.StatusMessage
End Sub
What a curious mind needs to discover knowledge is noting else than a pin-hole.
|
|
|
|
|
OK. The problem I wanted to avoid, you stumbled into. You cannot touch a UI control from a thread other than the one that created the control. So, that means you can't directly interact with the ToolStripStatusLabel from the code that is running in the BackgroundWorker.
I can't tell you how to do it right now, because I'm short on time, but if you do the research yourself, you're Googling for "VB.NET Delegate Invoke Thread".
|
|
|
|
|
Hi All,
How can i develop Barcode True Type Font.Please give me some idea about it.
Thanks
Best Regard
Anubhava Dimri
mailto: anubhava.prodata@gmail.com
|
|
|
|
|
You could just download one from here[^]
Simon
|
|
|
|
|
And this has what to do with VB.NET??
|
|
|
|
|
I have a Collections.Generic.List object which contains two fields:
Reference Amount<br />
--------- ------<br />
101223 100.00<br />
125567 200.00<br />
101223 110.00<br />
134225 300.50<br />
125567 116.00
I want to group these into another list to give
Reference Amount<br />
--------- ------<br />
101223 210.00<br />
125567 316.00<br />
134225 300.50
How can I do this please?
|
|
|
|
|
Well, with the object model you've chosen, you have little choice but to go through each item in your collection and generate a second collection with the totals. The basic idea is to see if a Reference number is in a collection, and if not, add it with the current Amount. If it already exists in the collection, you get the existing total from that collection, add the Amount to it, then put the new total back in the collection. You'd probably use a HashTable, or some other Key/Value pair collection, to store the totals.
|
|
|
|
|
i've a datagridview control populated with records from database.
i've formatted certain cells of datagridview according to a condition.
(i mean i've set the fore color and back color of cell).
But when i export these datagridview contents to excel 2003, no cell colors will be
appearing.pls help me.
i'm developing desktop application with vb.net 2008 and excel 2003.
Thanks in advance.
|
|
|
|
|
Never done this but I feel you will need to write code for this using Interop.
The word "politics" describes the process so well: "Poli" in Latin meaning "many" and "tics" meaning "bloodsucking creatures."
जय हिंद
|
|
|
|
|
You will have to go through each cell in your datagrid and set the colors in the Excel sheet yourself. Warning! This will be a slow process! You cannot do this through a CSV file, so if that's the method you're using, it won't work.
|
|
|
|
|
Hi,
i'm iterating through each cell of dataset table and writing it to excel using interop services.pls tell me how to do it?
|
|
|
|
|
I don't know the Excel object model off the top of my head, but I think you might be looking for a FillColor, or BackColor, or maybe a ColorIndex property. I seem to remember something about an Interior property that this may fall under.
Oh, wait. A quick Google for "vb excel cell background color" reveals a plethora of information[^].
|
|
|
|
|
I use this code. It copies the grid into excel as you see it in the vb app color and all formatting.
Response.Clear()
Response.AddHeader("content-disposition", "attachment;filename=FileName.xls")
Response.Charset = ""
Response.Cache.SetCacheability(HttpCacheability.NoCache)
Response.ContentType = "application/vnd.xls"
Dim stringWrite As New System.IO.StringWriter()
Dim htmlWrite As New HtmlTextWriter(stringWrite)
GridView1.RenderControl(htmlWrite)
Response.Write(stringWrite.ToString)
Response.End()
Chilly442
|
|
|
|
|
Hi
I need the code for windows application(desktop).i'm using vb.net 2008 with msexcel 2003.
Thanks in advance.
|
|
|
|
|
If you put the code I have provided behind a button on the form, and change the GridView1.RenderControl(htmlWrite) to the name of your grid, it does exactly what you want.
Protected Sub Button69_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button69.Click
Response.Clear()
Response.AddHeader("content-disposition", "attachment;filename=FileName.xls")
Response.Charset = ""
Response.Cache.SetCacheability(HttpCacheability.NoCache)
Response.ContentType = "application/vnd.xls"
Dim stringWrite As New System.IO.StringWriter()
Dim htmlWrite As New HtmlTextWriter(stringWrite)
GridView1.RenderControl(htmlWrite)
Response.Write(stringWrite.ToString)
Response.End()
End Sub
|
|
|
|
|
Hi chilly,
i'm getting the error as "Name 'Response' not declared"?.
i tried to add the namespace system.web,
but of no use..can u pls guide me.it is an windows applicatio using vb.net
sorry for late reply & thank u very much.
|
|
|
|
|
Hi,
I want to store the result of crystal report sum formula value in the vb.net global variable. so please suggest how i do this.
Thanks
~Khatri Mitesh
khatrimitesh@hotmail.com
Bikaner (Rajasthan)
INDIA
|
|
|
|
|
i have to add items in list view from a string variable 'filename'
how can i add this to a list view??
purvas
|
|
|
|
|
In 1994 i used think how will the Computing world be in 2010. I lived in times of VS2002, VS2003, VS2005, VS2008 and there is VS2010 Comming and to my suprise there are still people using VB6.
VB6 is dead wake up
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
www.ITS.co.za
|
|
|
|
|
Try this MSDN article out. ListView Class[^]It has some sample code in it for you. Pretty straight forward stuff.
|
|
|
|
|
Yeah, but he's using VB6, not VB.NET.
|
|
|
|
|
saprva wrote: i have to add items in list view from a string variable 'filename'
You mean, you have a variable FileName, and this variable contain one value like
FileName = "Somthing"
and you want to add the content of FileName which is 1 word to list view?
Me.ListView1.ListItems.Add , , FileName
Try to get a book or Press F1 or Search google.
Samir R. Ibrahim
|
|
|
|