Solve this and replay me i hunged here

Expand|Select|Wrap|Line Numbers

 
Imports System.Data.SqlClient

Namespace Accounts

    Public Class NewAccount

        Dim cmd As New SqlCommand

        Dim c As New DatabaseConnection.DataBaseConnaction.ConnectionClass

        Function CreateAccount(ByVal BankID As String, ByVal Account_TypeID As String, ByVal First_Name As String, ByVal Last_Name As String, ByVal Date_Birth As DateTime, ByVal Citizenship As String, ByVal Civil_Id As Integer, ByVal address As String, ByVal Father_Name As String, ByVal Profession As String, ByVal Description As String, ByVal Date_creation As DateTime, ByVal phoneNo As String, ByVal emailid As String, ByVal ext As String, ByVal CreatedBy As String, ByVal UserID As String)

            Try

                cmd.Parameters.Add("@BankID", SqlDbType.VarChar)

                cmd.Parameters.Item("@BankID").Value = BankID
 
                cmd.Parameters.Add("@Account_TypeID", SqlDbType.VarChar)

                cmd.Parameters.Item("@Account_TypeID").Value = Account_TypeID
 
                cmd.Parameters.Add("@First_Name", SqlDbType.VarChar)

                cmd.Parameters.Item("@First_Name").Value = First_Name
 
                cmd.Parameters.Add("@Last_Name", SqlDbType.VarChar)

                cmd.Parameters.Item("@Last_Name").Value = Last_Name
 
                cmd.Parameters.Add("@Date_Birth", SqlDbType.DateTime)

                cmd.Parameters.Item("@Date_Birth").Value = Date_Birth
 
                cmd.Parameters.Add("@Citizenship", SqlDbType.VarChar)

                cmd.Parameters.Item("@Citizenship").Value = Citizenship
 
                cmd.Parameters.Add("@Civil_Id", SqlDbType.Int)

                cmd.Parameters.Item("@Civil_Id").Value = Civil_Id
 
                cmd.Parameters.Add("@Address", SqlDbType.VarChar)

                cmd.Parameters.Item("@Address").Value = address
 
                cmd.Parameters.Add("@Father_Name", SqlDbType.VarChar)

                cmd.Parameters.Item("@Father_Name").Value = Father_Name
 
                cmd.Parameters.Add("@Profession", SqlDbType.VarChar)

                cmd.Parameters.Item("@Profession").Value = Profession
 
                cmd.Parameters.Add("@phoneNo", SqlDbType.VarChar)

                cmd.Parameters.Item("@phoneNo").Value = phoneNo
 
                cmd.Parameters.Add("@emailid", SqlDbType.VarChar)

                cmd.Parameters.Item("@emailid").Value = emailid
 
                cmd.Parameters.Add("@Ext", SqlDbType.VarChar)

                cmd.Parameters.Item("@Ext").Value = ext
 
                cmd.Parameters.Add("@Description", SqlDbType.VarChar)

                cmd.Parameters.Item("@Description").Value = Description
 
                cmd.Parameters.Add("@Date_creation", SqlDbType.DateTime)

                cmd.Parameters.Item("@Date_creation").Value = Date.Now
 
                cmd.Parameters.Add("@CreatedBy", SqlDbType.VarChar)

                cmd.Parameters.Item("@CreatedBy").Value = CreatedBy
 
                cmd.Parameters.Add("@UserID", SqlDbType.VarChar)

                cmd.Parameters.Item("@UserID").Value = UserID
 
                cmd.CommandType = CommandType.StoredProcedure

                cmd.CommandText = "Execute_Account2"
 
                Dim QueryExecute As New DatabaseConnection.DataBaseConnaction.ConnectionClass

                QueryExecute.ExecuteNonquery(cmd)

                Return "New Account has been successully added"

            Catch ex As Exception
 
                Return "Error"
 
            End Try

        End Function
 
    End Class
 
End Namespace

I am geeting the Error pls any one sole this

Nov 6 '08 #1

Subscribe Post Reply

1516

numberwhun

3,509

Expert Mod 2GB

Next time....

1. Please use code tags.
2. Please post questions in their appropriate forum, and not the introductions forum.

Regards,

Jeff
Moderator

Nov 6 '08 #2

nazimsal

