|
hi,
sorry for the delay
i want to help you, will you like to do some application side programming,
if you format your output in vb,C# etc.
its very easy,
but if you not interested in that, let me know, i can send u later
Any systematic work reflects its significance for a long time, Though I m not totally against "The Prototyping".So let's discuss in depth...
|
|
|
|
|
Is there a free/simple SQL tool somewhere that will help me create a SELECT SQL statement at runtime. I perfer the code to be in C#. I'd like to pass some SQL SELECT parameters and have it return a SQL SELECT string.
Thanks
Steve
|
|
|
|
|
String.Format() ?
I think you may need to explain what you are looking for a bit better because I don't quite understand what you want.
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
|
|
|
|
|
Thank You for repling
A need to "Push" a Crystal report with a DataSet.
The user opens a ADO.Net report selection form. The user makes selections on the form for the MS-Acess database report. I roll his selections into a SQL string (SELECT, FROM, WHERE and ORDER BY). Create the C# DataAdapter and DataSet and send the DataSet to the Crystal report (reportDocument()).
I'm looking for a C# class/method that I can pass the user selections to and it returns a SQL string like "SELECT...". Because I'm a non-profit it has to be free.
Hope this helps.
Steve
|
|
|
|
|
The simplest thing I can think of is not far off the String.Format() thing I flippantly suggested already. It looks like you need some code to build your SQL dynamically and a string builder could be used for that. (Remember that a SQL command is just a string that is sent to the database) There is a command builder for building SQL statements in .NET already, but I've never used it - it may have some useful methods that may help build a SQL statement dynamically without exposing you to the risk of SQL Injection Attacks (something you'd have to manage yourself if you were building the command by concatenating strings).
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
|
|
|
|
|
Thanks Colin
Two possible choices to evaluate for on-the fly SQL statements
http://www.easyobjects.net
http://www.reebsoftware.com
I think that command builder is for stored SQL procedures. Also, if you have VS do a Help search for SQL Pane - I think its for Access.
If I have to I'll reduce my report requirements and have 3 or 4 SQl templates and insert the parameters in the preformed SQL string.
string s = "SELECT " + field.text + "FROM " + "....";
Building dynamic SQL statement is an excellent choice for a Code Project code sample. Hope all this helps someone.
Thanks
Steve
|
|
|
|
|
Steve45 wrote: string s = "SELECT " + field.text + "FROM " + "....";
Watch out for things like:
field.text == "''; DELETE "
|
|
|
|
|
I've read the documentation and it says the following:
"This type is safe for multithreaded read operations. You must synchronize any write operations."
Would this mean it is unsafe to read and write at the same time?
I basiacly have a process running in the background that can generate an error set. This error willwill then get dropped into a dataview by my back end web page code.
Will this cause problems in my app when an update to the error report on the front end is called at the same time as the process is recording a new one?
Cheers
Tris
-- modified at 8:36 Friday 23rd December, 2005
|
|
|
|
|
Hi,
Following is my table
id name designation
---------------------------
1 Prakash Des1
2 Prakash Des2
3 Prakash Des3
4 Prakash Des4
5 Sathish Des5
6 Sathish Des6
I want the query which should display the data like following format
id name Des1 Des2 Des3 Des4
------------------------------------------
1 Prakash Des1 Des2 Des3 Des4
Thanks
Warm Regards
Prakash-B
|
|
|
|
|
this is a display problem select doesn't return "rows", it returns records. but most of the time, we reprensent them horizontally, because of the ease of the view.
if you want to display such a thing, you'll have to make the "decomposition" in the displaying job.
[edit]
will that timorous anonymous guy who vote this to '1' ever show off one day...
i persist thinking what i wrote is what to do, and if anybody counter say this, he'll always stay in the dark side of Codeproject, where people act anonymously.
[/edit]
TOXCCT >>> GEII power [toxcct][VisualCalc 2.20][VisualCalc 3.0]
-- modified at 8:07 Friday 23rd December, 2005
|
|
|
|
|
Hi,
Can you guide me how to make a decomposition
Thanks
Warm Regards
Prakash-B
|
|
|
|
|
well, i don't know how you display your data, but here are the hints.
when you get the set of records from SELECT, you then know the number of records returned.
then you can extend your grid depending on that.
but i cannot say more, as i don't know which language you're using, nor your database schema...
but i hope you see the job to do...
TOXCCT >>> GEII power [toxcct][VisualCalc 2.20][VisualCalc 3.0]
|
|
|
|
|
how we use soundprograming in vb.net through the help of data base
|
|
|
|
|
khurramzaidi wrote: how we use soundprograming in vb.net through the help of data base
I don't understand what you want to do? Please can you explain better.
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
|
|
|
|
|
I have a SQL record that contaings <NULL> and now i want to test on it as follows: If Not objConnReader.GetString(4) = "" Then
and got the error : Data is Null. This method or property cannot be called on Null values.
Is this to much straigt thinking.
|
|
|
|
|
Two options
(1) Test against System.DbNull.Value
(2) Use IsDbNull()[^] on the DataReader object.
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
|
|
|
|
|
I thought i had the solution but no. i wrote first:
If Not DBNull(4) Then
'There is a date
Else
'There is no date
End If
But it dit work if there was a date present. The second one was also wrong:
If Not IsDBNull(objConnReader.GetString(4)) Then
'There is a date
Else
'There is no date
End If
This one dint work at all so now i need some help
|
|
|
|
|
I said to use IsDbNull() on the DataReader
Use: myDataReader.IsDbNull(columnOrdinal)
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
|
|
|
|
|
Founf the solution. Have to use the stament:
If IsDBNull(4) Then
This works perfect
|
|
|
|
|
I'm getting a "Failed to open database using..." error when attempting to connect to SQL Server located on a remote machine, using a user account login. Do I need to use a different Account setting? I'm currently using ServiceAccount.LocalSystem.
Marc
VS2005 Tips & Tricks -- contributions welcome!
|
|
|
|
|
just wondering... Does the user account you are using to login to remote DB has right to access to?
<< >>
|
|
|
|
|
If i perform sql query in SQL Server 2000, how can i select a particular range of values returned by query result?
For example if i want top 20 results, i can use the "Select Top 10 ....".
But, suppose I want to select query results from 51 to 60, how can i do it?
Thanks in advance
|
|
|
|
|
For your answer check out this blog entry[^] by Bo Nørgaard[^]
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
|
|
|
|
|
I have this giant stored procedure executing many small queries. In between these queries, i want to be able to return a record or just some number to the record set so that i can update the value for a progress bar in my program. I have the asyncFetch part set when i do an open:
Set mRS = New ADODB.Recordset
mRS.CursorType = adOpenStatic
mRS.CursorLocation = adUseClient
mRS.LockType = adLockBatchOptimistic
mRS.Properties("Initial Fetch Size") = 1
mRS.Open sTmp, gdb, adOpenStatic, adLockBatchOptimistic, adCmdText + adAsyncExecute + adAsyncFetch
I also set up an event in VB to catch the record set's fetch:
Private Sub mRS_FetchProgress(ByVal Progress As Long, ByVal MaxProgress As Long, adStatus As ADODB.EventStatusEnum, ByVal pRecordset As ADODB.Recordset)
Debug.Print "Fetch: " & Progress & _
" Max: " & MaxProgress
End Sub
.. but it never gets there.
-- modified at 20:33 Wednesday 21st December, 2005
|
|
|
|
|
Hi everybody,
I like to asked anyone who is very good at sql to help me display this data in a table format that duplicate headings, subheadings or other columns won't appear twice or more. Can anyone help me? I need to sort them and load them in a Datatable. Loop thorugh all records and display them in a label control created at run time. Thanks in advance.
I have posted this topic on other forums, some solutions given but they are using approach for .Net Framework 2.0, I am using .Net Framework 1.1. I am trying to avoid using a lot of select Distinct sql queries to database and looping the data to be able to remove duplicates. Do anyone knows another approach using less code and less sql access?
Sample Data:
Topics Table
TopicId TopicLevel Topic ParentId
1 1 First 0
2 1 AnotherFirst 0
3 2 Second 1
4 2 AnotherSecond 2
5 3 Third 3
Contents Table
ContentID Heading SubHeading SubSubHeading1 NumberText Names Content1 ParentId
1 How are you? Hello Someone 1 Ben some text 5
2 How are you? Hello Someone 1 John other text 5
3 How are you? Hello Anybody 2 Ben some text 5
4 How are you? Hello Anybody 2 Mike other text 5
5 How are you? Greet Anywhere 1 Ben some text 5
6 How are you? Greet Anywhere 1 Luke some text 5
7 I miss you. Really When null null some text 5
8 I miss you. Really When null null some text 5
Display Format:
How are you?
----------------------------------------------
Hello
-----------------------------------------------
1 Someone
----------------------------------------------
Ben some text
---------------------------------------------
John other text
---------------------------------------------
2 Anybody
---------------------------------------------
Ben some text
---------------------------------------------
Mike other text
--------------------------------------------
Greet
-------------------------------------------------
1 Anywhere
-----------------------------------
Ben some text
-------------------------------------
Luke some text
================================================
I miss you
--------------------------------------------------
Really
------------------------------------------------
When
-----------------------------------------------
some text
----------------------------------------
some text
------------------------------------------
denpsia
-- modified at 19:33 Wednesday 21st December, 2005
|
|
|
|