I want to be able to display the entries in this table based on the date and time of recorded in the entry.
So as an example:
Entry A only appears on Mondays at time X.
Entry B appears on Tuesdays at time X and Sundays at time X.
Entry C appears every day of the week at time X.
Entry D appears every day of the week but twice on each day at time X and y respectively.
I have a web form that displays the results from a table. How can I compare the table between dates and display the differences of the table?
e.g. today 790 items, and two days ago there were 745 items and this is what is the difference;
xxx
yyy
ggg
hhh
aaa
etc.
I am creating an online employment application, and instead of creating a table with 20 columns for job duties that may or may not receive values, I simply want to create 3 columns
ApplicantID
EmployerName (Name of Work history Employer)
JobDuty
I want to create a form on a page with 10 textboxes so the applicant can type in some job duties they had at that job.
Is there a way in C# or SQL to then cycle through and insert the textbox values as separate rows?
An option to add a range of computers based on tag numbers, for instance, user input 800101 and 800110 would add computers SYS800101, SYS800102, SYS800103, SYS 800104, SYS800105, SYS800106, SYS800107, SYS800108, SYS800109, and SYS800110. Currently the app adds a single computer at a time.
Here I am using ASP.NET using C# and my backend in active directory.
Is it possible in to set up an SQL table column to have multiple values? Or would I have to put my values into a new table and link it to the original one?
View 6 RepliesI want to select data from a table where the user can search by 3 options; date, keyword, and type. The date will always be either today or a user chosen date. The keyword can be null or something the user inputs. The type will be chosen from a drop down and can be all or a specific category. I know how to search the date, but the other two create complications. I have created a stored procedure trying to figure this out:
[Code]....
Is there a way to say if the keyword is null then don't use it as a search criteria. If that is possible then type can use that same logic I suppose.
In general, If multiple users thru an application try to update the same tables in database simultaneously, then by default on what basis the priority will be given.Like if we don't have any extra logic for the locking implemented.
View 3 RepliesI'm trying to figure out how to update multiple rows in my Directory table, when a user changes their Street Number or Street Name in their profile. They can add multiple users to a directory and each user they add to the directory has this primary users UserId in it. So if the primary user changes their address, I want it to update the address for all the users they listed in the directory as well. I'm adding this to the On_Click in the Code Behind, so when they click to update their profile, it fires this function as well. This code may be way off, but here's what I have right now:
[Code]....
i am new to this linq concept,
i have used the following code to delete multiple records in my table,
but when i hit the button insteading deleting multiple records only one record is getting deleted
below is the code
protected void Button1_Click(object sender, EventArgs e)
I have read up on uploading multiple images and storing them to a file but so far i am only able to store one image into both file and into database. The problem i have is that i don't know how to create the table to store more than one image?
View 8 RepliesI've have to delete multiple rows from database in a table . Which is the best way to delete data to optimize performance of sql server as well as asp.net.
View 6 RepliesI have Tables customer (Customerid),Product(Productid),Order(orderid). i have created view Customerid,Productid,orderid . is it posssible that if i insert value in view it will get inserted in table itself. can i do it in MS SQL SERVER
View 1 RepliesI have been google some but I canīt find any solution that have been worked for me. I do use System.Net.mail on my site to send emails to individual employes. Now I would like to be able to email all emplyees. The emplyees email address is stored in a MS SQL table. Is it possible to make a BCC email to all employees in that table?
View 2 RepliesI've requirement where user can enter multiple columns like first name, lastname, email, age, sex fields and insert them into database.on my frontend aspx page, i'll be showing a single row initially with 5 text boxes(first name, lastname, email, age, sex) and a button to add more columns. when user clicks on add more, another 5 textboxes will be shown and then i'll be taking 5 + 5 (textbox values) and comma seperate them and need to insert into a table with primary auto increment key ID and the remaining 5 columns(firstname, lastname, email, age, sex). I previously worked on the same requirmeent but with only single column. Now i need to insert for 5 columns, How can i do this? Below is my stored proc which i used for single column insertion.
[Code]....
I have 2 tables:
- Salesmen with Pk.SalesmenID
- Appointments with Fk.SalesmenID and busy(bit)
How can I check if every salesmen has at least one appointment
Am I on the right way with statement below, though I got syntax problems
[Code]....
I have two tables for storing language translations - tblEN and tblES. They have the same structure which is nvcEnglish and nvcLocal - both nVarChar fields.
In nvcLocal of the Spanish table, I enter the Spanish translations of words and phrases used within my app. Problem is, when I add a bunch of new records to the English table I also have to go in and repeat the data entry into the Spanish table. I am wondering if there is a way to import the newly added records into the Spanish table using Transact SQL?The plain language query would be something like:
If the data in tblEN.nvcEnglish does not exist in tblES.nvcEnglish then insert a new row into tblES with the values from tblEN
i'm working on a SqlDataSource object, it has a deletecommand which is ( DeleteCommand="delete albums where albumid=@albumid") but whenever i try to delete a record, where albumid is an identity primary key column, i receive the following error message , An entry with the same key already exists. but there are no duplicate records, i wonder why i receive this msg, may i pls mention again AlbumId is a Primary Key Column with Identity(1,1)
View 1 Replieshow can i insert 'null' value in numeric column if no record is there.when i pass record to BLL like
MyCollegeAddmissionMst.GraduationYear = IIf(txtGrdyear.Text = String.Empty,
"", txtGrdyear.Text.Trim())
datatype is numeric(4,0) then error is Conversion from string "" to type 'Integer' is not valid. no record is in this textbox and i need to entry null value.so how can i do the same.
how can i show only the last INSERTED data entry made in SQLSERVER? And show that entry in a gridview but not all of the entries at once only the last one made.
View 1 RepliesI have to create a simple application which scans, displays and stores the info from a barcode. I have been able to sort the scanning and display part of this application but I need to know how to store the infromation entered into a textbox to a database and then be able to display the stored data as a list at a later stage.E.G. Once the "STORE" button is clicked, the information/text within the textbox is stored to a database. Once the "VIEW STORED DATA" button is clicked, the stored information in the database is displayed as a list.I am a complete beginner when it comes to creating web applications using asp.net. Also, the type of database to use (i.e. sql, wamp.etc) and how to link it to my application is also puzzling.
View 1 RepliesI am wanting to write this in linq SELECT *FROM Store_InformationWHERE Date BETWEEN '12/03/2007' AND '01/04/2008'Can anyone give me an example?
View 1 RepliesI have a calendar that can have multiple dates non sequentially selected. I have a gridview on the page with a sqldatasource control bound to it.
Again, I have already built the events calendar with the ability to select multiple dates... now I just want to show those detailed records below the calendar for only the dates selected.
How do I filter the records to only get the records of the SelectedDates of the Calendar control.
This has to be done dynamically in the code behind.
I have this query:
[Code]....
I want to select dates that also fallin the range. Heres the scenario: I have an event from 01/20/2010 TO 01/25/2010. So right now it would only return a date of 01/20/2010. How could I return 01/20/2010, 01/21/2010 , 01/22/2010, 01/23/2010, 01/24/2010, 01/25/2010? Mind you only a start and end date are in the database.
I'm trying to work out how many 1st of Septembers have occurred between two dates.
i.e.
2009-05-1 and 2010-08-02 = 1
2009-05-1 and 2010-09-02 = 2
I know that we can do a dateDiff to determine the number of days between two dates, I'm just having trouble getting some logic together.
how to right an SQL Query which will retreive Records of Tasks whose Deadline lies between two given dates.. The deadline is of type datetime.
View 5 Replies