data access that apply for and data source - Database Discussion Boards

First Prev Next

Re: DataGridview ???

sudhakar_vaddepalli4-Apr-07 19:40

sudhakar_vaddepalli

4-Apr-07 19:40

hi,

it is for blank space of Grid view n't for grid rows.

what i said & what u want is same.give the height to td tag of html designer or web page where u kept the Grid view tag like below

height="Some height">
Grid View control ...................................

i think now u will get it.

SQL Server 2005 - Get list of queries ran

Brent Lamborn3-Apr-07 5:25

Brent Lamborn

3-Apr-07 5:25

Can anyone tell me the best way to get a list of all the queries ran against a particular database on my server? I don't need queries ran against System Tables only the tables I've defined. As mention in the subject, it's SQL Server 2005. I've ssearched the Web as well as help files but apparently I'm not using the correct keywords in my search as I haven't found anything.

"Half this game is ninety percent mental." - Yogi Berra

If you can read thank a teacher, if you can read in English, thank a Marine.

Re: SQL Server 2005 - Get list of queries ran

kubben3-Apr-07 6:06

kubben

3-Apr-07 6:06

I would get a good sql log file parser. There are some good tools out there. The information you want is only in the log files.

Hope that helps.
Ben

Re: SQL Server 2005 - Get list of queries ran

Brent Lamborn3-Apr-07 6:13

Brent Lamborn

3-Apr-07 6:13

Ok, I'll try that, but I also thought SQL Server 2005 has a lot of new statisitcs and usage reporting built in?

"Half this game is ninety percent mental." - Yogi Berra

If you can read thank a teacher, if you can read in English, thank a Marine.

Re: SQL Server 2005 - Get list of queries ran

Jaiprakash M Bankolli3-Apr-07 7:40

Jaiprakash M Bankolli

3-Apr-07 7:40

I would suggest use SQL profiler tool, and start the session. That will record all the queries that are running on the DB.

Hope that solves your problem

Regards,
Jaiprakash M Bankolli
jaiprakash.bankolli@gmail.com

update query

jds12073-Apr-07 5:00

jds1207

3-Apr-07 5:00

I am trying to run an update query in vb.net using MySQL back end but I keep getting the following syntax error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' OrderItemSource = 'MD' , OrderType = 'Ron Ayers MotorSports'' at line 1

Here is my code:

Private Sub UpdatePrice(ByVal PartNum As String, ByVal PartRetailPrice As String, ByVal PartSalePrice As String, ByVal PartSource As String)

Dim myConnString As String = My.Settings.ConnectionString
Dim MyConnection As New MySqlConnection(myConnString)
MyConnection.Open()
Dim MyCommand As New MySqlCommand("UPDATE ls_orderitems SET OrderItemRetailPrice = '" & Trim(PartRetailPrice) & "', OrderItemSalePrice = '" & Trim(PartSalePrice) & "' WHERE OrderItemPartNum = '" & Trim(PartNum) & "', OrderItemSource = '" & Trim(PartSource) & "', OrderType = 'Ron Ayers MotorSports'")

MyCommand.Connection = MyConnection
MyCommand.ExecuteNonQuery()
MyConnection.Close()
End Sub

Any suggestions would be greatly appreciated.

jds1207

Re: update query

kubben3-Apr-07 5:15

kubben

3-Apr-07 5:15

Your where clause is the problem you have:
WHERE OrderItemPartNum = '" & Trim(PartNum) & "', OrderItemSource = '" & Trim(PartSource) & "', OrderType = 'Ron Ayers MotorSports'")
should be:
WHERE OrderItemPartNum = '" & Trim(PartNum) & "'And OrderItemSource = '" & Trim(PartSource) & "'And OrderType = 'Ron Ayers MotorSports'")

Hope that helps.

Ben

data access that apply for and data source

Hassan Amaar3-Apr-07 2:26

Hassan Amaar

3-Apr-07 2:26

