|
You may want to rename the title of your post. It sounds like you are demanding someone write the query for you. Since this is your first post, I recommend you read the forum guidelines.
__________________
Bob is my homeboy.
|
|
|
|
|
Hi
I am doing an application in which I am using a XML file to populate a datagrid.
In that XML file I have one like.....
<>
1.To generate leads efficiently and profitably.
2.To ensure that all details are collected in one call.
3.To provide email and chat support.
4.To manage Work Basket reports as required.
5.To meet targets for both quantity and quality.
<>
When I am trying to populate this column onto datagrid, all these lines or sentences are getting combine and displaying like a paragraph.
I want to know how to format this column to get them in the a new line
Thank u
Chandu
Thank u
Chandu
|
|
|
|
|
please don't spam the site, choose one forum for your question.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Does anyone know of the procedure, steps that need to be followed to allow installing SQL 2005 Express from a network? Since SQL 2005 express requires .NET 2 and the MSI engine 3.1 and MDAC 2.8 it is a real problem pushing it from a network such as active directory using an AIP (Administrator Installation Point).
|
|
|
|
|
I am required to create a database using Visual Studio with a built in SQL server, to do this i have chosen to make a 'windows application' and not .asp etc. I am creating a Database with 7 tables each containing many PK and FK's. From tutorials that i have currently done the only way to get a forgien to to relate to a primary key correctly seems very basic and not suited for tables that have many rows.
At the moment the only way i know how to do it is by creating another row (in the secondary table) which will be used as the forgein key. Then call this row the same name as the primary key from the wanted table. from there i have to manually assign the FKid value by ensuring it is the same as the unquie identifier PK from the other table.
Surely this is not the correct way to do it as once the database grows, manually entering the FK ID for seven different tables would be a issue.
How can i get the table to automatically gain the FK from a different table?
Sorry if my description seems a bit vague as im still learning many ropes.
Many thanks for any help provide, as u can see its well needed 
Cass
|
|
|
|
|
You need to use relationships. This will eliminate the second table.
The only way to speed up a Macintosh computer is at 9.8 m/sec/sec.
|
|
|
|
|
I have created relationships using datasets and database diagrams..is there more i need to do?
Do you have any sites that have tutorial on setting up these relationships ?
Thanks
|
|
|
|
|
Hi All
I need to add my Project logo to the user interface of SSRS2005. How can I do this?
Regards
|
|
|
|
|
It's been a while since I've done reporting services work, but I beleive there is an image control that you can add to the UI.
topcoderjax - Remember, Google is your friend.
|
|
|
|
|
I'll Have alook
Thanx
Progress is a process , so value it
|
|
|
|
|
No
What I want to do is to change the folder image on the report server web site to my Company image
Regars
Progress is a process , so value it
|
|
|
|
|
Hi
I am doing an application in which I am using a XML file to populate a datagrid.
In that XML file I have one like.....
<>
1.To generate leads efficiently and profitably.
2.To ensure that all details are collected in one call.
3.To provide email and chat support.
4.To manage Work Basket reports as required.
5.To meet targets for both quantity and quality.
<>
When I am trying to populate this column onto datagrid, all these lines or sentences are getting combine and displaying like a paragraph.
I want to know how to format this column to get them in the a new line
Thank u
Chandu
|
|
|
|
|
I am not totally sure how you are working with your xml, but usually there is a property called white space presever or something like that.
Check out this link:
http://msdn2.microsoft.com/en-us/library/6f00zs65(vs.71).aspx[^]
Once that value is set you should just be able to do a:
Environment.NewLine or Char(13)Char(10)
Hope that helps.
Ben
|
|
|
|
|
hi
IS there any way to optimize a stored procedure for quick data retrival..
please help me
thanks in advance..
pradip kishore
|
|
|
|
|
Yes, there is. Optimization with a stored procedure, like all other optimizations, is different for each procedure. Make sure you don't do anything unnessesary and that you don't pull the same information multiple times unless you have to. There might be some useful tools, try a google search on that.
The only way to speed up a Macintosh computer is at 9.8 m/sec/sec.
|
|
|
|
|
Dear
Used Minimum,Temporary table, Minmum Joins, It will be optimize ur query
|
|
|
|
|
Hi,
I'm using VC++ to connect to a SQL Server. At first there was no problem.
But the program has grown and there are now 13 threads accessing the database.
Some too retrieve the data they need, while others put there data in it.
My question is the following: What is the best way to let this work?
a. use a single connection by all threads.
b. let every thread make its own connection.
c. some other solution ...
Can solution (a) give problems when using the same connection pointer in multiple threads.
Solution (b) seems logical but further investigation showed that u must make sure that there are enough concurrent user session on the SQL server. But does that mean that you need 13 CAL's or can you use a single CAL for the whole applications. I can't seem to find any answer to that question?
Thanks in advance
Kurt Pattyn
codito ergo sum
|
|
|
|
|
Hi there,
Well I am starting to wade into the world of SQL however, I am stuck with a problem. At the moment I have two tables, product table and supplier table. In the product table I have a foreign key called supplierID which is the primary key of the supplier table. Using MS Access I have created a relationship between these two tables graphically, i.e. one to many relationship.
My problem is that I am trying to delete the supplierID column from the product table using queries.My problem is that I am not being allowed to delete the column supplierID from the product table due to an error:
"Cannont delete field 'supplierID'. It is part of one or more relationships".
My deletion query:
ALTER TABLE product DROP COLUMN supplierID
My question is how do i delete the existing relationship between the two tables I had created graphically ?
Any help will be highly appreciated.
thanks
EDIT:
I am interested in finding out how to delete the relationship programmatically 
|
|
|
|
|
Try
ALTER TABLE tblname DROP CONSTRAINT constraintname
topcoderjax - Remember, Google is your friend.
|
|
|
|
|
thanks for your reply. After looking at your response I realised I made Homer mistake in writing up initial post, doh!!!. The query you stated I already know.
What I meant to ask was how do you determine the name of the relationship between two tables programmatically?
|
|
|
|
|
Hallo
You can't delete the column because as you said it is part of a foreign key constraint. In MS SQL 2K you can drop this column programmatically by first dropping the foreign key constraint. Access, however, does not appear to give the relationship constraint a name and therefore you can't drop it. As far as I can tell your best option is to use MS SQL 2K instead.
There are 10 types of people in the world, those who understand binary and those who dont.
|
|
|
|
|
well I managed to workout a dirty hack that does the job. To remove the foreign key constraint from the table we need to determine the name of the relationship this is achieved by viewing the msysrelationship table. If you are in MS Access and enable the ability to view hidden objects and tables you will be able to view the msysrelationship table.
The msysrelationship table maintains relationship names as nameoftable1nameoftable2 i.e. if one table was product and the other was supplier then then relationship will productsupplier.
As long as you can access the msysrelationship table you are pretty much set. Then delete the relationship then drop the column easy!!!
|
|
|
|
|
I am new to asp.net 2.0 and i am badly confuse....Any help which can point me in a correct direction...
When we should use SqlDataSource and when we should ado.net datareader etc...What are the criteria to choose.....
Please help...
Amit
Amy
|
|
|
|
|
The SqlDataSource control allows a developer to access data stored in any relational database that supports ADO.NET. It can use the System.Data.SqlClient provider to access a SQL Server database, the System.Data.OleDb provider, the System.Data.Odbc provider, or the System.Data.OracleClient provider to access Oracle. Therefore, the SqlDataSource is certainly not only used for accessing data in a SQL Server database.
In order to use the SqlDataSource, you simply provide a value for the ConnectionString property and specify a SQL command or stored procedure. The SqlDataSource control takes care of working with the underlying ADO.NET architecture. It opens the connection, queries the data source or executes the stored procedure, returns the data, and then closes the connection for you.
Regards,
Satips.
|
|
|
|
|
Thanks...But when we should go for SQL DataSource option vs command/datareader/dataset in real world...
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