ALTER PROCEDURE [dbo].[InsertAccount]

@BankID AS VARCHAR(500) ,
@Account_TypeID AS VARCHAR(500) ,
@First_Name AS VARCHAR(500) ,
@Last_Name AS VARCHAR(500) ,
@Date_Birth AS DATETIME ,
@Citizenship AS VARCHAR(500) ,
@Civil_Id AS BIGINT ,
@Address AS VARCHAR(500) ,
@Father_Name AS VARCHAR(500) ,
@Profession AS VARCHAR(500) ,
@phoneNo varchar(500) ,
@emailid varchar(500) ,
@Ext varchar(50) ,
@Description AS VARCHAR(500) ,
@Date_creation AS DATETIME ,
@CreatedBy AS VARCHAR(500) ,
@UserID AS VARCHAR(500)

AS
BEGIN

------------Account Number genaration-----------
DECLARE @Account_Number AS VARCHAR(500) ;
-- DECLARE @AccountTypeID AS VARCHAR(500) ;
---- SELECT @Location=BankLocation FROM Bank WHERE BankID=@BankID
---- SELECT @AccountTypeID=AccountTypeID FROM AccountTypes WHERE AccountTypeID=@Account_TypeID
IF @Account_TypeID='SB'
BEGIN
IF @BankID='NBKFAR01'
BEGIN
SELECT @Account_Number=MAX(Account_Number) FROM AccountDetails WHERE Account_Number BETWEEN '101' AND '75000'
IF @Account_Number IS NULL
BEGIN
SELECT @Account_Number=101
END
ELSE
BEGIN
SELECT @Account_Number=@Account_Number+1
END
END
ELSE IF @BankID='NBKMIR01'
BEGIN
SELECT @Account_Number=MAX(Account_Number) FROM AccountDetails WHERE Account_Number BETWEEN '75001' AND '150000'
IF @Account_Number IS NULL
BEGIN
SELECT @Account_Number=75001
END
ELSE
BEGIN
SELECT @Account_Number=@Account_Number+1
END
END
ELSE IF @BankID='NBKSRK01'
BEGIN
SELECT @Account_Number=MAX(Account_Number) FROM AccountDetails WHERE Account_Number BETWEEN '150001' AND '225000'
IF @Account_Number IS NULL
BEGIN
SELECT @Account_Number=150001
END
ELSE
BEGIN
SELECT @Account_Number=@Account_Number+1
END
END
ELSE IF @BankID='NBKSRK02'
BEGIN
SELECT @Account_Number=MAX(Account_Number) FROM AccountDetails WHERE Account_Number BETWEEN '225001' AND '300000'
IF @Account_Number IS NULL
BEGIN
SELECT @Account_Number=225001
END
ELSE
BEGIN
SELECT @Account_Number=@Account_Number+1
END
END
ELSE
BEGIN
RAISERROR('Invalid Information',18,3)
END
END
ELSE IF @Account_TypeID='AC'
BEGIN
IF @BankID='NBKFAR01'
BEGIN
SELECT @Account_Number=MAX(Account_Number) FROM AccountDetails WHERE Account_Number BETWEEN '2000001' AND '2075000'
IF @Account_Number IS NULL
BEGIN
SELECT @Account_Number=2000001
END
ELSE
BEGIN
SELECT @Account_Number=@Account_Number+1
END
END
ELSE IF @BankID='NBKMIR01'
BEGIN
SELECT @Account_Number=MAX(Account_Number) FROM AccountDetails WHERE Account_Number BETWEEN '2075001' AND '2150000'
IF @Account_Number IS NULL
BEGIN
SELECT @Account_Number=2075001
END
ELSE
BEGIN
SELECT @Account_Number=@Account_Number+1
END
END
ELSE IF @BankID='NBKSRK01'
BEGIN
SELECT @Account_Number=MAX(Account_Number) FROM AccountDetails WHERE Account_Number BETWEEN '2150001' AND '2225000'
IF @Account_Number IS NULL
BEGIN
SELECT @Account_Number=2150001
END
ELSE
BEGIN
SELECT @Account_Number=@Account_Number+1
END
END
ELSE IF @BankID='NBKSRK02'
BEGIN
SELECT @Account_Number=MAX(Account_Number) FROM AccountDetails WHERE Account_Number BETWEEN '2225001' AND '2300000'
IF @Account_Number IS NULL
BEGIN
SELECT @Account_Number=2225001
END
ELSE
BEGIN
SELECT @Account_Number=@Account_Number+1
END
END
ELSE
BEGIN
RAISERROR('Invalid Information',18,3)
END
END
ELSE IF @Account_TypeID='FIX'
BEGIN
IF @BankID='NBKFAR01'
BEGIN
SELECT @Account_Number=MAX(Account_Number) FROM AccountDetails WHERE Account_Number BETWEEN '5000001' AND '5075000'
IF @Account_Number IS NULL
BEGIN
SELECT @Account_Number=5000001
END
ELSE
BEGIN
SELECT @Account_Number=@Account_Number+1
END
END
ELSE IF @BankID='NBKMIR01'
BEGIN
SELECT @Account_Number=MAX(Account_Number) FROM AccountDetails WHERE Account_Number BETWEEN '5075001' AND '5150000'
IF @Account_Number IS NULL
BEGIN
SELECT @Account_Number=5075001
END
ELSE
BEGIN
SELECT @Account_Number=@Account_Number+1
END
END
ELSE IF @BankID='NBKSRK01'
BEGIN
SELECT @Account_Number=MAX(Account_Number) FROM AccountDetails WHERE Account_Number BETWEEN '5150001' AND '5225000'
IF @Account_Number IS NULL
BEGIN
SELECT @Account_Number=5150001
END
ELSE
BEGIN
SELECT @Account_Number=@Account_Number+1
END
END
ELSE IF @BankID='NBKSRK02'
BEGIN
SELECT @Account_Number=MAX(Account_Number) FROM AccountDetails WHERE Account_Number BETWEEN '5225001' AND '5300000'
IF @Account_Number IS NULL
BEGIN
SELECT @Account_Number=5225001
END
ELSE
BEGIN
SELECT @Account_Number=@Account_Number+1
END
END
ELSE
BEGIN
RAISERROR('Invalid Information',18,3)
END
END

