Help for select statement - Database Discussion Boards

Re: System.OverflowException for large Decimal value

Uwe Keim14-Jul-07 20:15

14-Jul-07 20:15

Feedback: When using the ReturnProviderSpecificTypes (setting it to true), I succeeded.

I can do the conversion from the SqlXxx data types (e.g. SqlDecimal) to native CLR data types be myself, and not let it ADO.NET do it automatically.

Thanks for your help!

--
• Zeta Producer Desktop CMS
Intuitive, completely easy-to-use CMS for Windows.

• Zeta Helpdesk
Open Source ticket software for Windows and web.

• Zeta Uploader
Easily send large files by e-mail. Windows and web client.

• Desargues
Innovative, lean and neat calculator for Windows.

using datagrid in vb.net

Rharzkie13-Jul-07 23:16

Rharzkie

13-Jul-07 23:16

hi! i just wanna ask if it is possible for a datagrid to view some of the contents of a database, then another contents afterwards???

for example, I click the search button to search a particular school subjects. E.g. i search for subject "Theology", then all students who enroll in "theology" should be display, then i will going to search the subject "college algebra", all the students who enrolled in that will be viewed???

What code i will going to use there? will i use the OleDbDataAdapter??? If not, what should i do for it????

Re: using datagrid in vb.net

Manas Bhardwaj14-Jul-07 4:49

Manas Bhardwaj

14-Jul-07 4:49

Use dataview and thn set rowfilter to narrow down the result

Re: using datagrid in vb.net [modified]

Rharzkie14-Jul-07 20:23

Rharzkie

14-Jul-07 20:23

ok, i already know how, I saw the process and the codes in the internet...i used the "DISTINCT" in the query builder in Data Configuration Wizard... Then i put this codes in the search button:

OleDbDataAdapter2.SelectCommand.Parameters("subject").Value = ComboBox1.Text<br />
        DataSet21.Clear()<br />
        OleDbDataAdapter2.Fill(DataSet21)

but how, if i will going to put the codes in the combobox? Because what i want is if i will going to select a subject in the combobox, the students who enroll in that subject will automatically displayed in the datagrid without clicking the search button... Where i will going to put the codes above?

-- modified at 2:31 Sunday 15th July, 2007

Re: using datagrid in vb.net

TomGarth15-Jul-07 9:05

TomGarth

15-Jul-07 9:05

First of all, do yourself a favor and dump the DataGrid and use the DataGridView. You will be much happier with the added flexibility it has. Either way you can reset the contents by changing the DataSource, preferably to a DataView object.

Tom Garth
Developer
R. L. Nelson and Associates, Inc., Virginia

recover a database in sql 2005 server

prasadbuddhika13-Jul-07 22:54

prasadbuddhika

13-Jul-07 22:54

I created a db in as a dummy in sql 2005 and set the recover as full.But I want to know when there is a problem with the db how to recover.
I have backed up it also. Big Grin | :-D

Re: recover a database in sql 2005 server

Mike Dimmick14-Jul-07 5:53

Mike Dimmick

14-Jul-07 5:53

See my comment here[^].

Stability. What an interesting concept. -- Chris Maunder

Help for select statement

Prakash_Mishra13-Jul-07 22:29

Prakash_Mishra

13-Jul-07 22:29

Hi ALL
In my application i wrote a query like this
"select * from Cand_Information where Category= '" & DpCat.SelectedItem.Text & "' or (First_Name= '" & TxtFname.Text & "' or Last_Name= '" & TxtLname.Text & "' or Sex= '" & DpdownSex.SelectedItem.Text & "' )"

But i want the Category field to be mandatory so i kept it outside the bracket. so that it should only display data with that particular Category. so rest of the fields are optional.
How to write the correct one pl help
Regards

Prakash Mishra(Banglore,India)

Re: Help for select statement

kubben14-Jul-07 1:22

kubben

14-Jul-07 1:22

Change the or to an and

"select * from Cand_Information where Category= '" & DpCat.SelectedItem.Text & "' and (First_Name= '" & TxtFname.Text & "' or Last_Name= '" & TxtLname.Text & "' or Sex= '" & DpdownSex.SelectedItem.Text & "' )"

Ben

Re: Help for select statement

Prakash_Mishra14-Jul-07 1:37

Prakash_Mishra

14-Jul-07 1:37

HI
i tried it before also but according to specification if i select only Category then also records should be displayed. if i put and there then i need to select at least one field from the or options. else it not show any record.
Regards

Prakash Mishra(Banglore,India)

Re: Help for select statement

Arun.Immanuel14-Jul-07 2:37

Arun.Immanuel

14-Jul-07 2:37

Try this:

<code>string optionalFiters="";

