ASP.NET Discussion Boards

First Prev Next

Re: How to execute sql script from asp.net, need help

Ashfield7-Nov-08 9:12

Ashfield

7-Nov-08 9:12

It is nothing to do with taht, I bet if you take the string you are trying to run, paste it into a query analyser window in a new database and run it you will get exactly the same error. This error is caused by not havng a GO statment between each part, therefore your variable is declared twice. I wouldn't be suprised if other errors crop up when you have fixed this one, for example expect to see errors like 'Create xxx must be the first statemnt in th batch'

dream_liner_7e7 wrote:
Any idea how should i read the script in asp.net?

What ou are doing will be OK, asp.net is not teh problem, its your sql!

Bob
Ashfield Consultants Ltd

Re: How to execute sql script from asp.net, need help

dream_liner_7e77-Nov-08 22:54

dream_liner_7e7

7-Nov-08 22:54

U are very right, when reading the script in asp.net i m not including the go statement because even including the environment.newline it is only giving the single space and when go statement and other statement come in same line sql through error.

Thanks alot u r the best.

Re: How to execute sql script from asp.net, need help

dream_liner_7e78-Nov-08 5:52

dream_liner_7e7

8-Nov-08 5:52

Plz tell me how should i read the sql script in asp.net so i dont get go or same variable error and this sql script also include aspnetDB.

Thanks in advance.

Re: How to execute sql script from asp.net, need help

Ashfield9-Nov-08 20:16

Ashfield

9-Nov-08 20:16

I have already told you how to fix the problem, the error is caused by not havng a GO statment between each part.

dream_liner_7e7 wrote:
how should i read the sql script

Wthout knowing what the script consists of how do you expect me to do ths? If it is a single script then you cannot put the go statements in as you do not know where to put them, so you need to do it at the point of concatenating the scripts together.

dream_liner_7e7 wrote:
and this sql script also include aspnetD

Don't understand ths bit at all.

I'm afraid you are now on your own - you know the problem, so find a solution.

Bob
Ashfield Consultants Ltd

Re: How to execute sql script from asp.net, need help

dream_liner_7e79-Nov-08 22:37

dream_liner_7e7

9-Nov-08 22:37

Thanks a lot Sir. U r the best.

App Domains and logged in users

Soumini Ramakrishnan6-Nov-08 4:45

Soumini Ramakrishnan

6-Nov-08 4:45

How many App Domains an ASP.NET Worker Process creates if suppose 10 different users are logged into the web site

reasons for slow loading page

eyeseetee6-Nov-08 2:54

eyeseetee

6-Nov-08 2:54

One of the pages in my application is taking a lot longer then another page to load. Is there an easy way to check why this is?
I have a gridview which is populated but that is only two pages long.

Also when I use on row create, any factor I set for a row works apart from the last row in the page. If i put the same code in the row data bound it works on every row.
why is this?

Re: reasons for slow loading page

cyber-drugs6-Nov-08 3:46

cyber-drugs

6-Nov-08 3:46

The slow page, is it making use of the GridView?

If true:

Where is the data from the GridView coming from?
It SQL Server, which version?
Is the data coming from a query, stored procedure, or where?
Is the GridView making use of Paging?

Re: reasons for slow loading page

eyeseetee6-Nov-08 3:52

eyeseetee

6-Nov-08 3:52

cyber-drugs wrote:
The slow page, is it making use of the GridView?

Yes it is making use of Gridview

cyber-drugs wrote:
Where is the data from the GridView coming from?

SQL Server

cyber-drugs wrote:
It SQL Server, which version?

2003

cyber-drugs wrote:
Is the data coming from a query, stored procedure, or where?

Both, Im also running checks on the rows when the page loads

cyber-drugs wrote:
Is the GridView making use of Paging?

yes

Re: reasons for slow loading page

cyber-drugs6-Nov-08 4:07

cyber-drugs

6-Nov-08 4:07

ICT,

There is no SQL Server 2003, there is 2000 and 2005, so can I presume you are on 2000? If so, that would be why your page is slow, or at least my presumption without in deptch analysis!

