I needed a picklist implementation that involved a Listbox on the left and a Listbox on the right. With buttons in the middle to move items from the left to the right to the left, up and down within the Listbox, etc. I've programmed similar implementations, including my tree select demo. But my client had an existing control from Fluent Consulting.
The control is the List Transfer control. I was amazed at how easily I could implement the code.
In the code in front, simply register the control:
<%@ Register Assembly="Fluent.ListTransfer" Namespace="Fluent" TagPrefix="cc1" %>
<cc1:ListTransfer Runat="server" ID="lstClientTransferCodes" ListControlFrom="lstAvailable" ListControlTo="lstSelected" EnableClientSide="true" />
And in the code behind, simply add "onclick" attributes to the buttons:
ibtnMoveRight.Attributes.Add("onclick", Me.lstClientTransferCodes.ClientMoveSelected)
ibtnRightMoveDown.Attributes.Add("onclick", Me.lstClientTransferCodes.ClientMoveDownListControlTo)
ibtnRightMoveUp.Attributes.Add("onclick", Me.lstClientTransferCodes.ClientMoveUpListControlTo)
ibtnMoveLeft.Attributes.Add("onclick", Me.lstClientTransferCodes.ClientMoveBackSelected)
The rest, setting up the lists, binding the data, etc., didn't need to change at all.
All I had to do was add those 6 lines of code and boom, it was done!
I highly recommend this product!
I used this for client side transfer of data, but it also supports server side. View the demo here!
They describe the ListTransfer as "The ListTransfer control simplifies the transfer of ListItems between two ListControls. With this control you can easily create double listboxes or use several in combination."
I decided to see what other controls they have available, and noticed a Multi-LineTextboxValidator. This was of interest to me since I wrote an article in 2000 on the Javascript Dynamic Text Area Counter which I used extensively on my ASP Classic web sites. However, I'm all for upgrading to a control that can be easily plunked into my ASP.NET pages.
Here are the remainder of their controls:
- The MultiLineTextBoxValidator is a validator control which will restrict the length of MultiLine TextBox controls.
- Fluent.ControlFocus This is a very simple non-visual web control which will automatically set focus to a given WebControl after the page has completed loading. This may be useful in situations such as page validation, for example, if you want the cursor to be positioned in a given field which needs correction after a validation failure on postback.
- The DataGridAdapter control simplifies the sorting and paging of DataGrid controls with various data sources.
- The LogicTemplate controls simplify conditional presentation logic. These controls allow you to dynamically control the contents of templates in repeater controls (DataGrid, DataRepeater, etc). LogicTemplates provide easier, cleaner code than using OnItemCreated events or other code-behind functions.
May your dreams be in ASP.NET!
Nannette Thacker
In our final Section 9 of this tutorial by Nannette Thacker, we learn how to use our TableAdapters within our code. We also look at how Intellisense makes it easy to set up your TableAdapter code.
Download the ZIP files:
C#: ShiningStarCExcel.zip
VB: ShiningStarVBExcel.zip
Do everything without complaining or arguing, so that you may become blameless and pure. Philippians 2:14
May your dreams be in ASP.NET!
Nannette Thacker
In Section 8 of this tutorial by Nannette Thacker, we take a look at adding a OleDbDataReader and the ExecuteReader method to retrieve data from an Excel Spreadsheet.
Download the ZIP files:
C#: ShiningStarCExcel.zip
VB: ShiningStarVBExcel.zip
"Taste and see that the LORD is good; blessed is the man who takes refuge in him." Psalm 34:8
May your dreams be in ASP.NET!
Nannette Thacker
In Section 7 of this tutorial by Nannette Thacker, we learn how to create a select query statement in our table adapter and pass parameters to it. We learn how to create an insert query, use a "SELECT SCOPE_IDENTITY()" to retrieve the identity key value returned, and set our ExecuteMode to "Scalar" in our properties sheet.
Download the ZIP files:
C#: ShiningStarCExcel.zip
VB: ShiningStarVBExcel.zip
You may be learning ASP.net because you want to better yourself by learning a new technology. God has a care for you and your life and your career. Ask Him for help, and as long as you're within His will, He will bless you. He will help you learn. He will even help you find a career. Don't give up or be disheartened. Just ask Him and claim His promise below.
Ask and you will receive, and your joy will be complete. John 16:24
The prayer of a righteous man is powerful and effective. James 5:16
Therefore I tell you, whatever you ask for in prayer, believe that you have received it, and it will be yours. Mark 11:24
May your dreams be in ASP.NET!
Nannette Thacker
In Section 6 of this tutorial by Nannette Thacker, we learn how to retrieve data from an uploaded spreadsheet, and import it into a SQL Server database. We will create a Data Access Layer DataSet and some TableAdapters. We will learn how to add a data connection to our web.config. We will learn how to create SQL Statements in our TableAdapters and use the Query Builder.
Download the ZIP files:
C#: ShiningStarCExcel.zip
VB: ShiningStarVBExcel.zip
Be careful of listening to, and being a gossip. You can bet that if they're gossiping about someone else, they're also gossiping about you. And if they're listening to you gossip, they're going to repeat it.
Do not let any unwholesome talk come out of your mouths, but only what is helpful for building others up according to their needs, that it may benefit those who listen. Ephesians 4:29
May your dreams be in ASP.NET!
Nannette Thacker
In Section 5 of this tutorial by Nannette Thacker, we will learn how to create a connection to our Excel Spreadsheet using an OleDbConnection with a Microsoft.Jet.OLEDB Connection String. We will learn how to create a SELECT query to retrieve data from a given Excel worksheet using an OleDbCommand. We will populate and bind our data to our GridView using an OleDbDataAdapter and DataSet.
We will also look at using Server.MapPath to find a physical directory on the server.
Download the ZIP files:
C#: ShiningStarCExcel.zip
VB: ShiningStarVBExcel.zip
Do you spend hours and hours behind the computer, at the neglect of your spouse or children or parents? I used to think that the more hours I put in and the harder I worked, the more I would be recognized for my accomplishments and rewarded in responsibility and monetarily. However, this is rarely true. The work will always be there the next day. Your children won't. Your spouse may not. If you found out you were going to die tomorrow, would you spend the next 24 hours with your family or behind your computer? I hope you answered your family. Treat them like they're special today. You never know what's going to happen to you or them. We need to balance our lives. Of course we need to work, but we also need to spend quality time with our families and with God.
I denied myself nothing my eyes desired; I refused my heart no pleasure. My heart took delight in all my work, and this was the reward for all my labor. Yet when I surveyed all that my hands had done and what I had toiled to achieve, everything was meaningless, a chasing after the wind; nothing was gained under the sun. Ecclesiastes 2:10-11
What good will it be for a man if he gains the whole world, yet forfeits his soul? Or what can a man give in exchange for his soul? Matthew 16:26
May your dreams be in ASP.NET!
Nannette Thacker
In Section 4 of this tutorial by Nannette Thacker, we will learn how to add and Auto Format a GridView in our WebForm. We will also learn how to create and add a Cascading Style Sheet to our project.
We will learn more about the Design view, and look at applying a scheme via the AutoFormat functionality of the GridView.
Download the ZIP files:
C#: ShiningStarCExcel.zip
VB: ShiningStarVBExcel.zip
As developers, many of us need to guard against being arrogant. Be humble and teachable. You will get along a lot better with co-workers. Don't go into a new position telling others how smart you are, be humble and let them tell you how smart you are after you have assisted them with their problems in a humble fashion. Don't push your opinions on others either. There are multiple ways of doing the same thing, and in many cases, they are all correct. Respect others' opinions and they will respect you.
Humble yourselves before the Lord, and he will lift you up. James 4:10
Live in harmony with one another. Do not be proud... Do not be conceited. Romans 12:16
May your dreams be in ASP.NET!
Nannette Thacker
In Section 3 of this tutorial by Nannette Thacker, we are going to look at the "FileUpload" control. We will discuss how to set a Label text value and set Panel visibility from Codebehind. We will also learn how to use the Handles key word at the end of our procedure declarations to handle our Button Click events. We will also view a snippet of code that uses error handling through Try/Catch/Finally.
Download the ZIP files:
C#: ShiningStarCExcel.zip
VB: ShiningStarVBExcel.zip
I recently interviewed for a contract position and told the owners that I knew how to do a lot of things, but that there were a lot more other things that I hadn't yet done. The owners informed me that it mattered less how much the person knew, and more how they interacted with others. They told me that hiring a "know-it-all" was just too much trouble. I did get the position. Always be honest on your resume and at your job interview. A wise employer would rarely expect you to know everything. Just be honest with what you do know.
Do not be wise in your own eyes; fear the LORD and shun evil. This will bring health to your body and nourishment to your bones. Proverbs 3:7-8
May your dreams be in ASP.NET!
Nannette Thacker
In Section 2 of this tutorial by Nannette Thacker, we learn how to work with our WebForm and define the properties of an ASP.NET Table control to layout our buttons. We will learn how to add controls for Buttons, Panels and Labels.
We will learn a little bit about the Design mode, by creating our Tables using the Design mode.
Download the ZIP files:
C#: ShiningStarCExcel.zip
VB: ShiningStarVBExcel.zip
Throughout the years, I have learned through the blessings of others who have taken the time to write articles or blogs or respond to forums. I still widely use the internet and knowledge obtained from others nearly everyday.
As you're learning, you may feel that you have nothing you can share with others, but that is the best way to learn. As you learn a new technology, talk about it, write about it, share what you've learned with someone else, and that will help to reinforce what you've learned.
I believe that as God blesses us with answers, He smiles when we in turn take the time to share with others and help them as well. You never know what good may result from the connections made through your attempts to help others. Numerous clients have contacted me to do their web projects as a result of my desire to share with others. God truly blesses you when you are a blessing to others.
Be wise in the way you act toward outsiders; make the most of every opportunity. Colossians 4:5
May your dreams be in ASP.NET!
Nannette Thacker
In Section 1 of this tutorial by Nannette Thacker, we learn how to create a project and our SQL Server Database Tables using Visual Web Developer or Visual Studio 2005 or 2008. We will look at the design of our Excel Spreadsheet and create a new database and tables for our imported data.
We learn how to use the Solution Explorer (Solution Explorer in VWD and Server Explorer in Visual Studio), and use the Database Explorer. We learn how to add a table, set a primary key, and use the Identity Specifications property when creating a table column.
Download the ZIP files:
C#: ShiningStarCExcel.zip
VB: ShiningStarVBExcel.zip
As you're learning ASP.net, you may feel overwhelmed with bugs and errors. Don't underestimate God's concern with your daily troubles. He wants you to turn to Him as a flower turns to the sunshine. When you are struggling with a task, ask Him for help. He promises He will be there for you.
God is our refuge and strength, an ever-present help in trouble. Psalm 46:1
May your dreams be in ASP.NET!
Nannette Thacker
More Posts
Next page »