|
By using the Microsoft SDK for controlling Office files via .NET.
Christian Graus
Please read this if you don't understand the answer I've given you
"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 i have any sample code?
Hitesh sojitra
|
|
|
|
|
Sure[^]
Christian Graus
Please read this if you don't understand the answer I've given you
"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 )
|
|
|
|
|
Imports BrainCells
Class Google
<some work="" of="" your="" own="">
End Class
I don't speak Idiot - please talk slowly and clearly
|
|
|
|
|
Funny how answering a stupid question just gets you a 1 vote ( well, yours was a joke, but I got a 1 for being honest and helpful ).
Christian Graus
Please read this if you don't understand the answer I've given you
"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 Friends,
I have devleoped one application in VB 6.0. Packaged it and try to installing in others system.
But when i install in others system, for few of the systems the application is not installing and giving the following error message.
Setup cannot continue because some system files are out of date on your system. Click OK if you would like setup to update these files for you now. You will need to restart Windows before you can run setup again. Click cnacel to exit setup without updating system files.
Kindly help me for this issue.
Application developed in Windows XP , professional Edition...The system where I am getting problem is also windows XP and some are Windows 2000.\
Thanks in Advance,
Regards,
|
|
|
|
|
Well, I would assume that VB6 needs some runtime that is not present. What's your issue, does the installer not download the needed files so your app runs?
VB6 has been a dead language for 6 years and sucked long before that, why are you still using it ?
Christian Graus
Please read this if you don't understand the answer I've given you
"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 guys,
Been struggling with this and thought I had gotten it right when I realised my way affected the functionality of the databindingsource.
I have 2 databound comboboxes. The first contains a list of industry categories and the second contains the companies in those industries. I need the second combobox to only show companies that fall in the industry category selected in the first combobox. This needs to update whenever the records are navigated or the selection in the first combobox changes.
The way I did it (tried using companybindingsource.filter and refilling the company table on every selection) causes "haschanges" on the dataset and also screws up my "add new record".
If anybody could help me or point me to an example I would be grateful.
Thank you
Ed
|
|
|
|
|
Just handle the selected index changed of the first combo and then run SQL to select a new data source for the second. Sounds to me like you're using the built in SQL data source rubbish, throw that in the bin, write real code and you'll find you'll regain complete control over wat your program does.
Christian Graus
Please read this if you don't understand the answer I've given you
"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,
however Christian Graus already answer this question in therotically. if you have any problem in apply this thing practicaly then consider following
first of all use following statement in declaration section
Private ComboBox1LoadTime As Boolean<br />
Dim ds, ds1 As New DataSet
<br />
now fill the combo box as following at load event of form <br />
<br />
Dim str As String<br />
<br />
Dim mdins As New mdGlobal 'here mdglobal is <br />
str = "select areaname,areaid from areainfo"<br />
ds = New DataSet<br />
ComboBox1LoadTime = True<br />
ds = mdins.GetResultFromQuery(str)<br />
'in above statement i use class mdglobal which is created by me. and GetResultFromQuery return dataset<br />
<br />
ComboBox1.DataSource = ds.Tables(0)<br />
ComboBox1.DisplayMember = "AreaName"<br />
ComboBox1.ValueMember = "Areaid"<br />
ComboBox1LoadTime = False<br />
ComboBox1.SelectedIndex = -1
Now on selected index change event of combobox1 use following code
Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged<br />
If Not ComboBox1LoadTime And ComboBox1.Text.Trim <> "" Then<br />
Dim str As String<br />
Dim mdins As New mdGlobal<br />
<br />
ComboBox2.DataSource = Nothing<br />
If Not ds1 Is Nothing Then<br />
ds1.Dispose()<br />
End If<br />
<br />
str = "select iteminfo.itemid,itemname,area_item.areaid from iteminfo,area_item where iteminfo.itemid=area_item.itemid and area_item.areaid=" & ComboBox1.SelectedValue<br />
ds1 = New DataSet<br />
ds1 = mdins.GetResultFromQuery(str)<br />
<br />
ComboBox2.DataSource = ds1.Tables(0)<br />
ComboBox2.DisplayMember = "itemName"<br />
ComboBox2.ValueMember = "itemid"<br />
End If<br />
End Sub
Please take care that,in above code i use sample query and my own method for fill dataset
hope this helps
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
My Company
|
|
|
|
|
Yes, thank you both very much. That sorts it. It seems to be the .datasource= nothing bit that makes it all work.
|
|
|
|
|
Hello all,I'm using VS 2003,VB.NET creating a window form application. I found problem on retrieving data from my MySQL database which have varchar and tinytext column. I found error when I try to check if any data exited by using ObjRead.Read. Anyone can give me a solution on how to check the existance of the data inside the MySQL table using VB.NET?
The following are the database table structure of the command running:
Field Type Collation Null Key Default Extra Privileges Comment<br />
------------ ----------- ----------------- ------ ------ ------- ------ ------------------------------- -------<br />
LocationCode varchar(10) latin1_swedish_ci NO PRI select,insert,update,references <br />
SettingKey varchar(10) latin1_swedish_ci NO PRI select,insert,update,references <br />
SettingValue tinytext latin1_swedish_ci YES (NULL) select,insert,update,references
The following are the Code I used to check and I'm using If Statement to control the situation:
<br />
Try 'Check Server IP<br />
Dim s As String<br />
ObjComm = New OdbcCommand("SELECT SettingValue FROM pos_setting WHERE LocationCode='" & TerminalLocate & "' AND SettingKey='Server_IP' ", ObjConn)<br />
<br />
ObjConn.Open()<br />
ObjRead = ObjComm.ExecuteReader()<br />
If ObjRead.Read Then<br />
ObjConn.Close()<br />
<br />
s = ObjRead.Item(0)<br />
If (s = 0 Or s = 1 Or Len(s) < 3 Or s = "") Then<br />
'Something run here<br />
<br />
Else<br />
<br />
End If<br />
Else<br />
MessageBox.Show("Error on Checking Server IP")<br />
End If<br />
Catch ex As Exception<br />
MessageBox.Show("Error : " + ex.Message)<br />
Finally<br />
ObjConn.Close()<br />
End Try
I have put some integer into the table:
Example: LocationCode=KK SettingKey=ServerIP SettingValue=192.168.2.80
But when I run it,it shows me this error:
Error: No data exist for the row/column.
Why could this happen? Anyone can give me some solution?
Thanks for reading.
|
|
|
|
|
Not sure - but have you tried closing your connection after you've accessed the reader and not prior to reading? A datareader needs a connection to the database to retrieve the data.
And seeing as you have a close in your finally, you do most certainly not need any more in your "if read" scope.
|
|
|
|
|
Thank you my friend. I have got it now. You get the right solution for me. I just remove the objconn.Close() in my code and everythings goes fine now. Thanks alot Alsvha~! Happy Coding my friend. 
|
|
|
|
|
You are closing the connection but instead you should leave it open until you are done reading not just executing the query. You are using DataReader which is a connected class so you can only read in connected mode.
|
|
|
|
|
Thank you my CodingYoshi. I have got it now. You get the right solution for me. I just remove the objconn.Close() in my code and everythings goes fine now.Yeah,datareader problem. Thanks alot CodingYoshi~! Happy Coding my friend.
|
|
|
|
|
Are all the properties the same for different controls? Explain at least five properties of your favorite controls (e.g., what they do and how can they be used). Do not discuss 5 controls, rather 5 properties of your favorite controls.
I need help! A website somthing...second week in programming and I am LOST!
|
|
|
|
|
A property is a setting on a control, which you can set in code, or in the designer. For example, all controls have a Text property ( I believe ). But only databound controls have a Datasource property.
To answer this question, you just need to drag controls onto a form in the designer and look at what their properties are.
I'm hoping this is a middle school programming class, I'd be disgusted if a university called playing with properties in the designer a valid thing to focus on in a programming class. Second week of programming, IMO, you should not be looking at controls at all, or even windows.
Christian Graus
Please read this if you don't understand the answer I've given you
"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 )
|
|
|
|
|
Christian
Thank you for your help...and yes sadly this is a University class. Basic programming though.... Your responce did help.
|
|
|
|
|
OK - I'm glad I helped.
Christian Graus
Please read this if you don't understand the answer I've given you
"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 )
|
|
|
|
|
There is a GREAT definition on page 75 of our text book
Microsoft Visual Basic 2005 Step by Step
|
|
|
|
|
I'm using Visual Studio 2005 and programming in Visual Basic.
Can anyone assist me in how to Format a Cell in a TextColumn of the DataGridView Control and insert an Image in that Cell.
I want to put Images along a Row, rather than down a Column.
It is an UnBound DataGridView Control.
I understand it's all about having individual Cells Inherit the ImageType Column's Style. But I can't see how to go about it.
A code sample would be very much appreciated.
Regards, Graham
|
|
|
|
|
|
Dave,
Since posting this question, I have resolved how to display an Image in a DataGridViewTextBoxColumn.
Dim imageCell As New DataGridViewImageCell<br />
Me.DataGridView1.Item(2, 0) = imageCell<br />
Dim imageMe As New Bitmap("C:\Pictures\Graham.jpg", True)<br />
imageCell.ImageLayout = DataGridViewImageCellLayout.Stretch<br />
imageCell.Value = imageMe
That places the Image in Col 2, Row 0 and the other Rows in that Column, all accept Text input.
My problem now is to be able to do this to multiple Cells. In otherwords, reuse the variables, imageCell and imageMe as I won't know how many of these images there are until Runtime.
Any ideas on that issue please?
Regards, Graham
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
