|
I am trying to separate my data access code from my form code. I have a created a data access class containing a function to accept an EmployeeID and return a dataset containing just information for that employee. When I try to display the employee information on the form I am getting the column name rather than the value contained in the column. What am I doing wrong?
Form Code
Private Sub frmMaint_Load(ByVal sender As Object, _<br />
ByVal e As System.EventArgs) Handles MyBase.Load<br />
<br />
Try<br />
dsSpcInstrFRM = m_DAL.SpecialInstructions(strEmpIdFromChooseFrm)<br />
dtSpcInstrFRM = dsSpcInstrFRM.Tables("SpcInstructions")<br />
lblSpcInstructions.Text = dtSpcInstrFRM.Columns("SpcInstr").ToString<br />
Catch ex As Exception<br />
‘Error Routine<br />
End Try<br />
<br />
End Sub
Data Access Code
Friend Function SpecialInstructions(ByVal m_strEmpID As String) As Dataset<br />
<br />
Dim sqlRiskDR As SqlDataReader<br />
Dim SpecialInstructionsDS As New DataSet<br />
Dim SpcInstrDT As New DataTable<br />
Dim SpcInstrDR As DataRow<br />
<br />
Try<br />
sqlRiskCN = New SqlConnection(My.Settings.SQLRiskCNString)<br />
sqlRiskCN.Open()<br />
<br />
'Use Stored Procedure<br />
strSql = "GetSpecialInstructions " & "'" & m_strEmpID & " '"<br />
<br />
sqlCM = New SqlCommand(strSql, sqlRiskCN)<br />
sqlRiskDR = sqlCM.ExecuteReader()<br />
<br />
SpecialInstructionsDS.DataSetName = "SpecialInstructions"<br />
SpecialInstructionsDS.Tables.Add(SpcInstrDT)<br />
SpcInstrDT.TableName = "SpcInstructions"<br />
<br />
SpcInstrDT.Columns.Add("EmpID").Unique = False<br />
SpcInstrDT.Columns.Add("SpcInstr")<br />
<br />
Do While sqlRiskDR.Read()<br />
SpcInstrDR = SpcInstrDT.NewRow<br />
SpcInstrDR.Item("EmpID") = sqlRiskDR.Item("EmpID").ToString<br />
SpcInstrDR.Item("SpcInstr") = sqlRiskDR.Item("EmergInstructions").ToString.TrimEnd<br />
<br />
SpcInstrDT.Rows.Add(SpcInstrDR)<br />
Loop<br />
<br />
sqlRiskDR.Close()<br />
sqlRiskCN.Close()<br />
<br />
Catch ex As Exception<br />
‘Error Routine<br />
End Try<br />
<br />
Return SpecialInstructionsDS<br />
<br />
End Function
|
|
|
|
|
Because you are reading the value from the column information in the data set, not from the data rows. Use the Rows property.
---
b { font-weight: normal; }
|
|
|
|
|
Using the rows property makes sense, but now it brings up the question of how I actually retrieve the data from the dataset. As you can probably tell I am new at this. What code do I need to add to my form to get this to work?
Thanks!
|
|
|
|
|
lblSpcInstructions.Text =
dtSpcInstrFRM.Items("SpcInstr").ToString
Go here for more info
"People who never make mistakes, never do anything."
My Blog
|
|
|
|
|
Using item still places SpcInstr in the text of the label. I am trying to get the value from the column named "SpcInstr". Any other suggestions?
|
|
|
|
|
I am trying to create a gantt chart, and the article says that you must right click on your toolbox and add a the EventCalendarControl.dll, but I have added it to the toolbox but it does not highlight. I am using Visual Basic Express Edition.
Please Help
NOKO
|
|
|
|
|
Add a reference to the dll. In the solution explorer drag that to your toolbox.
"People who never make mistakes, never do anything."
My Blog
|
|
|
|
|
I am having a problem with a user control that I created for a windows form using VB.NET. The problem is that when I click the tab key or minimized the form, the control moves to the right side of the form. I really appreciate if anyone gives me any suggestion to stop moving that control from clicking tab key or minimize the form.
Thanx in advance.
Thanx
|
|
|
|
|
This control should only move if you have code to move it. Do you have something setup to change the layout of your controls?? I would also check the designer generated code that creates the controls for you to see if there is anything in there that setups up the wrong docking and anchor properties.
If you have any control containers on your form, make sure that the control that is moving is a member of the correct container.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Thanx for your reply...I fixed the problem. I really appreciate that.
Thanx
|
|
|
|
|
I have a multiline textbox on a form that a user can type information into. When they click update it writes the contents to a SQL table. If the user types a quote in the textbox the update fails. How do I update when there are quote characters?
Thanks for any help on the matter
|
|
|
|
|
That is because you don't handle the string values in the query correctly. You have to escape some characters when you put a string value in an SQL query.
For MSSQL and Access you escape the apostrophe by replacing them with double apostrophes.
For MySQL you escape backslashes by doubling them, and apostrophes by putting a backslash in front of them.
---
b { font-weight: normal; }
|
|
|
|
|
Thanks, I remembered reading that awhile back but had fogotten it.
|
|
|
|
|
Or you use parameterized queries (best practice!) and you won't have to worry about escaping anything yourself.
For more information, read SQL Injection Attacks and how to prevent them[^] by COlin Angus Mackay.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I have created a student database in Ms-Access.
the records are stored through the FORM(VB.NET).the form has different buttons for selecting the education forex-Primary,secondary & higher secondary etc.
now what i want is once a record is saved.the value in the name field(that is the name of the student) should be listed in the listbox depending on the button clicked (as mentioned above)
raman
|
|
|
|
|
How did you fill the ListBox in the first place? All you'd have to do is call that code again.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I have established a connection with Ms-Acess through dataset.Now i want to know how to generate autonumber in a textbox field(ID_NO) in my form
If i save the record then the next record should not have duplicate values
AND ALSO IF THE RECORD IS NOT SAVED THEN THE NUMBER SHOULDNOT BE SKIPPED
PL TELL ME
Arun
|
|
|
|
|
Arun Hegde wrote: Now i want to know how to generate autonumber in a textbox field(ID_NO) in my form
You don't. That number will only be generated when the record is actually written back to the database.
IF you went a "checked-out" a blank record in the database, you'd get the number generated, but you would be forced to "use or lose" the number.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
-- modified at 10:55 Friday 10th March, 2006
|
|
|
|
|
http://www.dreamsyssoft.com/image-to-pdf-library
When I regsvr32 this dll, it shows me that the dll no need to registry.
But I cannot add it to reference.
The author tells me that it can import to VB.NET directly but no need add to reference and registry.
Any one can tell me the method? Thanks.
|
|
|
|
|
cylix2000 wrote: When I regsvr32 this dll, it shows me that the dll no need to registry.
That's because it's not a COM .DLL.
cylix2000 wrote: But I cannot add it to reference.
Because it's not a COM .DLL.
cylix2000 wrote: The author tells me that it can import to VB.NET directly but no need add to reference and registry.
You have to import the functions from the .DLL to use them. THis is done using the Declare[^] statement in VB.NET.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hello, I am expereinced VB6 developer, have not coded for 3 years however. I need to design a class model for a Vb.NET application. I understand OO, I am however unclear on the implementation of Class collections in VB.NET. I read somewhere that class collections are now legacy. If so how do I enum and iterate though classes? All the topics I find on this involve a class collection still? Did I just read wrong about Class Collections being legacy?
On a similar note, are there any topic, threads on bind classes of data to the controls that show them on screen? In VB6 I did this long hand by iterating through the classes. I used the index property to do this. Will the new Handles event work with updating class collections?
Sorry if this is unclear.
Kadi
|
|
|
|
|
There are various collection classes you could use. Which one is up to your requirements.
System.Collections[^] namespace
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
 Hi I have managed to extract the following from some html source and display it in a Rich text Box.
What I would like to do now is either dsiplay just the numbers in a text box (in the above case) 3 5 8 10 44 3 & 5 or download the gifs and display then.
I can't hard code the numbers/ gifs in as they will change on a regular basis
Any help or advice would be most appreciated
Thanks
|
|
|
|
|
Could you just get the position of 'alt="' in each line, add 5 to get the position of the number you want, then just grab the following characters one-by-one until you hit another quote character?
|
|
|
|
|
You could either do it with simple String manipulation or with RegEx. If you're not familiar with Regular Expressions, it's can be a bit confusing to start with.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
