Database Discussion Boards

PuccPukka9-May-06 0:51

9-May-06 0:51

Hi all,

I have a problem regarding data bindings. I am using Ms Access database and I have an application which loads the tables in datagrids and textboxes.

I used joins since there are relations between tables. For example I have a table called "Alterations" and in this table there is a field called "Client" which brings the name of the client from the table "Clients" .

When running the application an error occurs stating that "no value given for one or more required parameters"

Some one knows what this error is please??

Thanks alot

Re: joins

albCode9-May-06 2:34

albCode

9-May-06 2:34

check syntax or can u display ur problem here??

Re: joins

PuccPukka9-May-06 3:29

PuccPukka

9-May-06 3:29

My problem is that when I run the application an error occurs stating that "no value given for one or more required parameters"

And I am not understanding the error!

Re: joins

albCode9-May-06 3:44

albCode

9-May-06 3:44

check syntax if any parapmeter is without value.
when u call method and possiblity u forgot to give value for parameter.

Query String

cshivaprasad8-May-06 21:30

cshivaprasad

8-May-06 21:30

Can u pls tell me, wether following SQL string format is correct or not.
textWord.text,comboCat.text are string variables of C#.
indexInCategoryTable and SubCategoryNo are integer variables.

"select * from Words where
word = N'"+textWord.Text+"' and

CategoryTableName = '"+comboCat.Text+"' and

IndexInCategoryTable = 'indexInCategoryTable' and

SubCategoryNo = 'SubCategoryNo'";

Re: Query String

Colin Angus Mackay8-May-06 22:37

Colin Angus Mackay

8-May-06 22:37

cshivaprasad wrote:
Can u pls tell me, wether following SQL string format is correct or not

No. You should use parameters rather than inject values into the query - See SQL Injection Attacks and Tips on How to Prevent Them[^] unless you want your database attacked by a rampaging mob of mallicious attackers.

"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog

Multiple user inserting table at same time

MaheshSharma8-May-06 20:11

MaheshSharma

8-May-06 20:11

Procedure: We have two tables namely table A and Table B. Table A contains a field called ID Table B contains field ID and field 1,field 2,field 3.The procedure is to pick value from table A ID field, increment it by 1 to it and update the table A, then insert data into table B with this incremented value and other data.

Problem: When multiple concurrent users perform updation/insertion of data into table A,table B duplicate IDs are getting created in table B even though the statements are written within ADO.NET BEGINTRANSACTION,COMMIT/ROLLBACK.

Thanks
Mahesh

-- modified at 2:11 Tuesday 9th May, 2006

Re: Multiple user inserting table at same time

Eric Dahlvang9-May-06 3:16

Eric Dahlvang

9-May-06 3:16

Study up on Holding Locks and SET TRANSACTION ISOLATION LEVEL in SQL Server Books Online.

----------
There go my people. I must find out where they are going so I can lead them.
- Alexander Ledru-Rollin

how to get name of the day in SQL2000

isroavi8-May-06 17:24

isroavi

8-May-06 17:24

Ex: SELECT DAY(GETDATE())

its display 9 but i need to show tuesday.

can anybody help?

raj

Re: how to get name of the day in SQL2000

isroavi8-May-06 17:33

isroavi

8-May-06 17:33

i found out myself. thanks Smile | :)

the answer is below:

SELECT datename(dw,getdate())

raj

how can i index the column ??

Mohammed Amine8-May-06 13:12

Mohammed Amine

8-May-06 13:12

Hi everybody
please i want to know how to index a column actualy a foreing key

i have a foreing key who megrate from a table to an other one

but i have to index the foreing key in the second table

is it a possibility to do that in sql server ??

try to be good if you can't be the best

Re: how can i index the column ??

Eric Dahlvang9-May-06 11:25

Eric Dahlvang

9-May-06 11:25

If you want to add a foreign key constraint:

ALTER TABLE dbo.tblForeignTableName
	ADD CONSTRAINT keyConstraintName 
	FOREIGN KEY(fldForeignFieldName) 
	REFERENCES dbo.tblPrimaryTableName(fldPrimaryFieldName) 
	ON UPDATE CASCADE
	ON DELETE CASCADE

----------
There go my people. I must find out where they are going so I can lead them.
- Alexander Ledru-Rollin

