ASP.NET

problem in passing query to crystal reports

4-Oct-07 4:55

Hello,

I'm thinking about two solutions:
1. Try to call MS Word using late binding.
2. Ty to use Aspose.Word library

cute_mines_20043-Oct-07 5:37

cute_mines_2004

3-Oct-07 5:37

hi
i m devloping a web application
and i m passing a parameter i.e empid through query i.e command text
i m getting error that parameter not found

pankaj sahni

User Control Tag Prefixes problem in aspx page

Kevin McFarlane3-Oct-07 4:28

Kevin McFarlane

3-Oct-07 4:28

I have a user control specified in an aspx page thus:

<CAS:BodyBox runat="server" TitleImage="../Style/Users_small.gif" Width="800">
<Title>
Welcome to <strong>Caslon</strong>
</Title>
<Content>
<CAS:Welcome runat="server" />
</Content>
</CAS:BodyBox>

I get parsing errors

Validation (XHTML 1.0 Transitional): The element 'Title' cannot be nested within the element 'bodybox'.

such that I cannot view the page in design view.

What is the correct way to write this snippet?

BTW, I did not author this code, I have merely been tasked with trying to understand it.

Kevin

Connecting to a Visual Foxpro (DBF) table.

Davem77143-Oct-07 4:18

Davem7714

3-Oct-07 4:18

I have put my web-site together and everything works fine when working on my computer. I have one page that works with a Visual FoxPro table (dbf). In my web.config file, the only way to get it to find the table is to put in the complete path to the file. The file on my site is located in the App_Data folder off of the root. Here is the connection string that works on my local computer when running under Visual Web Developer:

<connectionstrings>
<add name="ADAInfoConnectionString"
connectionstring="Provider=VFPOLEDB.1;Data Source='C:\Users\David\Documents\Visual Studio 2005\WebSites\Damar\App_Data\ADASurvey.dbf'"
providername="System.Data.OleDb">

How can I get my ASP.Net application to find this table on my web-site? Should I use information in the web.config file or is there another approach that will work?

Any help would be much appreciated.

Thanks!

Dave Smile | :)

Re: Connecting to a Visual Foxpro (DBF) table.

Ilya Verbitskiy3-Oct-07 4:29

Re: Connecting to a Visual Foxpro (DBF) table.

3-Oct-07 4:29

Hello,

You can use Server.MapPath("App_Data\ADASurvey.dbf"); This method maps the specified relative or virtual path to the physical directory on the server.

Davem77144-Oct-07 4:20

Davem7714

4-Oct-07 4:20

Ilya,

Can I use this in my web.config file or do I need to do something in my page load event?

Dave Smile | :)

Re: Connecting to a Visual Foxpro (DBF) table.

Ilya Verbitskiy4-Oct-07 4:50

Mail reminders and alerts.

4-Oct-07 4:50

You should manage this in load event.

priyank_ldce3-Oct-07 3:36

priyank_ldce

3-Oct-07 3:36

Hi all,

I am making one web application using ASP.NET and VB.NET 2.0. I want to make alerts and reminders for this application. User can set reminder for some specific date and they get mail as a reminder on that. Plus one day every week system check for users if they fill one form or not. If not then they will get mail to alert it. Can I know how I can do this? I am using SQL Server 2000 as a database.

Thanks in advance,
Priyank

Re: Mail reminders and alerts.

Ilya Verbitskiy3-Oct-07 4:37

Calendar in ASP.NET using javascript

3-Oct-07 4:37

Hi,

I think that you can use two solutions. First, you can create windows service which will do something automatically. In another way, you can create simple tool which will send e-mails and configure Windows "Schedule Task" to run it.

You can send e-mails using .NET Framework. But you also can create stored procedure for SQL Server fo e-mail sending. How to do this see here. If you will do this using SQL Server only, you can run this stired procedure using osql.exe in BAT-files.

Montu763-Oct-07 3:08

Montu76

3-Oct-07 3:08

Hi,
I want to create a popup calendar in .aspx page using javascript.
Can some one send and explain the code step by step.

Thanks,
Montu

Hello There

Re: Calendar in ASP.NET using javascript

Not Active3-Oct-07 4:12

Not Active

3-Oct-07 4:12

Sure,

Step 1) Open Internet browser of your choice
Step 2) Type www.google.com into address bar
Step 3) Press enter button
Step 4) Type javascript calandar into search box
Step 5) Click Search button
Step 6) Read

only two letters away from being an asset

Re: Calendar in ASP.NET using javascript

Richard Jones3-Oct-07 7:47

Richard Jones

3-Oct-07 7:47

http://www.asp.net/learn/ajax-videos/[^]

"Neque porro quisquam est qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit..."
"There is no one who loves pain itself, who seeks after it and wants to have it, simply because it is pain..."

Recursive Function in C#

varshavmane3-Oct-07 2:20

3-Oct-07 2:20

Hi All,