Hi all,
I am developing an asp.net application and i want to develop data access layer that is applicable for any data source type for example(sql server orcle).
is there any one have an idea about implementing this data layer without using oldbe connection.
it is important to say that i don't use any stored procedure ,I am dealing with database at run time using .net without any stored procedure or functions.
I will be gratefull if anyone can help me with this issue
Best regards,
Hassan Amaar.

Hassan Amaar

Re: data access that apply for and data source

Pete O'Hanlon3-Apr-07 2:39

Pete O'Hanlon

3-Apr-07 2:39

If you are dealing with multiple sources, you need to consider using the Factory pattern. Fortunately for you, MS has spent a lot of time and money extracting the interfaces out into relevant factories. This article is a small starting point for you: http://davidhayden.com/blog/dave/archive/2006/04/04/2900.aspx[^]

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

Re: data access that apply for and data source

Hassan Amaar3-Apr-07 4:26

Hassan Amaar

3-Apr-07 4:26

Thanks alot I do appreciate your help

Hassan Amaar

Re: data access that apply for and data source

Pete O'Hanlon3-Apr-07 4:42

Pete O'Hanlon

3-Apr-07 4:42

Not a problem. I'm glad to help with questions like this.

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

Merge 3 datatables into 1 data table

steve_rm2-Apr-07 23:14

steve_rm

2-Apr-07 23:14

Hello,

I have one data table with fields SerialNo, manufacturer, and model. Called AllParts.
Hello,

VS 2005

I have 3 other data tables (software, components, equipment) that have those same fields plus some extra fields.

I want to fill this allParts with the serialNo, manufacturer, and model from the other tables.

So allParts will contain rows from software, components, equipment

a bit like copying all the contents from the 3 tables and merging them into a single data table called allParts.

Can anyone help me with this.

Many thanks,

Steve

Re: Merge 3 datatables into 1 data table

Paddy Boyd3-Apr-07 1:15

Paddy Boyd

3-Apr-07 1:15

You could create AllParts as a view and then UNION the data from your three tables into here.

Re: Merge 3 datatables into 1 data table

Vinay Dornala3-Apr-07 1:59

Vinay Dornala

3-Apr-07 1:59

hi see this link u will get an idea
http://www.vbdotnetheaven.com/UploadFile/gulatisa/MergeTables11272006232307PM/MergeTables.aspx
DataSet dsContract = new DataSet();

DataSet dsMergedContract = new DataSet();

Database db = DatabaseFactory.CreateDatabase();

string sqlCommand = "usp_getContracts";

DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);

db.AddInParameter(dbCommand, "UWYear", DbType.Int32, UWYear);

db.LoadDataSet(dbCommand, dsContract, "ContractDetail");

dsMergedContract.Tables.Add("ContractDetail");

for (int i = 0; i < dsContract.Tables.Count; i++)

{

dsMergedContract.Tables["ContractDetail"].Merge(dsContract.Tables[i]);

}

return dsMergedContract

Re: Merge 3 datatables into 1 data table

Jaiprakash M Bankolli3-Apr-07 7:45

Jaiprakash M Bankolli

3-Apr-07 7:45

If this is just done at the run time and only resultset is required, then I would suggest create an stored procedure which does the following

1. Create a temp table in SP
2. fill this table one by one with the required information
3. execute a select query on this temp table

Hope this solves your purpose

Regards,
Jaiprakash M Bankolli
jaiprakash.bankolli@gmail.com

Merging multiple columns into one

Alex Feature2-Apr-07 22:09

Alex Feature

2-Apr-07 22:09

hello guys.

i have a question i was hoping someone would be able to help me with. here is my problem:

i have a database with 3 tables, one called CustomerInfo, one called Invoices, and one called CreditNotes. when i link and join the three together i get a new table that has (and looks something like) this:
(please ignore the dashes, they are only used to preserve spacing)

CustomerID CustomerName TransactionType InvoiceValue CreditNoteValue
-----1----------John----------Invoice----------100--------------------
-----2----------Jane--------CreditNote-----------------------200------

