I have a table which contains asp radiobuttonlists (see below) for a survey. Once submitted the results are written to a database.I would like to use this same table for a similar survey, but the trouble is the question order needs to be different. The questions are the same, just in a different order. Is there a way (server side) to change the order of the table rows?
I reordered some items in a listbox using Javascript. When I read the items in a postback in the code behind (ASP.NET), the order is in the original order. How do I get the same order as shown in the screen after Javascript manipulation?
The idea is that a pure html table will be generated on the client side. (using jQuery to add dynamic new rows to the table when the user clicks a button). These rows contain textboxes, dropdownlists, checkboxes and other input controls. When the user clicks a button, a PostBack is triggered in which I need to access this data from the table on server side, validate it and perform other actions on it.
I'm able to perform the client side and access the table data on server side by adding runat="server" to the table tag. However, I only see the initial table rows (not the ones added through JavaScript) and I have troubles retrieving the different inputs from the rows. put me in the right direction?? Or someone offering a better solution to the problem?
I have a table that the user can add rows to through javascript by clicking on a "add rows button". In each row there are two columns one with a dropdown list and the other a text box. The dropdown list is populated with data through a sub on server side code.I need to be able to insert the data from each row into a table but I'm unable to do this. I clicked on my "add rows button" to add several rows and then did a test to see how many rows the table was returning on the server side and it did not include the five rows I added .. only the header row.If there is a better way to allow users to dynamically add rows to a table and then access the dynamically created table on the server then I'm all ears!
I have a repeater which contains a table. I am giving the user the ability to add a new row in the repeater by adding a new row to the table. As I am very new to jQuery, can someone give sample code?
I have one table named 'dbo.ac_Products' Within this table there is a column named 'ProductId' There is also another table named 'dbo.ac_CatalogNodes' Within this table there is a column named 'CatalogNodeId' and a column named 'CatalogNodeType'
I need to delete all the rows from 'dbo.ac_Products' and 'dbo.ac_CatalogNodes' where 'ProductId' = 'CatalogNodeId' and 'CatalogNodeType' = 1
I have table a and would like update table a whose values from table b, but not update all rows at table a. Only update record ID in table a match record ID in tableC.
Here is my query
update a set a.Desc = b.Desc, a.Value = b.Value from TableA a, TableB b where a.name = b.name and a.ID = b.ID and a.ID in ( select ID from TableC)
I only have 12 a.ID match TableC, but above query update whole TableA.
How to only update 12 record at TableA from TableB?
I have a large database of user profile data. I need to be able to compare 1 row against all of the other rows, for all columns to find the best match.There are around 30 columns of data for each row. I need to be able to find the 5 best matching rows.
I.E. Row 1 matches on 2 column's Row 2 matches on 12 column's Row 3 matches on 7 column's Row 4 matches on 4 column's Row 5 matches on 9 column's Row 6 matches on 23 column's Row 7 matches on 29 column's
In the end it will show me the data for rows 7, 6, 2, 5, 3 Now to make it even harder, Some of the columns are bit, some are varchar.Some of them may be a direct match, some will need to search if the column for row2 contains the text of row 1.
I have a data table called Songs It has SongId as Primary Key of type INT SongName of Type VarChar UserId of Type Int. I simply want to check how many entries are in the Table already by The UserId before they insert more. So If there are already 3 songs by that User, I want to stop the insert process and warn them they have the maxium already. I think i am halfway there already using code below but problem is that UserId is of Type GUID, and not Int so I am missing something. On my Aspx, Page, I have a DetailsView for the Database Insert. I also have the following code using BusLogic Layer and DAL
SongsBLL public int ScalarQuery(Guid ArtistId) { int returnValue = ScalarQuery(ArtistId); return returnValue; } Code Behind ASPX page This in in DetailsView_ Item Inserting Event SongsBLL number = new SongsBLL(); currentCount = Convert.ToInt32(number.ScalarQuery(currentCount).ToString());..........
Let's say I have a table (Table1) with three columns (Col1, Col2, Col3) and two rows. Let's say I have a button on a page. I want to send the contents of those two rows in an email in the Click event handler of the button. Here's the SQL framework I've got: [Code]....
Suppose I have a temporary table (Shown below). The table is defined and populated in my stored procedure. After it is populated, I need to go through every row in the table. Here is what I need to do :
Check if Amount2 > Amount1 If Amount2 > Amount1 then set Amount1 = Amount2
It feels a little akward for me to use the temp table.
As a student can speak one or more language,the Sudent Table is linked to language table like this
StudentId LangaugeId 1 1 1 2 1 3
And a student can chose one or many subjects for exam:
StudentId ExamId 1 1 1 2 ....
In my asp.net page I would like to filter students via checkbox using ajax for example, student having female and male gender with Degree 1,speaking language 1,2... I filter rows in a stored proc using user defined table,and I have to use a lot of IF statements like this
if(EXISTS(SELECT GenderId FROM @GenderTable)) if(EXISTS(SELECT DegreeId FROM @DegreeTable)) if(....) else if(...)
How can I avoid all the IF statements? I have more than 5 filters.It's boring.
The topic of sql server deadlock has been discussed many times, however, I was unsure that even two simultaneous inserts on a table can end up in a deadlock situation. Scenario: While testing our application (SQL Server 2005 as backend, ASP.net 3.5) we inserted records into a table simultaneously (simplified overview) and that resulted into a deadlock for more than 70% of users.
I could not get a hang of this as how an insert is being deadlock as this is not a case of multiple resources. After a detailed analysis (of reproducing the bug by two users) I found that both the processes were holding a RangeS-S lock on the primary key index of the table and were trying to convert this into RangeI-N lock, that resulted into a deadlock and one transaction being killed.
Question: Can we avoid or reduce these kind of deadlocks as this is not a case of change in order of access of resources? Cant' we force the transaction to get exclusive lock initially so that it blocks the other process and avoid deadlock? What (adverse) effects that may have? Also could some one explain more about RangeI-N lock.
I've a table where one person teaches multiple classes. It looks like this.
Table1
Id Name Class Subject ---------------------------------------- 2 Sam 12 English 2 Sam 10 Maths 2 Sam 10 English 2 Sam 8 History 2 Sam 12 Economics
Here Sam teaches Class 12 - English & Economics, Class 10 - Maths & English, Class 8 - History
I want to display the result like this -
Id Name Class Subject --------------------------------------------------------------- 2 Sam 12 English, Economics 2 Sam 10 Maths, English 2 Sam 8 History
t1c1 t1c2 t1c3 1 1 jim 2 2 ruth 3 4 paul 4 8 sam 5 16 NA
Table2 ( Need this)
t2c1 t2c2 t2c3 t2c4 t2c5 10 1 1 jim 2010-02-03 10 2 1 ruth 2010-02-03 10 4 1 paul 2010-02-03 10 8 1 sam 2010-02-03
The tricky part I have to perform is to copy rows( only t1c2 -> t2c2, t1c3->t2c4 columns) untill I see NA(Not applicable string) in t1c3 to Table2 putting (10 in t2c1, 1 in t2c3, current date in t2c5 columns for all rows).
Now I want to create a list like below in the aspx page, created from the database. I have done the work of keeping all the tags and tagURL from the database in a dataset. But I have no idea how to create dynamic HTML list or asp.net list from database.
I have an excel sheet that contains around 30,000 rows and 18 colmns. These no of rows and columns may increase in future. I need to read all these records from excel sheet and insert into a table in sql database. For reading the excel book I am using Oledbconnections. The possible solutions I have known as per my knowledge, to insert the data are
1. To insert one record at a time which makes 30,000 database hits. How will this affect the performance? 2. To use liked servers - bu this is not working for me.I do not have database permissions to use linked servers. So, the only option i have is the first one.
I'm having a gridview in my aspx page with checkbox, User can select one or more than one record(s) at a time and clicks on delete button, Then i'm constructing an object of my DTO and adding all the checked row's Primary Key (DataKeyNames - GUID's in case) to a serializable class and generating an XML and sending it as parameter to the Stored Procedure.
My Doubt is, can i bulk delete all the rows from database table those are present in my XML document??
If it works, I can do bulk update with XML only, i already did bulk insertion by generating an XML..
My Another Question is, Will it affect the performance? Each time when i construct an DTO object and adding it to the Generic List??
WHich one is better, I mean ObjectDataSource or SQLDataSource or my XML method?
I am trying to create a table dynamically in my code behind. My problem is I have a count of how many controls I want added to each TableRow after which I want to add that TableRow to the table and then start a new row. Here is the code I have no far but it just adds one row and does not move any of the controls to a seperate new row.
public void FillTable(string DB, int? appID, string function, int? rID, string UserId, int ControlsperRow) { OneEvaDataContext datacontext = new OneEvaDataContext(); var results = datacontext.sp_Build_Menu_Field_Names(DB, appID, function, rID); int controlCount = 0;
[Code]....
I would have thought that doing the .Add only when I am finished building that row would work but I guess since I'm using the same TableRow "tr" It is only putting in just one row.
EDIT: in the is context base is my class which looks like this:
public class Dynamic_Search_Table : System.Web.UI.WebControls.Table {
I created a aesthetic control that creates two lists in seperate div tags organized with a table for each. The control always the user to click on the img tag associated with each item to move it between the two lists. I am doing all the movement between the lists via javascript and want to have a good method for obtaining the values and storing them in two lists upon Postback. I thought of doing something like storing the indexes/classes in hidden values and them reading them to find the items but that seems messy. Also, thought there might be a clever way of traversing the DOM via FindControl() but not sure. Any input would be great.
One other thing is that this is not a composite control. All the tags are being rendered in the RenderContents() method. So I don't know if there is a way to even tack on a runat="server" attribute to an elem like I normally would if I wanted code behind access to an html element.
Here is the HTML that is generated. I don't think there is need to post the server side code since it does nothing more than generate the html at this point.
How can i add a click event to my entire table (not row or cell) that will trigger a server side method and not a JS method.I know i can add attribute which calls JS and then add post back as follows:
