|
As already pointed out, use parameters: SqlParameter[^].
But if you still for some reason want to use literals in SQL statements, add apostrophes when you're adding texts to the statement:
chk1 = "select Sno from Student where SID = '"+ @smemno.Text.ToString() + "'";
|
|
|
|
|
Hi,
Can you please help me how data export in Excel File in Ado.Net using Gridview.
Thanks & Regards
Mohit Sharma
|
|
|
|
|
You can't, not on the client. Do you want to export data from the gridview into an Excel Spreadsheet on the server?
|
|
|
|
|
|
Heya, i got a new question,
I got my website, where i placed in header the logged in bar, which includes the "Hello, <username>" and bellow PROFILE | LOG OUT.
The thing is, that the LOG OUT in order to work, has to be a
|
|
|
|
|
You can only have 1 form per page. Put everything in the 1 form.
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
|
|
|
|
|
Yea, but brother told me that, but i got different containers, i.e: like this:
header container
form
LOGGED IN BAR
/form
/header container
body container
CONTACT FORM
/body container
can i do something like this ?
header container
form
LOGGED IN BAR
/header container
body container
CONTACT FORM
/form
/body container
Thanks for replying btw!.
|
|
|
|
|
There is no reason to have two separate forms on your page. Use one form and handle the proper events. Such as, handle the login/logout button click event and the submit button click event. What problem are you trying to solve with two forms?
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Hello again, Mark 
My doubt is about the asp:container's i got on each aspx.
as i mentioned in the previous reply, i got a header container and a body container.
My questions is: Am I able to open a form in the header container and close it in the body container, and afterwards, manage all the events with onclick property -as you said-?
Because i got the log out bar in the header, and contact us form in the body. Need a solution in order to place all the events in one single form 
Thanks again!!!
Marian.
|
|
|
|
|
One form and many ContentPlaceHolders is how the default masterpage is constructed when starting an ASP.NET web application project within Visual Studio. Do you understand the concept of masterpages and contentplaceholders?
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
yea, correct me if i'm wrong, the masterpage is the "DEFAULT" page and then i create other pages that "inherits" (i know is not inheritance, but just an example in order to explain what i know) from the masterpage. For example if i have a masterpage with header and footer as master.master with a contentplaceholder in the body. Then i create a login.aspx with master.master as the masterpage and include my independent code inside of the container of login.aspx. When i run the webpage, the masterpage creates the proper HTML.
I realised about the forms, when you create a new .aspx file, with the default code. It shows something like this:
// Here I should add all the ContentPlaceHolder's right?
And manage all the events from each page without needing a lot of forms.
Thanks again
Marian.
|
|
|
|
|
Hi community thanks for helping me so far, i'm really glad that i found this site.
Here's the doubt i got since i started with ASP:
1) I'm not using IIS yet, im using the localhost provided by ASP.NET to test and debug my website before i upload it to the host.
Anyway, when i change from aspx to aspx it takes like if i would be really connecting to the internet and its loading all the things, its not like when you are making the website with flat HTML, PHP, javascript, etc using XAMPP. Actually my website its not fully loaded with images and things that might get you lag.
After thinking why this is happening, i was really upset, so i tried to create my very same website (without asp components, masterpage and stuff ofc) and the same js files, image files, css files, all was alike, and it worked awesome, very fast... so i said, there's two things here... is it the ASP.NET inner localhost or ASP.NET itself.
For instance, i got some pictures with onmouseover event and change to another img, and on mouseout it returns to the "off" state.
And the very first time i mouseover the image, it takes about 3 seconds to load the mouseover image, after the first one, everything looks normal. But why it has to load the image if i'm locally requesting it?
2) Remembered that i have another thing to clear up. I'm trying to reset the fields of my asp inputs and selects components, is there anyway to do it as the HTML does with the
<input type="reset"> ? is there a similar property for ASP? I did it now by code behind with the onclick event, that restarts all the fields to "" or SelectedIndex = 0, works good, but it makes a postback because its server side, i would like to do it, without the postback. Any possibility???
Thanks! Hope i'm not bothering you with my noob questions.
Marian
|
|
|
|
|
Javascript is how you do it on the client side. A quick google search will teach you how to reset fields on page load, be careful though, you dont want the script running on postbacks.
The slow loading ASP.NET stuff can happen for lots of reason, a slow machine trying to run the site while using Visual Studio, having debuggers attached... ect...
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
|
|
|
|
|
Yea, it might be, tomorrow i will test my project on a better computer and not my netbook, anyway my netbook is pretty powerful (dual atom 1.8ghz, 4gb ram, and a 512mb video card (ION2 Platform)) dunno, it runns everything really fast.
But im still thinking about the Localhost. When its loading it says at the bottom of the browser in the status bar:
"Waiting for localhost..."
And remains like 2 or 3 seconds per page.... and it loads as i said, as if it would be running in the internet.
Thanks again!
Marian.
|
|
|
|
|
Yea! you were right! Tried my website in a C2D 2GB RAM and it worked PERFECT, took not even 1 sec to load a page. Everything runnning so smoothly (locally ofc).
Thank you very much!
Marian.
|
|
|
|
|
you have to remember when running on //localhost that you are essentially running a server for a minute in the background. The first time you run the application from within VS the server has to start up etc etc.. I run an asus laptop with i7 processor, 8 gigs ram and so on. even mine can be few seconds slow on the first run.
Programming is a race between programmers trying to build bigger and better idiot proof programs, and the universe trying to build bigger and better idiots, so far... the universe is winning.
|
|
|
|
|
Woo, but the localhost server is taking a lot in my netbook, every single time, not just the first one. Don't know why. And that didn't happen in my work computer, which has a Core 2 Duo and 2GB of RAM, it took like a second the first time.
btw, wtf nice notebook  alienware specs.
|
|
|
|
|
thanks, its not an alienware but its a nice pc. and was reasonably priced for what I got out of the deal. I run up to 4 vms at once in it since I am working with sharepoint. one vm with server2008r2 and sharepoint, one with sql, one for a webserver and one for an AD. I get very little lag out of it for the most part(of course I have the vms running on minimum ram for the OS since they are just for testing.)
I run all 4 of them that way to emulate our office environment and allow me to play with sharepoint without going and telling my boss that I had an oops on the live sharepoint server.
as far as the difference between your pc and work pc, it could be any number of settings, or maybe your pc has more services running in the background. Hard to say really. But if the code runs fine on the other machine my guess would be that the code is ok as far as performance its just your machine running localhost that is lagging up for whatever reasons.
Programming is a race between programmers trying to build bigger and better idiot proof programs, and the universe trying to build bigger and better idiots, so far... the universe is winning.
|
|
|
|
|
Thanks for your support gavidon!
You are being such a nice person, the whole community.
|
|
|
|
|
your welcome. I ahve been reading on CP for almost two years and am just now starting to add my half cent once in a while. Thought I better follow example of the CP guys and be nice myself..
Programming is a race between programmers trying to build bigger and better idiot proof programs, and the universe trying to build bigger and better idiots, so far... the universe is winning.
|
|
|
|
|
that's so cool! ok, don't want to convert this into a chat hahaha, thanks again!!! and see you around! 
|
|
|
|
|
Ok, as the title says... i would like to add a HyperLink inside of the CheckBox Text attribute, in order to create something like this.
I'm 18 years old, i read and accept the Terms and Conditions, and also the Security Policies.
Where Terms and Conditions and Security Policies are links, am i able to do this?
Thanks
Marian.
|
|
|
|
|
Did you try to do something like this:
<asp:CheckBox ID="myCheckBox" Text="To Search:<a href='http://www.google.com'>GOOGLE</a>" runat="Server" />
|
|
|
|
|
LOL  it worked, i tried but i didn't work for me, looks like i made a sintax mistake... thanks!!!! really appreciate that!
|
|
|
|
|
Hi,
I am using role based authorization. Is it possible to deny access to a control using webconfig.
I have created a menu ( not from sitemap) in the master page and I want this menu to be accessible only by users in roles and not by everyone else. I know I can make it invisible in login page etc but is there any other way?
Here is a part of the web config code
<authentication mode="Forms>
<forms loginUrl="login.aspx">
</forms>
</authentication>
<location path="Admin">
<system.web>
<authorization>>
<allow roles="Admin"/>
<deny roles="Employee"/>
<deny users="*"/>
</authorization>
</system.web>
</location>
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
