I have to update multiple row and two column of each row.
I have try to Update with case statement but after I perform that statement it blank out every other column that doesn't fall into the criteria of the update statement.
My table structure is like this;
table1
col1
row1 11
row2 22
I want to update row1 and row2 of their col1 in one single sql , how do i do that?
I want to update multiple column of a table using subquery ...My sample code is shown below
[Code]....
its throwing syntax error...I dont know where i commiting mistake.
I need to insert/update data to 3 or more tables on a single button click.What is best method for achieving this?I am using mysql as my DB.
View 2 Repliesi want to develop a data access layer ,it can support multiple database like oracle ,Mssqlserver and Mysql using enterprise library and C#.net 3.5 based on database connection
View 1 RepliesI am trying to design my logic to do this but I want to create a dataSet which will have records from several databases, The records all have the same layout.
I am reagin the connection string paths from a table in a database.
I am asking for your help in trying figure out my logic.
Should I use the connectionString builder in conjunction with a loop to Connect, read a record into a dataset Until therer are no more records to be read from my databse table with the database name/paths tables ?
Here is my beginning code which deals with one database:
[Code]....
i want to build a datagrid bound to a datatable with several columns. One column has only a dropdownlist with the number of the rows in the datatable.
Here a samplescreenshot:
[URL]
I know how to bind the columns to a grid and its no problem to create such a dropdown list with the content for me, too. But i dont know how to sort the complete datatabl after changing one value of one dropdown listbox.
So, how can i resort the values of a datatable column based on a given value and the datarow id?
im having a gridview in which im displaying records and status.....this gridview shows employee applied leave waiting for approvals..
so in gridview i have chabged the status button as radio button list and giving two choices as approve/reject ....so HOD seect relevant button and update the grid...
how to do this?
1) do i need to place a button on footer and do some write code behind?
2) or any other easier way?
I've got a single table, with project information and schedule information. To make the data easier to present, I created a tab control with two panels (a detailsview in each). The first tab is for project info, the second tab is for schedule info (again, all fields in the same table). The problem is, if i change info in both tabs, and then hit the update button, only the data from one tab is added to the table. I think this problem is simple to fix, and boils down to the way I have the page organized, but I can't quite figure it out.
I've boiled my code down to the following conceptualized structure:
[code]....
When you click the update button, you return to the listview, but with only the information from your current tab saved. How can I get it to update from both detailsviews?
I want to update multiple rows of gridview (only price field. for that i have added textbox) on click of update button which is outside of gridview.I have done following way
<asp:LinkButton ID="lnkUpdate" CssClass="BlueButton" runat="server" OnClick="lnkUpdate_Click">Update</asp:LinkButton>
[Code]....
Up to this its working fine but when no textbox updated then no need to go in for loop so i am looking for confiramtion before updating rows please help me how to do that becausei am less aware with javascript. another problem is textbox value disappear when page index changed how i can retain that values.
I have a user control, that has an update panel and update progress control in it.
I use this user control in more than 1 location on the same page.... problem is, when ucA posts back, I see the update progress control for both ucA and ucB. I assume this is because it is a user control and the update panel and progress are named the same?
Either way - how do I make it so that the update progress only displays for the proper user control?
I have an update panel in a user control and I am adding multiple instances of it for example 5.
When that update panel refreshes the page load occurs 5 times.
How can I prevent it only for once?
I have a requirement like need multiple update panel in web page and also i want to load only one (targeted one)Â update panel content when I click button on another update panel.
View 1 RepliesIn my web application, I have 2 totally different databases - one that's being used mostly by a CMS from which we'd like to get page information on non CMS pages on the same website, & one that contains totally different data. Is it possible to use Spring.NET's Open Session In View module with multiple session factories for both of those databases, so in this case I have 2 objects defined in spring.config of type Spring.Data.NHibernate.LocalSessionFactoryObject?
View 1 RepliesI have an application which connect to oracle db.
I have two database hitting functions.
One is adding Userdetails(Fn Name : AddUserDtls) and another one adding address details(Fn name : AddAddresDtls) based on UserName which will get added after execution of first method ie AddUserDtls.
Problem I am facing is :
I have a single transaction and in that I have all the methods.
After the execution of first method,with out commiting i will go to second method.
and if any error occurs in second method.
I will rollback everything including the changes made by first method also.
Here one issue is there.
Since I am not committing the changes made by first method,
While I am executing the second method I am getting error that 'No user Name exists'
I understood that if we commit the transaction before the second method starts ,it will solve the issue.
But then it creates another problem.If some problem araise in the second method,then I cannot rollback the changes made by first method since it aleready commited.
In following code I am binding two parameter by name. Program compile successfully but output isn't coming.
cmd = new OracleCommand("select * from books where book_id=:bid and title=:rat", conn);
OracleParameter op = new OracleParameter();
Not sure how to best accomplish this task. I do have several reports to make in Excel every day. The reports do have a shhet for every week and one column for each day in week. What is the best way to get the excel auto update and get data from the SQL table? As for now I run a query on a webpage and coying the data in to the excel sheet manually. Should I try making a database connection within the excel sheet? Should I try having a ADO connection working in .NET? I really donīt know where to begin.
View 2 Repliesi am having a transaction related problem regarding mysql.. need some advice how to proceed !!!
here is a gridview for my application and i am inserting or updating for each row.... like
[Code]....
well now what i want is if any of the row update or insert failes ... it should revert all the changes that was already made into the database ... even a single row update .. into that perticular table ... the code which i have called for payment.Update(PayDetails, 0) is :
[Code]....
can someone help me out how to proceed in this scenario ??? how do i undo each of the updates made into the table payment schedule details ...
visual studio: 2010
Database: oracle 11g r2
i'm using visual studio data set designer to create a typed dataset and I want the dataset to use Oracle stored procedures to query, update, and delete to the database. Query a view, update to a table, and delete a row from a table. This typed dataset will be the datasource for a gridview. In the grid view I want to display some information from the database and be able to update and delete. I was able to display what I wanted to the gridview using the typed dataset which used a Oracle stored procedure.
However, now I want to run a Oracle stored procedure to do an update but I'm not sure how to pass the required parameters to my stored procedure. error i got trying to configure the datasets tableadapter to use my oracle stored procedure as the update, not sure if this is the problem i'm having screen shot of the objectdatasource that brings together dataset and gridview
stored procedure for updating
PROCEDURE "update_config_magic"
(times_to_repeat_in IN NUMBER,
account_num_in IN NUMBER,
spell_num_in IN NUMBER
)
IS
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
UPDATE user_train_config_magic
SET timestorepeat = times_to_repeat_in
WHERE user_train_config_magic.account_num = account_num_in AND
user_train_config_magic.SPELL_NUM = spell_num_in;
COMMIT;
END "update_config_magic";
Although the below connection string works for Select, Insert and Delete functions I can't get to work with Update.
Returns error 'unable to connect to MySQL hosts'
Sub Edit (sender As Object, e As EventArgs)
Dim myConnection As MySqlConnection[code]...
I have fried a multitude of combinations, also from MySQL site without success.
if we are trying to add the several columns in select statement and only one condition in group by.
how can we do that ?
Example:
[code].....
Is it better for a collection of ASP.NET web apps to share the same session database, or should each one have its own? If there is no significant difference, having a single database would be preferable due to easier maintenance. Background My team has an assortment of ASP.NET web apps, all written in either Monorail 1.1 or ASP.NET MVC 1.0. Each app currently uses a dedicated session state database. I'm working on adding a new site to that list, and am debating whether I should create another new session database, or just share an existing one with another app.
View 1 RepliesI am supposed to develop an enterprise-class ASP.NET Web Application that connects to multiple databases. For example when the web form loads, I should populate different ASP.NET controls (GridView, DataPager, TextBox, DropdownList etc) from multiple databases (SQL Server, Oracle, DB2, SAP Server etc) and also, edit the data in the controls and save the data to the respective databases on button submit.
Should I use Web Service or WCF for data integration, if so is there a limit on the size of the data?
What should be the architecture considering the application should be scalable and easy to maintain?
i want to know how to connect to multiple databases in sql from our asp.net code??
View 4 RepliesI am using mysql as my database.From one of my web pages I want to insert data to 4 tables.All the data should be inserted to these different tables on a single button click from the web page.How can I achieve this?Which is most reliable way to insert data to multiple tables on a single click event?
Will the sql operation with 4 'insert' statements separated by semicolon work for me?
I have a doubt. For examples, Multiple users trying to update the same record usign asp.net application.
Can any one explain me indatil the situation how db process the request.?
