Database

Re: What will happen when more than one click same querry on networking

28-Nov-07 19:44

r_mohd wrote:
But i have no idea if more than one user fire same querry at the same time.
is this hang the system or crash the application.

SQL Server is designed as a scalable back-end database for multi-user applications. As long as you write your data access code and queries in an efficient manner, you should have no problems.

r_mohd wrote:
pl remdy also

What does this mean? Please try and use English - textspeak is really annoying.

BTW, you claim to be a Senior Developer but you don't have basic knowledge of data access? I find this very worrying Suspicious | :suss:

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

ChandraRam28-Nov-07 20:23

ChandraRam

28-Nov-07 20:23

pmarfleet wrote:
BTW, you claim to be a Senior Developer but you don't have basic knowledge of data access? I find this very worrying

The "Senior" is probably not an adjective for the "Developer"

Re: What will happen when more than one click same querry on networking

pmarfleet29-Nov-07 3:11

Re: What will happen when more than one click same querry on networking

29-Nov-07 3:11

He's now modified his post and changed his job title to 'Developer'. I wonder whether he got demoted after I posted my comments?

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

ChandraRam29-Nov-07 3:21

ChandraRam

29-Nov-07 3:21

pmarfleet wrote:
He's now modified his post and changed his job title to 'Developer'. I wonder whether he got demoted after I posted my comments?

Reading A CSV Then Writing To Oracle Database

cd0428-Nov-07 7:31

cd04

28-Nov-07 7:31

Hi all,

I need to be able to read in a CSV and then write all data back to a specified table within Oracle.

At the moment, I have put the following Oracle connection together, but need to read in c:\test.csv for example.

OracleConnection importOraConn = new OracleConnection();
importOraConn.ConnectionString = "User Id=USERNAME,Password=PASSWORD;Data Source=ORACLEDB";
importOraConn.Open();
OracleCommand importOraCommand = importOraConn.CreateCommand();
OracleDataAdapter oda = new OracleDataAdapter(importOraCommand);

Any help with this would be greatly appreciated.

Thanks

Re: Reading A CSV Then Writing To Oracle Database

Frank Kerrigan30-Nov-07 0:23

Frank Kerrigan

30-Nov-07 0:23

Oracle should have an import wizard you can use and load the data into a temp table then sort it from there.

If you must use code then you need to:

1) open the file as text via code.
2) Get each row from the text file
3) Copy row into an array as the ; being the delimiter of the array
4) transfer the array into an object or fields and sanitise it.
or boadge a sql insert string using the array values.
5) insert this into oracle using as a sql command.

There are a few ways of doing what you want and this is just a suggestion.

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)

http://www.frankkerrigan.com/[^]

Re: Reading A CSV Then Writing To Oracle Database

cd0430-Nov-07 4:00

cd04

30-Nov-07 4:00

Thanks, that's made things a little clearer of how to do things.

Do you have a snippet of how I get from step one to using insert statements?

Thanks

Must declare the scalar variable error::PleaseHelp

rzvme28-Nov-07 3:35

Re: Must declare the scalar variable error::PleaseHelp

28-Nov-07 3:35

public DataSet Get_Friends_Birthday(DateTime d)
{

User=0;
DataSet ds = new DataSet();
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=" + '"' + @"C:\Users\LadyLara\Documents\Visual Studio 2008\Projects\Private Notebook WebService\Private Notebook WebService\App_Data\Private Notebook Database.mdf" + '"' + ";Integrated Security=True;User Instance=True");
string scom = "SELECT FriendID, FFirstName, FLastName, FBirthday, FE_mail1, FE_mail2, FE_mail3, FE_mail4, FPhone_Number1, FPhone_Number2, FPhone_Number3, FPhone_Number4, UserID FROM Friends WHERE (UserID = "+"@IDUS)"+" AND (FBirthday = "+"@Date)";
SqlCommand sqlcom = new SqlCommand(scom,con);
sqlcom.Parameters.Add("IDUS", SqlDbType.Int).Value=User.ToString();
sqlcom.Parameters.Add("DATE", SqlDbType.SmallDateTime).Value=d.ToString();
SqlDataAdapter adapt = new SqlDataAdapter(scom, con);
con.Open();
adapt.Fill(ds);

return ds;
}

when it reaches adapt.fill(ds) i get the folowing error. "System.Data.SqlClient.SqlException: Must declare the scalar variable "@IDUS"."

Please Help!

rzvme

pmarfleet28-Nov-07 3:58

Re: Must declare the scalar variable error::PleaseHelp

28-Nov-07 3:58

rzvme wrote:
sqlcom.Parameters.Add("IDUS", SqlDbType.Int).Value=User.ToString();
sqlcom.Parameters.Add("DATE", SqlDbType.SmallDateTime).Value=d.ToString();

Prefix your parameter names with @ symbols.

BTW, you should consider not using inline SQL statements. Use stored procedures instead.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

rzvme28-Nov-07 4:26

Re: Must declare the scalar variable error::PleaseHelp

