View Complete Post
For efficiency's sake I've created a number of stored procedures to run against an SQL table. Which procedure runs depends upon the checkboxlist choices a user makes before clicking a button. The checkboxlist looks something like this:
<asp:CheckBoxList AutoPostBack="True" runat="server">
<asp:ListItem Enabled="True" Value="1">Item 1</asp:ListItem>
<asp:ListItem Value="10"> Item 2</asp:ListItem>
<asp:ListItem Value="100"> Item 3</asp:ListItem>
</asp:CheckBoxList>As an example,
What I can't figure out is how to loop through the checkboxes in the Button1_Click event in the .cs code behind page to add up the values of the selected items. (The value of an unclicked box being 0.) Converted to a string, the totaled value is then appended to a stored procedure name (MyPROC) for entry into the SQL statement. In other words, if the user clicks just Item 1, then the Button1_Click event would produce a stored procedure name of MyPROC1, insert it into the statement, and fire off the query; if Ite
I would like to know if there is a way I can select a checkbox and this would add an end date to another table? I have 2 tables Staff_Tasks, this has the checkbox set up as an int, 1 or 0, and the other Jobs which has a field end_date. So when the user clicks on a checkbox it will add this end_date as today's date. The end_date is never displayed, its just stored in the database. I am not even sure if this is something that can be done as an SQL query or if it will be done in my back-end code? I am writing in C#. Does anyone have a little more information?
I am new to gridview.
I want to make a gridview. Its row when selected should direct me to a specific .aspx page.Each row should direct to a different page.
Should I use querystrings for this? Please suggest.
I am using OLEDBConnection (@"Provider=Microsoft.ACE.OLEDB.12.0;") to connect to the EXCEL file and read contents. When I read the contents, I get all the contents from the excel sheet but i dont get contents for checkboxes placed inside.
My Excel sheet contains set of checkboxes and I need to know If they are checked or not.These checkboxes are controls which are added from Developer tab in EXCEL.
I dont want to use Excel Assemblies for reading contents as it is not recommended. And also i am using OLEDBconnection and want to stick to this .
Awaiting replies from you guys. Thanks in Advance.
MSDN Magazine October 2003
This month Aaron Skonnard covers how keys work in XSLT, XSLT match and select attributes, SelectNodes order, finding