date & time can you saparate them ??

Mohammed Amine8-May-06 13:10

Mohammed Amine

8-May-06 13:10

Hi ,
as you know in sql server we have just datetime we don't have date & time

so when i want to recuperate the date of something in ma textbox i recuperate also the time

can you giveme a solution ??

thank you very much

try to be good if you can't be the best

Re: date & time can you saparate them ??

Daniel Santillanes9-May-06 13:10

Daniel Santillanes

9-May-06 13:10

When you recover this value from the database and store it in a datetime variable, you can check the date part by calling:

datevariable.Date;

That's it, well pretty much hehe, this actually returns the date with the time part set to 00:00:00

to put in a text box, you can simply call something like.

datevariable.ToShortString();

or

datevariable.ToString("MM/dd/yyyy");

you should change the formatting as you see fit.

I hope I addressed what you are looking for Unsure | :~

.

daniero

Re: date & time can you saparate them ??

Mohammed Amine10-May-06 4:01

Mohammed Amine

10-May-06 4:01

thnx man , i will try the first because i tried the second before & it dosen't work

thanks a lot

try to be good if you can't be the best

How to Add Two dataSets Data ************* Urgent

Rupesh Shivarkar8-May-06 7:51

Rupesh Shivarkar

8-May-06 7:51

Hello Coders

In my 2.0 Application 2 DataSets. Here 2 DataSets tables are same. Let us assume the first DataSets Table is one, Second DataSet is also having one Table. both tables are same Tables.

DatasetA.table[0].rows.count=1000
DatasetB.table[0].rows.count=0
DatasetB.Tables[0].Merge(DatasetA.Tables[0]);
DatasetA.table[0].rows.count=1000
DatasetB.table[0].rows.count=1000

But i want this changes should be reflected to database table.

Here where i done the Mistake,

<br />
cnn = new SqlConnection("server=figmdtest01;database=CPOPMFigMD04Dev25ACA;uid=CPOPM;pwd=CPOPM");<br />
                cnn.Open();<br />
<br />
                cnn1 = new SqlConnection("server=(local);database=Master;uid=sa;pwd=''");<br />
                cnn1.Open();<br />
<br />
                cmd = new SqlCommand("select PatientProfileId,First,Middle,Last,SSN,Birthdate,Zip,MedicalRecordNumber from cus_FigMD_PatientSearch", cnn);<br />
<br />
                SqlDataAdapter dataAdapt1 = new SqlDataAdapter(cmd);<br />
              <br />
                DataSet ds11 = new DataSet();<br />
                dataAdapt1.Fill(ds11);<br />
<br />
                cmd2 = new SqlCommand("select PatientProfileId,First,Middle,Last,SSN,Birthdate,Zip,MedicalRecordNumber from demo", cnn1);<br />
<br />
                SqlDataAdapter dataAdapt3 = new SqlDataAdapter(cmd2);<br />
<br />
                DataSet ds33 = new DataSet();<br />
                dataAdapt3.Fill(ds33);<br />
                MessageBox.Show(ds33.Tables[0].Rows.Count.ToString()); <br />
                ds33.Tables[0].Merge(ds11.Tables[0]);<br />
                MessageBox.Show(ds33.Tables[0].Rows.Count.ToString()); <br />
                ds33.AcceptChanges();<br />
                MessageBox.Show(ds33.Tables[0].Rows.Count.ToString()); <br />
                //ds33.<br />
                dataAdapt3.S.Update(ds33.Tables[0]);<br />
                MessageBox.Show(ds33.Tables[0].Rows.Count.ToString()); <br />

anybody anysounds, plz help me will be appriciated greatly

regards
Rupesh

MSDE is not running

K. narasimharao7-May-06 18:48

K. narasimharao

7-May-06 18:48

I have installed MSDE software in one machine. it's running fine. Daily i am testing. if's working fine. But two weeks later, when i am trying to start MSSQL Server, It's not running. MSSQL Server immediately turn to off mode. what happened to the software? Please give any suggestions.

knarasimharao

Is it worth learning SQL server 2k now?

CoolAmir7-May-06 13:18

CoolAmir

7-May-06 13:18

Hi guys
The question is simple. Is is worth starting to learn SQL server 2000 now?

I've been programming to retrieve data from databases for a while & i'm currently familiar with the db design concepts & SQL.