SQL Server 2000 cannot handle "real paging", it gives you the effect of paging, when in fact it pulls down every single record from your query, and then when all the data from the database hits the .NET web server, this will cut up the data and make it appear as if you are getting paging.

In SQL Server 2005, they added the feature "Row Numbering", which allows you to get true paging, so when you ask for the first 100 records in a table, starting from record 101, it gives you just 100 records, where-as 2000 would of given you every single record.

The way to confirm this, if you run query analyser and run a trace on the database being used, and find the query being fired to the database by your GridView. After you have this query, try running it manually in query analyser. If this query runs as slow as your page takes to load, we have identified your problem. Smile | :)

The easiest solution would be to upgrade to SQL Server 2005 or above.

Re: reasons for slow loading page

eyeseetee6-Nov-08 5:15

eyeseetee

6-Nov-08 5:15

cyber-drugs wrote:
The way to confirm this, if you run query analyser and run a trace on the database being used, and find the query being fired to the database by your GridView. After you have this query, try running it manually in query analyser. If this query runs as slow as your page takes to load, we have identified your problem.

How do I do this then?

thanks

Re: reasons for slow loading page

whatUrunning.com6-Nov-08 3:52

whatUrunning.com

6-Nov-08 3:52

eyeseetee wrote:
One of the pages in my application is taking a lot longer then another page to load

If you are getting the data from a database it could be a database problem.
Try running the same query on the database to see how long it takes to run.
If it is slow, the table indexes may not be setup correctly.

eyeseetee wrote:
apart from the last row in the page

Do you mean last data row or footer row?

www.whatUrunning.com
www.whatUrunning.com blog

Re: reasons for slow loading page

eyeseetee6-Nov-08 3:53

eyeseetee

6-Nov-08 3:53

Last data row for the current page, so say there is 3 pages, the last row on each is not the same as the others in formatting.

Re: reasons for slow loading page

whatUrunning.com6-Nov-08 4:26

whatUrunning.com

6-Nov-08 4:26

How are you formatting the rows?

www.whatUrunning.com
www.whatUrunning.com blog

how do i run activexObject on my machine

koolprasad20036-Nov-08 1:26

koolprasad2003

6-Nov-08 1:26

hi there,
i have developed a site and use Javascript ActiveXObject. when i make it's vIRUALdirectory in IIS, then the code will work fine on my machine only.
But if i try to run from another machine then browser will block and can not auto install the ActiveXObject
what can i do ???

i have also allow all the security permissions but still i face same error

thankx in advance
koolprasad2003 Smile | :)

Be a good listener...Because Opprtunity knoughts softly...N-Joy

Re: how do i run activexObject on my machine

Ashfield6-Nov-08 1:51

Ashfield

6-Nov-08 1:51

You can't do anything, its the browser security settings taking control. The user shoudl get the option to install, but you cannot force it to happen.

Bob
Ashfield Consultants Ltd

Unrecognized attribute name cookiename

Member 43580266-Nov-08 0:08

Member 4358026

6-Nov-08 0:08

Hi All,
i am getting following web config parser error when i run my web application.

Parser Error Message : Unrecognized attribute 'cookiename'

Re: Unrecognized attribute name cookiename

Sandeep Akhare6-Nov-08 19:30

Sandeep Akhare

6-Nov-08 19:30

In your VS tool just check for "cookiename" by pressing (Ctrl+Shift f )
search it. as you have given very less information

Thanks and Regards
Sandeep

If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "

Check My Blog

Running an asp.net application with the Japanesse language

Member 19468575-Nov-08 23:41

Member 1946857

5-Nov-08 23:41

He..

I am working on an ASP.net application, that has been running in 2 different languages, danish and english for 4 years.

The customer needs now to include the japanesse language.

Is there something, that I should be aware off!

Like SQL statements, convertion of (dates,strings) and so on. I am using SQL server, ASP.net and C# code.

Some of the text used in the application is placed in the database and some in ressource files.

What about the server, IIS is there any settings needed?

