SQL Server :: Update Multiple Row With Different Value?
Feb 8, 2011
The goal is to update multiple row in the table. In my table there is 3 col, at here i will name it col1, col2 and col 3. The number of row in the table is, let say 10. Each row will have a different value in col1 and col2, where col3 value is static.
Something like the below;
|col1 |col2 |col3
Row1 |a |b |c
Row2 |aa |bb |c
Row3 |aaa |bb |c
My update statement;
UPDATE table1 SET Col2 = CASE Col1
WHEN 'a' THEN '1'
WHEN'aa' THEN '2'
End where col3 IN (c)
In plain, i just wanna update col2, but had to base on col1 and col3 value. After I run the statement above, it will empty Row3's col2, but in fact, i don't want to update Row3's col2.
View 2 Replies
Similar Messages:
Sep 11, 2010
On satisfying the If condition, I need to run 2 MS SQL update queries. How can I accomplish this? I am using C# as the server side language.
View 6 Replies
May 19, 2010
Here is my situation: I use the SqlCommond to update some records in the SQL Server in a ASP.NET web site. Users can choose which records they want to update. Sometimes they may choose 40 or 60 records to update at a time.Is there any good way to do it? I do not want to do like it
foreach(string ID in List)
{
Update here
}
View 3 Replies
May 21, 2010
I have two tables, Customer and CustomerPhone.
Single record in Customer can have multiple CustomerPhone records. As you see in the image below, Phone and Fax resides in CustomerPhone table whereas the rest of the fields resides in Customer table. If user want to edits a customer record, obviously i will have to update the record in Customer table and at least two records from CustomerPhone (Phone and Fax).
I could write two update statements, one Update customerPhone and the second update Customer table. Is there a better solution?
View 2 Replies
Feb 8, 2011
I have several rows in my database like this
ID Status Type Count Event
291 0 0 2 1
523 1 2 0 4
and so on. When my user performs some basic actions on my website, some values are passed through JSON to the server and are then converted into custom objects with 5 int properties(so they match the table). These objects that the server receives are the rows to be updated(based on ID) and the values for each column. How can I do this in one SQL statement without the need to loop through each object and update them all seperately? Is there a way? Preferably compatible with SQLServer 2005.
View 8 Replies
Jan 5, 2011
I have a table line (ID, LineNo, LineName) having values as :
1, 1, <blank>
2, 2, <blank>
3, 3, <blank>
ID is PK with Auto-Increment and LinNo(I am manually incrementing through ASP.Net Page while record insertion) Now i have to write a query such that it updates LineName column from line table which is blank(as shown above) with values from table linet(linenamet) having values as :
a
b
c
My trial query is :
update line set LineName = (select linenamet from linet);
It gives ERROR as : Subquery returns more than 1 row
Expected Result : After Updation it should show line table as :
1, 1, a
2, 2, b
3, 3, c
View 8 Replies
Jan 17, 2010
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?
View 8 Replies
Sep 14, 2010
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?
View 3 Replies
Sep 20, 2010
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?
View 3 Replies
Jul 10, 2010
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.
View 2 Replies
Feb 16, 2010
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?
View 3 Replies
May 2, 2010
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?
View 3 Replies
Nov 5, 2010
The question: Is it possible to configure multiple SMTP servers or update the SMTP object server information at runtime?
Description of problem: The site I'm working on has a few pages which send emails. Our site is using Gmail so even though it's a custom domain our email is sent out though Gmail SMTP servers.
Some emails come from the system and some emails come from users in certain groups. I have an SMTP server configured with the admin email for the system e.g. admin@mysite.com This works fine and when I get the email it shows from admin@mysite.comOne of our user groups let's call it "groupA" has an email configured on our domain i.e. groupA@mysite.com When I send the email and specify a from address for the MailMessage object as groupA@mysite.com it still shows up in my outlook as coming from admin@mysite.com I did a little further testing and if I specify both the from address and the ReplyTo as groupA@mysite.com it will show as From=admin@mysite.com but when I choose reply in outlook it shows groupA@mysite.com My best guess is that Gmail is overwriting the From address with the SMTP user to prevent email spoofing.
I found this: http://www.systemnetmail.com/faq/4.1.aspx but it won't work for me since group A, B, and C all need to send emails from the same page.
View 1 Replies
Apr 4, 2012
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 Replies
Oct 14, 2010
I have a function that checks for a username and if it finds the username it will allow the user to update the user, there are 3 main columns: Name,Age,isFemale. I have the enduser supply the information and then I try to update the record but I get a sql error for "not a valid" column.console app:
[Code]....
I pass the spIsFemale by using an enum, here is the Person Class with function.
[Code]....
I get an error that column isFemale is not valid. The isFemale column is a bit type. If it's a 1, it's a female, if 0 male. this is more of a test area and I'm trying to update records or create new one's if the name does not exist.II am new to C # and I am just trying to learn new ideas and methods within C sharp.
View 2 Replies
Sep 27, 2010
I have a vb.net page that has an optional parameter. If a user enters data for that field, and clicks save, it saves fine via the stored procedure. HOWEVER, if the user changes their mind, and wants to erase the data they entered, they go to the text field, and delete the characters, and click save, but no matter what, the stored procedure will not save the fact that they erased the data (it won't set it back to NULL). If the user enters a space, the stored procedure will save the space, and if they enter different data, it will save the other data. I can't figure out how to get it back to letting them set it to Null? I think this is because it's an optional parameter, and the stored proc is used by several forms (Some of those forms do not include this parameter), but this form utilizes that optional paramater.
Here's my stored procedure...
[Code]....
[Code]....
View 2 Replies
Dec 2, 2010
I have the query to retrieve selected record in textbox. How to use this query to update record: I want when I enter sumit in textbox1 and click submit button then the record with ID 1 will be updated to name sumit
Dim SQLData As New System.Data.SqlClient.SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance=True")
Dim cmdSelect As New System.Data.SqlClient.SqlCommand("SELECT TOP 1 Name FROM Table1 Order by Id DESC", SQLData)
SQLData.Open()
Dim dtrReader As System.Data.SqlClient.SqlDataReader = cmdSelect.ExecuteReader()
If dtrReader.HasRows Then
While dtrReader.Read()
TextBox1.Text = dtrReader("Name")
End While
Else
Response.Write("No customer found for the supplied ID.")
End If
dtrReader.Close()
SQLData.Close()
View 1 Replies
Feb 2, 2010
I have a GridView which I've sent to have all rows editable from the start. I've written SQL code behind to update the rows, however, when I run the page, it only updates the changes to the first row.
The changes are bound to the GridView, as when I click my Save Changes button, the new values are kept. But looking in the MySQL backend, only the first row has update.
[Code]....
View 4 Replies
Feb 7, 2011
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?
View 4 Replies
Mar 28, 2010
I have 10 tables in MSSQL I want to select some info from this tables and show on a webpage (formview maybe(based on user selection)). Also, Id like user to be able to EDIT this info, and it should go back to database.
The problem is that: the realtionships are pretty comprehensive. In sql management studio I saw awesome view creation, where u can drag and drop tables and select just the field u need, and it automatically do all joins for you.
View would work perfect for me, but i need to update database back. Maybe I can use linq classes?
I mean, its easy, but it takes a lot of time to do it by hand programatically. Is there some dragandgrop-like feature in visual studio?
what is the easiest way to bind multiple tables in one place with crud operations available?
sql datasource supports only 1 table at a time.
I Found on the web that we can use stored procedure? Do I need two stored procedures? for select and update? how we are going to bind update procedure with textobxes where user is going to edit info? Do you have some samples?
View 1 Replies
May 21, 2010
I have to update the users based on input value..
here is my code..
<fieldset>
<legend>StudnetInfo</legend>
here i have two textboxes and two dropdown list boxes.. this is the fiedlset user is going to enter their information..
</fieldset>
on the same page i have couple of other Fieldset with there studentInfo with twotextboxes and two dropdownlistboxes smililarly above Fieldset..this data dynamically generated from database for each users.
so all here my intension is insted of updating each and every Fieldset i made one generic fieldset to update all other Fieldsets information
on the Generic view I have this BeginForm
<% using (Html.BeginForm("Update", "home", FormMethod.Post,
new { @id="studentid"}))
{ %>
my JsonResult is
public JsonResult Update(StudentBE e)
{
try
{
var UStatus = Generic.UpdateStudent(e.student,"","");
return Json(UStatus.ToString());
}
catch (Exception ex)
{
return Json(ex.ToString());
}
finally
{
}
}
using this I can update only one user perfectly but I need to loo update all users based on generic Filedset values?
View 1 Replies
Feb 3, 2010
I have a page in which there are multiple updatepanels and each of these update panels are trigerred by different triggers.
These update panels are used to do Async post back and the page is updated with the data retrieved from the async post back.
Now the issue i am facing is that since there are multiple update panels, the update done by one panel is lost when the other panels does the post back.
let me know if any one knows on how to solve this issue.
View 5 Replies
Oct 20, 2010
This is a very simple ASP.NET master page example. The master page displays 4 hyperlinks and has two ContentPlaceholder controls. The first two links are to content pages that will display in ContentPlaceHolder1, the second two links are to content pages that will display in ContentPlaceHolder2.
<%@ Master Language="C#" AutoEventWireup="true" CodeBehind="Site1.master.cs" Inherits="ProofOfConcept.Site1" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<h1>
Demo site
</h1>
[code]...
View 2 Replies
Apr 1, 2011
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.
View 1 Replies
Jan 5, 2010
i have 3 update panels on the same page with labels that are showing different countdown and i want then to run separate from each other. I've tried to use timer control that triggers each of them separatley with limitations in ontick event., the coutdowns are strating but after a few seconds are stoping and i don't know why.i'm not using scripts. I want to run like those on mafia wars on Facebook when something is done to start one contdown and something else other timer.
View 3 Replies