Re: N-TIER APPLICATION - ASP.NET Discussion Boards

Re: connect sql 2005 database that is another sysem using asp.net

K03063-Jun-09 20:46

3-Jun-09 20:46

you can write the connection string in web.config file and use these connection abject in any where in your project.

like

<add key="ConnectionString" value="server=IP\SQLEXPRESS;Initial Catalog=dbname;uid = userid; pwd = pwd;">

and use like this in your form
string strSqlCon = ConfigurationSettings.AppSettings["ConnectionString"];

Aspnet_regsql.exe and generating scripts

NetQuestions29-May-09 22:35

NetQuestions

29-May-09 22:35

Hi,

The following command gave me the script for creating membership system

aspnet_regsql.exe -E -S {server} -d {database} -A all -sqlexportonly c:\script.sql

when i execute script.sql, i get the following message

"Cannot grant, deny, or revoke permissions to sa, dbo, information_schema, sys, or yourself"

i have been working using windows authentication... Is it fine?

Thanks,
NetQuestions

modified on Saturday, May 30, 2009 6:29 AM

Why I call flash or video always failed [modified]

jason_mf29-May-09 21:43

jason_mf

29-May-09 21:43

The following is my code:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<%--method 1--%>
<div>
<EMBED src="Flash/123.flv" style="HEIGHT: 331px; LEFT: 83px; TOP: 171px; WIDTH: 538px">
</div>

<%--method 2--%>
<div>
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0" width="150" height="280">
　　 <param name="movie" value="Flash/123.flv">
　　
　　 <param name="quality" value="high">
　　
　　 <embed src="Flash/123.flv" width="150" height="280" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" ></embed>
　　 </object>
</div>
</form>
</body>
</html>

after run, only display a rectangle. I am sure,the path is right.

modified on Saturday, May 30, 2009 4:05 AM

Re: Why I call flash or video always failed

Manas Bhardwaj29-May-09 23:24

Manas Bhardwaj

29-May-09 23:24

jason_mf wrote:
123.flv

This is no ASP.Net question.
BTW, it should be a swf file and not flv.

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Re: Why I call flash or video always failed

jason_mf30-May-09 0:00

jason_mf

30-May-09 0:00

but I use swf replaced was failed too.
still display a rectangle region.
has need any config or setting?
or only wrote "object" html tag?

N-TIER APPLICATION

Rolando Y. Puno29-May-09 20:47

Rolando Y. Puno

29-May-09 20:47

i have some question with regards to n-tier applications:

1. How do i design a layer?
--is it created in the App_code folder?
or is it a separate class library?
2. What is the design in layer application?

Thanks

Re: N-TIER APPLICATION

A k ch29-May-09 21:19

A k ch

29-May-09 21:19

you have to create a seperate class library then only you will get the DLL seperately and which can be modified with no modifications to your web project.

Thanks & Regards,
Anil Chelasani

Re: N-TIER APPLICATION

Colin Angus Mackay29-May-09 22:39

Colin Angus Mackay

29-May-09 22:39

Rolando Y. Puno wrote:
How do i design a layer?

Depends what they layer does.

Rolando Y. Puno wrote:
is it created in the App_code folder? or is it a separate class library?

It can be, but that is an implementatin detail, not a design detail. Typically, however you'd put each layer in its own class library. That way it is portable and can be reused elsewhere.

Rolando Y. Puno wrote:
What is the design in layer application?

I don't know what you mean by "design in layer application".

Man who stand on hill with mouth open wait long time for roast duck to drop in

Re: N-TIER APPLICATION

Baran M29-May-09 23:50

Baran M

29-May-09 23:50

Reference 1[^]

Reference 2[^]

Is there any Gantt Chart with critical path which support .NET web application

A k ch29-May-09 20:47

A k ch

29-May-09 20:47

Hi frd's
I am using Fusion charts for producation planning charts in my web application. But i did not find any feature to show Critical path in the Chart. Can you plase suggest me other Gantt charts.

Thanks & Regards,
Anil Chelasani

Page not working properly after file disposition

milpo29-May-09 20:32

milpo

29-May-09 20:32

Hi,

i am using a charting component to generate graphs for which data is dynamically gets bind from db
In my page there is an image creation button is there, if a user clicks on that an image download dialogue will be displayed

The code i am using for it is

MemoryStream mstream = new MemoryStream();

try
{

Chart1.Save(mstream, ChartImageFormat.Png);

byte[] byteArray = mstream.ToArray();

Response.AddHeader("Content-Disposition", "attachment; filename=report.png");

Response.AddHeader("Content-Length", byteArray.Length.ToString());

Response.ContentType = "image/png";

Response.BinaryWrite(byteArray);
}
catch
{ }
finally
{
mstream.Flush();

mstream.Close();
}

The image downloading works fine, but after image download if i rebind the report again from db the page is taking too long to load, some times page loads partially,some times page gives some xml error, which i will work fine if i dont click image generating button only binds the report.

In my local system this works fine, but in staging server(IIS 6.0) it is giving the above problem

Re: Page not working properly after file disposition

milpo29-May-09 21:03

milpo

29-May-09 21:03

Hi,

now it is working fine,

i just put Response.End() after Response.BinaryWrite(byteArray);

and it is working,although i dont know the exact reason why

'Page Init' approached twice in the master page

shabya29-May-09 20:30

shabya

29-May-09 20:30

