|
Are you sure that the DataTable has a primary key? If you Fill a table from a database you will get the data, but not necessarily the constraints and schema information. You will also have to perform a FillSchema (using a DataAdapter).
|
|
|
|
|
Thanks. I didn't perform Fillschema. that's the reason.
David Ye
|
|
|
|
|
Hi everyone,
I was wondering if it is possible to format a listview item's data after the data has been added to the listview. I have a custom listview that is populated from a datatable and one of the columns needs to be in a currency format. Do I need to format the data as it is being added? or can I modify it afterwards? thank you
eatwork
|
|
|
|
|
Hi,
I am trying to figure out how to share a common data between two seperate applications: app 1 and app 2.
Let's say I have a 2 dimensional array representing a grid with coordinate(x,y). Each coordinate represents a cell within the grid. This grid is used as a work floor divided into many cells. At any time, there's only one person supposed to be in one cell with coordinate(a,b). If the cell is occupied, it is marked as unavaible in app 1 thus no one is allowed to enter that cell at coordinate(a,b).
This grid (array) data is only updated in app 1. I want to send this array data to app 2 (on the same computer) or let app 2 have access to this data . How can I do this? Any help would be greatly apprececiated.
Thanks
|
|
|
|
|
I guess I'd write the data to a text file or (even more handy) to a database in app 1. Then app 2 would have a timer control that would check that file or access the database every so often and reload to show any changes in availablity.
|
|
|
|
|
Try to add Marking field on your database..
If any changes or user in app1 is using the cell then make a routine that will sets the fields value. The value will be represent as locking for example.
So.. when app2 is accessing the current cell, it will check the state of the cell and will set the rules to the user how to interact with it.
Example:
0=Unlocked
1=Locked
Make sure, you mark it when u click on the cell and immediately the routine will send/update marking value into related record that represent your current cell to prevent app2 to mistaken retrieve the incorrect marking value.
|
|
|
|
|
Hi,
I am trying to create a window application to control another application. At the moment I can only find info on how to open applications such as note pad and send strings to write in note pad. Let's say if I would like to do other things apart from just sending a string to notepad, how would I do it.
For example if I want to run a specific program such as MS Word, and then I want to access one of the menus to perform a certain action such as changing fonts or input shape into the Word document. I would like to perform all this using the controls such as a button on a form in VB.NET, how can I do this? Any help would be greatly appreciated.
|
|
|
|
|
Hello mrmathesw99!
Well there is a couple of things to note here:
To start various applications, you could use Process.Start.
I have noticed however, that you mention you want to able to do many things with MS Word for example. In that case you could use Automation to do whatever you want with Word, Excel etc.
So, what you need to do is to add a Reference To the Microsoft Word Object Library (Just click References in the Solution Explorer, and say Add Reference, Select the COM tab, and scroll until you find it) You can add references to all MS Office programs like that.
Once that is done, you can create Word Apllication variables and manipulate Word through that. Amazing huh ¿
Here's a small sample :
Dim SSWord As New Word.Application 'word application
Dim SSWordDoc As Word.Document 'document object
SSWord = DirectCast(GetObject(, "Word.Application"), Word.Application)
SSWordDoc = SSWord.Documents.Add(, , 1, False) 'add a document
SSWord.WindowState = SSWord.WindowState.wdWindowStateMaximize 'maximise word window
SSWord.Activate() 'activate it
SSWord.ActiveWindow.ActivePane.View.ShowAll = True 'show / hide symbols = true
After using the Word objects, you need to set the Word Objects to Nothing
And Quit it as well
Hope it helps!
H T G
|
|
|
|
|
Thanks HTG... I will give this a try with the application I'm trying to run and will see how it goes.
|
|
|
|
|
I wonder if anyone has had the same problem I am having at the moment.
I have a form with a tab object with a collection of 5 tab pages.
For this example, say the tabs are A, B, C, D, E
They are all in the correct order but when I run the application they are appearing as ;
A, B, D, E, C
I close the form and they are in this order,
A, B, D, E, C
I make the changes to be back as
A, B, C, D, E
Save the form and run again, they are back to
A, B, D, E, C
I have tried closing down VB.Net and doing as above but with no success.
Help me please before I pull out what is remaining of my hair.
|
|
|
|
|
I'm developing an application through LAN, when I use Insert, Delete functions on Server they'are ok but use them on Client they'are fail, so tell me the way how i do? The application is developed by SQL 2000 and VB.net
|
|
|
|
|
cayoaihuong84 wrote: when I use Insert, Delete functions on Server they'are ok but use them on Client they'are fail, so tell me the way how i do?
What do you mean by "fail"? What is the error message you are getting? What code are you using?
|
|
|
|
|
Hi all
Plz help me ;
i work in vb 6.0
i want to change a color of perticular cell in Hierachical FlexGrid Control 6.0
or bold a perticular cell
|
|
|
|
|
Hello Sinchan Nikam!
This :
Private Sub Grid_Click()
Dim i as Integer
With Grid
.Row = .MouseRow
For i = 1 to .cols-1
.Col = i
.CellBackColor = RGB(255,0,0 ) 'red
Next
End Grid
End Sub
Will highlight an entire Flexgrid Row in Red. Note here Grid is the name of the FlexGrid.
To change only one cell's color, I think it's obvious by now, that you need to use the .CellBackColor property
Hope it helps!
Always remember to play araound with example supplied - you'll be amazed at what you'll learn!
H T G
|
|
|
|
|
I really wonder why viewing report using crystal report in vb 2005 is very slow. It is not good if it is slow to crystal report.
Is there any solution with this? Is there any other kind of report that is better?
|
|
|
|
|
Hi,
I m working with vb.net 2005 and crystal report 10 .the time to load crystal report is very high.it takes a minute to load a simple report.
the code i used given below.
if anyone know to solve this problem, please give me reply.
Dim repDoc As New ReportDocument
Dim subRepDoc As New ReportDocument
Dim crSections As Sections
Dim crSection As Section
Dim crReportObjects As ReportObjects
Dim crReportObject As ReportObject
Dim crSubreportObject As SubreportObject
Dim crDatabase As Database
Dim crTables As Tables
Dim crTable As Table
Dim crLogOnInfo As TableLogOnInfo
Dim crConnInfo As New ConnectionInfo
repDoc.Load(CrystalStrReport) 'Report path
crDatabase = repDoc.Database
crTables = crDatabase.Tables
For Each crTable In crTables
With crConnInfo
.ServerName = "Server"
.DatabaseName = "Sample"
.UserID = "sa"
.Password = "abcd"
End With
crLogOnInfo = crTable.LogOnInfo
crLogOnInfo.ConnectionInfo = crConnInfo
crTable.ApplyLogOnInfo(crLogOnInfo)
Next
crTable.Location = "Sample" & ".dbo." & crTable.Location.Substring(crTable.Location.LastIndexOf(".") + 1)
crSections = repDoc.ReportDefinition.Sections
CrystalReportViewer1.ReportSource = repDoc
CrystalReportViewer1.Show()
Gopakumar
|
|
|
|
|
how to add combobox in listview.very urgent.
|
|
|
|
|
Does anyone have an examples/ideas about how to format data using a datagrid in VB Net - maybe its not possible to do this with a simple data grid
My data comes from two tables w multiple records for the same id number and name. I don't want to keep repeating id and name fields
It comes out like this in the datagrid:
ID1 Name1 data group1 (several fields)
ID1 Name1 data group2 (several fields)
ID1 Name1 data group3 (several fields)
ID1 Name1 data group4 (several fields)
ID1 Name1 data group5 (several fields)
ID2 Name2 data group1 (several fields)
ID2 Name2 data group2 (several fields)
etc
I'd want to look something like this:
ID1 Name1 data group1 (several fields) data group2 (several fields) data group3 (fields) etc
ID2 Name2 data group1 (several fields) data group2 (several fields) data group3 (fields) etc
ID3 Name3 data group1 (several fields) data group2 (several fields) data group3 (fields) etc
OR maybe like this
ID1 Name1
data group1
data group 2
data group 3
data group 4
etc
ID2 Name 2
data group1
data group 2
data group 3
data group 4
etc
Thanks
|
|
|
|
|
It looks like Pivot Table...
I don't know if Datagrid Control in VB can does.
How about this.. you unbound your datagrid with your datasource..
You will create several collection/array to act as buffer/dataset for your data
Then you will put that data into datagrid cell like the way you want to.
It make sense?
|
|
|
|
|
Hi everyone!
I need put the splash scree to programme,which display infront some few minitues whenever start the programme.Can anyone help for this,its better if someone give me to any example codings or guid web site
Thanks
|
|
|
|
|
putting a splash screen that runs for a few minutes; don't you think a few seconds will do? the program users will get 'bored' if they have to wait for the minutes evry time they run the programme. go through some human interface design notes.
Regards,
Hesbon.
|
|
|
|
|
thank u
can u some example codings to me,bcouz if i put the splash scree its not running when i'm run the prgramme shold i use any coding for that?
|
|
|
|
|
Well, to have a splash screen, best practise in my opinion is to have a Sub Main procedure in a seperate Module. (You add a module to your project, by clicking Project - > Add Module...). You will also need to add another form, to be used as a Splash Screen.
Once in your Module Type something similar to :
Public Sub Main()
Dim fSplash As New frmSplash
fSplash.ShowDialog()
Application.Run(New Form1)
End Sub
And This is the coding for the Spalsh Screen Form (frmSplash)
Private Sub frmSplash_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load
Timer1.Interval = 3000 ' Approx. 3 Seconds.
Timer1.Enabled = True
End Sub
Private Sub frmSplash_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Click
Me.Close() ' Close when the Splash Screen is Clicked
End Sub
Private Sub Timer1_Tick(ByVal sender As Object, ByVal e As System.EventArgs) Handles Timer1.Tick
Timer1.Enabled = False
Me.Close() ' Close the Splash Screen after the time has elapsed
End Sub
That should give you quite a good idea on what to do. Now, the rest is up to you!
HTG
|
|
|
|
|
Yes it's working thank you very much.But how can i put any picture to splash screen.
|
|
|
|
|
It's a pleasure.
How do you mean get a different picture ¿
Like, do you want it on the form ¿ If that's the case, you must select the BackgroundImage Property of the SplashScreen and browse for your picture you want to use.
Just a note: You may not see the image in the design window on your form, only once you run it, you'll see the picture.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
