|
Hi all, thanks for looking
When filtering a text field using a parameter from the querystring or a control with a "like" condition, "%" as a default value for the parameter will return all the rows in the datatable (In design time with no code)
How can i get all the rows when no parameter is specified for a query filtered by a numeric field? (In design time with no code)
Thanks in advance
Alexei Rodriguez
|
|
|
|
|
Hi
i also did the same for crystal report genration hope this will help you in your purpose also.
define a string and asign the blank in it by default.
The use the sqlquery for data source like: -
<br />
Select * from table {Parameter}<br />
so now pass the string as parameter if the string in "" then it will retrive all the records else if the string is some condition like: -
<br />
str=where name like %a%<br />
then it will retrive the filter records.
Yogesh Agarwal
|
|
|
|
|
Thanks for the reply, but what i need is to apply this same logic to a numeric field
Alexei Rodriguez
|
|
|
|
|
i was surprise when i knew O/R mapping in VS2005.
then i used it in my project, it's company inner website for view document, discuss, sharing sth(like blog) and so on.
everything looked good until i modified database structure,
the VS IDE doesn't have a tool to synchronous the database and the objects.
i had to updated all methods refer to modified tables.
the second troublesome is the name of O/R mapped objects. if you have a table 'table1' then you will have a dozen of long name objects, like 'table1DataTable' 'table1Row' 'table1DataAdapter'... even if i know it can be modified. but i don't want to modify it manually...
LINQ sounds a good O/R mapping way to replace old in VS2005. what's your opinion about this?
|
|
|
|
|
Hello,
I have been banging my head against the wall and google-ing to find the answer. Either I am not looking for the right phrase or there is something simple that I don't understand.
I have a Generic List(Of T) that I am using to feed a GridView control. I can get the data into the Gridview with no problem, however, I cannot get the rows to show in the proper order (they are basically in reverse order) and I cannot get the sorting function of the gridview to work. For the sorting, I have AllowSorting = True, and I have a method set up to handle the event when it fires. I see the "javascript _doPostBack" line in the status bar of the browser when I try to click on the sorting. Clicking on one of the headers gives no response...it doesn't even act like it is trying to do anything.
I would put more in here, but I am not sure exactly what you would need, if anything, to help me find the answer.
Thanks
|
|
|
|
|
Does the sorting event fire ? What happens in there ? Is your list being resorted ? Have you checked that the order of the list is as you expect ?
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 am not sure if it does fire. I am having to run my test application on a remote server that has access to the data...so I can't do inline de-bugging (or at least, if I can, I don't know how to).
The list is not being re-sorted that I can tell. It doesn't even look like it refreshes the screen.
The only other thing I have running on this page is an auto-refresh feature. I am trying to get that to be a user-selectable refresh time. That isn't working either, but that is a topic for another post. I added that here as I am not sure if that might be interfereding somehow.
|
|
|
|
|
iam creating a reporting webpage. we have several types of reports like sales , customer ,....... if the user selects sales it will redirects to a separate page where they need to enter different parameters using the dropdown,textbox or listbox. for example they have different parameters like product,month,year,location. the user can enter any combinations. like either they select product and location or month and year like any combinations. once they submit the webpage , we have to pass those parameters to the XML and then query the database according to that. hope you've understood my explanation. so for this i just want to know how to send the parameters to the XML and then query the database. Please help me out
|
|
|
|
|
I answered this earlier today and it still makes no sense. What is the XML used for - is there a stored proc using OpenXML at the other end ? Are you saying you don't know how to create an XML document ? And are you hoping for help passing the XML to an existing stored proc, or for some explanation on how to write your query so it takes XML ?
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 some problem with javascript.
when I use update panel then this problem comes.
when i click on Button1 first time, then some error occurs. but next time it not comes. it may be some script register problem. but i reister the javascript function in Page_Load event on button click. i ma very confused, why this error coming. i search many on this but not found any solution.
please help me.
here is sample code . i also did like this..
i write this code on button click
protected void Button1_Click(object sender, EventArgs e)
{
string scriptString = "function msgg() { alert('hello');}";
ScriptManager.RegisterStartupScript(this ,typeof (UpdatePanel), "scriptString", scriptString, true);
//i tried these also..
//ScriptManager.RegisterStartupScript(Button,typeof (Button1), "scriptString", scriptString, true);
//ScriptManager.RegisterStartupScript(updatepanelid ,typeof (UpdatePanel), "scriptString", scriptString, true);
}
protected void Page_Load(object sender, EventArgs e)
{
Button1.Attributes.Add("onClick", "return msgg();");
}
in aspx I write this--
<asp:updatepanel id="UpdatePanel1" runat="server" childrenastriggers="true">
<contenttemplate>
<asp:button id="Button1" runat="server" text="Button" onclick="Button1_Click">
thanks.
|
|
|
|
|
i write aspx code
<asp:updatepanel id="UpdatePanel1" runat="server">
<contenttemplate>
<asp:button id="Button1" runat="server" text="Button" onclick="Button1_Click">
thanks.
|
|
|
|
|
Register your script on page load event.
OR you can try this:
protected void Button1_Click(object sender, EventArgs e)
{
string scriptString = "function msgg() { alert('hello');}";
ScriptManager.RegisterStartupScript(this ,typeof (UpdatePanel), "scriptString", scriptString, true);
//i tried these also..
//ScriptManager.RegisterStartupScript(Button,typeof (Button1), "scriptString", scriptString, true);
//ScriptManager.RegisterStartupScript(updatepanelid ,typeof (UpdatePanel), "scriptString", scriptString, true);
Button1.Attributes.Add("onClick", "return msgg();");
}
protected void Page_Load(object sender, EventArgs e)
{
//Button1.Attributes.Add("onClick", "return msgg();");
}
/***********************/
Parwej Ahamad
g.parwez@gmail.com
/***********************/
modified on Tuesday, March 4, 2008 10:35 PM
|
|
|
|
|
thanks Parwej.
i did like this as you told.
now wrror is not coming but when I click first time nothing happen.
i mean javascript function not run. but second time it runs.
can you give me any solution.
thanks
|
|
|
|
|
Did you registered on page load event ?
Parwej Ahamad
g.parwez@gmail.com
|
|
|
|
|
no. i remove from there.
is it need.
thanks
|
|
|
|
|
on button click event i fetch some data from databse base and then i use this data in javascript function, then i register this.
i think when i will register on page load it will not work properly.
thanks
|
|
|
|
|
Ok, I got your point
You can do with hidden controls or session variable.
When you clicked on button set the value in hidden variable or session variable
and then access that variable in javascript function with the help getElementById method.
Parwej Ahamad
g.parwez@gmail.com
|
|
|
|
|
I have an html form that I want to send to an access database. I want a user to be able to volunteer to work a specific timeslot at a charitble function. Currently, each row is a timeslot and asks for name, phone and email then has its own submit button at the end of the row. I want the submit to update a database table and, if possible, display the name but not the phone and email back in the form to prevent a second person from taking the same timeslot. I have no coding experience except html and css so do not know how to write the code to do this. Everything in my site is currently written in html and style sheets.
Thanks for any help!
rick8s
|
|
|
|
|
http://www.google.com.au/search?sourceid=navclient&aq=t&ie=UTF-8&rlz=1T4ADBS_enAU225AU226&q=C%23+access+database[^]
If you find winforms examples on the web, they are using the same libraries and will work inside ASP.NET.
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 )
|
|
|
|
|
Does anyone have some sample code to use adsi to ad a certificate mapp to IIS. I have the script code but have not been able to get it to work under an ASP or asp.net page. I prefer VB but C# will also work. I am getting Generic errors using the invoke method in asp.net for client mapping. It is giving DISP_E_UNKNOWNNAME I have verified all the paths usernames and other info. This is running on a stand alone machine that is W2003 Server with IIS and VS2005 and 2008 installed. Any help or pointers anyone can give would be appreciated.
|
|
|
|
|
Hi,
I am using multi lang. web site using sessions & master page, resourse files. ex: default.resx, default.fr.resx, default.be.resx...
with a single page.. default.aspx.
Now , From external link, want to connect the page with choosen lang by a querry string.
suggest me the best way! Thnx
|
|
|
|
|
This isn't the way that localized resource files work. Based on the currently selected culture, ASP.NET will load the resources from the appropriate resource file. Your users will get the appropriate resource information based on their local machine settings.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
How to write arabic by default in a textbox in asp.net webform?
I need to swtch to arabic langwhen focusing in this textbox.
Thanks in advance
|
|
|
|
|
I don't think you can change character sets for just one textbox.
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 )
|
|
|
|
|
please how do i set the gridview cell width? I am binding the gridview to a datatable. I wrote something like this in the
gridview_databound event
grdview.cells(0).width=100
but it does not work
pls help
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
