|
You can do as :
Select a.col1, b.col1 from table a, table b
|
|
|
|
|
I would like to know how to modify a sitemap and/or change some C# 2010 code to not allow certain users access to this new web page.
I am basically adding a new web form page to an existing C#.net 2010 application. I am adding some web pages that will be displayed from the main page.
Right now the contractor that setup this application, had 'shells' for the modules that will be added at different points. When the existing web page displays that I am going to add to this website, the page is pointed to a 'mapped url' that displays 'the site is under construction'.
In the web.config file, there is a sitemap that says who access the web page. I tried to give the sitemap a user role that does not exist in the active directory and the web page still displayed.
Thus can you tell me and/or point me to a reference on how to modify the sitemap and/or add some code to the application so only users under a certain role have access this this new web page?
|
|
|
|
|
To the best of my knowledge, the sitemap.xml is just a xml file that contains sitemap nodes.
You can't control access to files and folders through it.
You have to write code for each page, to control access.
So let's say you have 5 levels of security
On login, you would add
Context.Session.Add("security", 5)
And in the page, on page.init, your code would say
If Not Context.Session("security") > 3 Then
Context.response.redirect("security.aspx")
End If
|
|
|
|
|
I agree with this.
You cannot control security using xml but you can check variables and then redirect accordingly.
Another option would be to use a database and check the users security level and that will determine what pages they can view.
Kind Regards
Julian Mummery
|
|
|
|
|
Hi
I am making a website in ASP.NET on which i want to show food menu. It can be any no pages. I want to save it in database and show it on web page with page turn. What is the best way to do it. I know how to upload single file to database and show
it on web page.
Thanks in advance
Inderjeet Kaur
Inderjeet Kaur
Sr. Software Engg
|
|
|
|
|
See here[^]; please post your question in one forum only.
|
|
|
|
|
We need your help to solve printing issue with Card Printer (Zebra P430i)
Card Printer is directly connected to Server and it is working in LAN.
From the web application we are directly printing to the server as in the sample code provided (By invoking zebra DLL).
Copied the DLL files to system folder.
The printer is working fine from client and server if we are doing test print or running using visual studio.
But not woking through the IIS.
I am getting the following exception from IsPrinterReady()
An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)
Is there any other method to print the card (printer in client/server) using c# and ASP.net?
Please help us to sort out the issue.
HELP HELP HELP PLEASE
|
|
|
|
|
Hi to all,
I have more than 100 values in one table column(Database).I need to show in gridview to those values in ten rows(like 10 rows and 10 columns).
Is it possible or not.
Thanks in Advance,
Sundaramoorthy
|
|
|
|
|
Your question is not quite clear. Please rephrase and elaborate a little more.
|
|
|
|
|
I think I know what you are trying to say.
I do not think you can do this from the data in one column.
What you might try doing is create a temp table with which mirrors the layout of your gridview and then populating the rows and columns from that.
Kind Regards
Julian Mummery
|
|
|
|
|
Use Datalist for your requirement..Without any more efforts Datalist fulfills your requirement.
<asp:DataList ID="Datalist1" runat="server" RepeatColumns="10" RepeatDirection="Horizontal" >
</asp:DataList>
Bind the Datalist same as Gridview through Dataset or Datatable or as you like.
Thanks
|
|
|
|
|
Hi, I am using telerik grid i need to compare two or more person details which control i need to use in asp.net and i need check box control in rows.
|
|
|
|
|
On one side you say that you use telerik grid but on the other hand you ask for asp.net control! You can use Grid with checkbox or datalist with checkbox for this if you want to use standard ASP.NET control.
|
|
|
|
|
I am suppose to enhance an existing C# web form 2010 application. On the current web form page that I am suppose to enhance, the users enter some informatiion on the web page that updates one table in a sql server 2008 database.
Now the table has been expanded to contain an additional 20 more columns. When the user clicks the existing 'submit' button, I am going to add a formview control that will be displayed on the lower part of the web page. The user will enter more information on the formview control and the one sql server table will be updated.
I only want one update to the database table.
Thus my questions are:
1. From the exisitng asp.net table, how can I make the formview control be displayed?
2. How would I pass data fromn the asp.net web table to the formview control? Would I make the properties public for this one object?
Can you tell me how you suggest I work with the formview control?
|
|
|
|
|
Hi classy
It is very simple job to do the insert in database with formview you just need one sqldatasource control with the Insert and select statement and attach that sqldatasource control to the formview and set the mode of form view to the insert so it will work like normal form to insert record
If you have any problem about the formviw or sqldatasource let me know i am happy if i could help you.
Best of luck !!
|
|
|
|
|
How should I obtain the information that is obtained from the existing web page and pass that information along to the formview control? I do not want to update the database on the existing 'submit' button. I want to update the database when I create the new submit button that will be displayed farther down on the page?
|
|
|
|
|
Hi,
I have dynamic tabs (no of tabs vary according to Business), I have created dynamic tabs using code behind by adding into unordered list using
for(int i=0;i<5;i++)
htmlBuilder.AppendLine( Tab(i))
it created all tags in html code with specific ids.
In the designer page i have gridviews hardcoded each region for each tab.
I am trying to href the tabs from code behind to bind to gridview. like
tab1--- href=#a1 (tabs are generated using Jquery)
tab2--- href=#a2
<gridview id="a1">; ... and so on
How to handle multiple gridviews from code behind. how to declare multiple template gridviews dynamically
|
|
|
|
|
I would like to find alternatives for updating a database every time the user clicks a 'next' or 'submit' button on a C# 2010 web form application
Right now I have added two new web pages to an existing C# 2010 web form application. Currently when the user enters information on the first page and hits the next button, the 'main' table and the 'sub' tables have rows inserted into the database. When the user is on the second web page, they can update additional information on the 'main' table only.
Also on the second web page the user can click a 'previous' button and return to the first page. The user can correct fields that were incorrect on the first page. They hit the submit button and those columns are updated on the main table and the user is directed to the second web page. When the user hits the 'submit' button on the second page the database is updated again.
Thus I would like to find a way to pass information between the first web page and second web page and not update the database. I only want to update the database when the user clicks the 'submit' button on the second page.
Can you tell me and/or point me to a reference on how to accomplish this task?
|
|
|
|
|
One way would be to add the form values to the session so it is available on both pages and only update the database when the user presses a save button. You could also, for instance, create a class to hold all of the form values as properties and add the class to the session rather than a bunch of individual form values.
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum
me, me, me
|
|
|
|
|
Thanks for your answer so far! I have the addtitional question to ask:
I will need to pass information that would update two different tables. One table contains about 50 columns that would update one row in the table called 'main'. The second table called 'sub' only has 4 columns in each row. However the second table is joined to the fist table and can have from 1 to 400 rows that ties to the 'main' table.
Could I pass the information between the passes using a dataset that contains two data tables? The form values you suggested to does not suggest this as an option. Is that a possibility?
Thus I am wondering what option would be the best for my situation?
|
|
|
|
|
Maybe you could implement a staging table where you would write entries as the user navigates between the pages and only when the proper "submit" button is clicked would you process those records from staging to production.
just a thought.
|
|
|
|
|
What do you mean by a staging table? Would this be a real table that I write write directly on the sql server database? I mean it would be a table that I create while the application is running and delete the table when the application is finish running? The table would be on sql server and not in a data table?
|
|
|
|
|
Yes, this would be a real, server-side table (maybe more than one).
My idea is that when the user goes into "edit" mode, you would:
1) Generate a transaction ID which would be valid for the lifetime of the edit session
2) copy the necessary data from your primary tables to this staging area along with the Transaction ID for each record.
3) As the user navigates between the pages all edits are saved to this staging area
4) when the final "save" button is clicked all of the staging data associated with the Transaction ID would be applied to the primary tables and the staging data is deleted.
You will have to deal with abandoned transactions when the user just closes his browser and that staging data is neither applied or deleted. If your applicaiton has a logout page, then you could delete all staging data when the user logs out.
just a thought.
Vote if you find this helpful.
|
|
|
|
|
Hello all
I wish your opinion about the above differences in performance between VB.net application that uses the web services through Web Reference and made a web application in ASP, Javascript or PHP.
I am developing an application using just the web services via webservice. I have an IIS server with a database that my application connects to. I'm following this path since I'm a pretty old designer. I have much more familiar with procedures and forms rather than HTML, Javascript and other gadgets and the spare time between work and family that I would remain for the study of such environments and possible coding is very little beyond the fact that progress would be much slower.
That said, a desktop application like this, what limitations should be meeting?
The big advantage is that I write in one language, I do not have to worry about HTML, CSS and similar mischief, but what do I'm going to lose?
My biggest fear is to be penalized in terms of performance, perhaps with restrictions on access to the db, because basically this is the only service that my server provides, but much more I'm worrying to realize after much time and work that I had gotten into a blind alley
Thanks a lot for your kind replies
|
|
|
|
|
ilgrongo wrote: VB.net application that uses the web services through Web Reference and made a web application in ASP, Javascript or PHP.
IN theory, it would run faster, because it's not running in a browser. Doesn't matter if its vb or c-sharp, in terms of speed or functionality, its all the same. It produces the same result in the same amount of time. A web service is a web service, regardless of it being php, asp or asp.net. It's suppose to be homo-genius, and transparent regardless of who made the request.
ilgrongo wrote: desktop application like this,
Are your talking about a windows program written in vb?, that talks to a web server running asp.net?
ilgrongo wrote: I do not have to worry about HTML, CSS and similar mischief,
If it's a windows program, then none of that applies anyways.
I'm confused here, I think you have 1 way to do it in mind, and your trying to solidify your decision, in which I don't see an alternative. If you have to get data from a remote server, then you either tunnel to the server using ssl, or make a request to a web service.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
