I have a simple form, it gets the date and allows a user to input a 6 digit number. The user then clicks a button, the page needs to take the date and apend the 6 digit number and insert it into a SQL database. So:
1/26/2010
Text Input is : 123456
It appends both, so it would get: 1/26/2010-123456 Then with the button click, it inserts that data into a field in a table. Here is the page (with C# CodeBehind)
[Code]....
I have 3 tables in Oracle database. From my asp.net C# page, I am inserting records into all three tables as shown below:
[code].....
My question is, how do I make sure that either all the above are executed or none is executed in C#.
If the first 2nd or 3rd insert fails, everything should fail.
I have some issues about retrieveing and storing date information to my database (ms sql server 2005).My data column is a DateTime, and i have set my web.config globalization culture is set to "en-gb"
When i retrieve date from the datebase it appears as dd/MM/yy, that's fine. But i cannot insert a new date as same format?! It will only accept MM/dd/yy or yy/mm/dd.Right now i'm using this code to correct the error:
[Code]....
Is it possible to change the date format on the database or something, so i dont need to use this code?
I am using Jquery datepicker in a textbox...if user want to type the date in the format of 12202010 needs to convert to 12/20/2010...
I didn't it on the server side...but its always doing a postback once i got the focus on the textbox...
I just want to do it on the client side using jquey...
I have a date like this:-20091023i have to convert it to a suitable format so that i can insert it into the database.For this firstly i have to convert it to 2009/10/23.How can i do this?
View 2 RepliesI need to run a variable amount of insert statements. Is it best to run through a loop and execute the query one at a time? Or, is there a way to send all the inserts in one go?
View 5 RepliesI am creating a leave form for employee where i am using datetimepicker to select date from, to etc..
from that i have automatically calculate the no of days and display in an textbox.. for eg: From date:06/01/2010 To date:08/01/2010, if u select like this, i have to automatically calculate the no of days between that and display in a seperate texbox as 2.
I have an easy problem for the experts here...been a few years since my last development work. I have an appl that will track complaints. When an administrator logs in, they go to the main admin.page. From there, they can create a new complaint record-here is where i'm stuck and am looking for a better way. When the admin loads the create.aspx page. i need a way go generate a unique number that i can insert into the db. What is the best way to generate the number...i don't care whether it's numerical or combo, just unique and durning postback the number does not change...the number will be given out as a reference back to the complaint... This seems pretty standard but I can't think of a way that will not duplicate numbers and am looking for best practice with low
View 3 Repliesi have a web site and the user is entering a number range like,
From:___ To: ____ Submit
Ex. From: _1_ To:_5_ Submit
But when the user click on the "Submit" button, this is what the code should do. It should insert the values in the database in this manner
1
2
3
4
5
I want to display the number of days left until next friday, but not counting Saturday or Sunday.
For example, the following would display the number 7.
[Code]....
[Code]....
How to construct a code in vb.net on how to Calculate Number Of Days Between DateNow minus given date In VB.NET ...
View 1 Repliesi am using timspan to find number of days between dates
protected void Page_Load(object sender, EventArgs e)
{
TextBox3.Text = DateTime.Now.ToString("dd/MM/yyyy");
}
protected void Button1_Click(object sender, EventArgs e)
{
con.Open();
SqlDataAdapter adp = new SqlDataAdapter("select * from rent_books where isbn='" + TextBox2.Text + "' and member_id='" + TextBox1.Text + "'",
[code]...
The scenario is that I wanna insert a record to the database via INSERT query and I need to user the identity number of this record in the INSERT query.
But I don't know how to achieve this.
Here is my table structure and code for your better understanding.
There are three columns in the Table: categoryID, categoryName, categoryPath. I need the path based on the categoryID which is an identity int column.
Now I used this code to do INSERT:
[Code]....
When we were using SVN, we'd always print at the footer of our pages: "Revision XXXX". I've been looking, but I can't figure out how to do the same thing with TFS. Can anyone offer some pointers?
In case this matters: we're using ASP.NET MVC. I'm guessing it doesn't matter, however.
I have gridview with two column. Id and number. Id begin 1 continue till 300.
Id Number
1 2
2 1
3 4
4 5
5 3
6 2
7 5
8 3
9 1
10 1
11 2
13 2
14 5
But I want insert id and number from gridview into TableNumber like this:
If id in( 1 , 9) then add three space before number .
If id in( 10 ,9 9) then add two space before number .
If id in( 100, 999) then add one space before number .
For example:
" 1"
" 2"
" 3"
" 4"
" 5"
" 6"
" 7"
" 8"
" 9"
" 10"
" 11"
" 100"
" 101"
How I can solve this?
I am generating a unique Ref number using this sql statement: SELECT REPLACE(STR(CAST(CAST(NEWID() AS binary(5)) AS bigint),12),0,0) as REF Subsequently, I need to insert this REF into sql database table in stored procedure. Here is what I did in my stored procedure:
USE [iBankRecords]
GO
/****** Object: StoredProcedure [dbo].[stp_addPayee] Script Date: 07/05/2010 21:57:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[stp_addPayee]
(
@CUSTID char(10),
@PAYEEACCNUM nvarchar(20),
@PAYEEACCTYPE char(10) ,
@PAYEENAME char(20),
@PAYERINITIAL char(20),
)
AS
DECLARE
@ReturnValue int
INSERT INTO PAYEE (CUSTID, PAYEEACCNUM,PAYEEACCTYPE,PAYEENAME,PAYERINITIAL, REF)
VALUES (@CUSTID,@PAYEEACCNUM,@PAYEEACCTYPE,@PAYEENAME,@PAYERINITIAL, REF)
IF @@ERROR<>0
BEGIN
PRINT 'ERROR'
SET @ReturnValue=1
RETURN @RETURNVALUE
END
ELSE
BEGIN
SET @ReturnValue=0
RETURN @RETURNVALUE
END
May I know how do I have generating a unique ref num and inserting the REF into the above statement?
In my gridview I have a datetime columns and couple of decimal number columns. Lets say I have a datetime value like this 19.03.2011 00:00:00 and I want it to seem like 19.03.2011. And I would like 2 decimal digits only. How can I achieve this?
View 2 Repliesmy dateformat is dd/mm/yyyy but in oracle 10g the date format in inserting is mm/dd/yyyy,
but i need to show to the user the select date as dd/mm/yyyy how to change the format as mm/dd/yyyy in my program to be insert in my database.
have a table with a transaction date in it. It is set as a timestamp and basically I want on creation of a new record that field automatically inserts the current date. I am using visual studio 2010 and ASP.net SQL not sure how to go about it. Dont need SQL injection protection for this just a simple way of doing it.
View 3 RepliesIf I have a checkboxlist where I insert a clients clientid and a number of interests they check off. How do I then update that later when they check off additional interests. The insert tries to insert the original ones as well as the new ones. This is a violation of the Primary key and the statement is terminated.
Is there a way to skip some or do I need to run a delete first and remove the existing interests for that client and then do a new insert? When the page opens the checkboxlist is populated with the previous interests that were inserted for the client. The user can then check additional interests for the client and then click a button to do the insert.
[Code]....
i need code to be able to check if (the date in a textbox) is already (used) in the database or not, if yes then give an error message!!
i am using asp.net 3.5 c#
I am importing images names from a file into a database by using the code below. When I import the image names, I aslo want to add a date of "June 12, 2009" in the DATE column. Finally, I do not want to import any duplicates. Is there something I can change in this code to make that happen?
declare @cmd varchar(1000)
set @cmd = 'dir "D:imagesREVIVE" /b'
if (object_id('ImageTable..tblimages') is not null)
begin
insert into tblimages (imgname)
execute xp_cmdshell @cmd
delete e
from tblimages e
where ISNULL(e.imgname, '') = ''
select *
from tblimages
end
else
create table tblimages ([id] int identity(1,1), imgname varchar(1000))
insert into tblimages (imgname)
execute xp_cmdshell @cmd
delete e
from tblimages e
where ISNULL(e.imgname, '') = ''
select *
from tblimages
I am trying to insert a new record via a SPROC in sql . In my date columns I check for nulls being passed to the SPROC this way Dim BirthDateParam As SqlParameter = New SqlParameter("@DOB", SqlDbType.DateTime) If estateRec.BirthDate Is Nothing Then BirthDateParam.Value = DBNull.Value InsertCommand.Parameters.Add(BirthDateParam) Else BirthDateParam.Value = estateRec.BirthDate InsertCommand.Parameters.Add(BirthDateParam) End If But I am getting an overflow error message about dates, SQL Stack Overflow Isn't this way correct
View 2 Repliesmay i know how to add in current date into the database?i've try using INSERT INTO OrderList (Date) VALUES (DateTime.Now,"dd-MMM-yyyy")
View 3 Repliesis there ny data type of date which can hold the date only.....coz i have a field of date in which i have write date manually... i have taken the datatype as DateTime.... and its showing "incorrect datetime value"..
View 1 Replies