I have been working with this database for some time. Here is the situation...
I inherited a MS SQL database that has hundreds of tables with similar data. For instance:
FordTampa_customer is a table,
ChevyAtlanta_customer is a table, etc....
All of the columns are the same...just different tables with their own ID field. All I have done...Inside of another database id is created a table called 'Customer' and added an 'Dealer ID' column along with the rest of the other columns in the other tables...
So the combination of the 'Dealer ID' and the 'ID' field are unique.....I know...its not the best way to do things...but I cannot change the old data structure because I cannot have access to it. I am give back-ups on a weekly basis, so this is all I have to work with.
All right, on to the real point of my post...
Currently, I have an application that I use to select all of the data from the 'Ford_customers','Chevy_customers',etc... and inserts them into my new main 'Customer' table. I do this by selecting the table names, bind it to an arraylist, loop through the list and execute an insert statement.
I do this in VB.NET, but I would prefer to do it in a Stored procedure of some kind....I just am not sure how to accomplish it. I use this syntax to get my list of tables:
[Code]....
I am not sure how to take those names from the table and do another select based on that list of names.
I have connected listview by using datasourceid that means by using "sqldatasource1" now i want to change value of listview at run time according to search so for that i am using datasource at codebehind. but it give an error
"listview have already bind with datasourceid you can not bind it with datasource"
i seem to have a problem with my gridview, i have a gridview with a list of names, this gridview is assign to a datasource and the datasource already has a select statement to display a list of names to my gridview, and i have a search dialog which i use to filter data to be displayed on my gridview, my problem iS after filtering , when a user select a certain row the gridview refreshes and display the initial data(it binds again the use the default setted select query). On my search i use
to filter the grid according to my search criteria, which is the one i have assigned its select to the string varieble filterQuery.
That works fine, and dispaly only d data i setted my search to retrieve, bt my problem is when a user select a row on d gridview , d gridview is repopulated with d initial data(Use initially datasource select statment). How to make d grid to stick to d select statement that i setted on my search and not letting it to go back to the initial setted select.
populating the dropdownlist with column name. I have a gridview that has 7 columns . I want to have a textbox search and dropdownfield where user can select column name and type a word in search box and click search so that text for that column name is being search and displayed in grid. how I can fetch just column names from DB and search ?
I have 2 views(2 view pages) in first view page I will display some names in this page i will have add button after clicking on add button it will redirect to another page (2nd view page) in this i will display multi selected list or listview then i will select multiple items from multi selected list now this selected items has to bind with first view names and display updated list in 1st page?
My question is this selected items in 2nd view page has to bind with 1st view page and display how to do this using mvc razor for mobile application?
I have a listview that is bound to a table. I want to select a record from the listview and that record display in the detailvew from which I can edit. How do you bind these two controls so the detailview uses the records selected in the listview?
I am using a listview to which I want to bind the MembershipUserCollection which you get from GetAllUsers(). I don't want to use reflection, I want to assign it in the ItemDataBound event of my listview. I've done this before, but with datatables. The code will be something like DataRow dr = (e.item.DataItem as DataRowView).Row. You can then access specific columns with
dr["ColumnNamehere"].ToString().
But how do you do this with MembershipUserCollection?
I have a ListView where I am trying to implement Updating. My update parameters are not sent to update command correctly. The value sent is the original value and ignores what I type into the EditItemTemplate. Running a trace on my SQL Server verifies this. In this example, I am only trying to modify [dedamt]. What is wrong?
i want to populate a gridview within the listview.I amm taking reference from the article Populate ASP.Net ListView from database and Repeat columns horizontally using GroupTemplate.
Last time I had problem in getting value from Dropdown List that located in the listview. I want to use the Jquery to get the value of thos Dropdown list and insert that data into the database,.
This time I have added some more radio buttun that are generated from my SQL server database and I want to use Jquery to get those radio button.
i am facing a minor problem but can't find out its syntaxi have listview, and inside the template i have 2 labels, in design time i bind 1 label to one column thatis 'type' and depending upon this type i want to bind other labels to different columnsif type is question than 2 label will have to show data of question columnif type is job than 2 label will have to show data of job, so on........how to accomplish this,in databinding event handler i can check the value of typebut i want to know the syntax of binding 2 label in run time, with different fields using EVAL
i would like to sort a listview. i don't have a datasourceID. i bind the datasource manually. i think of using jquery(tablesorter) but i don't know how to use it.
I successfully bind ListView DataSourceID to ObjectDataSource but it binds only initially on Page_Load event. When I want to bind another data through a Button_Click event, the new data doesn't bind.
aspx code:
[Code]....
Codebehind:
[Code]....
On Page_Load, I get result:
A1 <hr /> T1 A2 <hr /> T2 A3 <hr /> T3
When I Button1_Click, nothing happens, no error, no any more results and _airLineData is 53 records, not 3 records (A1T1 to A3T3) I want the binding to be with DataSourceID to ObjectDataSource (not through DataSource property and control.DataBind() method)