|
Hi all,
Thanks a lot for your help in advance.
I am doing a Mail Merging Application. I can get all data from the source (database, file or anything) and using mail Merge fields in Word Document from C# code, I open up the word which is merged with data from database.
MS Word Document Opens –
--- should this be open in IE
--- Or should this be open as ordinary MS Word on Desktop
The problem is if I open it anyway, I loose all control over the Word Document which is opened. I don’t want to do that. I want to keep control over it and allow the Users to update the document with some standard messages which we have in the project. What that means is, the messages will be selected and those messages selected will be put at some point where cursor is kept in the document.
So, when mail merging happens
MS Word Document is opened.
A pop up with standard messages is opened.
User selects the messages he/ she wants to insert into the MS Word Document which is opened.
For these things to happen, I should have control over the MS Word Document which is opened on the client side. Do selection of the messages and populate in Word document (this is my understanding, is there any way to do it easily).
The Issues are:
I need a way to open the MS Word Document in a controlled manner where I can still control the User editing or help user in editing when he / she clicks on my standard messages and wants them to populate on the MS Word Document.
How can I save the MS Word document and make sure that user is not saving it locally and has to upload it again to save it on server.
I Hope I am clear in explaining the situation, please find the attachments which show the MS Word Doc and the popup on side .
|
|
|
|
|
Sounds like you are asking for a lot of client side javascript in order to handle it.
Maybe the approach should be more server-centric.
1) Perform the merge on the IIS server.
2) Prompt the user for messages that need to be incorporated
3) On the server, using Document automation, incorporate those messages
4) Confirm that the user wants to save the document. Save it on a server directory.
Basically, have everything under control on the server, don't try to open MS-Word on the client machine.
Just a thought. ![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
|
|
|
|
|
Hi Iam new to C#,Asp.Net.
Iam working on building a website http://www.missmegs.com/ this site is for a restaurant.
I have this site working fine in IE but when I go to Firefox the bottom image which I used as borders for this website is coming up which is making my client little upset.
How can I overcome this issue. Iam sure this can be done with CSS and divs but I dont know how. Please help me.
Any help is greatly appreciated.
Thank in advance.
|
|
|
|
|
|
Hi
I have a listbox in aspx page and has some list in it.
Now i am trying to get the list count of the listbox from javascript.
I am trying to get that by using the following code.
function count()
{
var x = document.getElementById(<%=listbox1.ClientID %>);
var cnt = x.options.length;
}
I am using a master page here.
But the value cnt is not having any value.
I tried by using like this also
var cnt = x.length;
but still it gave me the result as undefined.
Please help me to get the count.
Thanks in advance
Naina
|
|
|
|
|
This works properly.
alert(document.getElementById('<%=ListBox1.ClientID %>').options.length);
I Love T-SQL www.aktualiteti.com
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
I am using a GridView and one of the fields is a DateTime. The values in this field can be null. When I call gvwDetails.DataBind() I get this error:
"String was not recognized as a valid DateTime."
I just want it to display an empty string if its a null value. It doesn't seem that hard but I have tried searching google and read a bunch of MS pages on GridViews and DataBind. The closest I have come is setting the ConvertEmptyStringToNull property in my field to true but its not doing anything. My code for the template field is:
<asp:TemplateField HeaderText="Date Due"> <br />
<EditItemTemplate> <br />
<asp:TextBox ID="txtDateDue" runat="server" Text='<%# Bind("DATE_DUE") %>'></asp:TextBox> <br />
</EditItemTemplate> <br />
<FooterTemplate> <br />
<asp:TextBox ID="txtNewDateDue" runat="server" Width="100" ></asp:TextBox> <br />
</FooterTemplate> <br />
<ItemTemplate> <br />
<asp:Label ID="lblDateDue" runat="server" Text='<%# Eval("DATE_DUE") %>'></asp:Label> <br />
</ItemTemplate> <br />
<HeaderStyle HorizontalAlign="Left" /><br />
</asp:TemplateField>
Is this really simple and I'm not seeing it? I'm sure there's some way of handling null values that I must not be seeing. Thank you for any help.
|
|
|
|
|
Cast the date to varchar or char in Query then try.
if u r using MySql then cast the date like this.
select cast(Date_Format(Date_Due,'%d %M %Y') as char) as Date_Due from table_name
if u r using Ms SqlServer then do it like this
select CONVERT(varchar(20), Date_Due, 107) AS Date_Due from table_name
You can change the date format according to requirement.
|
|
|
|
|
That works, thank you very much.
Scratch that, I had made it a bound column and forgot to change it back. When I change it back to a template field it still doesn't work. 
I have found some stuff that seems helpful (like this http://stackoverflow.com/questions/584570/why-does-my-repeater-keep-crashing-on-evalnull-values[^]) but still can't get this to work with my DateTime field.
One more edit: Okay I figured it out. I had some code in my RowDataBound event that was formatting the dates and I had to modify it in the case of an empty string. 
Thank you again for the help.
modified on Friday, July 10, 2009 1:02 PM
|
|
|
|
|
Hello all,
Iam new to C# and .NET but leanrt a lot while iam in here. I ran in to a situation, I have created a shopping cart application and made successfully all the way to the order confirmation. Now the client wants to reset the "Order Num" to zero on a daily basis.
i.e "Order Number" once order is placed has to start at 0 from 12 AM and has to be set to 0 at 12 PM so that they have a count on how many items they are selling per day.
How this can be achieved any help will be appreciated. Thanks in advance.
|
|
|
|
|
There are 2 obvious ways I can think of....
1 - Store the order date in the database, that way the order numbers don't need to be reset, you can simply provide a screen to display the total number of orders for a given day.
2 - Store the order date and order number in the database against each order. Create a new table called something like currentordernumber, with 2 columns date and nextordernumber, each time you create a new order query this table to get the next order number and update the table to set the nextordernumber +1. If the current date is different to the date in the currentordernumber table update the date in the table and set the order number to 1.
Option 1 is by far the best option IMO.
|
|
|
|
|
Thank you DoctorMick for a quick solution.
If I go with Option 1, there is a small issue. I also have to show the "Order Number" to the user so that they can take that to the store with them[Carry Out].
Like 7/9/09 -- orders 1 to 100. Purchaser can go a tell the restaurant for their order number that day.
7/10/09 -- order 1 to 150.
|
|
|
|
|
Well, for that reason you can add another column to the table, lets say OrderNrOfDay.
Every time you insert the order in the table, check if the date today is same as that of the last order. If yes, the increment the OrderNrOfDay else set it to 1.
Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
Thank You Manas
That makes sense, let me try that should fix me.
|
|
|
|
|
That's again problematic. You should take extra care to make the increment atomic as multiple users will be using the web site simultaneously. Your client's idea of resetting the order numbers to 0 each day is plain stupid. In such case, how do you refer to a order? You may need order number and the day order placed.
The option 1 suggested in the other reply is good. I am not getting what is the issue you are facing with that approach?
|
|
|
|
|
I accomplished this task by creating another table which has OrderId,OrderNum, Date, OrderNrOfDay. OrderNum is the FK here to PK of orders table.
Then OrderNum from marchant warehouse is always saved in database and for clients sake generating daily order numbers starting from 1 to so on and for records we have OrderNum.
This solved the issue.
|
|
|
|
|
Hi,
Guys I have a peculiar problem here, I need to display data from two tables having no fields at all common and want to display them in one gridview on the click of a radio button .
If radiobuttton(1) is selected then data from table one will be displayed and if radiobuttton(2) is selected then data from table two will be displayed.
each of the table is having field name as:
table(1)
fname lname mname abid
table(2)
fname lname mname cdid
is there some advice you guys can help me?
thanks
|
|
|
|
|
this seems easy enough to me. Change the data source of the gridview on the event of the radio button being clicked
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Hi Chris,
The problem is that even if I change the data sources ,the gridview which I am using has only one name(name of the coloumn here) so how will the grid view show second table's data?
|
|
|
|
|
each of the table is having field name as:
table(1)
fname lname mname abid
table(2)
fname lname mname cdid
gridview
fname lname mname abid
Now as you can see the gridview has a field name abid and this field is databound that is it has to have the same name as that with the respective table, so by my limited knowledge this gridview will show only one table's data but I want to display data of two tables in one gridview.
Is there a way out from this problem?
|
|
|
|
|
you have to change in select Query Like this .
for table(1) use the following Query.
select fname,lname,mname,abid from table(1)
and for table(2) the select Query will be.
select fname,lname,mname,cdid as abid from table(2)
now u have the same column name for both tables.
and if u want to change the headerText text of the column with condition of radio buttons.
after data bound like this.
GridView1.DataBind();
if (RadioButtonList1.SelectedValue == "one")
{
GridView1.Columns[3].HeaderText = "abid";
}
else
{
GridView1.Columns[3].HeaderText = "cdid";
}
|
|
|
|
|
How to select and return more than one values using select stored procedure.
How to configure login control using wizard.
How to edit connection string at configuration file or how to change database name, server name, username nad password.
|
|
|
|
|
I think you need to read my article on how to use google. Or perhaps try asking detailed, intelligent questions. You've asked three very different things. In each case, I have to ask, where are you stuck ? Do you not have any books on ASP.NET ? Do you not have access to google ? Have you tried reading some articles on the site ?
What have you tried ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Christian Graus wrote: I think you need to read my article on how to use google
I feel that people just post a question at CP and go for a coffee break.
And boy, they have the answer by the time they come back.
So, it like why should I take any pains when someone else can do it for them. 
Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
It sure looks that way.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
