About Stephen Jackson Expertise I can help with questions regarding VB.NET syntax and object references, with data interfaces and with the design and creation of robust, data aware object classes. I can also be very helpful with creating distributable applications and provide tricks and tips on .msi creation. I also have extensive experience in designing SQL Server Databases and interfacing them with VB.NET. I try to avoid web specific questions, as that is an area of expertise all its own.
Experience
Experience in the Area: I have been a programmer in Visual Basic since version 1.0 and have worked with VB.NET (which is infinitely more powerful than previous versions) since its initial release and SQL Server, both as a corporate IT professional and professional consultant. I first wrote Basic in 1976 on a TRS 80 and have worked in Visual Basic 1.0 and every subsequent release of Microsoft Visual Basic. I worked for over 7 years as a Senior Level Consultant in the area and currently hold a Project Manager position in IT.
Education and Credentials: MBA in Econometrics, 1983, University of Memphis.
BBA in Financial Management, 1982, Fogelman College of Business and Economics, University of Memphis. Microsoft Certified Professional
Areas of Special Expertise:
My specialty is the design of Object Oriented Solutions with robust, data aware object classes. I generally avoid the classic ‘Three Tier’ model as I find it redundant and cumbersome to maintain. I also specialize in the creation of ‘User Friendly’ User Interfaces which help lessen the need for user training and help prevent user error. I work best with Windows Forms based applications, and while I do work in C# as well, I prefer to limit my questions here to Windows Forms based applications created in Visual Basic.NET and SQL Server. I wil also address questions relating to the distribution and installation of Windows Forms based applications created in VB.NET.
Expert: Stephen Jackson Date: 5/26/2008 Subject: continued previous code
Question Hello Stephen, I hope that you are doing well.
Concerning the code i have sent to you, well in the build i get the following errors , i just don't know where the problem could reside:
Well Stephen , I can say that in the debug :
Whenever I click the GetData button I get the following error in the Private Sub getdata_Click()in the syntax Trim(starttime_cmb.SelectedItem.Text):
Public member ‘Text’ on type ‘String’ not found
Besides when I click the checkbox SkillsetGrpchk I get the following error in the Private Sub OpenConnection()in the syntax SqlConnection.ConnectionString = "Data Source=user;Initial Catalog=db;Integrated Security=True":
Not allowed to change the ‘ConnectionString’ proprety, the connection’s current state is open.
And when I click the two checkboxes AppGrpchk and RepGrpchk I get the following error in the Private Sub RepGrpchk_CheckedChanged()in the syntax Adapt.Fill(ds, “crtAppGrpObj”):
There is already an open Database associated with this Command which must be closed first.
Besides, the other combo boxes have null values when I click the ▼
Answer Carolina,
I think maybe I can help with this now :c)
It appears that the compile is telling you that the starttime_cmb.SelectedItem object does not have a 'text' attribute. This would be true, since this is actually an object in and of itself and does not have a text attribute. If you need the text being displayed as selected in the combo box, try using starttime_cmb.SelectedText.ToString() This will give you an actual string value which you can send to the trim command. Declare a String object and set it to starttime_cmb.SelectedText.ToString() and then Trim it.
If you are setting the connection string of SqlConnection, you do have to be sure the connection is not open. You can either close it, set the string and then open it, or if you are using that connection for another purpose, create a new connection object, set the string and then open it. If the connection string is the same as the original one, you can probably just use the original connection (which must be open?) and run a command against it.