Do u think what i learn about SQL 2000 would be of any use for version 2005? Are the changes so drastic to make my SQL 2000 knowledge useless?

Thanx for any tips Smile | :)

Re: Is it worth learning SQL server 2k now?

Rob Graham7-May-06 14:22

Rob Graham

7-May-06 14:22

SQL 2005 builds on the foundation of SQL 7.0 and SQL 2000. Knowlege of an older version will almost always apply to a newer version.

We need to graduate from the ridiculous notion that greed is some kind of elixir for capitalism - it's the downfall of capitalism. Self-interest, maybe, but self-interest run amok does not serve anyone. The core value of conscious capitalism is enlightened self-interest.
Patricia Aburdene

Pass value from dropdownlist to SQL select using SelectedIndexChanged?

FionaDM7-May-06 5:37

FionaDM

7-May-06 5:37

I want to pass a(numerical) value from a dropdownlist to an SQL select using the DropDownList SelectedIndexChanged event.

Here's my code so far.

protected void MyDropDownList_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList MyDropDownList = (DropDownList)("MyDropDownList");
MyLabel.Text = MyDefinitionDropDownList.SelectedItem.Value.ToString();

string strSQL;

strSQL = "SELECT COUNT(*) as count from MyTable where ID= ???";

}

My problem is that I don't know what should replace the '???'. I've tried

strSQL = "SELECT COUNT(*) as count from MyTable where ID= MyLabel.Text";

but this is interpreted as "SELECT COUNT(*) as count from MyTable where ID= MyLabel.Text"
even though my debugger tells me MyLabel.Text is grabbing an OK value.

If I do strSQL = "SELECT COUNT(*) as count from MyTable where ID= 6" for example it works fine.

I think my problem is with casting?

Thanks

Majella

Re: Pass value from dropdownlist to SQL select using SelectedIndexChanged?

Rob Graham7-May-06 6:01

Rob Graham

7-May-06 6:01

try:
strSQL = "SELECT COUNT(*) as count from MyTable where ID=' " + MyLabel.Text + " ' ";

Or better yet use parameters (see Colin Mackay's article here[^]) for reasons and examples.

We need to graduate from the ridiculous notion that greed is some kind of elixir for capitalism - it's the downfall of capitalism. Self-interest, maybe, but self-interest run amok does not serve anyone. The core value of conscious capitalism is enlightened self-interest.
Patricia Aburdene

Re: Pass value from dropdownlist to SQL select using SelectedIndexChanged?

FionaDM7-May-06 22:12

FionaDM

7-May-06 22:12

Thanks.

Majella

sql

naidu nagam7-May-06 0:43

naidu nagam

7-May-06 0:43

how copy a coloumn ? from one table to another table using SQL query

naidu

-- modified at 6:44 Sunday 7th May, 2006

Re: sql

Rob Graham7-May-06 6:18

Rob Graham

7-May-06 6:18

What do you want to do:

copy the data from one column in a database table to a different column in another table?

If so, you need a key field that will have identical values in both tables:

Update t2 set t2.c2 = t1.c1 from t1 where t2.ct2key = t1.ct1key

This specifies that the value in c2 of t2 should be set to the value found in t1.c1 where the rows to use are identified by the field t1.ct1key having a value equal to that in t2.ct2key

If this is *not* what you want, then rephrase your question to be more specific, perhaps including and example so we can understand...

We need to graduate from the ridiculous notion that greed is some kind of elixir for capitalism - it's the downfall of capitalism. Self-interest, maybe, but self-interest run amok does not serve anyone. The core value of conscious capitalism is enlightened self-interest.
Patricia Aburdene

FullTextSearch and Arabic Words

TheEagle6-May-06 22:56

TheEagle

6-May-06 22:56

Hi..

I have used Full Text Search successfuly with English words (through a stored procedure) but when i use it with arabic words like this(in the Sql Analyzer):

DECLARE @HowManyResults int
EXEC SearchProject 'المواقع العامة','ar-SA',@HowManyResults OUTPUT

I get the error:

Server: Msg 7619, Level 16, State 1, Procedure SearchProject, Line 17
Execution of a full-text operation failed. A clause of the query contained only ignored words.

Does any one know how to solve this problem? Cry | :((

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.