|
I have a text column that is greater than 255 characters.
Excel has a problem when I try to move the info around.
|
|
|
|
|
Excel as a reporting tool is a dog, integrating any office product to a database/c# application is always fraught with danger.
Outputting the data to a csv file and manipulating it in excel on the other hand is reasonable.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I write XML and then use XSLT to transform the data (to HTML or CSV).
|
|
|
|
|
Get to know SSRS, theoretically as a DBA it does (sort of) come under database.
It's free and you can use embedded reports if your requirements are simple (if you do not need the full server capability).
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi everyone.
First i want to ask apologize for my english but it isn't my mother language. But i try my best to explain myself. second i already post it in the .Net Framework section at Question & Answers label, but Henry Minute said to post it here because.
My Problem is:
I'm building a project using entity framework. The data base is generate by a edmx(database project). To implement business logic i use stored procedures, but i only con map the to parent entity funcions. I can't map stored procedures to an associated table.
Thanks
|
|
|
|
|
give me your sp
Help people,so poeple can help you.
|
|
|
|
|
Hi,
the problem is not the sp. The problem is i can't map it. I only can map sp to an Entity(stored procedure mapping) that exists in the .edmx file. Ex: sp_insertClient is mapped to the addClient at mapping functions. But imagine that is another table associted with the Client table by a many-to-many association. The intermediate table beetwen them has no entity in the designer model(.edmx file). So, i can not map a sp to that intermediate table.
Best regards
|
|
|
|
|
send your data as an xml to the sp as
SET @Sls_Serial = SCOPE_IDINTITY();
DECLARE @insptr Int;
EXEC sp_xml_preparedocument @insptr OUTPUT, @XML;
INSERT INTO Sales_Head
SELECT
@Sls_Serial_No
FROM OPENXML(@insptr,'<element path>',1)
WITH
(<column> <type> '@<attribute name>');
EXEC sp_xml_removedocument @insptr
Help people,so poeple can help you.
|
|
|
|
|
Guys, I have a situation here.
I have tried to Install SQL Server 2005 on my pc, all the components were installed successfully except the 'Database Engine'.
Any body knows why?
Help people,so poeple can help you.
|
|
|
|
|
What error did it give..?
|
|
|
|
|
|
Does your hardware configuration matches the one needed for the installation of Database Server?
|
|
|
|
|
I guess yes it is.
Help people,so poeple can help you.
|
|
|
|
|
Hey, congrats buddy. You solved you problem on your own. Great thing in it's own. Keep going.
All the Best.
|
|
|
|
|
Did you verify that there was not error when setup scaned your system? Which installation version are you using i.e Express edition, enterprise etc.?
|
|
|
|
|
Sir, I checked the log file carefully and found a the edge of the thread where i can start "Product: MSXML 6 Service Pack 2 -- (KB973686) Configuration failed." so i got redirected to the MSDN, searched for "(KB973686)" and simply fount the solution.
thanks for all who participated in this thread and tried to help me.
100
Help people,so poeple can help you.
modified on Wednesday, February 9, 2011 6:13 PM
|
|
|
|
|
hi all
i am using sqlServer 2008
so how to attach two varbinary(MAX) variables?
@bin3= @bin1 + @bin2
??????
|
|
|
|
|
You mean concatenate them? If so then...
set @bin3= @bin1 + @bin2;
|
|
|
|
|
There is top money to be earned, here and now! I will get straight to the point about this top money-earning program! You can earn top money by becoming as an Employ right now-for only 200$! No experience, no products to han...
http://alturl.com/fca9p
|
|
|
|
|
1) I use vs2010. I want to add a "LOCALE" database to my project. just local not in localserver. connecting vi binding a datagridview works. but connecting vi ado classes (sqlconnection) not work cause wrong connection string. I test many connectionstring even orginal connectionstring that binding use "4 ex: datasource:|datadirectory|\text.sdf" but wrong connection string error occur.
in vs 2008 I had no problem.
2) what kind of database is better to use in simple program: local? or in localhost? after publishig the program will use in another pc. is putting db in localhost is work then?
Thanks,
Sia swar
Baluch
|
|
|
|
|
This[^] site should help you get the right connection string.
siaswar wrote: what kind of database is better to use in simple program: local? or in localhost? after publishig the program will use in another pc. is putting db in localhost is work then?
It depends on how are you going to deploy the application. If the database resides on the client computer, local* should be fine. If the database is going be on another computer, connection string should be likewise. Make sure to configure database to allow remote connections (SQL server surface are coanfiguration will help doing that).
* I have no idea what you mean when you say "local or localhost".
|
|
|
|
|
siaswar wrote: in vs 2008 I had no problem.
You're using Sql Ce by the looks of it. There might be different versions[^] of the SqlCe driver on your system.
siaswar wrote: what kind of database is better to use in simple program: local? or in localhost?
Since SqlCe is serverless, I'm assuming that you're comparing SqlCe and SqlExpress. If you're just going to store some data that could have been in a text-file, go for SqlCe. If you need a real database, go for Express.
I are Troll
|
|
|
|
|
I have simple db with 4 tables: class, book, student and studentbook. studentbook has st_id and book_id as foreign keys and an extra field for result. book has some book for classes. I just insert new students. I'm quite beginner in db and don't know how to fill studentbook. should I fill it (just foreign keys) when filling student table? or it can be automatically? I don't know the routine. I should insert students and result in different times.
Extra information:
I use visual studio 2010 for programming and access 2003 for db. for user-friendly reason I want a datagridview that shows students and result in on table to insert result for each student. I got some success but it's not quite update but inserting action, that my insert two or more rows for a student in studentbook table cause clicking of updating button.
Please any idea or simple code?
Thanks,
Sia swar
Baluch
|
|
|
|
|
siaswar wrote: should I fill it (just foreign keys) when filling student table?
Your data model isn't clear.
I will presume that any one book can only be used by one class. Thus one book is associated with only one class. So your tables and fields would look like the following.
class: class_id, class_name
book: book_id, book_name, class_id
student: student_id, student_name
Students takes classes so there must be a way for a student to be associated to a class. So that gives another table.
student_class_link: student_id, class_id
For this table you would populate it as follows.
1. Create classes - fill class table.
2. Assign books to classes - fill in book table and include appropriate class id.
3. Create students - fill student table
4. Assign students to class - fill in student_class_link table. (It is NOT 'automatic' you must add the values.)
If I want to find what books are associated with which student I do NOT need another table. That is because I can use the following relationship to get the books.
student -> student_class_link -> class -> book
|
|
|
|
|
I don't use class in this manner. I mean grade for classes such class A is for student of 7 years old and class B is for student in age 8. student table has class_id field too. in this way one student can have every book of class like, math, english,... and each book belong to all student in class. so I create studentbook table which has book and student ID and an extra field: RESULT. well student table will be fill by a user of software. afther a long time he/she will import student result which goes in studentbook table.
question is how and when studentbook.st_id and studentbook.book_id should give value. suggest a query and when use the query, when importing the students or when want to import results?!
As you know it's my first database as homework.
Thanks,
Sia swar
Baluch
|
|
|
|