|
Hi all, thanks for looking
I need a form to retrieve rows from a table based on parameters from querystring
SelectCommand Example:
SELECT * FROM Users WHERE Name LIKE '%' + @str + '%'
This will return all rows that have the word @str in Name column
If i set the defaultvalue for the @str Parameter to %, it will return all the rows when no parameters are passed
I need the same but for an int column
SelectCommand Example:
SELECT * FROM Users WHERE UserID = @UserID
If i pass a number, it will return a row of the user with UserID = @UserID
But if no parameter is passed it wont work
My question is
Is there any way i can make this last query to return all the rows if no UsersID is passed
Im giving this examples, i know they might seem very easy, and you may say, make 2 different SelectCommands and set them in the code
But in fact, Ill have more than 5 diferent querystring parameters, all applied to the same table, and any combination of this parameters is valid (param 1 and param2, param 1 only, param 5 only, param 1 2 and 4, and so on), so if i implement this in separated SelectCommands ill end up having more than 20 almost equal SelectCommands
Any advice will be appeciated
Thanks in advance
Alexei Rodriguez
|
|
|
|
|
AlexeiXX3 wrote: If i set the defaultvalue for the @str Parameter to %, it will return all the rows when no parameters are passed
You just showed an example of SQL Injection Attacks. I would do some research on how to keep that from happening. By doing this research you should find the answer to your question as well.
SQL Injection is nasty business, fix it now, before you have to deal with the consequences, like deleted tables...
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
|
|
|
|
|
Doesnt the use of parameters for SQlDatasources prevent SQl injection??
I know that sqlinjection is a big problem and i need to prevent it at al cost, i tought that one of the functions of parameteres was to prevent SQl injection
Alexei Rodriguez
|
|
|
|
|
hi
i need guidance and help regarding following scenario for a web app using asp.net 1.1(C#)
i am getting output of a web service that is xml but as a string now i want to put all the info in a table
i am putting that output stream to a dataset and then try to utilize that but there is a problem that when i give that xml to a dataset as source dataset create more then one tables while i want to store all as a one table column also there are no dependencies in those table all have unique values
so can some one guide me that if there is some better scenario or how i can merge dataset tables column in one table so that can be store able in a db table
regards
shezi
modified on Thursday, March 6, 2008 12:54 AM
|
|
|
|
|
Have you solved this?
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
|
|
|
|
|
Hi,
I have developed a website and deployed it in a remote server.
When i access the site through http://localhost, the site works very well.
But when i give the ip address instead of localhost, i get a 404 page not found error message. The same site worked well when accessed through ip in my Testing environment.
I am using framework 2.0. Any ideas?
|
|
|
|
|
hi all..
iam developing a web application using asp.net/vb.net.
in my application i have some data to tbl_sample table.
now i want to convert the data in sample table to a text file..
so, can plz give me some links which helps me to solve this...
iam searching google but, i didn't find correct links.....
if it not the correct fourm for this kind of help ,
plz tel me where i have to post dis...
thank you,
siri
|
|
|
|
|
Your question has nothing to do with ASP.NET.
It is SQL-related, so it belongs in the SQL forum.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
 Hello all!
I've been folowing Scott Guthries MVC Blog[^] and I'm having some issues getting it to work.
I've implemented it using a SQL Server database, which is an asp.net roles/membership implementation with some other tables added in for Products, Categories etc.
My problem is on the View page and the Code behind. When I place a asp:ListView control (with ID="categoryList") on the page (by code not dragging and dropping in the Design pane) and then switch to the code behind page, I get no IntelliSense type ahead on the ListView control to do the databinding. If I type the control name and binding lines, ie
public void Page_Load()
{
categoryList.DataSource= ViewData;
categoryList.DataBind();
}
and attempt to build the project it tells me the categoryList control doesn't exist in the context.
I've tried removing the Page_Load() section, building the project and then re-entering but to no effect. I'm sure it's going to be a silly mistake I've made. Any suggestions?
Brian
|
|
|
|
|
Well i found the problem, or at least a fix for it. Have got tons of other issues now of course!
In the code behind I added
protected System.Web.UI.WebControls.ListView categoryList;
in the partial class and it fixed it.
|
|
|
|
|
hi guys i have a query, i have a website which is developed in html now i want to add some .aspx pages into it. is it possible, if so how to do it?
please reply if u know, i need it urgently.
jAgAdEeP.sUgGuLa
|
|
|
|
|
Member 4194906 wrote: please reply if u know, i need it urgently.
Of course you do.
Yes, it works.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
hi all... i have been working on an idea that stems from my knowledge of application design and development. I have been developing an application which allows end-users use to drag & drop elements and set properties on a design canvas to create a diagram which will (once completed) be used to generate asp.net application code.
users can use my application to build simple forms or webbased applications and will eventually enable them to create quite complex systems by piecing together "sub-diagrams".
the elements are broken down into logical objects like: eshop, user, data (order, product, etc), country list, etc... and the user can connect them up (using fully rule based connections).
just imagine my application being similar to creating a visio diagram with elements having properties and wizards to define their use. then at the end it generates application code and compiles it to create a fully functional application. or alternatively the my application just creates source-code from the diagram so developers can further customize it.
anyway, my question is, now that i have created a very functional prototype which works pretty well, i need to ask all of you for your opionion on whether the concept is viable? would people use it? are there complexities i might have forgotten about? I plan to provide it for free as it will be more of a labour of love and hope to get other developers onboard for future enhancements.
|
|
|
|
|
Yes, people will use it, and people already do. Just the other day someone was posting about how they found out an old employee used code generators. I have used code generators for CSS. It isn't worth the manual labor required to do what can take seconds.
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
|
|
|
|
|
Hi,
i have one problem. I create web site in VS.2008 on .NET 3.5. On my parent page i have iframe which source attribute src i populate dinamically in code behind :
HtmlControl frame1 = (HtmlControl)this.FindControl("ifrCache");
frame1.Attributes["src"] = "form.aspx?form=" + formID;
Iframe source is child page who have input text field.
Is there any way to get value of input text fields on parent page from iframe source page?
|
|
|
|
|
Yes, you can access the controls on the IFrame page just like you did with this:
c#ivan wrote: HtmlControl frame1 = (HtmlControl)this.FindControl("ifrCache");
You have to do it on the IFrame Document though, but same idea.
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
|
|
|
|
|
Another problem is that HtmlControl frame1 = (HtmlControl)this.FindControl("ifrCache");
return null but i add runat=server to ifrCache so i can use it like server control and it works. The same problem still persists. I do not know how to access to controls in iframe? Is it javascript solution? 
|
|
|
|
|
I have gridview for update by template field. Update activate with click twice. How can i make it work with single click? This is coding
.aspx ->
<asp:BoundField DataField="ITM_MGRP" HeaderText="M-Grp" ReadOnly="True" />
<asp:BoundField DataField="ITM_SGRP" HeaderText="S-Grp" ReadOnly="True" />
<asp:BoundField DataField="POD_ITEMID" HeaderText="ID" ReadOnly="True" />
<asp:BoundField DataField="ITM_DESCIP" HeaderText="Description" ReadOnly="True" />
<asp:BoundField DataField="IVD_UPC" HeaderText="UPC" ReadOnly="True"><HeaderStyle Width="0px" /><ItemStyle Width="0px" /></asp:BoundField>
<asp:BoundField DataField="POD_UNIT" HeaderText="Unit" ReadOnly="True" />
<asp:BoundField DataField="POD_QTY" HeaderText="Ord Qty" ReadOnly="True">
<HeaderStyle HorizontalAlign="Center" />
<ItemStyle HorizontalAlign="Left" />
</asp:BoundField>
<asp:TemplateField HeaderText="Rcv Price">
<ItemTemplate>
<asp:Label ID="lRCVPRI" runat="server" Text='<%# Bind("RCVPRICE") %>' Width="40px"></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtRCVPRI" runat="server" Text='<% Bind("RCVPRICE") %>' Width="40px"></asp:TextBox>
</EditItemTemplate>
<HeaderStyle HorizontalAlign="Center" />
<ItemStyle HorizontalAlign="Right" />
</asp:TemplateField>
<asp:TemplateField HeaderText="Rcv Qty" >
<ItemTemplate>
<asp:Label ID="lRCVQTY" runat="server" Text='<%# Bind("RCVQTY") %>' Width="30px"></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtRCVQTY" runat="server" Text='<% Bind("RCVQTY") %>' Width="30px"></asp:TextBox>
</EditItemTemplate>
<HeaderStyle HorizontalAlign="Center" />
<ItemStyle HorizontalAlign="Right" />
</asp:TemplateField>
<asp:TemplateField HeaderText="Edit" ShowHeader="False">
<EditItemTemplate>
<asp:LinkButton ID="lbkUpdate" runat="server" CausesValidation="true" CommandName="Update" Text="Update"></asp:LinkButton>
<asp:LinkButton ID="lnkCancel" runat="server" CausesValidation="false" CommandName="Cancel" Text="Cancel"></asp:LinkButton>
</EditItemTemplate>
<ItemTemplate>
<asp:LinkButton ID="lnkEdit" runat="server" CausesValidation="false" CommandName="Edit" Text="Edit"></asp:LinkButton>
</ItemTemplate>
<HeaderStyle HorizontalAlign="Left" />
<ItemStyle HorizontalAlign="Right" />
</asp:TemplateField>
.aspx.cs ->
protected void grpITEM_RowEditing(object sender, GridViewEditEventArgs e)
{
grpITEM.EditIndex = e.NewEditIndex;
}
Please help me.
|
|
|
|
|
 In the rowEditing and rowUpdating events, call the function which will load your grid.
In your above example, after setting the newEditIndex, you need to load your grid again.
Surendra Prasad
|
|
|
|
|
How can I do that? Please let me know little more detail.
|
|
|
|
|
Assume the following is your gridview rowediting event
private sub gridview_rowediting()
'this will be your code.
gridview.editindex = e.neweditindex();
'call the function which loads your data - see be  low
loadData()
end sub
'This is the function which loads data in your grid.
private sub loadData()
query = "select * from ..."
.
.
.
gridview.datasource = dataTable
gridview.databind()
end sub
|
|
|
|
|
Web Page setting ->
<asp:checkbox id="chkBILL" runat="server" text="Receiving Bills" oncheckedchanged="chkBILL_CheckedChanged" tooltip="Check if you input for billing">
.aspx.cs ->
protected void chkBILL_CheckedChanged(object sender, EventArgs e)
{
if (chkBILL.Checked == false)
{
lRCVTYPE.Text = "P/O No";
cmdLKPO.Enabled = true;
lBILLDTID.Visible = false;
txtBILLDT.Visible = false;
}
else
{
lRCVTYPE.Text = "Bill No";
cmdLKPO.Enabled = false;
lBILLDTID.Visible = true;
txtBILLDT.Visible = true;
}
}
This is coding. When I checked check box, cs coding is not activated. How can I make it work when check box checked? Please help me.
|
|
|
|
|
Set AutoPostback=true
You'd do better IMO to write javascript to do this, so that there's no need for a postback.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
I'm still new at ASP.NET and java coding. How can I do that? any example?
|
|
|
|
|
<asp:checkbox id="chkBILL" runat="server" text="Receiving Bills" oncheckedchanged="chkBILL_CheckedChanged">
tooltip="Check if you input for billing" AutoPostBack="true" />
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
