|
I am able to fill a dataset and fill the datagrid.
The issue that I am having is that I only want certain columns in the data grid. If there is 10 columns in a database, how can I display 3 of them and only them three in a datagrid? Any suggestions or examples is greatly appreciated. Thanks.
Beginner in ASP.Net and VB.Net
|
|
|
|
|
Dim oConn As New OleDbConnection
Dim oCmd As New OleDbCommand
Some thing like this:
Dim oDS As New DataSet
Dim oDSNew As New DataSet
Dim oDA As New OleDbDataAdapter(oCmd)
Dim oCol As New DataColumn
Dim oCol2 As New DataColumn
Dim oCol3 As New DataColumn
Dim oRows As DataRow
Dim oTable As New DataTable
oConn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=HealthandSafety;Data Source=."
oConn.Open()
oCmd.CommandType = CommandType.Text
oCmd.Connection = oConn
oCmd.CommandText = "SELECT * FROM HSDocumentFloorZone"
oDA.Fill(oDS)
With oDS.Tables(0)
oCol = .Columns(1)
oCol2 = .Columns(3)
oCol3 = .Columns(5)
End With
oDS.Tables(0).Columns.Clear()
oDS.Clear()
oDS.Dispose()
With oTable
.Columns.Add(oCol)
.Columns.Add(oCol2)
.Columns.Add(oCol3)
End With
oDSNew.Tables.Add(oTable)
With DataGrid1
.DataSource = oDSNew
End With
Many Thanks
Harry
|
|
|
|
|
Manually add a mapping to those specific columns by adding columnstyles to your datagrid. The columnstyles are accesible through the TableStyle property at design-time.
Note: you will also have to map the TableStyle to your table
"if you vote me down, I shall become more powerful than you can possibly imagine" - Michael P. Butler.
|
|
|
|
|
What would be the mapping name? The database is Address and the table is ADDDAT. The combo box only displays none and I tried typing in Address.ADDDAT but nothing happened. Do you know where I can find some examples of this? Thanks.
Beginner in ASP.Net and VB.Net
|
|
|
|
|
Let's say I have a table named "user" and columns "name","sex", "address" in that table, and I want to display only name and sex in the datagrid.
Therefore, the mapping name for the tablestyle would be "user", and I'll create two columnstyles with the mapping name "name" and "sex".
HTH.
"if you vote me down, I shall become more powerful than you can possibly imagine" - Michael P. Butler.
|
|
|
|
|
What I have done was mapped the table style to Address and mapped the columns to First, Last, and Work (using First, Last, and Work). This all seems to make sense to me but nothing seems to happen when I load the form. Is there something that I might be missing? Do I have to programatically fill the datagrid using the new tablestyle?
Thanks.
Beginner in ASP.Net and VB.Net
|
|
|
|
|
That's weird.
Well this is how I do it.
In Design View, I drag the datagrid onto the form. Then on the property grid, click on the ellipse for the TableStyle property. A dialog box will appear. Click Add to add a tablestyle, set the Mapping Name property to your tablename, then click on the ellipse for the gridcolumnstyle property. Another dialog box will appear. Click on Add to add a columnstyle, then set the mapping name to the column you want to show. Repeat this last bit for each column.
"if you vote me down, I shall become more powerful than you can possibly imagine" - Michael P. Butler.
|
|
|
|
|
So there is nothing to do programatically? I have done the above steps and rechecked them but nothing still happens. Would you mind me zipping up my project and emailing it too you to see if you see the problem? I'm sure there is something that I am doing wrong.
Thanks.
Beginner in ASP.Net and VB.Net
|
|
|
|
|
Sure, go ahead.
"if you vote me down, I shall become more powerful than you can possibly imagine" - Michael P. Butler.
|
|
|
|
|
nick.seng@gmail.com
Is this your email? I tried to send you a zip file called Address.zip but it came back as illegal attachment. If you want you can contact me via email directly, timothy@myactv.net.
Thanks.
Beginner in ASP.Net and VB.Net
|
|
|
|
|
Sorry for the late reply, time-zone difference and all. if the gmail doesn't work, send it to catpainter79 AT yahoo DOT com
"if you vote me down, I shall become more powerful than you can possibly imagine" - Michael P. Butler.
|
|
|
|
|
I have been searching all over, but I cannot find a way to set properties like "Size" or "Font". Can anyone help?
Mike
|
|
|
|
|
That's because the ToolTip controls in the Shell Common Controls .DLL, that the ToolTip .NET Classes wrap, don't support changing the font. In order to implement new fonts and custom graphics, you would have to write your own ToolTip control, inheriting from the existing ToolTop Class and owner draw everything yourself. If your a beginner, I don't recommend tackling this.
But, if you want to do this, you can take a look at a couple of samples of this on GotDotNet:
Extended ToolTip (IExtenderProvider Sample)[^]
ToolTipClass - ToolTip with more features[^]
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Dave,
Thanks very much for the link. As you noted, I can't change the font, but I was able to limit the width of the textbox.
Mike
|
|
|
|
|
Hello,
I am trying to initialize mssoap object in a vb macro but I get this error.Seems like the .wsdl file is not readable at all. I am using IIS 5.1 and winXP + MS Soap 3.0. I have installed all the DLL necessary and made configurations needed,
on the virual dir, read the docs on msdn but it still doesnt work. Someone please help !
my code is
<br />
WSDL_URL = http & "http://localhost/myapp/cfg.WSDL"<br />
WSML_URL = http & "http://localhost/myapp/cfg.wsml"<br />
<br />
Set soap_sql = CreateObject("MSSOAP.SoapClient30")<br />
soap_sql.mssoapinit WSDL_URL, "", "SqlSoapPort", WSML_URL <br />
<br />
error msg is:
"WSDLReader:XML Parser failed at linenumber 0, lineposition 0, reason is: Th
e download of the specified resource has failed.
HRESULT=0x1: Incorrect function.
- WSDLReader:Loading of the WSDL file failed HRESULT=0x80070057: The parame
ter is incorret"
|
|
|
|
|
I have always done this this way, hopefully it will help
Private m_strEndPointURL As String
Private m_strWSDLFile As String
'SOAP / SQLXML members
Private m_oNodeList As IXMLDOMNodeList
Private m_oSoapClient As New SoapClient30
Private Sub ConfigureSOAP()
'Location of the WSDL - XML catalog of the SPs
m_strWSDLFile = "http://localhost/SQLXML/SOAP?wsdl"
'Set the destination host - this is the URL to the server
'without the wsdl path so http://Localhost/MERCSQLXML/SOAP
m_strEndPointURL = Left(m_strWSDLFile, (Len(m_strWSDLFile) - 5))
'This method configures the various SOAP objects ready for use
Set m_oSoapClient = New SoapClient
m_oSoapClient.mssoapinit m_strWSDLFile
m_oSoapClient.ConnectorProperty("EndPointURL") = m_strEndPointURL
End Sub
'Call Soap
Set m_oNodeList = m_oSoapClient.Method(Args)
"If i was king cigarettes would be free."
|
|
|
|
|
thanks
but that doesnt seem to work for me
could it be something wrong with the IIS
I cant open the .wsdl file at all when typing
http://localhost/somedir/myfile.wsdl
|
|
|
|
|
your wsdl file url should be
http://localhost/somedir?wsdl
you need a ? not the direct path, try putting that in IE and see if it presented.
If its not it's your IIS VDs
"If i was king cigarettes would be free."
|
|
|
|
|
HI guys
I have a couple of questions on creating custom activeX controls. I have a customs activeX control with two constotutent controls An ImageBox and a label. I've exposed two properties namely Picture which corrsponds to the image boxes picture property and Caption which corresponds to teh labels caption.
At the moment I'm like setting the picture property by just passing it a string. But that's seriously not how it should be working I mean when you set the Image controls picture property you choose from a file dialog. My code is as below:
<bold>
Option Explicit
Public Event Click()
Private Sub Image1_Click()
RaiseEvent Click
End Sub
Private Sub UserControl_InitProperties()
With Image1
' .Picture = Nothing
End With
With lblRouterIP
.Caption = ""
End With
End Sub
Private Sub UserControl_ReadProperties(PropBag As PropertyBag)
BackColor = PropBag.ReadProperty("BackColor", BackColor)
With Image1
.picture = PropBag.ReadProperty("Picture", .picture)
End With
With lblRouterIP
.Caption = PropBag.ReadProperty("caption", .Caption)
End With
End Sub
Private Sub UserControl_WriteProperties(PropBag As PropertyBag)
Call PropBag.WriteProperty("Picture", Image1.picture)
Call PropBag.WriteProperty("caption", lblRouterIP.Caption, "")
End Sub
'PROBLEM AREA
Public Property Get picture() As String
picture = Trim(Image1.picture)
End Property
Public Property Let picture(ByVal img As String)
Image1.picture = LoadPicture(img)
Call UserControl.PropertyChanged("picture")
End Property
Public Property Get Caption() As String
Caption = lblRouterIP.Caption
End Property
Public Property Let Caption(ByVal str As String)
lblRouterIP.Caption = str
Call UserControl.PropertyChanged("Caption")
End Property
it doesn't make any sense to return a picture as a string.
Also lets say that I want to create my own property for this active X control like uh the name of Status that can hold 3 values. How can I do that.
I've been using vb6 for a while but this is my initial attempt at activeX programming.
I'm using vb 6 and would greatly appreciate the help.
|
|
|
|
|
I don't understand your problem...what is it that you need? You want the user to be able to browse the windows to find the picture? If it's the case, it can be easily be done with the common dialog control...but what is that you really need?
|
|
|
|
|
Actually when I declare teh public Properties for the Picture element of the activeX control what sort of object do I pass to the property like in the following declaration:
Public Property Get Picture () AS ????
what do I get teh piucture as in what format a string or an image?
I also have another simple problem on how to create instances of the line control at run time through code.
|
|
|
|
|
The Picture component loads a picture file into its image. So to load a picture you usually specify the file name of the picture to be loaded...a file name is a string. So you need to GET the file name as string
Public Property Get Picture () As String
|
|
|
|
|
i am not able to handle events (SelectedIndexChanged) fired by a combo box inside a datagrid
this is in VB.net
can anyone help me
thank u
Srikanth
|
|
|
|
|
Hello,
I've a text box in a group box on a form and upon startup, this box is NOT enabled. My UI behavior is supposed to enable the box if the user double clicks on it (I cannot get messages from the box itself while not enabled). After a few hours of trying to find a method, I'm giving up and asking if anyone knows how to do this? I find it hard to believe that there's no "hit test" contained in the Rectangle or Point object types and that I cannot get a rectangle type directly from the text box itself!
thanks!
JennyP
|
|
|
|
|
By definition, the enabled property "Gets or sets a value indicating whether the control can respond to user interaction"-MSDN. It can't catch any user interaction, including the click, double-click events and the mousemove, mouseup, mousedown events that you may need to hittest. Try setting the read-only property instead. This makes the control able to receive user interaction but will still be uneditable. Good Luck!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
