Issues in Word Automation - ASP.NET Discussion Boards

OK I understand, thanks.

Where are you from? I'm from South Africa.

ma se wrote:
Where are you from?

---
single minded; short sighted; long gone;

ma se wrote:
Why can't the following not work because logically it looks the same??

background-image: url(/Images/logo.jpg);

To make it work in localmachine I suggest don't use any virtual directories. Copy all files to IIS root folder and try.

printf("Navaneeth!!")

www.w3hearts.com

Hi,

I need a help that,,

How to connect particular Databse based on selected DB1/DB2 in Home page.
Then onwards entire application Use that selected DB only.
[Web Application]

Is it possible?

Any one give suggestion..

SasiP wrote:
How to connect particular Databse based on selected DB1/DB2 in Home page.

Since each database has a different connection string. All you need is the relevant connection string to connect to the relevant database.

Upcoming events:
* Glasgow: SQL Server 2005 - XML and XML Query Plans, Mock Objects, SQL Server Reporting Services...

Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton

My website

Yep - I use two databases for the ASP.Net ap I am working on, just need to define two connection strings, I use:

Dim conn As New SqlConnection("Server=SERVER;" & _
"Database=DATABASE1;User ID=nottelling;Password=nottelling")

Dim conn2 As New SqlConnection("Server=SERVER;" & _
"Database=DATABASE2;User ID=nottelling;Password=nottelling")

(this may not be the best way to do it, but it works)

also, remember you can query two databases in a single SQL query if they are on the same server

Dim SignedOutCommand As New SqlCommand("Select S.StaffID, S.InTime, S.HaveMob, I.FirstName, I.LastName FROM WhereAreYou.dbo.StaffOut S, Infobase.dbo.Staff I WHERE S.StaffID = I.StaffID ORDER BY I.FirstName", conn)

is one of my commands.

Hope this helps!

I have a web application developed for a single customer in VS2003. The application consistes of about a dozen pages. I am now deploying it to several other customers. For each different customer, most of the pages remain the same, with one or two pages being "custom" for each customer. I would like to maintain the source code for the "common" pages in a single location and just create or modify the different pages for each customer. I tried this using the "sharing" feature of Visual SOurce Safe 6, with no luck.

Can anyone reccommend a method of doing this such that i can create a new web app that shares a "base" set of pages so that as i make upgrades to the app, they will be made in one common set of files?

I was generating a word document with a password set to it from an ASP.NET application...

It was working fine except that a table which is assigned as the header is not correctly getting executed and that the 2 gif images are also not loaded.

The code is.....

wordApp.ActiveWindow.ActivePane.View.[U]SeekView[/U] =
Word.WdSeekView.wdSeekCurrentPageHeader;

if(Convert.ToString(POarray[17]) != "0")
{
object dBehaviour = Word.WdDefaultTableBehavior.wdWord9TableBehavior;
object aBehaviour = Word.WdAutoFitBehavior.wdAutoFitWindow;

Word.Range tableRange = wordApp.Selection.Range;
Word.Table TblPO = wordDoc.Tables.Add(tableRange, 1, 3, ref dBehaviour,
ref aBehaviour);

TblPO.AllowAutoFit = true;
TblPO.TableDirection = Word.WdTableDirection.wdTableDirectionLtr;

TblPO.Columns.PreferredWidth = 10.0f;
TblPO.Cell(0,1).Range.Select();

string picHeaderLeft =
"C:\\InetPub\\WWWroot\\FolderName\\images\\Logo1.gif";

TblPO.Cell(0,1).Range.InlineShapes.AddPicture(picHeaderLeft, ref missing,
ref missing, ref missing);

//The above code in If Block is not getting executed correctly

//Only the following code is executed correctly (the middle cell)
TblPO.Columns.PreferredWidth = 80.0f;
//used setwidth()method...Got an exception
//which i could not resolve...
//And i am Automating Word 2000 (Word 9.0.2720)

TblPO.Cell(0,2).Range.Select();

wordApp.Selection.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter;

//TblPO.Cell(0,2).Range.Font.Size = 11;
//TblPO.Cell(0,2).Range.Font.Name = "Times New Roman";

string file = Convert.ToString(POarray[17]); // FilePath

TblPO.Cell(0,2).Range.InsertFile( file, ref missing, ref missing, ref missing, ref missing );
// The file got inserted correctly to the document as header
// Meaning TblPO is active in memory

// Again the following code is not getting executed properly
TblPO.Columns.PreferredWidth = 10.0f;
TblPO.Cell(0,3).Range.Select();

string picHeaderRight
= "C:\\InetPub\\WWWroot\\FolderName\\images\\Logo2.gif";

TblPO.Cell(0,3).Range.InlineShapes.AddPicture(picHeaderRight, ref missing,
ref missing,ref missing);
}

