|
Second approach; Select 1 is used to minimize the processor workload (there is no need to return the fields)
you could also consider:
SELECT count(*) AS Results FROM dbo.by27_Levels WHERE LOWER(@LevelName) = LOWER(LevelName)
|
|
|
|
|
hi friends
i have 5 textboxes(empid,date,intime,outtime,workingtime) and submittbutton
now i enter some integer value in the textboxes
now my query is
empid,date is already entered in database.i dont want enter same empid,date
how can i compared parricular empid,date exist or not.if that empid,date exists it will show error
thanks in advance
saravanan 
|
|
|
|
|
Hi all
I have a datagrid, which holds item name, item price, and its image(all from SQL Server database), what I need is when the user clicks on the image, I need the (id) for the item to be carried to the new page where I want to show more details about the item (expiry date, ...)
Regads
|
|
|
|
|
Can someone explain when would be a good time to user Server.Transfer? Thanks.
- Robert
|
|
|
|
|
Hello Robert,
Assume you have two forms form1.aspx and form2.aspx. now you want all the controls of form1.aspx can be retrieve in form2.aspx, in this situation you can use form2.aspx.
Regards,
S Kumar
|
|
|
|
|
In 2.0 we have three options and all come with its +/-ve
A) Response.redirect
-ve : round trips, value can not be passed across pages
b) Server.Transfer
-ve : Loose browser history, but good for value pass and no round trip
C) PostBackUrl
New feature in 2.0 and in my views, you should use this only when you need to transfer from page a to b. Because in background it creates all the page events of page a  ...
So use wisely and smartly...
Amit Gugnani
|
|
|
|
|
I will also post this in VB forum. I have a general question. I want to create a "webbased, interactive, and collaborative classroom learning tool". I believe ASP would be a good language for this. However, I also have a strong need to become proficient in VB. My application will be a type of question and answer game to be used in the classroom.
Here is my question; If I first build it entirely VB.net as a VB application, how easy is it to then move it to the Web using ASP?
You can tell from my question, I am not an expert in either or I wouldn't be asking. I know some VB but no ASP. I have six months to work on this so I am somewhat confident I can do whatever needs to be done.
Thanks,
Jinx
|
|
|
|
|
Answered in VB.NET forum
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
Hai,
i am working on project which is having 10 modules already,used ASP.net,vb.net for coding.in this new technologies are not included like websevices,ajax.
Now i am including new module.i want to use c# for coding,is it possible to integrate with existing modules others are used vb.net.
and what thenew technologies i can use ,which can make my screen appearence rich and makes my job easier, Please send the possibilities
nice to be a member of codeproject,
surendra
surendra
|
|
|
|
|
Hi,
you can always integrate VB.NET and C# assemblies together if they maintain CTS properly.
For new technologies, I can say that you are well aware of AJAX and WebService. What I can say that you try scriptoculous and dojo libraries for rich user interface.
Pradipta Basu
|
|
|
|
|
Thanks for ur reply,but i am not well aware of ajax and websevices,where can i get better pratices for them
and u said some libraries for rich look...can u plz eloborate ..?
surendra
surendra
|
|
|
|
|
To learn about ajax technology please search google. you will definitely get good links.
The libraries that I had mentioned are javascript libraries with inbuilt AJAX and effect in it. It will make your life easy for good looks of your pages.
The links are
Scriptaculous[^]
Dojo[^]
Dojo will give you better effects than Scriptaculous, but Scriptaculous is easier to use.
Both the libraries are free.
Pradipta Basu
|
|
|
|
|
thank u pradipta,
surendra.
surendra
|
|
|
|
|
Hai Friends,
I have a Requirement ,in that Dynamically Textboxes and Dropdowns will be generated
then page will become large, when i click on any dropdownlist(autopostback = true)
it is being post backed, its again starting from page begining
agin i am going to that dropdownlist position,again doing some thing
not doing like this,when i click on it, post back should be done and ctrl should be there only,is there any solution for it?
actually iam using SMARTNAVIGATION = TRUE,It is working fine, postback is done, ctrl is there only
but some times ,it is giving problems some times
we can use ajax for it
but other than that is there any solution for it?
|
|
|
|
|
smart navigation is not a good solution, it would not work in Mozilla.
Pradipta Basu
|
|
|
|
|
why not... create web request thru javascript. But honestly speaking as per my understading we are all buying same fruits but with different color...
AJAX, POSTBACKURL, XMLHTTPRequest all feature do the same job more and less....
what is your view...
Amit Gugnani
|
|
|
|
|
I have a GridView that displays rows of pictures along with text that describes the pictures. One of the columns in the GridView is a template column. In that column I have added a HyperLink. When a user clicks on the HyperLink I want it to go to another page but I want to pass this page the value from another column (my primary key column) in the GridView. So far I have defined the PostBackURL in the HyperLink but how can I get the value from my primary key column in order to pass it as a parameter? Thanks.
|
|
|
|
|
U can define DataKeyNames="PrimaryKey" in the html of gridview and on code behind u can do this way:
Dim oGridViewRow As GridViewRow
oGridViewRow = CType(CType(e.CommandSource, Control).NamingContainer, GridViewRow)
ID = grdTitlePlantInformationView.DataKeys(oGridViewRow.RowIndex)("PrimaryKey").ToString
For redirect to another page write this on Row Command of Gridview:
Response.Redirect("frmAnotherPage.aspx?ID=" & ID & "&info= " & e.CommandName)
|
|
|
|
|
What event in the code behind to I add this code?
Dim oGridViewRow As GridViewRow
oGridViewRow = CType(CType(e.CommandSource, Control).NamingContainer, GridViewRow)
ID = grdTitlePlantInformationView.DataKeys(oGridViewRow.RowIndex)("PrimaryKey").ToString
|
|
|
|
|
could anyone help me on how i can connect asp.net page to read and displa data from an excel file in asp.net page.
The first row of the Excel, i want to use as the fields contains caption names and the names is made up of characters combined with other charcaters like (%, ', -, /, @).
t.aransiola
|
|
|
|
|
Where are the xls files, on the client or on the server ?
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
the Xls file is on the client. Im also considering connecting the asp page to the Excel file on a remote(web) server
thanks
t.aransiola
|
|
|
|
|
|
You can make an web service that shar both application.
Parwej Back...............DON of Developer.......
Parwej Ahamad
g_parwez@rediffmail.com
|
|
|
|
|
just pass it in the query string... in App A do:
<br />
Response.Redirect("www.appB.com/?run=yes);<br />
Then check it in AppB, you could also encrypt the querty string to protect its contents.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
