|
I have a database script which include my custom tables and asp.net roles and membership structure also and i have to execute it from asp.net, i tried but getting errors, all i did through stream read i saved the whole script in string s and then through executenonquery i m trying to run it but getting page full of errors
System.Data.SqlClient.SqlException: The variable name '@RoleName' has already been declared. Variable names must be unique within a query batch or stored procedure.
The variable name '@RoleMemberName' has already been declared. Variable names must be unique within a query batch or stored procedure.
Plz help
Thanks in advance.
|
|
|
|
|
The error message is self-explanatory. SQL variable names are declared multiple times.
|
|
|
|
|
As the error says, the @RoleMemberName' has been declared more than once. You may well end up with other errors as (for example) you cannot reference a function within your code until the function has been created.
The best bet is to put your sql into query analyser, run it, fix the problems (repeat until clean) and then use that script from your application.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
but i am trying to execute the script in newly created database, i think the problem is in reading the script into string var, normally the same script is working fi9 in sql server. Any idea how should i read the script in asp.net?
Thanks in Advance.
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
Thanks a lot Sir. U r the best.
|
|
|
|
|
How many App Domains an ASP.NET Worker Process creates if suppose 10 different users are logged into the web site
|
|
|
|
|
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?
|
|
|
|
|
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?
|
|
|
|
|
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
|
|
|
|
|
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.
The easiest solution would be to upgrade to SQL Server 2005 or above.
|
|
|
|
|
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
|
|
|
|
|
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?
|
|
|
|
|
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.
|
|
|
|
|
How are you formatting the rows?
|
|
|
|
|
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
Be a good listener...Because Opprtunity knoughts softly...N-Joy
|
|
|
|
|
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
|
|
|
|
|
Hi All,
i am getting following web config parser error when i run my web application.
Parser Error Message : Unrecognized attribute 'cookiename'
|
|
|
|
|
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
|
|
|
|
|
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 
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