The code snippet continues as...

wordApp.Selection.TypeParagraph();
wordApp.ActiveWindow.ActivePane.View.SeekView =
Word.WdSeekView.wdSeekMainDocument;

wordApp.Selection.TypeParagraph();

wordApp.Selection.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter;

wordApp.Selection.Font.Bold = 1;
wordApp.Selection.Font.Underline = Word.WdUnderline.wdUnderlineSingle;

wordApp.Selection.Font.Name = "Times New Roman";
wordApp.Selection.Font.Size = 12;
wordApp.Selection.TypeText("Heading");

I heve checked up the code with breakpoints...But surprisingly it is not entering that "if " statement itself...It was jumping to a statement way
after wordApp.Selection.TypeText("Heading"), after it has executed SeekView statement.

Before also i had problems with breakpoints....Some times it will not enter to this class itself...

As this code is executed in Word(Unmanaged code) and not in CLR...I think inconsistancies can happen.....

I also had problems with solution....Changes not getting reflected in the solution even after building...In .NET is there versioning for solution ?

Please help....

I have no idea why it is behaving like this....

I’am using the System.Configuration.NameValueSectionHandler to read a key value pair from the web.config file
The code works perfect fine on our offshore environment, but it has failed on our onsite environment.
The web.config has the following entries
<configSections>
<section name="Twin" type="System.Configuration.NameValueSectionHandler, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
</configSections>
<Twin>
<add key="Pair1" value="Value1"/>
<add key="Pair2" value=" Value2"/>
</Twin>

The Error message generated is
An error occurred creating the configuration section handler for TwinCOBAM: Could not load type 'System.Configuration.NameValueSectionHandler' from assembly 'System.Configuration, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'.

I’ve tried the following combinations of the Section entry, I picked up the version number; the public token number from the GAC
<section name="Twin" type="System.Configuration.NameValueSectionHandler, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

<section name="Twin" type="System.Configuration.NameValueSectionHandler, System.Configuration, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>

After some googling, there are some varied findings; some say that it’s a bug in the .net framework. For some it works without even specifying the version numbers and public token keys. I haven’t been able to pin down the source of this problem.

Please help.

-Ben Salins

How to apply style to the content in autocompleteextender?

Sandeep Kumbhar

I am currently working on a competition site that will automatically draw winners at certain times. I have three seperate draws all to be drawn. One every month, another every week and another anually. I have a seperate table in a database with all entrants, obviously all with a unique id.

What I want is an automatic method for the draws. So that they happen seamslessly in the back ground. Draw the winners, email me to tell me about the winner, and update the database.

I'm guessing that it would make more sense to do this in a standalone app as I cant think of a way of getting a web site to automatically check this. Is this a good approach.

Also what would be a good, random method for selecting a winner from the list??

Sam Heller wrote:
I'm guessing that it would make more sense to do this in a standalone app as I cant think of a way of getting a web site to automatically check this. Is this a good approach.

Yeah, you will have to use a standalone application to do this.

Sam Heller wrote:
Also what would be a good, random method for selecting a winner from the list??

I would suggest Gaussian method to get the draw, you would get a perfect U curve while plotting the results.

Ok thanks for that. I had a brief look at Gaussian but looks like it could be slightly overkill for my requirements. I also couldnt see how u would tie that into my problem of having what is basically an array from the database of unique numbers and how to select one of these?

Any other ideas? or examples?

Thanks

Sam Heller wrote:
Ok thanks for that. I had a brief look at Gaussian but looks like it could be slightly overkill for my requirements. I also couldnt see how u would tie that into my problem of having what is basically an array from the database of unique numbers and how to select one of these?

The Gaussian numbers can be used to get a set of random numbers which could be used as the index of the array. If you have 1000 records in your database, you can have your Gaussian function return 10 values(according to how many you need) between 0 and 999. Use the numbers generated as the index and pull out those from the array.

The reason I suggested this is because it follows a uniform distribution and your draws would not follow a pattern.

Don't suppose you know of any good examples regarding this before I go looking?

You can have a look at this thread[^]. I wrote the function using the formula I found online, you probably have to search online to find if some code is available.

Formula I used[^]

Hi all,

I have an aspx page which contains a hiddenfield ..i have javascript in the samepage which contains the following piece of code..

function PostPage()
{
var popup;
document.form1.action = "Default6.aspx";
document.form1.method = "POST";
document.form1.submit();
}

