|
I think you are missing one thing
acol1.MappingName = "name of the field in datatable binding with the grid"
Give that name and you will see the data displayed. Let me know if there is still any probs regarding that.
Het Waghela
Be Humble in Victory and Strong in Defeat.
Het Waghela, Blog|Het Waghela DotNet Questions Link|More Links
|
|
|
|
|
Still seem to be getting a problem. It will properly be something simple or setting I have missed. Here is an example of some code. I have copied it from the Microsoft site.
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'FormatDataGrid
AddDataGridTableStyle()
End Sub
Private Sub AddDataGridTableStyle()
' Create a new DataGridTableStyle and set MappingName.
Dim myGridStyle As DataGridTableStyle = _
New DataGridTableStyle
myGridStyle.MappingName = "Customers"
' Add two DataGridColumnStyle objects.
Dim colStyle1 As DataGridColumnStyle = _
New DataGridTextBoxColumn
colStyle1.MappingName = "firstName"
Dim colStyle2 As DataGridColumnStyle = _
New DataGridBoolColumn
colStyle2.MappingName = "Current"
' Add column styles to table style.
myGridStyle.GridColumnStyles.Add(colStyle1)
myGridStyle.GridColumnStyles.Add(colStyle2)
' Add the grid style to the GridStylesCollection.
DataGrid1.TableStyles.Add(myGridStyle)
End Sub
|
|
|
|
|
Here is the brief sample code which i placed and its working in my app. Steps i followed is
first bind grid with datasource (datatable in my case)
grd.DataSource = dtBase
next step is applying the custom table style as below from a seperate function,
Dim ldgTableStyle As DataGridTableStyle ''' Table Style Variable
Dim ldgColumnText As DataGridTextBoxColumn ''' Text Box Column Variable
Dim ldgColumnBool As DataGridBoolColumn ''' Boolean Column Variable
ldgTableStyle = New DataGridTableStyle
'''ldgTableStyle = GetTableStyle(blnSorting:=True) ''' this functions sets general properties like forecolor backcolor, sorting etc.
ldgColumnText = New DataGridTextBoxColumn
ldgColumnText.MappingName = "MyColumnMappingName"
ldgColumnText.HeaderText = "Header I want on Grid"
ldgColumnText.Width = 200
ldgColumnText.TextBox.MaxLength = 15
ldgColumnText.TextBox.TextAlign = HorizontalAlignment.Left
ldgColumnText.TextBox.Enabled = False
ldgColumnText.ReadOnly = True
Call ldgTableStyle.GridColumnStyles.Add(ldgColumnText)
ldgColumnBool = New DataGridBoolColumn
ldgColumnBool.MappingName = "BoolColMapName"
ldgColumnBool.HeaderText = "HeaderText"
ldgColumnBool.Width = 175
ldgColumnBool.ReadOnly = True
Call ldgTableStyle.GridColumnStyles.Add(ldgColumnBool)
Call grd.TableStyles.Clear()
Call grd.TableStyles.Add(ldgTableStyle)
thats it, and its working try seeing the code and figure out if you are missing anything from ur code.
Het Waghela
Be Humble in Victory and Strong in Defeat.
Het Waghela, Blog|Het Waghela DotNet Questions Link|More Links
|
|
|
|
|
I done the following.
Dim dt As DataTable = New DataTable
DataGrid1.DataSource = dt
What appears on my grid is the start of the datagrid but with no headings.
Sorry for being such a nuisance but once I have cracked this, it will solve a lot of problems.
|
|
|
|
|
|
The problem I seem to be having now, is that I can get values onto the datagrid but want to put another value in that is a calculation of 2 values in a field. How can this be done if this can not be mapped to datatable. This worked fine when I did the following.....In short all I want to do is increase/decrease column sizes in the grid but this cannot be done if I do the following
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
DataGrid1.DataSource = CreateDataSource()
End Sub
Function CreateDataSource() As ICollection
Dim i As Integer
Dim IK As Integer
Dim objDA As OleDb.OleDbDataAdapter
Dim objDS As New DataSet
Dim sSQL As String
Dim sData(,) As String
Dim objDR As OleDb.OleDbDataReader
Dim dt As DataTable = New DataTable
Dim dr As DataRow
Dim col1 As New DataColumn
Dim col2 As New DataColumn
Dim col3 As New DataColumn
Dim col4 As New DataColumn
col1.DataType = System.Type.GetType("System.Int32")
col2.DataType = System.Type.GetType("System.String")
col3.DataType = System.Type.GetType("System.String")
col4.DataType = System.Type.GetType("System.Int32")
col1.ColumnName = "ID#"
col2.ColumnName = "Surname"
col3.ColumnName = "Forename"
col4.ColumnName = "Value"
col1.ReadOnly = True
col2.ReadOnly = True
col3.ReadOnly = True
col4.ReadOnly = True
dt.Columns.Add(col1)
dt.Columns.Add(col2)
dt.Columns.Add(col3)
dt.Columns.Add(col4)
i = 0
sSQL = ""
sSQL = "SELECT EmployeeID, LastName, FirstName FROM EMPLOYEES"
Dim cmdOLE As New OleDb.OleDbCommand(sSQL, sOleDbConnection)
ReDim sData(2, 0)
objDR = cmdOLE.ExecuteReader
Do Until objDR.Read = False
sData(0, i) = objDR("EmployeeID")
sData(1, i) = objDR("LastName")
sData(2, i) = objDR("FirstName")
i += 1
ReDim Preserve sData(2, i)
Loop
IK = i
objDR.Close()
i = 0
For i = 0 To IK - 1
dr = dt.NewRow
dr(0) = sData(0, i)
dr(1) = sData(1, i)
dr(2) = sData(2, i)
dr(3) = 15 * i
dt.Rows.Add(dr)
Next
Dim dv As DataView = New DataView(dt)
Return dv
End Function
|
|
|
|
|
While adding columnstyle, you can change the width of the column, i think it should work fine.
ldgColumnText = New DataGridTextBoxColumn
ldgColumnText.MappingName = "MyColumnMappingName"
ldgColumnText.HeaderText = "Header I want on Grid"
ldgColumnText.Width = 200
ldgColumnText.TextBox.MaxLength = 15
ldgColumnText.TextBox.TextAlign = HorizontalAlignment.Left
ldgColumnText.TextBox.Enabled = False
ldgColumnText.ReadOnly = True
Call ldgTableStyle.GridColumnStyles.Add(ldgColumnText)
I have made line of code in bold which i think allows u to change the width of the column.
try and let me know the exact problem, if still it persists.
Het Waghela
Be Humble in Victory and Strong in Defeat.
Het Waghela, Blog|Het Waghela DotNet Questions Link|More Links
|
|
|
|
|
Hi,
I have problem when trying to print Crystal report from vb.net.
Program is very simpel : He accepts 4 parameters from 1 ComboBox and 3 TextBoxes and that should be printed in Crystal Reports report, but constantly shows " An unhandled exception of type 'System.ArgumentException' occurred in system.drawing.dll
Additional information: '-1' is not a valid value for 'value'. 'value' must be greater than or equal to 0. "
the code is below, thanks in advance for help.
Dim crReportDocument As New CrystalDecisions.CrystalReports.Engine.ReportDocument
Dim paramFields As New CrystalDecisions.Shared.ParameterFields
Dim paramField As New CrystalDecisions.Shared.ParameterField
Dim discreteVal As New CrystalDecisions.Shared.ParameterDiscreteValue
paramField.ParameterFieldName = "txtPrefix"
discreteVal.Value = cboPrefix.SelectedText
paramField.CurrentValues.Add(discreteVal)
discreteVal = New CrystalDecisions.Shared.ParameterDiscreteValue
paramField.ParameterFieldName = "txtDate"
discreteVal.Value = txtDate.Text
paramField.CurrentValues.Add(discreteVal)
discreteVal = New CrystalDecisions.Shared.ParameterDiscreteValue
paramField.ParameterFieldName = "txtpartnr"
discreteVal.Value = txtPartNr.Text
paramField.CurrentValues.Add(discreteVal)
discreteVal = New CrystalDecisions.Shared.ParameterDiscreteValue
paramField.ParameterFieldName = "txtPickingLocation"
discreteVal.Value = txtPickingLocation.Text
paramField.CurrentValues.Add(discreteVal)
paramFields.Add(paramField)
CrystalReportViewer1.ParameterFieldInfo = paramFields
CrystalReportViewer1.ReportSource = "C:\DotNetApps\Printlabel\WindowsApplication1\kistlabel.rpt"
CrystalReportViewer1.PrintReport()
|
|
|
|
|
I am using a vc++ dll in a vb program. The function require a pass byref single type. because in vc++ it require a floating point pointer. However, the values I'm getting is wrong. Anyone got any idea what could be wrong? I guessing the values are read in the wrong direction.
Thanks for any help.
Aaron
|
|
|
|
|
float* is not equal to single byref .
byref means the value is passed by reference, where pointers don't. it should be float& instead...
moreover, i'm not certain that float is the equivalent to single . isn't float (vb type) better ?
TOXCCT >>> GEII power [toxcct][VisualCalc]
|
|
|
|
|
I have check on msdn, there is no float type for vb 6.0. Not sure about .net.
I've look up several papers saying that when the vc function in the dll is using a pointer as a parameter, the vb-side of calling the function should be using byref.
Aaron
|
|
|
|
|
aarontan wrote:
I have check on msdn, there is no float type for vb 6.0. Not sure about .net.
Surely VB6 has a type for floating point numbers ?
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
The C/C++ float data type is equivalent to a VB6 Single .
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I wanted to override the onpaintbackground of my listview control, but it never seems to be invoked. Is there a way I can cause it to invoke..maybe getting a message from WndProc. If so, what message?
|
|
|
|
|
I'm kind of at a loss of what your trying to do with the listview, the vb.net listview has a backcolor and picture properties.
If you are you trying to add colors to the sub items, you'll need to set the listviewitem "UseItemStyleForSubItems" property to false:
' Make a ListView row.
Private Sub ListViewMakeRow(ByVal lvw As ListView, ByVal item_title As String, ByVal ParamArray subitem_titles() As String)
' set the listviw back color
lvw.BackColor = Color.LightGoldenrodYellow
' Make the item.
Dim new_item As ListViewItem = lvw.Items.Add(item_title)
'must set useritemstyleforsubitems = false to change color
new_item.UseItemStyleForSubItems = False
' Make the sub-items.
For i As Integer = subitem_titles.GetLowerBound(0) To subitem_titles.GetUpperBound(0)
new_item.SubItems.Add(subitem_titles(i), Color.Black, Color.AliceBlue, Font)
Next i
End Sub
I hope this helps
|
|
|
|
|
I am recreating a Windows Explorer control. I am stuck at making the selected column (when in details view) have a different color. I was hoping that maybe I could paint the rectangle when the packground was painted and the items would still paint alright. I am just trying about anything I can think of or find close on the internet.
|
|
|
|
|
Hai...
I want to extract wav file from the mp3,mpeg,avi or wmv files. With this i want to display the wav file in my application. I can do this, my problem is to convert into wav file from the above formats.
Thanking you,
e.veera raghavendra
|
|
|
|
|
I am having a datagrid which is reading data from an XML file
<?xml version=""1.0"" encoding=""ISO-8859-1""?><medgivanden><medgivande betalarnummer=""121212121212"" status=""10"" datum=""2004-12-31""><avtal avtalsnummer=""11111111111"" produkt=""Skoter""/><avtal avtalsnummer=""22222222222"" produkt=""Tjej MC""/><avtal avtalsnummer=""33333333333"" produkt=""Hem och Villa""/></medgivande><medgivande betalarnummer=""121212121212"" status=""10"" datum=""2004-12-31""><avtal avtalsnummer=""23232323232"" produkt=""Personbil""/><avtal avtalsnummer=""45454545454"" &produkt=""Liv""/></medgivande></medgivanden>
Now this will show + signs in the datagrid.
What i am not able to do is to be able to select the row when i click on it . I want to get the a few selected columns of the parent row.
How can i get the columns of the selected parent row.
|
|
|
|
|
Hi nitin
this is what i would do.
You can i add a button column in your datagrid.Make it a select button
Sub ItemsGrid1_Command(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.ItemCommand
' this event is raised when any row on a datagrid is clicked if you are doing more than one task
' so in order to differentiate the eevents you can check for the commandname
'this name tag is attached to the commandbutton column of your datagrid
If e.CommandName = "Select" Then
Dim column5 As String = e.Item.Cells(5).Text
Dim column6 As String = e.Item.Cells(6).Text
column7 = e.Item.Cells(7).Text
end if
end sub
I hope this is helpful to you
Mandar Patankar
Microsoft Certified professional
|
|
|
|
|
Hello,
I have an Identity column 'FormNo'...'autogenerated/seeded' column in my (SQL Server) database. I am using datagrid to display the records. My 'Insertvalues' with codebehind is working since the FormNo is automatically incremented on saving. But my 'UpdateValues' refuses to work or recognize the 'FormNo'...In general my datagrid does not seem to like identity columns.
Can someone kindly throw some light on the 'Identity' columns in datagrid?
Thanks a ton!!
arty=me
|
|
|
|
|
|
Hi all, ok, as the subject stated, I am trying to make my form link up to a Ms Access file that is password protected. I tried linking using oledbdataadaper1 on a un-protected MS Access file and it works fine, I can access the inside DB and all. But when I put a password into that Access File, I cannot get my form to link up to it.
It came out a message saying 'Test connection failed because of an error initializing provider'. I put the username as Admin and the password I put in for the Access file, but still this error... Anyone have any idea where I went wrong.? Thanz..
|
|
|
|
|
In the connection string, you have to supply a User Id, Password, and possibly the System Database path that holds the workgroup security information. I really can't tell you for sure because I stopped using Access for all of my database work years ago.
Just a little sample:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyDb.mdb;Jet OLEDB:System Database=C:\MySystemDB.mdw"
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hmm, didn't really help there since I am using the oledbdataadapter wizard to link to my MS Access file.. Anyone else who got any idea to my situation..? Thanz anyway, Dave.
P.S :- You mentioned that u are not using Access years ago... What are you using now to keep your data and all.. Can it be password protected? If so, I might want to look into it...
|
|
|
|
|
icowa wrote:
What are you using now to keep your data and all
He might be using SQL Server.
icowa wrote:
Can it be password protected?
You can use a combination of user name and password to access the data.
<italic>Work hard, Work effectively.
|
|
|
|