I am using ASP.NET 2.0 (C#). I have a datatable where all the values are there now I need to write a recursive function but I am not getting the proper values. My datatable has the following data:

CID Desc PID
A T1 NULL
B T2 A
C T3 B
D T4 A

Please help me with this...

Thanks in advance...

N a v a n e e t h3-Oct-07 2:25

N a v a n e e t h

3-Oct-07 2:25

ASP.NET 2.0 wrote:
now I need to write a recursive function

Recursive function for what ?

My Website | Ask smart questions

varshavmane3-Oct-07 2:29

3-Oct-07 2:29

Thanks for the reply. I have to write the recursive function to show the output as treeview.

pmarfleet3-Oct-07 2:28

pmarfleet

3-Oct-07 2:28

ASP.NET 2.0 wrote:
need to write a recursive function but I am not getting the proper values.

What are you trying to do? Where is your code?

Paul Marfleet

varshavmane3-Oct-07 2:35

3-Oct-07 2:35

Thanks for the reply. I have to write the recursive function to show the output as treeview.
I have to generate the script based on the datatable rows. My normal function works fine if it has only one level but now in my datatable there can be more levels and for this I need to write recursive function. Following is the code:

private void FillValues(DataTable dtFinal)
{
int intChildRowCnt = 0;
StringBuilder strDBScript = new StringBuilder("");
strDBScript.Append("<script language='javascript' type='text/javascript'>");
// Create wsGrid Instance
strDBScript.Append("var m_wsGridCtrl = new jsTreeGridCtrl();");
// Param1: width
// Param2: OnMouseOver Color
//strDBScript += "m_wsGridCtrl.initializeDocument(1000, '#FF9999');";
strDBScript.Append("m_wsGridCtrl.initializeDocument(1000, '#8A9FFF');");
// Titles
// Param1: Text
// Param2: Width

// DataTable dtFinal = GetDataTable();
Int32 intColCnt;
if (dtFinal.Rows.Count > 0)
{
for (intColCnt = 0; intColCnt <= dtFinal.Columns.Count - 1; intColCnt++)
{
if (intColCnt == 0)
{
strDBScript.Append("m_wsGridCtrl.InsTab('Show All', '30');");
}
else if (intColCnt == 2)
{

}
else if (intColCnt == 1)
{
strDBScript.Append("m_wsGridCtrl.InsTab('" + dtFinal.Columns[intColCnt].ColumnName + "', '50');");
}
else
{
strDBScript.Append("m_wsGridCtrl.InsTab('" + dtFinal.Columns[intColCnt].ColumnName + "', '20');");
}
}
DataRow[] foundParent;
DataRow[] foundChild;
foundParent = dtFinal.Select("PresentationParentSpecElementID Is null");

if (foundParent.GetUpperBound(0) > 0)
{
for (Int32 intRowCnt = 0; intRowCnt <= foundParent.GetUpperBound(0); intRowCnt++)
{
foundChild = dtFinal.Select("PresentationParentSpecElementID=" + foundParent[intRowCnt]["SpecElementID"]);

if (foundChild.GetUpperBound(0) > 0)
{
strDBScript.Append("var iItem" + intRowCnt + "=");
}

strDBScript.Append("m_wsGridCtrl.InsItem(null, '");
for (intColCnt = 0; intColCnt <= dtFinal.Columns.Count - 1; intColCnt++)
{
if (intColCnt == 0 || intColCnt == 2)
{
}
else
{
strDBScript.Append(foundParent[intRowCnt][intColCnt] + ";");
}
}
strDBScript.Append("');");

for (intChildRowCnt = 0; intChildRowCnt <= foundChild.GetUpperBound(0) - 1; intChildRowCnt++)
{
strDBScript.Append("m_wsGridCtrl.InsItem(iItem" + intRowCnt + ",'");
for (intColCnt = 0; intColCnt <= dtFinal.Columns.Count - 1; intColCnt++)
{
if (intColCnt == 0 || intColCnt == 2)
{
}
else
{
strDBScript.Append(foundChild[intChildRowCnt][intColCnt] + ";"); }
}
strDBScript.Append("');");
}

}
}
else
{
foreach (DataRow row in dtFinal.Rows)
{
strDBScript.Append("m_wsGridCtrl.InsItem(null, '");
for (intColCnt = 0; intColCnt <= dtFinal.Columns.Count - 1; intColCnt++)
{
if (intColCnt == 0 || intColCnt == 2)
{
}
else
{
strDBScript.Append(row[intColCnt] + ";");
}
}
strDBScript.Append("');");
}
}

strDBScript.Append("m_wsGridCtrl.GenerateCode();");
strDBScript.Append("m_wsGridCtrl.RecudeAllTree();");
strDBScript.Append("</script>");

ClientScript.RegisterClientScriptBlock(this.GetType(), "onload", strDBScript.ToString()); }
}

Now I need to convert this in recursive function..

Please help me...

Thanks again...

pmarfleet3-Oct-07 3:12

pmarfleet

3-Oct-07 3:12

You could consider using the SQLXML managed classes to return the results of your query as an XML document. I don't know what treeview control you are using (some 3rd party / bespoke component) but if you use the TreeView control in ASP.NET 2.0 then you can bind the control to an XML datasource. You then don't have the hassle of writing your own population routine.

Paul Marfleet

varshavmane3-Oct-07 3:38