and the aspx page contains the following

<asp:ImageButton ID="ImageButton1" runat="server" OnClientClick="Javascript:PostPage()" />

with the hidden field populated from codebehind...

Now i want the Default6.aspx to be opened as a pop-up after submitting the current page.I need to submit the page instead-of using 'window.open' coz i'can retrieve the hiddenfield value in the popup page...

Overall my question is that when i click on the imagebutton the javascript submit() should occur annd then the new page should be opened as popup ..how to do that? please let me know

Koushik

Use This link:

http://www.pageresource.com/jscript/j_a_02.htm
Hope this helps u...

Use this:
http://www.pageresource.com/jscript/j_a_02.htm
OR
Use this
window.showModalDialog("http://www.altavista.com","","dialogWidth:500px;dialogHeight:500px")

I have a grid and i want to do pagging, i have a form in which i am taking 3 inputs , ID , and 2 dates and showing records in that grid on the base of that ID and dates. for example my Qry returns 25 records and it shows in 3 pages when i click page number 2 all values remain same ,when i click on 3rd page it makes it page size to 5 but values remains same.
any help in this respect will be higly appreciated.

K Dastgir

Post ur code let see...

i guess problem is due to parameters i am passing in Qry strin that every time parameters are passed again and results comes same instead of next page

on Page load i have this code
If Not Page.IsPostBack Then
bind SQL
end if

BindSQL()
'DSgrid is a data.dataset
'DB is a object of a class where i make connection

dsgrid = db.getRecords("SELECT attendence.EmpNo, Strength.Name,convert(varchar,Strength.DOJ,101)as DOJ,Strength.EmpStatusid,convert(varchar,attendence.Date,101)as DDate,convert(varchar,attendence.InTime,108) As InTime,convert(varchar,attendence.OutTime,108)As OutTime,attendence.Present AS Status,convert(varchar,(OutTime-InTime),108)As WorkedHrs FROM attendence INNER JOIN Strength ON attendence.EmpNo = Strength.EmpNo Where attendence.EmpNo ='" & cempid & "'AND attendence.Date >= '" & mfromdate & "' And attendence.Date <= '" & mtodate & "' Order by Date")

Dim mtcheck As Integer = dsgrid.Tables(0).Rows.Count()
If mtcheck = 0 Then
lblerror.Visible = True
Label3.Visible = False
Label5.Visible = False
lblerror.Text = "No Record Found"
Else

DG_CheckBox.DataSource = dsgrid
DG_CheckBox.DataBind()
End If

End Sub

Sub myDataGrid_PageChanger(ByVal Source As Object, ByVal E As DataGridPageChangedEventArgs)
DG_CheckBox.CurrentPageIndex = E.NewPageIndex
BindSQL()
End Sub

K Dastgir

Didnt understood this function
Sub myDataGrid_PageChanger(ByVal Source As Object, ByVal E As DataGridPageChangedEventArgs)
DG_CheckBox.CurrentPageIndex = E.NewPageIndex
BindSQL()
End Sub

I Think it should be like this
Sub DG_CheckBox_PageChanger(ByVal Source As Object, ByVal E As DataGridPageChangedEventArgs)
DG_CheckBox.CurrentPageIndex = E.NewPageIndex
BindSQL()
End Sub

Hope this helps u...

sorry it was my mistake it is DG)checkbox_pagechanger(...)
result is same
can it be the parameters passing in the qry making this problem

K Dastgir

I have Change your code please,

'Bind GridView Method
Public Sub BindGridView()

Dim oDS As New DataSet

strSql = "Your Query"

oDS = db.ExecuteDataSet(strSql)
DG_CheckBox.DataSource = oDS
DG_CheckBox.DataBind()

End Sub

'Return Dataset
Public Function ExecuteDataSet(ByVal strsql As String) As DataSet
Dim dtad As SqlDataAdapter
Dim dtst As DataSet
dtst = New DataSet
dtad = New SqlDataAdapter(strsql, GetConnection)
' GetConnection Get the sql connection
dtad.Fill(dtst)
CloseConnection()
Return dtst
End Function

Protected Sub DG_CheckBox_PageIndexChanging(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewPageEventArgs) Handles DG_CheckBox.PageIndexChanging
Try
DG_CheckBox.PageIndex = e.NewPageIndex()
BindGridView()
Catch ex As Exception

End Try
End Sub

U Can use EmptyDataText if your query doesnt returns any records.
eg: EmptyDataText = "No Record Found"
Else u can use your code also for showing error "No Record Found"

Hope this helps u...