I would like to duplicate a table record but not all the columns.For example, Select from "TableA" Where recordid='1' AND insert into "TableA" All values except "col2" , "col3". I hope you got the idea. Could you please advise me what is the cleanest approach to get this done.
View 9 RepliesI am counting from a table for that i have written code as below
protected void get_Id_Afterpoint()
{
int counter = 0;
string strSql = "select count(*) as ID from tblEnergy where ID=?";
OdbcCommand com = new OdbcCommand(strSql, con);
com.Parameters.AddWithValue("ID", DropDownList1.SelectedValue);
OdbcDataAdapter oda = new OdbcDataAdapter(com);
DataTable dt = new DataTable();
oda.Fill(dt);
if (dt.Rows.Count == 0)
{
lblID2.Text = "1";
}
else
{
counter = dt.Rows.Count;
counter = counter + 1;
lblID2.Text = Convert.ToString(counter);
}
}
there is no record related to DropDownList1.SelectedValue. but as i am counting if(dt.rows.count) and i put break point on the bolded part it shows 1 record. how it can be possible?
how can i select a record from A table and insert into B table using linq?
View 2 RepliesI have website database with a data table constently being "insert, select, count". This table has over a million record and is growing really fast.
Now I'm start worring about whether or not my sql server could handle the pressure. or maybe to have a million record is not a good practice at all.
The specs of my server is almost the best in the market. So I won't worry about the hardware.
Just wondering if ended up 3 million record in that table, will my queries and sql server itself still running smoothly?
Is there a function that will search a record in a Sql Table, I'm using VB.Net.
View 3 RepliesI'm not sure if I'm using the correct SQL for what I need. Well, I know that I am not because I'm not getting the results that I expect.
I have a table of products and it has a productID field and a setID field.
Products can be grouped together by making the groupID the same for the both of them.
I have only @productID parameter. My goal is to get a list of products minus this product and any other product that it is grouped with (ie..setID is the same).
Here is the query that I wrote because it has worked when excluding products from another table. I used the explicit GUID and still nothing.
[Code]....
I have to retreive all records from a table except 1 record. For example: I give example from default database in SQL ie "master" In "master" DB we have "spt_values" table. Now if I want to retreive all records from spt_values table except 1-1 record of type = A and type = B. To retreive all records its a simple query "Select * from spt_values where type in ('A','B')" -- this will returns 16 records. Now I want to retreive all record except 1-1 record left in each type, so it will return 14 records in result.
View 6 RepliesI want to retrieve the data from the last record of a table. For eg: I have sorted the data in my table and want the value from the last record? How can I do that?
Is there a way to check that "saving" data to a table was successful and then do something after that?
I want to get record count from below example.
I made two tables. One is club_info and another one is club_members.
And each table has data like following
[club_info]
club_id
club_name
:
[club_members]
mem_id
club_id
:
I want to get club_name and the member count for selected club_id and want to return the result as sqldatareader.
There is a similar instance of this @ http://forums.asp.net/p/1380776/2919093.aspx#2919093 However I haven't had a response, maybe due to the age of the topic, but the problem is different in the sense I am not using AJAX Rating Control, I am using radio buttons contained in a Div named Ratings, which is picked up by jQuery to style to radio buttons accordingly.The output is that it will put the stars on the first record but anything after just shows origionalunstyled radio buttons.Just thinking off the top of my head, but does anything need to be put in the ItemDataBound event?The jQuery for the stars etc were attained from the link below:http://orkans-tmp.22web.net/star_rating/index.html#demos=&main-menu=0&demo-tabs=3Here is my code:.ASPX:
[Code]....
[Code]....
I have been able to successfully read a row of data from an SQL table using two column parameters. Now I would like to update this row with new information. Is this possible since the reader does not specify which row was read with the 'reader.Read();' command?
View 7 Repliesi Am using Special character while insert in the database. When i user single Quotes('), it shows an error that "Unclosed quotation mark after the character string" How can i over come this issue. But i want to insert the special characters"
View 5 RepliesI've got a sp as below:
The functionality I want to achieve is that when isHomePageFeatured is checked then this record is set to 1 for that column and for all the other records in the table it is set to 0.
This is fine for update as I can use the property Id to compare against, but for the newly inserted record it doesn't yet have a propertyId so I wondered if using newID() to affect all other records would have the same affect.
[Code].....
when i want insert a record i see an error like this Can't perform Create, Update, or Delete operations on 'Table(MainMenuLink)' because it has no primary key. with this codes:
MyLinqDataClassesDataContext db = new MyLinqDataClassesDataContext();
MainMenuLink li = new MainMenuLink { Link = "www.tprogrammer.com", LinkSubject = "subject" };
db.MainMenuLinks.InsertOnSubmit(li); [code]....
here is my query which is not working properly. I have 5 fields in my table Company, Reseller, Item, Code, Price. How can i get minimum Price when i pass parameters for Code is dublication value
Company Reseller Item Code Price
A A-1 I1 C1 20
B A-21 I2 C2 13
C A-B I1 C1 19
select Company,Reseller,Item,Code,Min(Price) from Table1 where code='C1' order by Code HOW CAN I GET THIS BELOW TYPE OF RESULT
Company Reseller Item Code Price
A A-1 I1 C1 20
C A-B I1 C1 19
I need to copy the records of a row to the next available row in the same table. I tried with "Insert ...Select " but it throws me a error since the pk is auto-increment. Also, i cant specify each and every column inside the insert...select statment cause i've almost 30 columns.
View 5 RepliesI have two UpdatePanels on a page. The first one works perfectly. The other one works as well, but when it is updated. A table nested inside the <ContentTemplate> is duplicated...meaning that where there was 1 there are now 2 exact copies. Otherwise everything appears to be operating fine. Both UpdatePanels have the UpdateMode set to "Conditional".
View 2 RepliesDoes a DB transaction get automatically rolled back during exception or we should explicitily write transaction .Rollback inside the catch block to rollback a transaction...
View 3 RepliesIn sqlserver2005 how to handle exceptions in stored procedures and
1)redirect to other page
2)write in to log file
I am creating an album using the following stored procedure, which returns the primary key for the newly created record:
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[fpa_sp_albums_update_insert]
@album_id int,
@album_name nvarchar (50),
@album_descr nvarchar(250),
@album_img_cover_id_FK int,
@album_creation_date date
AS
If @album_id > 0
UPDATE [fpa_albums]
SET
album_name=@album_name,
album_descr= @album_descr,
album_img_cover_id_FK = @album_img_cover_id_FK,
album_creation_date = @album_creation_date
Where ((album_id = @album_id))
Else
INSERT INTO [fpa_albums] (
album_name,
album_descr,
album_img_cover_id_FK,
album_creation_date)
VALUES (
@album_name,
@album_descr,
@album_img_cover_id_FK,
@album_creation_date)
Return SCOPE_IDENTITY();
I execute the above stored procedure using the SQLHELPER. The VB.NET code for the page is as follows:
[Code]....
However, the createdAlbumID always shows -1 instead of the id for the newly created album.
i am trying to compare four columns in two tables(both are in the same schema), table a has two columns for firstname and last name , table b has similar columns firstname and last name, i wish to compare both and if there are similarities, do nothing but if there are differencies, export or write them to a exception or error table.. not quite sure what if statement i should write or how to go about this.
View 6 RepliesI'm building the standard 3-tier ASP.NET web application but I'm struggling as to where to do certain things - specifically handling exceptions.
I've tried to have a look around on the web for some examples but can't find any which go as far as a whole project showing how everything links together.
In my data-tier I'm connecting to SQL Server and doing some stuff. I know I need to catch exceptions that could be raised as a result but I'm not sure where to do it.
From what I've read I should be doing it in the UI tier but in that case I'm not sure how to ensure that the connection to the database is closed. Is anyone able to clarify how to do this? Also if anyone knows as to where I could find an example 3-tier web application that follows best practices that would be great too.
I have a datasource that uses a business logic object for the select event. How can I catch an exception that occurs in the business logic layer and pass it to my presentation layer to display to the user in a label?
View 1 RepliesWe have a asp.net application and want to implement logging. The first idea was to use the Application_Error method in the global.asax file.
The problem is that ASP.NET very often seem to throw exceptions internally that are not caused by the application and which seem not to interfer with the users normal workflow. For example we often get HTTPExceptions, UnauthorizedAccessExceptions and others caught in this method, although there is no real error in the application.
login 3 users for a apllication at a same time from different id's & appllied a leave from different id the leave is apllying for same id
View 13 Replies