INSERT INTO AccountDetails
(
Account_Number ,
BankID ,
Account_TypeID ,
First_Name ,
Last_Name ,
Date_Birth ,
Citizenship ,
Civil_Id ,
Address ,
Father_Name ,
Profession ,
Date_creation ,
phoneNo ,
emailid ,
Ext ,
Description ,
CreatedBy ,
UserID

)
VALUES
(
@Account_Number ,
@BankID ,
@Account_TypeID ,
@First_Name ,
@Last_Name ,
@Date_Birth ,
@Citizenship ,
@Civil_Id ,
@Address ,
@Father_Name ,
@Profession ,
@Date_creation ,
@phoneNo ,
@emailid ,
@Ext ,
@Description ,
@CreatedBy ,
@UserID
)

END

Dear All
i'm using this code to insert a record, but wen i'm using wrong data that time i'm not able to retrivew Error msg please replay me.
nazim

Dec 31 '08 #3

nazimsal

ALTER PROCEDURE [dbo].[InsertAccount]

@BankID AS VARCHAR(500) ,
@Account_TypeID AS VARCHAR(500) ,
@First_Name AS VARCHAR(500) ,
@Last_Name AS VARCHAR(500) ,
@Date_Birth AS DATETIME ,
@Citizenship AS VARCHAR(500) ,
@Civil_Id AS BIGINT ,
@Address AS VARCHAR(500) ,
@Father_Name AS VARCHAR(500) ,
@Profession AS VARCHAR(500) ,
@phoneNo varchar(500) ,
@emailid varchar(500) ,
@Ext varchar(50) ,
@Description AS VARCHAR(500) ,
@Date_creation AS DATETIME ,
@CreatedBy AS VARCHAR(500) ,
@UserID AS VARCHAR(500)

AS
BEGIN

