|
I have a general question about how to work on subsets of datasets
I have a dataset that has data. I want to operate on only part of that dataset. So I create a dataview and filter the datatable into it. Then I create a datagridview from the dataview. Then I perform my operations on the datagridview.
This works, but I guess it seems kind of strange -- datagridviews seem to have an entirely different purpose. Does it make sense to do data analysis on a datagridview, or is there a better approach for me?
Thanks!
|
|
|
|
|
I am confused...I am trying to learn how to send a query to a oracle database (i am connected to it) I am just doing a test to retrieve a piece of data from this database and displaying this info on a label... Its not working Im having a hard time because Oracle needs a password to be sent to access the data. Does anyone know the format for doing this? Any help would be appreciated.
Thanks
Erica
|
|
|
|
|
Can u tell in detail how are you connecting to the DB and what is the connection object u are using...
The basic idea is
We define the connection object
We define the connection string....with the DB password
Open the connection
Then use the connection object whenever you have to access any data
Good luck
|
|
|
|
|
Hi All! I'm looking for a way to convert xml data to Tiff format in VB6. Previously I'm using a III'rd party component to generate PDF file. But the problem is that, it is taking too much time to generate the PDF Files. What I'm looking for is a way to generate Tiff file or any other common format out of the XML in VB6 preferably through code or some free component.
Thanks in advance
Don't Quit
|
|
|
|
|
The way of VB6 - get components to do the work. GDI+ will write a tiff, if you want to create your XML in a bitmap format ( and I can't imagine why ), then just draw the string on a bitmap and save it. VB.NET has tiff support built in, VB6 sucks, and probably does not, but the XML part isn't your problem, just the saving in different image formats is. Surely there's tons of components that will help VB6 save jpg/tiff/etc ?
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
hi,
how can hide some textbox some time and this moment show another textbox ,after the time finish show again first textbox in form
|
|
|
|
|
You can use the Timer Control for this purpose set its interval property then use visible property of the textboxes to hide or show them on screen. I am assuming Textboxes are already on your form and some of them with their visible property set to false. If you want to add Textboxed dynamically then you have to make an object of it and after seeting its properties add it in the control collection of your form.
AliAmjad(MCP)
First make it Run THEN make it Run Fast!
|
|
|
|
|
I've got an axwebbrowser object embedded on a standard windows form within a VB.Net (vs2003) application. Everything works fine until it tries to link to a pdf file. I get script errors and a blank screen. The strange thing is that if I point it to a pdf file on my hard disk eg. c:\example.pdf it works fine and the pdf displays ok. It just seems to be pdf files from the intenet that it has a problem with.
Anyone had a similar problem ?
Cheers.
|
|
|
|
|
hi all,
i have developed an application in vb.net on my pc which have 800/600 secreen resolution. on whice i developed various user interfaces fit to my screen.
but when i install my application on another pc it give me very diffrent screen display say it compressed to half in size than on my pc.
kindly help me with providing approriate sollution so i can enjopy auto screen setting facility .
thanks
rmshah
Sr. Developer
|
|
|
|
|
Seriously learn to Google.
http://www.freevbcode.com/ShowCode.asp?ID=5915
http://www.thescripts.com/forum/thread381482.html
|
|
|
|
|
Hi To all ,
I didnt find help for this so i am posting inthis forum .
Now , i want to enter text when i click on grey area whether it is on any row or particular colum dynamically like entering text into textbox for datagridview .I dont know whether this feature supports to datagridview .
After running the form(design Mode for my application ),Actually i am creating an instance of datagridview and placing at any point. Then he clicks a Row Header Cell or ColumHeader cell Which are in GREY color and he writes Text (Empno ) at that instance like entering text into textbox .I dont want to give the user to enter text in cells only he can enter text for header (Both row and column ). This is all in design mode .
(In run Mode for my application )If we open that particular Form again , He cannot change the text of Column and row Headers but he can enter text in cells .This is the way i have to design the datagridview .
(For saving and retrieving) , i want to save all this data which is in Datagridview in an XML file and i have to retrieve the same .
<br />
Emp Det|Jan| Feb| March |Apr |May ............<br />
<br />
ENo |<br />
<br />
Ename |<br />
<br />
Age |<br />
<br />
Salary |
I amnot connecting to any type of datasource .I dont know how to do this task .
Help Required ,
Regards,
Sriram .
|
|
|
|
|
I am using Adodb recordset to get the count of the total number of rows reterieved from a query?
In vb6 we can get this easily with
myrcd.recordcount
but if I use the above statement in vb.net 2003 it return -1.
Can we get count from reader without putting this in a loop to count every single record?
Thanks In advance
Ejaz
|
|
|
|
|
Try this
dr.RecordsAffected
Regards
Pankaj Joshi
If you want to shape your dreams into reality, please wake-up...
|
|
|
|
|
hi i m begnner in vb 6 plz give me code to open a new form from the older form
thanx in advance
help as a alias.
Be happy and make others happy.Cheer up...........
|
|
|
|
|
HI...
Say u want to open form2 from form1
then what u cam do is
form2.show 'From the place in form1 where u want to show form2
you can close or hide form1 after u show form 2
form1.hide 'TO hide
unload.me 'To show
|
|
|
|
|
Why are you starting VB6 ? VB.NET is free, and VB6 is a dead, unsupported language.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
can anyone help me in getting the code for displaying the total no. of working days in a month using crystalreportviewer for generating a payslip?
I am creating a payroll system for a company using vb.net..
Another problem is that in loan repayment report,how do i display the names of all the months remaining till loan repayment is complete?..
pls help soon...........
god bless
|
|
|
|
|
Hi
I have Create windows Services. I have set Prorerty ServiceProcessInstaller Account is " LOCAL SYSTEM "
I want to get current loggin User ID..
If I set ServiceProcessInstaller Account is "USER" I can read User id But If i set " LOCAL SYSTEM " I cant read. But My Recruitment is Local System at the same time I want to read Current Login User Id.
How I can Read Help Me...
Thanks & Regards,
Sathiskumar.M
|
|
|
|
|
hi all,
anyone help me?
i have generated menus at run time.Now i want to disply reports on each menu.But i can't get index value of menu.I have created one click event for the menu but how i can identify the index of menu which is clicked.plz help me.
poonam
|
|
|
|
|
I am still confused on what you are trying to accomplish. Are you wanting an index value to determine what report to print? By the way, every control has a Tag variable. You could set integer values in the tag to differentiate betten the menu items.
Cheers!
Richard
may your code be error free.
(okay, maybe two lines.)
|
|
|
|
|
Hi Richard
Hw can i set tag value,Becoz my menus are generating at run time.Thats why i have created event handler.If i don't know which menu is clicked runtime then hw i can show the reports.I need a code which will store index value of a menu which is clicked.
by the way thanks for reply
poonam
|
|
|
|
|
Please post the code of how the menus are dynamically generated.
may your code be error free.
(okay, maybe two lines.)
|
|
|
|
|
[code]
Dim mShowMenuItem As System.Windows.Forms.MenuItem
mShowMenuItem = DirectCast(sender, System.Windows.Forms.MenuItem)
mShowMenuItem.MenuItems.Clear()
Dim n, i As Integer
Dim a, b As String
s = "Select srno from cash"
com = New OleDbCommand(s, con)
con.Open()
dr = com.ExecuteReader
While dr.Read
n = dr(0)
End While
con.Close()
For i = 1 To n
s = "Select account from cash"
com = New OleDbCommand(s, con)
con.Open()
dr = com.ExecuteReader
While dr.Read()
a = dr(0)
Dim mSubSubMenuItem As System.Windows.Forms.MenuItem
mSubSubMenuItem = New System.Windows.Forms.MenuItem
mSubSubMenuItem.Index = i
mSubSubMenuItem.Text = a
mSubSubMenuItem.Enabled = True
mSubSubMenuItem.Visible = True
AddHandler mSubSubMenuItem.Click, AddressOf MenuClickHandler
mShowMenuItem.MenuItems.Add(mSubSubMenuItem)
i = i + 1
End While
con.Close()
Next
this will generate menus
Public Sub MenuClickHandler(ByVal Sender As Object, ByVal e As System.EventArgs)
'Don't know wt to write here
End Sub
poonam
|
|
|
|
|
I'm playing around with the above method and I'm trying to calculate and display the difference between two dates. I'm getting the error "Value of type 'system.timespan' cannot be converted to 'string'". Can someone provide some guidance. Thanks. The following is my code.
Dim dateadd, datesubtract As System.DateTime
Dim datedifference As System.TimeSpan
Dim Date1 As System.DateTime = System.DateTime.ParseExact("20051127", "yyyyMMdd", System.Globalization.CultureInfo.CurrentCulture)
Dim Date2 As System.DateTime = System.DateTime.ParseExact("20061127", "yyyyMMdd", System.Globalization.CultureInfo.CurrentCulture)
datedifference = Date2.Subtract(Date1)
MessageBox.Show(datedifference)
George
|
|
|
|
|
The last line is the problem, that's where you assume a timespan is a string. Try the ToString method on the timespan object.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|