if(TxtFname.Text!="")
  optionalFiters+="  and First_Name= '" & TxtFname.Text + "'";

if(TxtLname.Text!="")
  optionalFiters+="  and Last_Name= '" & TxtLname.Text + "'";

if(DpdownSex.SelectedItem.Text!="")
  optionalFiters+="  and Sex= '" & DpdownSex.SelectedItem.Text + "'";
</code>
Query:

<code>"select * from Cand_Information where Category= '" & DpCat.SelectedItem.Text & "'" & optionalFiters
</code>

Regards,
Arun Kumar.A

Insert

pmartike13-Jul-07 21:09

pmartike

13-Jul-07 21:09

Please tell me how to insert a string like this: SAMPLE'STRING into an SQL table? How escape special characters in MSSQL?

Thank you.

--------------------------------
visit: http://pmartike.deviantart.com/

Re: Insert

pmartike13-Jul-07 22:17

pmartike

13-Jul-07 22:17

Problem solved Big Grin | :-D

--------------------------------
visit: http://pmartike.deviantart.com/

Classic ASP and MS SQL Express Edition

Fayu13-Jul-07 6:06

Fayu

13-Jul-07 6:06

I have a Classic ASP website and i want to use MS SQL Express edition as the datasource. I tried the .NET Connectionstring and they do not work for the Classic ASP (ADO) site. I have tried figuring this out for the last three days. PLEASE HELP! Thanks in advance.

Re: Classic ASP and MS SQL Express Edition

Paul Conrad13-Jul-07 6:11

Paul Conrad

13-Jul-07 6:11

What kind of messages are you getting, if any?

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

Re: Classic ASP and MS SQL Express Edition

Fayu13-Jul-07 6:24

Fayu

13-Jul-07 6:24

Here is the connection string im using:
Data Source=.\SQLEXPRESS; Integrated Security=True;AttachDbFilename=|DataDirectory|\MyDatabase.mdf;Initial Catalog=MyDatabase

This is the error:
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

Re: Classic ASP and MS SQL Express Edition

Dave Kreskowiak13-Jul-07 6:19

Dave Kreskowiak

13-Jul-07 6:19

ConnectionString.com[^]. Look under "SQL Native Client OLE DB Provider" for your situation.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Re: Classic ASP and MS SQL Express Edition

Fayu13-Jul-07 6:34

Fayu

13-Jul-07 6:34

Okay I changed my ConnectionString to:
Provider=SQLNCLI;Server=localhost\SQLExpress;Database=data.mdf;

I now get a new Error:
Invalid authorization specification.

I do not have a username or password on the file. Now what??

Re: Classic ASP and MS SQL Express Edition

Dave Kreskowiak13-Jul-07 8:55

Dave Kreskowiak

13-Jul-07 8:55

It should be:

Provider=SQLNCLI;Server=.\SQLExpress;AttachDbFilename=FullyQualifiedPathToDBFile.mdf;Database=dbname;Trusted_Connection=Yes;"

This will only work for code executed server-side. It won't work for client-side code.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Re: Classic ASP and MS SQL Express Edition

Fayu16-Jul-07 12:50

Fayu

16-Jul-07 12:50

This CS did the trick. Thanks

DO NOT CROSSPOST

leckey13-Jul-07 7:05

leckey

13-Jul-07 7:05

please read the forum guidelines.

_____________________________________________
Flea Market! It's just like...it's just like...A MINI-MALL!

Re: DO NOT CROSSPOST

Paul Conrad13-Jul-07 11:46

Paul Conrad

13-Jul-07 11:46

Dang. You beat me to it. Just saw the cross post in the other forum and wondered where I saw it before.

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

Re: DO NOT CROSSPOST

Sathesh Sakthivel13-Jul-07 16:21

Sathesh Sakthivel

13-Jul-07 16:21

leckey wrote:
Flea Market! It's just like...it's just like...A MINI-MALL!

What happened to cats and awesome.

Regards,

Satips. Rose | [Rose]

Don't walk in front of me, I may not follow;
Don't walk behind me, I may not lead;
Walk beside me, and just be my friend. - Albert Camus

How to create hash clustered index in oracle?

Mushtaque Nizamani12-Jul-07 23:53

Mushtaque Nizamani

12-Jul-07 23:53

Hi,
How can i create hash clustered index in oracle?

Best Regards,
Mushq

Mushtaque Ahmed Nizamani
Software Engineer
Ultimus Pakistan

"English is my second language, so please don't mind if i do some grammatical or spelling mistakes in my messages."

Re: How to create hash clustered index in oracle?

Paul Conrad13-Jul-07 11:49

Paul Conrad

13-Jul-07 11:49

Have you looked around in the Oracle forums?

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

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