what i was wondering is if it is possible to query the DB to get something like this:

CustomerID CustomerName TransactionType Value
----1----------John----------Invoice-------100
----2----------Jane---------CreditNote-----200

the idea is that i would like to merge the two columns (invoice & credit note together) into one Value column. since it is never possible for a TransactionType that is an Invoice to have a value in the CreditNoteValue field or a TransactionType that is a CreditNote to have a value in the InvoiceValue field, there is no possibility of a clash in the Value field (by clash i mean having values for both InvoiceValue and CreditNoteValue and not knowing which one to put in the Value field).

so, if this has made any sense to anyone, can it be done? i also understand that it may not be possible to do in one step and may require multiple sql queries or intermediate tables.

thanking you all in advance for your time. hope to hear from someone soon... Smile | :)

kind regards, Alex.

"All your base are belong to us..."

- The Nameless One (2110 A.D.)

Re: Merging multiple columns into one

Paddy Boyd2-Apr-07 22:50

Paddy Boyd

2-Apr-07 22:50

Try this:

SELECT CustomerID, CustomerName, TransactionType,
     CASE TransactionType WHEN 'Invoice' THEN InvoiceValue
     ELSE CreditNoteValue
     END AS Value
FROM CustomerTable

Re: Merging multiple columns into one

Pete O'Hanlon2-Apr-07 23:33

Pete O'Hanlon

2-Apr-07 23:33

If the InvoiceValue and CreditNoteValue fields are nullable, you could always do this:

SELECT CustomerID, CustomerName, TransactionType,
  COALESCE(InvoiceValue, CreditNoteValue, 0)
FROM
  ...

Coalesce looks for the first non-null value, so if InvoiceValue is null it picks up CreditNoteValue. If both are null, it falls back to printing 0.

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

Re: Merging multiple columns into one

Jaiprakash M Bankolli3-Apr-07 7:49

Jaiprakash M Bankolli

3-Apr-07 7:49

Is this feature Coalesce available in MS SQL 2005? I though it is available only in oracle ....

Regards,
Jaiprakash M Bankolli
jaiprakash.bankolli@gmail.com

Re: Merging multiple columns into one

Pete O'Hanlon4-Apr-07 2:47

Pete O'Hanlon

4-Apr-07 2:47

Jaiprakash M Bankolli wrote:
Is this feature Coalesce available in MS SQL 2005? I though it is available only in oracle ....

Nope - it's in SQL Server as well. Has been since 2000.

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

Re: Merging multiple columns into one

Frank Kerrigan5-Apr-07 3:03

Frank Kerrigan

5-Apr-07 3:03

Its in every version of SQL server I believe. Certainly in 2000

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

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

.NET

v s m subramanyam k2-Apr-07 21:06

v s m subramanyam k

2-Apr-07 21:06

How to populate data in Excel sheet from database.

Re: .NET

Pete O'Hanlon2-Apr-07 23:30

Pete O'Hanlon

2-Apr-07 23:30

Now, repeat after me. "Google is my friend. Google has the answer. I have Googled it and found the following." Clickety[^]

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

Re: .NET

Paul Conrad3-Apr-07 18:04

Paul Conrad

3-Apr-07 18:04

Pete O'Hanlon wrote:
repeat after me. "Google is my friend. Google has the answer. I have Googled it and found the following."

Very good

Query

Devkranth Kishore Vanja2-Apr-07 21:05

Devkranth Kishore Vanja

2-Apr-07 21:05

Hi

I have an sql Query to select 2 different date.. "select * from offerdate >= '31/02/2006' and offerdate <= '04/04/2007' " ... this query does not take the TO date (04/04/2007)

if i give the next day date the '05/04/2007' then it is taken....
help ....

thanks in advance

Last Visit: 31-Dec-99 18:00 Last Update: 13-May-24 23:18

Refresh

ᐊ Prev 1...1611 1612 1613 161416151616 1617 1618 1619 1620 Next ᐅ

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