|
I said you to see the value of "str" after tbUsername & mtbPassword is binding with it.
Maybe something is wrong with those values.
|
|
|
|
|
Just set a break point after the SELECT query is constructed. When it breaks at that point, copy the value of the string out and paste it somewhere else to execute the query to see the result. You may figure out the problem that way.
|
|
|
|
|
I too think this is the way to go.
Step 1:
First you have to make sure the connection string is correct.
Try this.
string str = ("SELECT username,password FROM dbo.Login ");<br />
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(str, conn); <br />
conn.Open(); <br />
DataTable dt = new DataTable(); System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(cmd);<br />
da.Fill(dt);
then debug and see if the da has all details from the database table.
Step 2:
If step 1 was successful, use your program, debug and see what is the value of str just before the query is fired. Execute that query directly from Query Analyzer and verify the results.
|
|
|
|
|
ok with that i get an error due to no connection string so i add in
conn.ConnectionString = "Data Source=KADAEN-PC\\SQLEXPRESS;Initial Catalog=EasyStorePro;Persist Security Info=True;User ID=********;Password=***********";
and it runs i think my main problem is in the if statment section, more or less getting the textbox to verify itself with the information in the database
so something like
password is equal to mtbPassword.Text
|
|
|
|
|
I have the following code to update the account number in the account summary & clients tables when creating a new client profile but I have a major problem now with existing records as the account concept was proposed lately.. I want to know how can I use the same code to loop through all existing (already created) records and define an account number for it?
note: I want a random weekday and dayofyear so not all records will have the same weekday creation..
INSERT INTO clients (company_id, client_name, client_cpr, client_passport, client_gender, client_nationality, client_date_of_birth, client_visa_number, client_visa_expiry, client_workpermit_number, client_workpermit_expiry, client_telephone, client_fax, client_mobile, send_sms, client_occupation, client_email, send_emails, client_salary, home_country_address, client_is_vip, client_is_blacklist) VALUES (@company_id, @client_name, @client_cpr, @client_passport, @client_gender, @client_nationality, @client_date_of_birth, @client_visa_number, @client_visa_expiry, @client_workpermit_number, @client_workpermit_expiry, @client_telephone, @client_fax, @client_mobile, @send_sms, @client_occupation, @client_email, @send_emails, @client_salary, @home_country_address, @client_is_vip, @client_is_blacklist)
SET @record_identity = SCOPE_IDENTITY()
INSERT INTO accounts_summary (client_category, client_id, cr_cpr_number, account_number, account_name) VALUES ('I', @record_identity, @client_cpr, SCOPE_IDENTITY(), @client_name)
SET @account_number_string = RIGHT('0' + convert(varchar(1), DATEPART(WEEKDAY, GETDATE())), 1)
SET @account_number_string = @account_number_string + RIGHT('000' + convert(varchar(3), DATEPART(DAYOFYEAR, GETDATE())), 3)
SET @account_number_string = @account_number_string + RIGHT('0000000' + convert(varchar(7), SCOPE_IDENTITY()), 7)
SET @account_number = convert(bigint, @account_number_string)
UPDATE accounts_summary SET account_number = @account_number WHERE account_id = SCOPE_IDENTITY()
UPDATE clients SET account_number = @account_number WHERE client_id = @record_identity
|
|
|
|
|
A note,
No one will even look at this question until you edit the sql so that it fits within the page.
I don't speak Idiot - please talk slowly and clearly
'This space for rent'
Driven to the arms of Heineken by the wife
|
|
|
|
|
USE takhlees
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET NOCOUNT ON
DELETE FROM accounts_summary
-- reset primary key
INSERT INTO accounts_summary (account_number, account_name, core_account, is_read_only) VALUES (10000000001, 'CASH', 'True', 'True')
INSERT INTO accounts_summary (account_number, account_name, core_account, is_read_only) VALUES (10000000002, 'ACCOUNTS RECEIVABLE', 'True', 'True')
DECLARE @client_id int, @client_cpr varchar(50), @client_name varchar(255), @account_number_string VARCHAR(50), @account_number numeric(38,0)
DECLARE account_numbers CURSOR FOR
SELECT clients.client_id, clients.client_cpr, clients.client_name
FROM clients
ORDER BY clients.client_name
OPEN account_numbers
FETCH NEXT FROM account_numbers INTO @client_id, @client_cpr, @client_name
WHILE @@FETCH_STATUS = 0
BEGIN
INSERT INTO accounts_summary (client_category, client_id, cr_cpr_number, account_number, account_name) VALUES ('I', @client_id, @client_cpr, SCOPE_IDENTITY(), @client_name)
-- get random from 1 to 7
SET @account_number_string = RIGHT('0' + convert(varchar(1), DATEPART(WEEKDAY, GETDATE())), 1)
-- get random from 1 to 365
SET @account_number_string = @account_number_string + RIGHT('000' + convert(varchar(3), DATEPART(DAYOFYEAR, GETDATE())), 3)
SET @account_number_string = @account_number_string + RIGHT('0000000' + convert(varchar(7), SCOPE_IDENTITY()), 7)
SET @account_number = convert(bigint, @account_number_string)
UPDATE accounts_summary SET account_number = @account_number WHERE account_id = SCOPE_IDENTITY()
UPDATE clients SET account_number = @account_number WHERE client_id = @client_id
FETCH NEXT FROM account_numbers INTO @client_id, @client_cpr, @client_name
END
CLOSE account_numbers
DEALLOCATE account_numbers
|
|
|
|
|
Hi,
I want to use SQL Server's "Query Editor" in my C# project, can i integrate it in C# Project.
Thanks,
Sonia
modified on Wednesday, December 30, 2009 5:34 AM
|
|
|
|
|
I want to open a password protected database in vc 6 program but it do not works following is the code (if db has no password then every thing works fine)
m_pConnDB->Open (_bstr_t ("Provider=Microsoft.Jet.OLEDB.4.0; \
Data Source = Database1.accdb"), \
_bstr_t (""), \
_bstr_t (""), \
adModeUnknown);
I have also tried "Jet OLEDB:Database Password = mypassword" but it dont work
I have also tried same code on MDB file instead of accdb files but still same error.
Thanks in advance
|
|
|
|
|
pc_dev wrote: I have also tried "Jet OLEDB:Database Password = mypassword" but it dont work
Probably the wrong format for the password-argument, see connectionstrings.com[^]. I expect something like this would work;
_bstr_t ("Provider=Microsoft.Jet.OLEDB.4.0; Data Source = Database1.accdb;User Id=admin;Password=blabla;")
I are Troll 
|
|
|
|
|
|
Hello guys,
I am creating a database script and in this script i am declareing a datetime variable like below
DECLARE @ENDDATE DATETIME
Now my question is that i want to initialize the value of this variable
and i am doing it this way
SET @ENDATE '30/12/2009'
and this is giving me an error saying that i cannot covert from char to datetime. How can this be done guys?
Thank you in advance
Regards,
Christian Pace
|
|
|
|
|
DECLARE @EndDate DATETIME
SET @EndDate = '20091230'Something like this?
I are Troll
|
|
|
|
|
The default format of a date in sql = MM/dd/yyyy, so 30/12/2009 is indeed an invalid date.
So there are three ways to solve this:
- Use
set DateFormat dmy - use
set @EndDate = '12/30/2009' - use
set @EndDate = '20091230'
The first option will allow you to use your own way of using dates.
In the second option you use the current settings of the server. You cannot always be sure of this setting, so I wouldn't use this.
The third option is using the ISO format for dates. I prefer this method because it is language independent.
Wout Louwers
|
|
|
|
|
Thank you that did the trick!  thx for all the help
|
|
|
|
|
I have a series of time series data. How do I construct a SQL statement to find whether the minimum (or trough) between 2 different dates is smaller than both the values on the starting date and the ending date? My table has StockName, Date, and Price column.
The purpose of this query is to find all the stocks when their price slopes changes from negative to positive.  So if a minimum point does exists between the 2 dates but is smaller than either starting and ending values, it means there's a slope change like the following:
*................*..
..*............*....
....*........*......
.......*....*.......
.........*..........
Could you please provide a sample query statement?
Much thanks in advance!
|
|
|
|
|
Hi,
for begin point B and end point E, you could
- select all points X between B and E;
- order them by the distance between val(X) and the smallest of begin and end points = MIN(val(B),val(E));
If any record is selected, you have a V pattern, and specifying "TOP 1" would yield it.
|
|
|
|
|
Thank yuo Luc, that is pure elegancy, much better than my original idea which involves 2 separate comparisons.
Could you please let me know how to write that query statement? I currently have the following which doesn't work.... 
The time series data is stock price and I want to retrieve all the stocks with that V shape price pattern:
[Edit] Sorry for some reason when I tried to post my code, I got an error internet message and not able post the message. Could you please show me a sample of the query? I'd greatly appreciate it!
modified on Tuesday, December 29, 2009 4:04 AM
|
|
|
|
|
James Shao wrote: which doesn't work
James Shao wrote: got an error internet message
that is too vague, nobody can help you without a more accurate description.
|
|
|
|
|
Thanks for the reply Luc. Here's a more accurate discription of what my DataTable looks like:
Ticker Date Price
MSFT 1/2/2009 20
MSFT 1/3/2009 19
MSFT 1/4/2009 18
MSFT 1/5/2009 17
MSFT 1/6/2009 16
MSFT 1/7/2009 18
MSFT 1/8/2009 20
MFST 1/9/2009 21
DELL 1/2/2009 11
DELL 1/3/2009 12
DELL 1/4/2009 17
DELL 1/5/2009 17
DELL 1/6/2009 16
DELL 1/7/2009 15
DELL 1/8/2009 15
DELL 1/9/2009 14
AAPL
...
...
...
I need a query to return all the stocks with its price first going down then going up, in other words a V pattern; and the query would need to check whether this happens for a particular date. In the example above, this happened to MSFT on 1/7/2009 when the first V patter is formed.
Not sure if this can be done using SQL, but if possible, could you please help me with it? I'd be very very thankful!
|
|
|
|
|
<br />
select @minval = min(stockval) from table where stockdate between d1 and d2<br />
select @mindate = stockdate from table where stockdate between d1 and d2 and stockval = @minval<br />
This is just a starting point.
Good luck
modified on Wednesday, December 30, 2009 8:13 AM
|
|
|
|
|
Thank you djj55, a question about the query statement you wrote. Is that 2 different SQL statement, as I don't see anything between the first SELECT and the second SELECT statement. Or could you actually write a statement like that? Because I thought the @minval in the second statement is not defined....of course it's defined in the first statement, but the two statements are not connected, right?
|
|
|
|
|
Sorry for the confusion. I did notice that I did a cut & paste instead of a copy & paste so I edited my query.
There should be two queries
select @minval = min(stockval) from table where stockdate between d1 and d2;
select @mindate = stockdate from table where stockdate between d1 and d2 and stockval = @minval;
Not being a C programmer I do not normally use the semicolon which in T-SQL is not needed.
Hope this helps.
|
|
|
|
|
Hi,
I am facing some problems related to french characters. One of the character "₣" is not supported by sql server 2005. rest of the french characters is suppoeted by sql server 2005.
When ever i tried to insert data or run a select query it returns as a question mark "?".
Full text search is provided on table for search functionality.
Select doc_id,1 from DocumentMaster Where 1=1
AND (CONTAINS(Document_Filename, '"*Œ*"') OR CONTAINS(Document_Filename_French, '"*Œ*"'))
AND (CONTAINS(Document_Filename, '"*œ*"') OR CONTAINS(Document_Filename_French, '"*œ*"'))
AND (CONTAINS(Document_Filename, '"*€*"') OR CONTAINS(Document_Filename_French, '"*€*"'))
AND (CONTAINS(Document_Filename, '"*?*"') OR CONTAINS(Document_Filename_French, '"*?*"'))
i have read in couple of the site that the data type of the colum should be nvarchar or ntext for french characters to support. I even that. but then also it is not supporting the "₣" french character. Rest french character it is supporting.
please suggest any solution.
Regards,
Pranav Dave
|
|
|
|
|
Hi,
I don;t know the F-like character your message shows, and which you call a "french character".
What is its name?
Can you show us some words containing it?
do you know its unicode number?
are there things you can do with it successfully?
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
