|
In your opinion, what is the best way to implement searching / filtering on an sqldatasource? Right now i have my datasource linked to a gridview. I use the FilterExpression property and assign is a "LIKE %" expression, and FilterParamerters which are control parameters.
I have a feeling that there is a better way to do this more efficiently, and securely (beware sql injections).
Any suggestions ?
|
|
|
|
|
I am working on web based emart project in asp.net. I want to make my own framework for it. how can i design it
Signature preview salil_k_singh 11:06 15 Jul '07
|
|
|
|
|
That's a rather broad question for a reasonable answer on a forum. I'd recommend that you start by getting Framework Design Guidelines[^], authored by Brad Abrams and Krzysztof Cwalina of Microsoft's CLR team. While you're waiting for that to arrive, start reading through some results from Google[^].
Hope that helps to get you started. 
--Jesse "... the internet's just a big porn library with some useful articles stuck in." - Rob Rodi
|
|
|
|
|
Hi guys,
I've just started a new ASP.NET application and this time we're using SQL Server 2005, I've normally uses MySQL with the .NET Connector (a membership and role provider for MySQL).
And when I'm looking at the tables generated by the membership provider there's one table I don't recognize: the dbo.aspnet_Paths table. It has three columns (ApplicationId, PathId, Path, and LoweredPath).
So, what is that normally used for?
I've tried to google for it and so forth, but without any luck.
"When you have made evil the means of survival, do not expect men to remain good. Do not expect them to stay moral and lose their lives for the purpose of becoming the fodder of the immoral. Do not expect them to produce, when production is punished and looting rewarded. Do not ask, `Who is destroying the world?' You are."
-Atlas Shrugged, Ayn Rand
|
|
|
|
|
Its used for personalization. This entry[^] from Microsoft describes them in the context of Web Parts personalization, but if memory serves me correctly, I believe they are also used for other personalization that is not bound to the user profile.
Hope that helps.
--Jesse "... the internet's just a big porn library with some useful articles stuck in." - Rob Rodi
|
|
|
|
|
Hi Jesse.
Thanks for your answer. You know, I did had the hunch that that's that they were for, since there's also two Personalization tables. Oh well we're not gonna use WebParts so I can simply ignore them - I just like to knows what's in my database.
Thanks Jesse.
"When you have made evil the means of survival, do not expect men to remain good. Do not expect them to stay moral and lose their lives for the purpose of becoming the fodder of the immoral. Do not expect them to produce, when production is punished and looting rewarded. Do not ask, `Who is destroying the world?' You are."
-Atlas Shrugged, Ayn Rand
|
|
|
|
|
Hi,
Is it possible to add a ValidatorCalloutExtender in a Composite control?
The problem I have is that I can add the control, but I can't access the TargetControlID. Has anyone solved this or know what is causing this problem.
The same problem applies to the ConfirmButtonExtender control.
Thanks,
--Tomas
modified on Thursday, April 10, 2008 11:20 AM
|
|
|
|
|
Find the solution myself. The error was caused by the missing reference System.Web.Extensions. To be able to access the TargetControlID property that reference need to be in the project.
Hope this will help someone else.
Regards,
--Tomas
|
|
|
|
|
I think this might be a common problem with IE, but I'd like to hear anyone's thoughts and hopefull fixes to the issue.
using vs.net 2003 - gif image sometimes freezes in IE.
|
|
|
|
|
Hi
I have an image button in a template field
I have an onclick event for this button
How can I find the id of the row I am on in the gridview
previously I had a hyperlink so I could just use something like this:
NavigateUrl='<%# "page.aspx?variable=" + Eval("datafield")
but now I need to do it in the c# on the click event
any help would be great thanks!
|
|
|
|
|
A hands-on example for ya (don't mind the Dutch words in it)
In your aspx:
<asp:TemplateField ItemStyle-Width="16px" >
<ItemTemplate>
<asp:ImageButton runat="server" ID="imgAnnul" ImageUrl="~/Images/x16.png" AlternateText="Reservering annuleren" CommandName="AnnulGrid" OnCommand="Grid_OnCommand" />
</ItemTemplate>
</asp:TemplateField>
in your aspx.cs code:
protected void Grid_OnCommand(Object sender, CommandEventArgs e)
{
ImageButton btn = (ImageButton)sender;
GridViewRow row = (GridViewRow)btn.NamingContainer;
if (e.CommandName.Equals("AnnulGrid"))
{
grdReservation.SelectedIndex = row.RowIndex;
grdReservation.SelectedIndex = -1;
}
LoadReservation(grdReservation.PageIndex);
}
|
|
|
|
|
what does
LoadReservation(grdReservation.PageIndex);
mean
and where do i delcare LoadReservation?
thanks so far
also
how can i display the ID from the gridview, where is it stored?
thanks!
|
|
|
|
|
In the Method LoadReservation I reload my GridView with the correct PageIndex. I created this method so it is no default in ASP.NET.
I do this cause you change the settings of the GridView and after the age has been rendered you need to show the altered gridview.
What do you mean by ID. Isn't it what you state in your ASPX page:
asp:GridView runat="server" ID="grdMyGrid" ....
?
|
|
|
|
|
Basically the rows are displayed from a query.
Say I have ten rows and I click on a button in one of the rows, well I need to get one of the column ids from that row. e.g.
Item Code Item Price
df4545 test 12.99 Button
fh9707 test2 14.99 Button
Say I clicked on one of the buttons, how would I get the item_code ID as it is the same row?
thanks
|
|
|
|
|
In GridView you have the ID set
DataKeyNames="ID"
In the aspx.cs you can do:
ImageButton btn = (ImageButton)sender;
GridViewRow row = (GridViewRow)btn.NamingContainer;
if (e.CommandName.Equals("AnnulGrid"))
{
grdReservation.SelectedIndex = row.RowIndex;
Int64 waardeID = Convert.ToInt64(grdReservation.SelectedValue);
grdReservation.SelectedIndex = -1;
}
I convert the SelectedValue (which is available after setting the SelectedIndex) to In64 because my Databasefiled ID is a BigInt
For a DB-field int you can use int/Int32 in your conversion.
The value of a CELL in a GridView can be obtained via:
In Selected Mode:
row.Cells[1].Text
In Edit-mode:
(TextBox)row.Cells[1].Controls[0]).Text
|
|
|
|
|
I developed an ASP.NET web page using as object Crystal Report. I'm using multiview. After the report run, when I clicked Export or move to the next page, the web page goes blank. I tried in different ways to see the report. I have the following code:
protected void Page_Load(object sender, EventArgs e)
{ // Begin Page_Load
if (!Page.IsPostBack)
{ // Begin if
mvwReport.SetActiveView(viewParameterPrompt);
} // End if
} // End Page_Load
To open the report I have the following code:
CrystalReportViewer1.ParameterFieldInfo = myPFs;
CrystalReportViewer1.RefreshReport();
mvwReport.SetActiveView(viewReportOnDemand);
I don't understand why when I click any button of Crystal report the report goes blank. I hope that someone can help me to handle this issue. I appreciate any help or suggestion or idea.
|
|
|
|
|
Your code in the Page_Load should be put in the Page_Init eventhandler
|
|
|
|
|
I wrote the code in Page_Init but the report is still not showing the second page. Also, I have problems to use the toolbar. I need help about this matter. Does someone have an example of the code to load a Crystal Report Object using C# in ASP.NET ? I appreciate the support.
|
|
|
|
|
can you show the code(-behind) of that page?
|
|
|
|
|
Hi all
I am trying to write an application that would generate an ASP.NET page, based on certain defined criteria. Database support will also be needed... Has anybody attempted such a thing? Any pitfalls I should be aware of? All suggestions are welcome.
Thank you in advance
Chandra
|
|
|
|
|
ChandraRam wrote: generate an ASP.NET page
What do you mean by this? Generate the html output, or generate a file with ASP.NET server tags, etc.?
only two letters away from being an asset
|
|
|
|
|
Hi
Thanks for replying...
What I am looking for is to generate the ASP.NET page (aspx file) and also the VB code behind file. Maybe I can use some templates? In the generating application, I will know what controls (like combo boxes, text boxes and check boxes) and how many of each will be needed, as also the database to connect to and the criteria for populating the controls.
I really hope this is feasible
Chandra
|
|
|
|
|
Have a look at ASP.Net Maker- may help you
|
|
|
|
|
Thank you But what I want to do is write my own generator, which will probably not include all of the features in ASP.NET Maker.
|
|
|
|
|
I get the following error message as soon as I run my application. The problem is I get it randomly(not every time I run my app) and if I try to run my application again after couple of hours, it works fine.
***********************************************
Server Application Unavailable
The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request.
Administrator Note: An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur.
**********************************************
Can someone please suggest whats wrong. Is it the application or the .Net or IIS?
Thanks
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
