i 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 insert a particular value against a range of dates into my sql server database from the front end using c#.
the table has the column date and worker. so i desire that the user writes the name of the worker and then enters a From and To range into two textboxes so that thorugh a loop function the name of the worker gets written into the table along with the range of chosen dates.
I have a table "RANGES" with the following columns
LowRange as int
HighRange as int
with the data similar to below
select * from Ranges
LowRange HighRange
1 100
101 200
201 300
.
.
.
901 1000
And another table "infoDetails" with the following columns
Range as INT
amount as money
with the data similar to below
select * from infoDetails
Range Amount
23 34.00
235 44.00
345 34.00
678 100.00
555 100.00
530 100.00
510 100.00
I need one report with the following format without cursor.
LowRange HighRange Count Amount
1 100 1 34.00
101 200 0 0.00
.
.
501 600 3 300.00
601 700 1 100.00
i showed two column (Electronics,Photoshop) but i have six. i want to update their checked or unchecked condition in database (0,1) how do i do?
<asp:CheckBox ID="CheckBox1" runat="server" Text="Electronics" />
<asp:CheckBox ID="CheckBox2" runat="server" Text="Photoshop" />
<asp:CheckBox ID="CheckBox3" runat="server" Text="VideoEditing" />
<asp:CheckBox ID="CheckBox4" runat="server" Text="Gaming" />
<asp:CheckBox ID="CheckBox5" runat="server" Text="Coding" />
<asp:CheckBox ID="CheckBox6" runat="server" Text="Miscellaneous" />
I am working on website where i am getting error when try to insert data into database from my asp.net website
The Error says that :
" System.Data.SqlClient.SqlException :
The conversion of a varchar data type to a datetime data type resulted in an out-of-range value."
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
[Code] ....
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?
How to Validate the Range of Number
[Code]....
Imports System.Data
Imports System.Data.OleDb
Partial Class _Default [code]...
in my database table has four field as follws firstname, lastname, User_id and serial no as (Autonumber as well as PK) i am able to insert first 3 values by insert query as above but, insert autonumber data type mismatch.
how to upload datas from c# to sql database....which means i want to save textbox values to sql column..
View 1 RepliesI'm trying to build up some regular expressions to validate some textbox controls. I have done some research and testing but cannot get this one working. Examples of what i am trying to create regular expressions for are as follows:
Range 0-45, 0 decimal places
Range 0-20, 2 decimal places
Range 16-65, 0 decimal places
Range 0-99, 2 decimal places
Range 0-1500000, 0 decimal places
Range 0-200, 1 decimal place
For 1 and 5 respectively, I have used
([0-9]|[0-9]d|45)$
([0-9]|[0-9]d|1500000)$
The first one I am having problems for is an age range of 16-65 (inclusive), where I want no decimal places. After a post on here (Regular expression to allow numbers between -90.0 and +90.0) I thought I could use the logic and get it sussed, but can't! The expression I got to was:
(d|([1-6][6-4]))|65
I am at my wits end (again).
(reservation system, guest signs up and at the same time checks checkboxes to indicate their wishes)
[Code]....
[Code]....
[Code]....
Using sql server and trying to insert decimal values using a ASP.NET C# code. I get the value for hours from a text box through user input and I'm trying to insert it to the database.
strSQLWAUpdate = " UPDATE Project SET WAHours='" + txtWAHours.Text + "' WHERE WAProjectID='" + hidWAProjectID.Value + "' ";
What happens is it rounds off the hours to interger value. So if I insert 22.3 in the text box what i get in the database is 22 and if I insert 22.7 I get 23 in the database. I do not need any rounding but need to get the values as it is. ( that is 22.3 and 22.7 respectively)
Im a PHP programmer and now I'm try to do some work with ASP.NET but I got into trouble just in the first stage of my application.Can Anyone help me find out how to get the user inserted values from CreateUserWizard and insert it to sql database. I have implemented using the following codes, but I keep getting the error message "The name 'identifier' does not exist in the current context". I have tried different approaches but any of them worked.Code:.aspx
<%@ Page Title="Register" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeBehind="Register.aspx.cs" Inherits="PaperReviewSystem.Account.Registe
[code]...
I have the following regex to check if a number with 11 digits are entered
^[0-9]{11}$
Now I instead want to check if the number has 11-14 digits, how should I change my regex?
I am getting Range1 and Range2 from database. Dataset is like below.
Range1 Range2
AB100 XY200
AB300 XY400
AB500 XY600
I have to bind these ranges to a Drop Down List as list items includung range number in my application.So list item should be like ==> 1 AB100 XY200 . When user selects a range I have to pass Range1 and Range2 to database.How can I bind the two ranges with range number to Drop Down List.
I'm using the ASP Validation control a wanted to test that multiline textbox content was between 2 and 40 characters. Any character can be provided, including the new line character. What would be the expression? What I have below fails.
[code]...
for some SQL queries I know the expected number of rows that must be affected by UPDATE, DELETE or INSERT statements. It could be a number such as 1 or a range such as 0-1 or 1-2 etc.
What is the best way to enforce that this is the number of affected rows and that otherwise an exception is thrown?
Also, can I limit the number of rows affected for UPDATE/DELETE/INSERT to say 1 row and otherwise get an exception?
I want to validate a number by regular expression. Here is the requirement.
1- It should be between 1 and 200
2- maximum 2 floating point (e.g. 24.54 accepted but not 24.546)
3- the radix point can be either Dot or Comma (e.g. 29.45 - 29,45 both accepted)
4- can be intiger in this range also (e.g. 24 or 24.00)
Can anyone post an efficient regular expression for this?
I am using the crystal report, in that i am using code like below to show the SQL data into the crystal report,
string req = "{View_EODPumpTest.ROId} IN " + str + " AND " + "({View_EODPumpTest.RecordCreatedDate}>=date(" + fromDate.Year + " , " + fromDate.Month + " , " + fromDate.Day + ")" + "AND" + "{View_EODPumpTest.RecordCreatedDate}<=date(" + toDate.Year + " , " + toDate.Month + " ," + toDate.Day + " ))";
ReportDocument rep = new ReportDocument();
rep.Load(Server.MapPath("PumpTestReport.rpt"));
DateTime fromDate = DateTime.Parse(Request.QueryString["fDate"].ToString());
DateTime toDate = DateTime.Parse(Request.QueryString["tDate"].ToString());
CrystalReportViewer_PumpTest.ReportSource = rep;
//CrystalReportViewer1.SelectionFormula = str;
rep.RecordSelectionFormula = str;
CrystalDecisions.CrystalReports.Engine.TextObject from = ((CrystalDecisions.CrystalReports.Engine.TextObject)rep.ReportDefinition.ReportObjects["txtFrom"]);
from.Text = fromDate.ToShortDateString();
CrystalDecisions.CrystalReports.Engine.TextObject to = ((CrystalDecisions.CrystalReports.Engine.TextObject)rep.ReportDefinition.ReportObjects["txtTO"]);
to.Text = toDate.ToShortDateString();
//Session["Repo"] = rep;
CrystalReportViewer_PumpTest.RefreshReport();
after running my application it executes fine with no exception but such error i am getting, A number range is required here. Error in File
C:DOCUME~1DelmonLOCALS~1TempPumpTestReport {14E557A7-51B3-4791-9C78-B6FBAFFBD87C}.rpt: Error in formula . '{View_EODPumpTest.ROId} IN ['15739410','13465410'] AND ({View_EODPumpTest.RecordCreatedDate}>=date(2010 , 12 , 1)AND{View_EODPumpTest.RecordCreatedDate}<=date(2010 , 12 ,25 ))' A number range is required here. error.
I need regular expression validation for textBox
(integer and min value 200)
If input text 200, 201,202 OK
Else error input!
I am trying to insert 8 different selected values from a CheckBoxList into 8 different columns of a database. As it now, I am only able to concatenate all 8 selections into a single string in one column. But this is not what I want to do. In my DB I have Column1, 2, 3, 4, 5, 6, 7, 8. Is there any way of getting this done?
View 5 RepliesI am using SQL data source to display existing records from database as well as adding new records to the database.But in VWD 2008 we can insert only those values which have been inserted into the text box,if I try to change the values or text the Insert option gets disabled.I want to allow user to add only specific field values,for the rest I have created session variables and want to use values from these session variables to be inserted into database.
View 12 RepliesI have to in sert the gridview values into database, the values can be single or more than one values, so here i have to use the XML to store the data, but my question is?
i have to sent the values as a string, to the database, so how i convert that, and how could i retrieve the values as it is, and stored or display to the another gridview.
im using asp.Net 2005
Save (Insert) values of multiple CheckBoxes to database in ASP.Net
View 1 RepliesI am getting Range1 and Range2 from database. Dataset is like below.
Range1 Range2
AB100 XY200
AB300 XY400
AB500 XY600
I have to bind these ranges to a Drop Down List as list items includung range number in my application.So list item should be like ==> 1 AB100 XY200 . When user selects a range I have to pass
Range1 and Range2 to database.
How can I bind the two ranges with range number to Drop Down List.