28-Nov-07 4:26

i thought about using stored procedures only i don't know exactly how to do this.(oracle fan) and by the way....even with the @ symbol in front of the parametername i still get the exact same error.

rzvme

pmarfleet28-Nov-07 4:41

Re: Must declare the scalar variable error::PleaseHelp

28-Nov-07 4:41

string scom = "SELECT FriendID, FFirstName, FLastName, FBirthday, FE_mail1, FE_mail2, FE_mail3, FE_mail4, FPhone_Number1, FPhone_Number2, FPhone_Number3, FPhone_Number4, UserID FROM Friends WHERE (UserID = "+"@IDUS)"+" AND (FBirthday = "+"@Date)";

You don't need to do any string concaternation here.

You should still really consider using stored procedures instead - you wouldn't have these problems if you did.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

rzvme28-Nov-07 6:46

Re: Must declare the scalar variable error::PleaseHelp

28-Nov-07 6:46

ALTER PROCEDURE [dbo].[uspGetBirthdayFriends]

@CRK INT
@BDATE SMALLDATETIME

AS
begin

select * from Friends where UserID=@CRK and FBirthday =@BDATE

RETURN
end

same error
incorrect sintax near '@BDATE'
must declare scalar variable "@crk"

rzvme

pmarfleet28-Nov-07 8:03

Re: Must declare the scalar variable error::PleaseHelp

28-Nov-07 8:03

You have made a syntax error. Each parameter declaration should be separated by a comma.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

rzvme28-Nov-07 9:30

Re: Must declare the scalar variable error::PleaseHelp

28-Nov-07 9:30

Thank you. That worked. But now i get another error and i can't seem to determine the cause

after i invoke

adapt.Fill(ds);
/*This is the code of the procedure*/
ALTER PROCEDURE dbo.uspGetBirthdayFriends

@CRK INT,
@BDATE SMALLDATETIME

AS
begin
declare @ID int
declare @BDATE smalldatetime
select * from Friends where UserID=@ID and FBirthday =@BDATE
end
RETURN

i get the following error "Procedure uspGetBirthdayFriends has no parameters and arguments were supplied."

Thank you

rzvme

pmarfleet28-Nov-07 10:02

Re: Must declare the scalar variable error::PleaseHelp

28-Nov-07 10:02

You've declared @BDATE twice in your SP - once as a parameter and secondly as a variable. This code won't complile - remove your variable declaration.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Pete O'Hanlon28-Nov-07 10:38

Pete O'Hanlon

28-Nov-07 10:38

You should really pass @ID in. Change it to:

dbo.uspGetBirthdayFriends


@ID INT, 
@BDATE SMALLDATETIME

AS
begin
select * from Friends where UserID=@ID and FBirthday =@BDATE
end
RETURN

From what I saw of your earlier post, you also seem to have a problem with the way you are handling your parameter. When you add in the SqlParameter, you need to put the parameter in with an @ in front of the name, e.g. command.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int));

Deja View - the feeling that you've seen this post before.

My blog | My articles

Re: Must declare the scalar variable error::PleaseHelp

rzvme29-Nov-07 3:00

Re: Must declare the scalar variable error::PleaseHelp

29-Nov-07 3:00

Thank you very much. Both of you. I finaly solved the problem.

rzvme

Paul Conrad29-Nov-07 13:01

Paul Conrad

29-Nov-07 13:01

pmarfleet wrote:
You don't need to do any string concaternation here.

Yes, that is dangerous.

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

ADO .NET Problem with SQL Server 2000

skhan_wah28-Nov-07 3:03

skhan_wah

28-Nov-07 3:03

I wrote the following code. application runs , no error but it does not display any data. What will be the problem with it? some one please help me.although code i tokk is from book, but still there is problem...

using System;
using System.Data.SqlClient;

namespace ConsoleApplication2
{
public class ExecuteReadExample
{
public static void Main(string[] args)
{
// string source = "server = \\10.8.7.67" + "integrated security=SSPI;" + "database=Northwind";
//string select = " SELECT ContactName, CompanyName FROM Customers";
"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\App1\Your_Database_Name.mdb; User Id=admin; Password="
SqlConnection conn = new SqlConnection(source);
conn.Open();
SqlCommand cmd = new SqlCommand(select, conn);
SqlDataReader reader = cmd.ExecuteReader();
while(reader.Read())
{
Console.WriteLine("Contact : {0,-20} company : {1}" , reader[0] , reader[1]);
}
}
}
}

Safdar Khan

pmarfleet28-Nov-07 3:53

28-Nov-07 3:53

Check your query. Does it return any data if you run it through Access?

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

skhan_wah29-Nov-07 4:24

skhan_wah

29-Nov-07 4:24

Thanks a lot. OK,I do that but still it didn't work.

Safdar Khan

pmarfleet29-Nov-07 11:05

29-Nov-07 11:05

Look at Mike's reply[^]. What he says is correct. You are using the SQL Server classes when you should be using the OleDb classes.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush