|
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
|
|
|
|
|
I needed to replace the disk on my development machine. Everything went fine. I had my VB.Net application backed up to DVD.
I reloaded the folder, and tried a build, I received 42 of these warning messages:
Namespace or type specified in the project-level Imports 'PegasusImaging.WinForms.TwainPro4' doesn't contain any public member or cannot be found. Make sure the namespace or the type is defined and contains at least one public member. Make sure the imported element name doesn't use any aliases.
They relate to different Pegasus Namespaces (TwainPro, PrintPro, etc). I tried removing the reference, and adding it back in, but the warnings persist.
|
|
|
|
|
The only thing that would do this is your project is missing a reference or the libraries you're using haven't been reinstalled and properly registered.
|
|
|
|
|
I am working on a attendance program (for a club) that pulls the dates (all of them) for a member from a database. I know how to display all of the dates but I was wondering if it is possible to group by week? For example, you have 3 dates (i.e. 05/07/2008, 05/08,2008, 05/09/2008) from last week and two dates from the current week (i.e. 05/11/2008, 05/12/2008) and wish to display them like:
05/07/2008 05/08/2008 05/09/20085/
05/11/2008 05/12/2008
and not like:
05/07/2008
05/08/2008
05/09/2009
05/11/2008
05/12/2008
Thanks for the help in advance!
|
|
|
|
|
The DateTime class has a DayOfWeek property. you can display your data anyway you'd like, are you asking how to work out which days are in the same week, or how to display that data ? What are you using to display it now ?
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 )
|
|
|
|
|
I want to display which days are in the same week. I am using a SQL statement to pull the attendance information from a database on a server but just want to group the attendance records into weekly groups. I am throwing the information into a list box.
|
|
|
|
|
OK - so this is a SQL question. I am not sure how to do it in your query, if you don't have the day of week already. I recommend asking in the SQL forum.
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 )
|
|
|
|
|
Try this, daetpart is your friend - from BOL
SELECT
DATEPART(wk,datadate) Week,
COUNT(*) Attendees
FROM MyTable
WHERE DATEPART(YEAR,datadate) = 2008
GROUP BY
DATEPART(wk,datadate)
ORDER BY DATEPART(wk,datadate)
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Oh - cool.
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 )
|
|
|
|
|
In SQL Server Datepart(Week,{date}) gives you teh week of the year, so you could group like that.
eg
select datepart(week,getdate()) for today gives yuo 20, i.e. the 20th week of the year.
Hope this helps
Bob
Ashfield Consultants Ltd
|
|
|
|
|
i have apllication with forms created in design view.
this forms have controls in them, like datagrids, buttons etc.
my application reads text from a CSV file and putting the text in the datagrids and other controls.
these controls use the "arial" font.
my CSV loads both hebrew text and russian(not in the same time).
i have no trouble viewing russian. but when i switch my regional settings to hebrew, the datagrids display russian charecters(scrambled) instead of hebrew.
ive noticed that when i select a font in the form or buttons it gives me the option of choosing also the right script for the font.
but in the datagrid i can only choose the font name and dont have the option of script.
anyone knows how can i deal with this font problem?
thanks.
|
|
|
|
|
I need help i have been trying all day yesterday and all day to day to try and get this working
What i trying to do is create buttons dynamically i can now do this thanks to Dave Kreskowiak he told me how to wire up the events for this but i just can’t get my head round it
I can get the event to work but the event is the same for each button
I need it to get the relevant drink and price from the database and put them in a list box
Dave mentioned directcast i tried to find out how to do this but with no joy
Original thread
http://www.codeproject.com/script/Forums/View.aspx?fid=1646&tid=2546094[^]
|
|
|
|
|
If all your buttons fire the same event, you can cast the object passed into the click event ( typically called 'sender' ) to a button, and then you can examine it's name or tag to work out what button was clicked and change the behaviour accordingly. I'd typically use the same event handler if all the buttons did roughly the same thing, for example, if three buttons all added a different value to something, I'd store the value in the tag property.
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 )
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