hello,
i have a strange phenomenon which happens only at the remote site.
it doesnt happen in my local machine.
i noticed that the PageInit is called twice in the master page.
i know that because i trapped there an Exception that writes to a file
the information of the Exception.
the file was written twice with the delay of approx 300 msec between them.
(i use a tick counter to construct the file name)
in the local machine the file is written only once.

does anyone have an idea why this happens ?

tnx,

avi

Re: 'Page Init' approached twice in the master page

Manas Bhardwaj29-May-09 23:26

Manas Bhardwaj

29-May-09 23:26

shabya wrote:
does anyone have an idea why this happens ?

Its really difficult unless you debug D'Oh! | :doh:

Well, do you know that you can also debug a remot site from VS?

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Re: 'Page Init' approached twice in the master page

shabya30-May-09 0:44

shabya

30-May-09 0:44

mm.. interesting.

i put a trap for all the events and all of them loaded only once.
(pageload, pageinit)
the twice load happened only when there was an exception.
the exception was called twice.
is there a retry or something?

Re: 'Page Init' approached twice in the master page

Ramesh Swaminathan30-May-09 0:00

Ramesh Swaminathan

30-May-09 0:00

Is the Page_Load event also called twice?

If so, look into this link[^]

Re: 'Page Init' approached twice in the master page

shabya30-May-09 0:43

shabya

30-May-09 0:43

MultiLanguage web site

cocoonwls29-May-09 19:37

cocoonwls

29-May-09 19:37

Hi all,

I have view of some example (globalization) to develop a multilingua web site. But still cant success on it.i have create a .resx file call rsc.zh-CHS.resx in floder App_GlobalResources. Then using the the code following to display selected language. And also use a dropdownlist to select a preferral language

private ResourceManager rm;
protected void Page_Load(object sender, EventArgs e)
{
CultureInfo ci;
if (!IsPostBack)
{
 Thread.CurrentThread.CurrentCulture = new CultureInfo("en-US");
 rm = new ResourceManager("rsc", Assembly.Load("App_GlobalResources"));
 ci = Thread.CurrentThread.CurrentCulture;
 LoadData(ci);
}
else
{
 rm = new ResourceManager("rsc",Assembly.Load("App_GlobalResources"));
 ci = Thread.CurrentThread.CurrentCulture;
 LoadData(ci);
}
}

public void LoadData(CultureInfo ci)
{
 lblCNName.Text = rm.GetString("lblCNName", ci);
 lblENName.Text = rm.GetString("lblENName", ci);
}

I get a error in LoadData() and said that:

Could not find any resources appropriate for the specified culture or the neutral culture.  Make sure "rsc.resources" was correctly embedded or linked into assembly "App_GlobalResources.qb8c2ydr" at compile time, or that all the satellite assemblies required are loadable and fully signed.

Note: my example come from http://ashrafur.wordpress.com/2008/01/17/multi-language-supported-web-site-in-aspnet/[^]

any tips are welcome.

regards
cocoonwls

Re: MultiLanguage web site

Parwej Ahamad29-May-09 20:17

Parwej Ahamad

29-May-09 20:17

Did you added there a default resource file ?

Parwej Ahamad

Re: MultiLanguage web site

cocoonwls1-Jun-09 20:07

cocoonwls

1-Jun-09 20:07

Hi there,

Sorry for late reply.Thanks for your information.I have solve my problem~

regards
cocoonwls

date time picker

jainiraj29-May-09 19:15

jainiraj

29-May-09 19:15

how can i use datetime piker associated with a textbox which sows date selected in page.

Re: date time picker

Baran M29-May-09 19:22

Baran M

29-May-09 19:22

DateTimePicker Web Control[^]

About Datagrid [modified]

mahichandu29-May-09 10:16

mahichandu

29-May-09 10:16

Hi..
Below is my databse table..

I can populate this data into the UI Page..
My task is to automatically delete the columns which has '0'(zero) value...and i have to delete the first row of my table...
Hear i am not going to use any itemtemplate column..
I have to write some code in codebehind..

JurisdictionID JurisdictionDescription Year1 Year2 Year3 Year4 Year5 Year6 Year7 2005 2006 2009 0 0 0 0 AL Alabama 0 0 6 0 0 0 0 AK Alaska 2 0 0 0 0 0 0

Could Anyone suggest me ..How to proceed further in detail with some code...

modified on Monday, June 1, 2009 12:14 PM

Re: About Datagrid

Bassam Saoud29-May-09 11:08

Bassam Saoud

29-May-09 11:08

If you are just displaying data in the UI , I would recommend a repeater. it is much lighter.

As for deleting 0 values simply add a constraint to your where clause in the proc where you are retrieving data.

Re: About Datagrid

adatapost29-May-09 15:48

adatapost

29-May-09 15:48

Here is a code might help you. I think you are using MSSQL server 2005.

SqlConnection cnnew SqlConnection(...your_connection_string....);
SqlCommand cmd=new SqlCommand();
cmd.Connection=cn;
cmd.CommandText="your_proc";
cmd.CommandType=CommandType.StoredProcedure;

...
...
SqlDataAdapter adp=new SqlDataAdapter(cmd);
DataTable dt=new DataTable();
adp.Fill(dt);
GridView v=new GridView();
v.DataSource=dt;
v.DataBind();
form1.Controls.Add(v);

..
..

A DATAPOST COMPUTER CENTRE
(K.V Prajapati)

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.