How to get the IST (Indian Standard Time) word from MS SQL Server if SQL servers culture is Indian and same for PDT (Pacific Date Time), i got to able to get the TimeZone using SELECT DATENAME (TZoffset,SYSDATETIMEOffset()) this but now need to convert this zone to "IST" to "PDT"
View 9 Repliesi have a feild in database where we store data like
wrkcmt
------
PTPT4
PTPR3
PTPD2
i want only first to word to show in textbox1 like(only PT).
i want to save afile(word or pdf) to database table and allow user to download itStored Procedure
alter procedure addAttachments
(
@ENo varchar(6),
@CID nvarchar(7),
@ATT image,
@Date nvarchar(50),
[code]...
I am developing the Home page of a Client. Apart from various things on this home page I have a text box and search button. Having said that, I have a database in which I have almost 12 tables with varying number of columns. Now my question is,Is there anyway to search a word typed by a user in the textbox to search it in all the tables(all columns) of the database.
View 2 RepliesI am Generating a Word Document by using Following Code:
StringBuilder str1HTMLContent = new StringBuilder();
str1HTMLContent.Append("<html>".ToString());
str1HTMLContent.Append("<body>".ToString()); [code]....
The word file is Created and popup on windows .How can i save this created word Document on Database, or on server folder?
I want to know how to upload Word, PDF and Excel documents to SQL Server database in ASP.Net
View 1 RepliesHow to download a word document which is stored in database, sql server as a content data through C#? This is my Code I'm using:
string doctype = dtResumeInfo.Rows[0]["ContentType"].ToString();
string docname = dtResumeInfo.Rows[0]["FileName"].ToString();
//[code]....
But, it is showing the following error:SubStatusCode 'Response.SubStatusCode' threw an exception of type 'System.PlatformNotSupportedException'
base {"This operation requires IIS integrated pipeline mode."} System.NotSupportedException {System.PlatformNotSupportedException}
Headers 'Response.Headers' threw an exception of type 'System.PlatformNotSupportedException'
My IIS version is 6.0 where I published. Donwloading word document can be done only in IIS 7. So, this is the cause of the error. Is there any other way to overcome this problem? Any other code will support lower version??
I have a local database which is updated regularly. Now I need a good way to reflect the local database changes into the remote sql server. Both the server have same database structure.
All the above pocess should work automatically from the local database server because I need to update the remote one so that the website visitor can get the updated results in the morning.I need a detailed description/ procedure to accomplish the work.
This issues has been driving me nuts. I am trying to follow the tutorial on [URL] I am trying to connect to a database in Microsoft SQL Server 2008. The way I do this is by right clicking on the "Data Connections" > Add Connection. Afterwards the Add Connection window comes up, I make sure my data source is "Microsoft SQL Server (SqlClient). And, I choose a server name; the only server I can choose is DomainSQLEXPRESS. The issue is when I go down to the "Select or enter a database name" drop down box, I do not see my database listed. I have also made sure in the SQL Server Management Studio that I have given my user all the privileges for the database. I know my explanation is kind of vague, but would anyone know the reason why I would not see my database?
View 3 RepliesI want to convert sql server 2000 database into sql server 2005 database. I am using sql server 2005 express.
I am trying by taking backup/Restore method, but it not work.
I have text box and submit button in my page and I have 2 table 1- WORD table 2-name table in database
when I click on submit button it insert textbox.text in database in Name table
I define some word in my word table like:
Bad
Worst
badly and other words
Now I want if users enter word's that is in Word table when they click on submit button it replace that word with this word-->"GOOD"
How I can do it?
I have QuestionTable.
ID Question Answer1 Answer2 Answer3 Answer4
But I want import from MS Word into table. I have question like this:
Question: @1.The capital of India.
Answer:$A) Dushanbe;$B) Moscow;$C) Delhi;$D) Kabul;
@2.The capital of Tajikistan.
$A) Dushanbe;$B) Moscow;$C) Delhi;$D) Kabul;
@3.The capital of Afganistan.
$A) Dushanbe;$B) Moscow;$C) Delhi;$D) Kabul;
Output result:
ID Question Answer1 Answer2 Answer3 Answer4
1 1.The capital of India. A) Dushanbe; B) Moscow; C) Delhi; D) Kabul;
I used SQL SERVER 2008 R2 express as my web development database and I set its compatibility level to 2005. Unfortunately this database cannot be be attached to SQL server 2005. Are there any other options?
View 3 RepliesI am not that good in SQL syntax and need some help. I am trying to create some search functionality for my website. Basically it just has to search for product names. Now I have a simple statement like SELECT * FROM Products WHERE ProductName LIKE '%' + @ProdName + '%' This statement does not fit to my requirements.I have 2 issues:
1. Assuming someone searches for "blocks". The result that I get is product names with the word "blocks" in it, however I would also like to display results with product names the have the word "block" in it i.e without the "s" In short I want to match the possible product names from the keyword e.g block, blocks, blocking etc I dont want it to search the exact name but may be just partially. If the keyword contains the exact word from the product name, well and good but it should also display the products where the keyword is partially matching.
2. Assuming someone searches for the words "concrete blocks". I get the result with products that have the words "concrete blocks" only. But I would also like to get the result with say "Louvre Blocks" in the total results displayed.So can someone kindly help me sort out my issues. Sorry if im repeating words but im just trying to make an understandable point.
Need to do a mail merge for ASP.NET application. Considered just programatically using word directly but this has liscening implications and is not recommended [URL] So was looking into openXML / Word Automation Services. But not sure if can easily achieve a mail merge via this?
View 1 RepliesHow can I store a word document using an upload control in sql server? Also is there a better way to store a word document without using an upload control
View 7 RepliesHow To Store Word Document in Sql Server
View 3 Replieshow do i import whatever is in a word document(including bullets and tables and images) into sql server
View 2 RepliesI have an asp.net app that uses a SQL Server 2005 database to store word documents. One of the application requirements is that when a user clicks a button, the system retrieves some number of word documents from the db, zips them up in memory and allows the user to save the zip file to disk.
Is there a zip library that provides the ability to zip up files in memory? The few that I've seen read from the file system.
how to display the word document which is binary document which is stored in database?
View 2 RepliesI would like to generate word reports on the web server. My web host does not have office installed, and from what I've read it´s not recommended to use word on the server.
Now, I just recently found this out, and I more or less counted on the reporting stuff being quite simple to set up.
This is what I need.
The user logs in and uploads data, changes it, calculates it and so on. When this is done he will need to generate a report, although preferably in a format he can edit (like maybe adding a comment or a logo or whatever).
How do I do this? This really needs to look professional so features like page breaks and other kinds of formatting is needed.
It is sufficient if the document is generated and not opened on the server. I think I can require the user to have office installed locally in order to actually open the document and maybe print it. But the content must be generated from the sql database.
I am trying to open a Word document from a .Net web application. The code (in brief) contains ...
using Word = Microsoft.Office.Interop.Word;
using System.Reflection;and, the code that actually creates the document includes:
object oMissing = System.Reflection.Missing.Value;
object oEndOfDoc = "\endofdoc"; // endofdoc is a predefined bookmark [code]......
which suggests something wrong with the bookmarks. So I took references to the bookmarks out and started using a file called Hello.doc as my template. No bookmarks - just the word 'hello' in it.This fell over too - but the StackTrace indicated it was when SaveAs was called.So, the question is ... why does it work on my development box but not on the server. The server has Word installed on it.
I created a web application in which I am generating a ms-word document using Microsoft.Office.Interop.Word dll. The application is running fine in the visual studio but when I tried to run on IIS 5.0 through virtual directory then its giving the following error -
Retrieving the COM class factory for component with CLSID {000209FF-0000-0000-C000-000000000046} failed due to the following error: 80070005.
In my application I have taken reference of Microsoft Word 12.0 Object Library, but its coming as Microsoft.Office.Interop.Word dll, this interop dll is just a wrapper of the actual word COM dll. But I have to register the actual word COM dll. so my problem is to find -
1) The path of the original word dll(COM)
2) How to register this dll, either using regsvr32 or to register on IIS.
How to print PDF/Word in server side?
View 4 RepliesWe have an app that hits a database, pulls back the data and puts it into the correct labels, etc on a web page, then opens it as a word document. Testing locally and on our test servers, everything works, but not on production. On production, the window starts to open, the document is never actually generated (so you see an empty window opening), then the window quickly closes.
We're using a javascript function window.open to open the document. The user clicks a command button to view the data as a word document, and it should open and let the user save, print, etc. A direct link to the web page works, but not the javascript.
what headers we might need to add to make this work in our production environment? So far the only difference we can see in the environments is SSL.