Banging my head with this one...
I have a SQL query that pulls data for charting based on a per month basis. The month range is dynamic and selected from the front end. My issue is when no data for a month within the month range is present, that month is skipped. Is there a way/method to have the query give a 0 value for the columns when no data for that month exists? Below is my current query
[Code]....
I would like to check and see if a record exists before doing an insert. Here is the code I have tried:
[Code]....
For the below query (sdate is column name and table name is storedata)
View 2 Repliesi need below output do i need to use cursors for this can i do this with case statement.
CREATE TABLE [dbo].[tablesales2](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Name] [nchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[cost] [numeric](18, 0) NULL,
[saledate] [datetime] NULL,
)
[code]....
I have a database for a shop. Now I have run into problem when I'm adding products. I have a page where i add general info of the product that will be adding to the product table. Then I should have a page where I can add colors and sizes and so on. But how do I do that? When I add the product I set a price in the productdetail table and colorId and sizeId is sett to null. If I add a color to the table how do I do this the easiest way? I will not have a product where both colorId and sizeId is null. I have this SP and table structure. Then I'll do the same when I add sizes.
[Code]....
I want to check if the record is already exists before insert using Ajax ActionLink in Create View. I am getting error 'Object reference not set to an instance of an object.' Here is a code in View :
<div class="editor-label">
<%= Html.LabelFor(model => model.PolicyId) %>
</div>
<div class="editor-field">
<%= Html.TextBoxFor(model => model.PolicyId) %>
<%= Html.ValidationMessageFor(model => model.PolicyId) %>
<em>can not be changed later.</em>
//error occurs here
<%= Ajax.ActionLink("Check", "CheckIfExists", "Life", new { PolicyId = Model.PolicyId }, null)%>
</div>
And Controller action :
public JavaScriptResult CheckIfExists(string PolicyId)
{
if (lifeRepository.IsExists(PolicyId))
return JavaScript("alert(' Already Exists');");
else
return JavaScript("alert(' Not Exists');");
}
When processing many records starting from 10,000 System.OutOfMemoryExceptio get the error. There would be some way to handle this type of memory error ?.
ASP.Net SqlBulkCopy- Bulk Insert records and Update existing rows if record exists Exception: Out of Memory Exception C# and VB.Net
I need a way of doing the following:
I receive data in .csv format. I have a some records on a table, so what I need to do is to check if the data I receive exist on the table of records that I need to match against.
If the record exist, then an email/sms should be sent to notify me that the records has been matched and then that record should be flaged that it has been tested so that I don't test it again as the incoming data are saved.
How to insert data from local SQL server to remote SQL server (without using linked server) like below?
insert * into [remote server].[northwind].orders
from [local server].[northwind].orders
I have a gridview. However, though I would like to hardcode in a particular column the months of a year. so that I have the following below. How do I go about doing it
Month
JAN
FEB
MAR
I wish to select my data in sql server where it could be data that were added this month and/or this week.
For example my table - TestTable has the following fields:
AddDate - nchar(10)
RandomData - nvarchar(50)
When the user input the date, the format is in "dd/MM/yyyy". How do I go about doing this?
I have an "effectivedate" field that is displayed using a label inside a detailsview control... In the code behind I need to add 12 months to this to check if a policy is up for renewal or not...
To find the control I use this code... Dim EffectiveDate As Label = DetailsView1.FindControl("EffectiveDatelbl").ToString
But when I try and convert the label to datetime type using this... Dim ExpireDate As DateTime = EffectiveDate.AddMonths(12)
I get the error - Cannot convert string to date, addmonths is not a member of label etc...
I would like to check whether a folder exists or not if not create. I'm sure this folder exists, but for some reason I get "false" when I check with "Exists" method.
The only reason I think could be because of the W: drive? I moved this application to production site and even there it returns false.
while I'm type in Windows explorer on my localhost and on the server "W:/Webs/ASPPages/cropper/uploads" it opens this folder. So my localhost and IIS server has W: mapping.
for test I tried to create the folder then it says can't find the path...
userFolderName = @"W:/Webs/ASPPages/cropper/uploads"
//I also tried @"W:WebsASPPagescropperuploads"
//I also tried @"W:WebsASPPagescropperuploads"
//I also tried "W:\Webs\ASPPages\cropper\uploads"
DirectoryInfo dirInfo = new DirectoryInfo(userFolderName);........
I'm building a pretty simple application where a user can enter/modify/delete data from a table. Right now, the only field is month, which I'm storing as an integer (1-12). The actual table has more fields but I'm simplifying for the purposes of this question.I have the entry part. For modifying, I've set up a gridview with an 'Edit' button:
[Code]....
The code is putting the gridview row into edit mode. Now, I want to show a dropdownlist of months so the user can select the new month. Also, I would like the dropdownlist to default to the value in the database. I can't figure out how to bind months to the dropdown list ddlMonth.
I want to generate 30,000 cards and each card must be duplicate check with database. In my card, there are 2 things. Serial No and CardID. If any card already exists then I generate another card id but with the same serial no.
So how faster way I can generate 30,000 card with duplicate check? Which one I have made application, it takes about 25 minutes to insert.
As I know, we can use INSERT INTO (....) SELECT FROM command to select data from one table and can insert into another table.
Now I need instead of 1 table, I want to select data from one table and Insert into another 2 tables.
Shall I write another INSERT INTO (..) SELECT FROM command or is there any other way?
is possible to insert and delete data in database sql server from global.asax? How to make the connection string? Does anyone have any examples? it is difficult for my level.
View 3 RepliesI'd like to use a simple switch to display one image or another but I need a way to find out if the image exists.
If FILEEXISTS("pathtojpg") Then
'Display jpg
Else
'Display "no_image_yet.jpg"
End If
I am very new to this and have watched a lot of the videos. While trying out VWD2010 and SQL2008 Express, I come across many things, I just don't know how to do. Here is the latest:
I have a Table
UserId - Int - AutoIncrement
FirstName - Var(10)
LastName - Var(10)
I also have an ASP web page that allow the user to enter a first name and last name. It also has a button to submit. What I would like to do is have a Select statement check to see if the name already exists, then send a comment back to the user via a label. If it doesn't exist, then I would like to Insert the info and then again inform the user via label.
SelectCommand="SELECT COUNT (UserId) FROM Users WHERE ((FirstName=@FirstName) and (LastName=@LastName))"
InsertCommand="INSERT INTO User(LastName, FirstName) VALUES (@FirstName, @LastName)"
<InsertParameters>
<asp:ControlParameter ControlID="tbFirstName" Name="FirstName"
PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="tbLastName" Name="LastName"
PropertyName="Text" Type="String" />
</InsertParameters>
<SelectParameters>
<asp:ControlParameter ControlID="tbFirstName" Name="FirstName"
PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="tbLastName" Name="LastName"
PropertyName="Text" Type="String" />
</SelectParameters>
On the code behind, I get lost. (Obviously this doesn't work, but I don't know how to go about getting a results back. Protected Sub bSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles bSubmit.Click
SqlDataSource1.Select(DataSourceSelectArguments.Empty)
(get a return)
(check return value, if <>0 then
lblResults.Text = "exists!"
else
SqlDataSource1.Insert()
lblResults.Text="added!"
end if)
End Sub
I want to be able to check if a value exists before inserting a new record in the table. I am taking a nvchar value from a textbox and want to compare it to existing values in the table. My codebehind is:
[Code]....
It is also important to filter down by CompanyID which is held in a Profile table. So the value can be equal in records where the CompanyID does not equal the loggedin Profile.CompanyID. So a user with a CompanyID of 2 can have a value in the table for SubType as "laptop" but a user with CompanyID of 3 can still enter "laptop" if there is no match for "laptop" and companyId = 3.
i need to insert multiple rows at a time into database table(sqlserver) from datatable or gridview. Actually iam looping through the rows of gridview and inserting each row. Is there any method to insert entire table of rows at a time into database table. Both datatable columns and database table coulmns are similar.
View 2 RepliesIs there any benefit (performance wise) to check if a record exists before updating it or do I just go straight in with an UPDATE WHERE?
View 2 RepliesThis is my Table Structure..
View 2 RepliesI am developing a website in ASP.NET with SQL SERVER as backend.
I want to find the best(FASTEST) way by which I can find if USERNAME exists or not.
My application is taking a bit of time finding that out. Do I need to look into my TABLE structure,indexes.
Is there any replacement for the query
Select username from usermaster where username=@Username
i have a site that will enable users to download an ebook file.i have successfully built architecture to enable users to download pdf and txt files, but it won't work when i try with a .mobi file, even though i know the file exists.the site works by allowig users to upload their work as .doc, .docx or .odt. once it's verified, the site publishes it as .pdf, .txt and .mobi and makes it available for download. the download code is...
string mstitle = title.ToUpper();
string dlpath = [the server path] + msid + mstitle + ".mobi";[code]....
(there are also versions with .txt and .pdf) the file definitely exists at the location in .txt, .pdf and .mobi extensions. however, the .mobi version simply won't work i get an error 404 resource not found. mystifyingly, the pdf and txt versions work perfectly.