I hope somebody out there have done such implementation and can share some of the experienced issues.

Regards Juliette Sniff | :^)

Re: Running an asp.net application with the Japanesse language

Paddy Boyd6-Nov-08 0:31

Paddy Boyd

6-Nov-08 0:31

I'm not 100% certain if this is the case, but if Japanese is read in a different direction (e.g. right to left), then you'll have to have a good look at the design of your site to ensure that it can be supported.

You'll also need to make sure that your DB is using wide text types (e.g. nvarchar) to allow the saving of the Japanese characters.

Re: Running an asp.net application with the Japanesse language

Member 19468576-Nov-08 2:10

Member 1946857

6-Nov-08 2:10

I have seen, some applications with the Japanesse language, but the text looks like it's writen from left to right. But I am not sure exactly.

Re: Running an asp.net application with the Japanesse language

Paddy Boyd6-Nov-08 2:21

Paddy Boyd

6-Nov-08 2:21

This site seems quite useful:

http://www.i18nguy.com/temp/rtl.html[^]

Cursor Location in Freetextbox

wajans5-Nov-08 23:24

wajans

5-Nov-08 23:24

Hi All

I am getting problem in putting text at the cursor location in freetext box which is place in a Place holder and .
My code is as follows:

<select name="ddlPlaceHolders" onchange="FTB_API['ctl00_ContentPlaceHolder1_ftbMailText'].InsertHtml<br mode=" hold=" />(ddlPlaceHolders.options[ddlPlaceHolders.selectedIndex].text);">
                 <option value="<!FN>">First Name</option>
        <option value="<!LN>">Last Name</option>
        <option value="<!EM>">Email</option>      
        </select>

the statement

"FTB_API['ctl00_ContentPlaceHolder1_ftbMailText'].InsertHtml
(ddlPlaceHolders.options[ddlPlaceHolders.selectedIndex].text);"

is working fine but when i change it to get value instead of text as

"FTB_API['ctl00_ContentPlaceHolder1_ftbMailText'].InsertHtml
(ddlPlaceHolders.options[ddlPlaceHolders.selectedIndex].text);"

its not showing any thing in the freetext box. Please help me

Thanks
wajans

Re: Cursor Location in Freetextbox

wajans5-Nov-08 23:26

wajans

5-Nov-08 23:26

Hi All

I am getting problem in putting text at the cursor location in freetext box which is place in a Place holder and .
My code is as follows:

<select name="ddlPlaceHolders" önchange="FTB_API['ctl00_ContentPlaceHolder1_ftbMailText'].InsertHtml<br mode=" hold=" />(ddlPlaceHolders.options[ddlPlaceHolders.selectedIndex].text);">
                 <option value="<!FN>">First Name</option>
        <option value="<!LN>">Last Name</option>
        <option value="<!EM>">Email</option>      
        </select>

the statement

"FTB_API['ctl00_ContentPlaceHolder1_ftbMailText'].InsertHtml
(ddlPlaceHolders.options[ddlPlaceHolders.selectedIndex].text);"

is working fine but when i change it to get value instead of text as

"FTB_API['ctl00_ContentPlaceHolder1_ftbMailText'].InsertHtml
(ddlPlaceHolders.options[ddlPlaceHolders.selectedIndex].value);"

its not showing any thing in the freetext box. Please help me

Thanks
wajans

Re: Cursor Location in Freetextbox

Qasim198425-Jun-09 19:46

Qasim1984

25-Jun-09 19:46

hi
I have same problem. I have a freetextbox, a button and a hidden field
I want to insert the hidden field value at cursor position in freetextbox by pressing the buttion. How I can do it using the

"FTB_API['FreeTextBox1'].InsertHtml(HiddenField1.value);"

Please send me complete code.
Code that you used in Code behind file, Javascript and html
I am stucked from last week

Thanks

Last Visit: 31-Dec-99 18:00 Last Update: 27-Apr-24 14:26

Refresh

ᐊ Prev 1...2650 2651 2652 265326542655 2656 2657 2658 2659 Next ᐅ

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