------------Account Number genaration-----------
DECLARE @Account_Number AS VARCHAR(500) ;
-- DECLARE @AccountTypeID AS VARCHAR(500) ;
---- SELECT @Location=BankLocation FROM Bank WHERE BankID=@BankID
---- SELECT @AccountTypeID=AccountTypeID FROM AccountTypes WHERE AccountTypeID=@Account_TypeID
IF @Account_TypeID='SB'
BEGIN
IF @BankID='NBKFAR01'
BEGIN
SELECT @Account_Number=MAX(Account_Number) FROM AccountDetails WHERE Account_Number BETWEEN '101' AND '75000'
IF @Account_Number IS NULL
BEGIN
SELECT @Account_Number=101
END
ELSE
BEGIN
SELECT @Account_Number=@Account_Number+1
END
END
ELSE IF @BankID='NBKMIR01'
BEGIN
SELECT @Account_Number=MAX(Account_Number) FROM AccountDetails WHERE Account_Number BETWEEN '75001' AND '150000'
IF @Account_Number IS NULL
BEGIN
SELECT @Account_Number=75001
END
ELSE
BEGIN
SELECT @Account_Number=@Account_Number+1
END
END
ELSE IF @BankID='NBKSRK01'
BEGIN
SELECT @Account_Number=MAX(Account_Number) FROM AccountDetails WHERE Account_Number BETWEEN '150001' AND '225000'
IF @Account_Number IS NULL
BEGIN
SELECT @Account_Number=150001
END
ELSE
BEGIN
SELECT @Account_Number=@Account_Number+1
END
END
ELSE IF @BankID='NBKSRK02'
BEGIN
SELECT @Account_Number=MAX(Account_Number) FROM AccountDetails WHERE Account_Number BETWEEN '225001' AND '300000'
IF @Account_Number IS NULL
BEGIN
SELECT @Account_Number=225001
END
ELSE
BEGIN
SELECT @Account_Number=@Account_Number+1
END
END
ELSE
BEGIN
RAISERROR('Invalid Information',18,3)
END
END
ELSE IF @Account_TypeID='AC'
BEGIN
IF @BankID='NBKFAR01'
BEGIN
SELECT @Account_Number=MAX(Account_Number) FROM AccountDetails WHERE Account_Number BETWEEN '2000001' AND '2075000'
IF @Account_Number IS NULL
BEGIN
SELECT @Account_Number=2000001
END
ELSE
BEGIN
SELECT @Account_Number=@Account_Number+1
END
END
ELSE IF @BankID='NBKMIR01'
BEGIN
SELECT @Account_Number=MAX(Account_Number) FROM AccountDetails WHERE Account_Number BETWEEN '2075001' AND '2150000'
IF @Account_Number IS NULL
BEGIN
SELECT @Account_Number=2075001
END
ELSE
BEGIN
SELECT @Account_Number=@Account_Number+1
END
END
ELSE IF @BankID='NBKSRK01'
BEGIN
SELECT @Account_Number=MAX(Account_Number) FROM AccountDetails WHERE Account_Number BETWEEN '2150001' AND '2225000'
IF @Account_Number IS NULL
BEGIN
SELECT @Account_Number=2150001
END
ELSE
BEGIN
SELECT @Account_Number=@Account_Number+1
END
END
ELSE IF @BankID='NBKSRK02'
BEGIN
SELECT @Account_Number=MAX(Account_Number) FROM AccountDetails WHERE Account_Number BETWEEN '2225001' AND '2300000'
IF @Account_Number IS NULL
BEGIN
SELECT @Account_Number=2225001
END
ELSE
BEGIN
SELECT @Account_Number=@Account_Number+1
END
END
ELSE
BEGIN
RAISERROR('Invalid Information',18,3)
END
END
ELSE IF @Account_TypeID='FIX'
BEGIN
IF @BankID='NBKFAR01'
BEGIN
SELECT @Account_Number=MAX(Account_Number) FROM AccountDetails WHERE Account_Number BETWEEN '5000001' AND '5075000'
IF @Account_Number IS NULL
BEGIN
SELECT @Account_Number=5000001
END
ELSE
BEGIN
SELECT @Account_Number=@Account_Number+1
END
END
ELSE IF @BankID='NBKMIR01'
BEGIN
SELECT @Account_Number=MAX(Account_Number) FROM AccountDetails WHERE Account_Number BETWEEN '5075001' AND '5150000'
IF @Account_Number IS NULL
BEGIN
SELECT @Account_Number=5075001
END
ELSE
BEGIN
SELECT @Account_Number=@Account_Number+1
END
END
ELSE IF @BankID='NBKSRK01'
BEGIN
SELECT @Account_Number=MAX(Account_Number) FROM AccountDetails WHERE Account_Number BETWEEN '5150001' AND '5225000'
IF @Account_Number IS NULL
BEGIN
SELECT @Account_Number=5150001
END
ELSE
BEGIN
SELECT @Account_Number=@Account_Number+1
END
END
ELSE IF @BankID='NBKSRK02'
BEGIN
SELECT @Account_Number=MAX(Account_Number) FROM AccountDetails WHERE Account_Number BETWEEN '5225001' AND '5300000'
IF @Account_Number IS NULL
BEGIN
SELECT @Account_Number=5225001
END
ELSE
BEGIN
SELECT @Account_Number=@Account_Number+1
END
END
ELSE
BEGIN
RAISERROR('Invalid Information',18,3)
END
END

