|
Hello Sir,
I want to port the .dbf files into Sqlserver.i m not able to port the .dbf files into Sqlserver. I m a novice in this.
i hope u have done this..Can u please tell me how can i do this.
The requirement are as such that
The user should be able to specify the name of Database and login Credential prior to porting the files into the Database.
i m using Visual Studio 2005 as development platform.
Thanks and Regards
Avesh Agarwal
|
|
|
|
|
Hi All,
Simple questions: New to SQL
I have a SQL stored procedures which has a bunch of input parameters. Three of the input parameters are @LastName, @FirstName, @PhoneNumber.
I want to take the first letter from @LastName and @FirstName and 4 letters from the phone number and create a primary key.
Here is the code snippet:
DECLARE @CustomerLastInitial CHAR
SET @CustomerLastInitial = SUBSTRING(@LastName, 1, 1)
DECLARE @CustomerFirstInitial CHAR
SET @CustomerFirstInitial = SUBSTRING(@FirstName, 1, 1)
DECLARE @CustomerPhoneString CHAR(4)
SET @CustomerPhoneString = SUBSTRING(@Phone, 4, 4)
SET @CustomerID = @CustomerLastInitial + @CustomerFirstInitial + @CustomerPhoneString
But for some reason @CustomerID only has the first letter from the last name and ignores the rest.
Also tried:
@CustomerID = SUBSTRING(@LastName, 1, 1) + SUBSTRING(@FirstName, 1, 1) +
SUBSTRING(@Phone, 4, 4)
What am I doing wrong?
Frustrated
|
|
|
|
|
What data type / length are you using for @CustomerID? It should be char(6).
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Hi Paul,
Thanks for the reply.
I am using VARCHAR(10)
Calvin
|
|
|
|
|
Your code works for me (when I set up @LastName, @FirstName, @Phone and @CustomerId). You have not posted the code you are actually using.
DECLARE @LastName varchar(50);
DECLARE @FirstName varchar(50);
DECLARE @Phone varchar(50);
DECLARE @CustomerID varchar(10);
SELECT @LastName = 'Mackay', @FirstName = 'Colin', @Phone = '12345678';
---- START COPY FROM POST ----
DECLARE @CustomerLastInitial CHAR
SET @CustomerLastInitial = SUBSTRING(@LastName, 1, 1)
DECLARE @CustomerFirstInitial CHAR
SET @CustomerFirstInitial = SUBSTRING(@FirstName, 1, 1)
DECLARE @CustomerPhoneString CHAR(4)
SET @CustomerPhoneString = SUBSTRING(@Phone, 4, 4)
SET @CustomerID = @CustomerLastInitial + @CustomerFirstInitial + @CustomerPhoneString
---- END COPY FROM POST ----
SELECT @CustomerID
Additional: Actually, no it doesn't quite work. It does not take the last 4 chars from the phone number. It takes the penultimate 4 characters.
|
|
|
|
|
Colin Angus Mackay wrote: It does not take the last 4 chars from the phone number. It takes the penultimate 4 characters.
It does what you asked it to: takes four characters starting from position 4. That'll be positions 4, 5, 6 and 7. If you actually want the last four characters, use the RIGHT function, e.g. RIGHT(@Phone, 4).
DoEvents: Generating unexpected recursion since 1991
|
|
|
|
|
Here is the complete stored procedure:
I am debuggin and making sure I am sending it the right parameters from the application.
Code:
*
Description: Handles insertion of new customers.
*/
USE VideoSet
GO
IF OBJECT_ID('up_InsertCustomer') IS NOT NULL
DROP PROC up_InsertCustomer
GO
CREATE PROC up_InsertCustomer
@CustomerID VARCHAR = NULL,
@LastName VARCHAR(25),
@MiddleInitial CHAR(1) = NULL,
@FirstName VARCHAR(25),
@UserName VARCHAR(15) = NULL,
@Password VARCHAR(15) = NULL,
@Salutation VARCHAR(4) = NULL,
@Address VARCHAR(50) = NULL,
@City VARCHAR(25) = NULL,
@Province VARCHAR(25) = NULL,
@PostalCode VARCHAR(10) = NULL,
@Country VARCHAR(25) = NULL,
@Phone VARCHAR(15) = NULL,
@Phone2 VARCHAR(15) = NULL,
@Notes VARCHAR(50) = NULL,
@SalesPersonID VARCHAR(10)
AS
IF NOT EXISTS (
SELECT *
FROM Employee
WHERE EmployeeID = @SalesPersonID
)
RAISERROR('The speicified SalesPersonID does not exist! Invalid SalesPersonID!', 11, 1)
IF @CustomerID IS NULL
BEGIN
DECLARE @CustomerLastInitial CHAR
SET @CustomerLastInitial = SUBSTRING(@LastName, 1, 1)
DECLARE @CustomerFirstInitial CHAR
SET @CustomerFirstInitial = SUBSTRING(@FirstName, 1, 1)
DECLARE @CustomerPhoneString CHAR(4)
SET @CustomerPhoneString = SUBSTRING(@Phone, 4, 4)
SET @CustomerID = @CustomerLastInitial + @CustomerFirstInitial + @CustomerPhoneString
INSERT INTO Customer
VALUES (@CustomerID,
@LastName,
@MiddleInitial,
@FirstName,
@UserName,
@Password,
@Salutation,
@Address,
@City,
@Province,
@PostalCode,
@Country,
@Phone,
@Phone2,
@Notes,
@SalesPersonID
)
END
Also I am trying to jump into the stored procedure from the application but for some reason it does not jump into it. I am using VS 2005 and I checked the SQL Debuggin Option in the project properties. I also have a break point in my stored procedure.
Thanks,
Calvin
|
|
|
|
|
Hi,
I use "microsoft access" file (mdb) as a local database. (visual studio 2003)
I have no problem reading the data from it and show it on the DataGrid. the problem is when i want to delete a row i get Exceptions like:
"An unhandled exception of type 'System.InvalidOperationException' occurred in system.data.dll
Additional information: Update requires a valid DeleteCommand when passed DataRow collection with deleted rows."
Well , this is my code. can someone tell me what im doing wrong ?
Thanx
----------------------------------------------------------------------
dsDB.Tables["Clients"].Rows[1].Delete();
ClientsAdapter.Update(dt);
----------------------------------------------------------------------
dsDb is my DataSet.
ClientsAdapter is my DataAdapter.
as i wrote above, i can see the data from the database on my datagrid so i assume that there is no problems with the object i use.
|
|
|
|
|
Please don't post your question in multiple forums. It's considered rude. I've already replied to your post in c# forum.
|
|
|
|
|
I'm sorry. im new here.
will do next time. Thanks.
|
|
|
|
|
I'm new to C#,but I used VB.NET a lot ... This prject I have to do in C# and I allready have problems connecting to my SQL SERVER Database.
I put an combobox into my form which I want to link to some records in my database ...
So combobox.Datasource = ... Add Project DataSource ... Database ... Connection to my SQL SERVER Database ...
I saved the connection string as TSConnectionString ... Selected the tables and views I need from my database ...
and Visual Studio has created the files ... TSDataSet.xsd ( TSDataSet.Designer.cs , TSDataSet.xsc , TSDataSet.xss )
I mention that the combobox.DataSource property is still empty and the program can compile succesfully ... for now
When I come back to fill combobox.Datasource with TSDataSet namely tSDataSetBindingSource when i try to compile the
next error message pops up :
Error 1 The type name 'TSDataSet' does not exist in the type 'TSales.TSales'
... and the code behind this error is :
this.tSDataSet = new TSales.TSDataSet(); --------------- here is the error
this.tSDataSetBindingSource = new System.Windows.Forms.BindingSource(this.components);
this.panTop.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.tSDataSet)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.tSDataSetBindingSource)).BeginInit();
this.SuspendLayout();
Remember though I wrote above that Visual Studio creates those 4 files (TSDataSet.xsd , TSDataSet.Designer.cs , TSDataSet.xsc , TSDataSet.xss ) and puts them in Solution Explorer
So my question is ... how come there is no tSales.TSDataSet ?
and what should I do to link those records to that combobox and other records to other controls in my form
Thank you
|
|
|
|
|
how did you put those file in solution?
|
|
|
|
|
|
|
the problem was elsewhere man ... I reolved changing the form name from TSales to Main ... anything else was just fine
|
|
|
|
|
Hi how can i get from oledb or sql data reader data to messagebox or a Textbox ?
Can someone gimme an example.
|
|
|
|
|
Please don't post your question twice. Your post has been answered in c# forum
|
|
|
|
|
I am totally new to .net. I'm trying to code for a simple search engine. But on debugging I am getting the following exception.
System.NullReferenceException: Object reference not set to an instance of an object.
Can any body help please?
|
|
|
|
|
Shireesha wrote: I am totally new to .net.
And apparently to using forums. Your question doesn't appear to have anything to do with SQL.
Your error says that you're trying to use a method or set a property on a null (C#) or Nothing (VB.NET) object. Trying asking this question in the forum of the language you're using and post a code snippet. Without it, it's impossible to tell you what you did wrong.
|
|
|
|
|
Hi
i have a problem in calculating Date Diffrence.
how can i calculate the Day diffrence of same Date.
first i tried this way:
eg: Select DateDiff(Day,'01/01/2007','01/01/2007')
this query will return Zero
Second i tried this way:
eg: Select DateDiff(Day,'01/01/2007 00:00:00','01/01/2007 23:59:59')
this also return Zero, But calculate the Hour diffrence, this will show 23 Hrs.
By
George Garvasis
|
|
|
|
|
This behaviour is expected. DATEDIFF returns the number of complete units between 2 values. As the difference between your 2 times is not a complete day, the difference is still 0.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Hi
Thank you for your valuable information.
then how can i calculate the day difference.
By
George Garvasis
|
|
|
|
|
If you want to round the difference between 2 dates to the nearest day, calculate the difference in hours, express the result as a fraction of whole days and round up/down as appropriate.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Hello to Everybody,
I am Shireesha.Hey I'm Fresher to this .net world.I got a simple project.I'm trying it since from 5 days.The project is like Address ditactor .It contains a text box where the user enters a string then it will be followed to search button where it has to be get the connection to the data base(I'm Using Access).And in a Label I want the get the address.
Here how to provide the connection. Can any one plz plz plz suggest me
Regards
Waiting for answer
|
|
|
|
|
Hi there. Welcome to CodeProject.
First of all, you should give your posts more meaningful titles. Read the forum guidelines, specifically point no. 3. Also, textspeak is really annoying to read and makes you look unprofessional. If you have a question, use English.
Regarding your question, the following link[^] gives you a sample connection string for connecting to an Access database. You should use the classes in the System.Data.OleDb namespace to establish a connection. I suggest you read the documentation, make an attempt to solve the problem yourself and post again if you encounter further difficulties.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
