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:

SQL Server :: Run Multiple MS Update Queries

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

Asp - Update Multiple Records In SQL Server

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

SQL Server/T-SQL - Update Multiple Tables At A Time ?

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

SQL Server :: Update Multiple Rows - Loop Through Each Object

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

SQL Server :: Update Multiple Records - Subquery Returns More Than 1 Row

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

Forms Data Controls :: How To Update A DataTable And Update Multiple Rows Due Sorting

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

Forms Data Controls :: How To Update Multiple Row In One Update Button Click

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

Forms Data Controls :: Trying To Update A Single Table Using Multiple Tab Panels - Incomplete Update?

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

Forms Data Controls :: Update Multiple Rows Of Gridview On Click Of Update Button?

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

AJAX :: Update Panel & Update Progress In User Control / Multiple Instances On Same Page

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

Web Forms :: Multiple User Control With Update Panel Causing Multiple Page Load?

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

Configuration - Multiple SMTP Servers Or Update The SMTP Object Server Information At Runtime?

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

AJAX :: Multiple Update Panel In Webpage - Update Only One At A Time

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

SQL Server :: Update Statement, Trying To Update A 'bit' Type Column?

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

SQL Server :: Update Parameter Doesn't Update If Null?

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

Update Particular Record Using Update Query In SQL Server With Vb.net?

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

Multiple Row Update In GridView

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

Databases :: Update Multiple Row With Different Value?

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

How To Update And Bind Multiple Tables

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

MVC :: Update Multiple Users At A Time?

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

AJAX :: How To Update Multiple Updatepanels Simultaneously

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

Way To Have Multiple ContentPlaceHolder Controls Update Independently Of Each Other

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

Databases :: Update Multiple Column Using Sub Query?

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

AJAX :: Multiple Update Panels On Same Page?

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







Copyrights 2005-15 www.BigResource.com, All rights reserved