INSERT INTO AccountDetails
(
Account_Number ,
BankID ,
Account_TypeID ,
First_Name ,
Last_Name ,
Date_Birth ,
Citizenship ,
Civil_Id ,
Address ,
Father_Name ,
Profession ,
Date_creation ,
phoneNo ,
emailid ,
Ext ,
Description ,
CreatedBy ,
UserID

)
VALUES
(
@Account_Number ,
@BankID ,
@Account_TypeID ,
@First_Name ,
@Last_Name ,
@Date_Birth ,
@Citizenship ,
@Civil_Id ,
@Address ,
@Father_Name ,
@Profession ,
@Date_creation ,
@phoneNo ,
@emailid ,
@Ext ,
@Description ,
@CreatedBy ,
@UserID
)

END

Dear All
i'm using this code to insert a record, but wen i'm using wrong data that time i'm not able to retrivew Error msg please replay me.
nazim[/quote]

Dec 31 '08 #4

nazimsal

i'm not able to retriew Error mg
@nazimsal

Dec 31 '08 #5

by: Sharone Shani | last post by:

Hi John, thanks for your replay. What I'm trying to do is as follows: We are hosting a server, which is used by our clients. We have a printing object written in Visual Basic.NET. I want to...

ASP.NET

Record and Replay another applications keystrokes

by: zak | last post by:

I have some testing to do and I need to put a whole set of data in I want to Record and replay in a loop keystrokes. An idea

Visual Basic .NET

WSE 2.0 - How could I replay the action recorded in the trace file

by: newcomer | last post by:

I have traced action in XML. Now I would like to replay that. How could I do that based on this XML trace? I am using soap:tcp between client and server. thanks,

.NET Framework

Replay Attacks in Webservice

by: Baheri | last post by:

Does any one have a sample on how can replay attacks be prevented in a webservice?

.NET Framework

queue & replay keyboard messages in a win form instead of using SendKeys.Send()

by: neonspark | last post by:

I'm buidling some simple macro functionality for my app so the users can record a sequence of keyboard inputs and replay them reliably via some menu. Originally, I used: protected override bool...

.NET Framework

Tool to capture and "replay" IIS/ASP.NET traffic?

by: Derrick | last post by:

Can anyone suggest a tool (if one exists) to capture IIS traffic and be able to "replay" that traffic? We are in the process of moving from sql2k to sql2005. What I would like to do is take a...

ASP.NET

please solve my problem

by: phanimadhav | last post by:

Actually i am new one of this ASP.NET.i have have one problem with session_end() in Global.aspx.when this session_end() is faired. I call the session.abandon() method.but my requirement is whenever i...

.NET Framework

SQL Capture/Replay tool for db2 luw

by: Lew | last post by:

Hi, I'm looking for a tool that can capture all the sql transactions for a period of time (24 hours or so ) from our production server and replay it exactly as entered on our performance tuning...

DB2 Database

Help Please in making Code replay the game.

by: Gomi | last post by:

Hi guys I'm new to C++ Programming and I am having trouble in making my Guessing game code replay. I am suppose to give the user that is playing my game the opportunity to play again with options of...

C / C++

I design stores database and I have a problem

by: hany1002 | last post by:

I design stores database and I have a problem I maked Invoices for the purchase and sale, I need to transfer Items between Branches in my store access database ? Any Ideas thank you

Microsoft Access / VBA

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Solve this and replay me i hunged here

Similar topics