SQL QUERY - ASP.NET Discussion Boards

vvashishta1-Aug-12 3:37

1-Aug-12 3:37

INNER JOIN Table2 t2 ON t1.Column = t2.Column

and then take result from SP to a Dataset or Datatable and use .DataSource property of DropdownList

- Happy Coding -
Vishal Vashishta

Re: Sql Query Inner Join

Samii492-Aug-12 18:55

Samii49

2-Aug-12 18:55

Thanxxzz ..!!
This one helped me .. Smile | :)

Classic ASP

rock_monu28-Jul-12 0:17

rock_monu

28-Jul-12 0:17

How to hide url path in classic asp..?? Confused | :confused:

Re: Classic ASP

Sandeep Mewara29-Jul-12 8:56

Sandeep Mewara

29-Jul-12 8:56

Go through this: URL Rewriting (Classic ASP)[^]

Sandeep Mewara
[My last article]: Server side Delimiters in ASP.NET[^]

ValidationSummary not displaying RegularExpressionValidator results?

jojoba201127-Jul-12 20:05

jojoba2011

27-Jul-12 20:05

I have a page with a few validation controls and a ValidationSummary control. Most of the validation controls are RequiredFieldValidator controls and the summary control displays these messages just fine.

I do have a RegularExpressionValidator that checks for the format of an email address. If the address isn't entered correctly my error message from this control isn't being displayed by my summary control.

I know the problem isn't with my regular expression as I can display the error message by the regex control if I change the Display setting.

ValidationSummary doesn't just work with RequiredFieldValidator does it? That would be less than helpful.

My code :

ASP

<asp:ValidationSummary ID="ValidationSummary1" ValidationGroup="Test" HeaderText="You must enter a value in the following fields:"
            DisplayMode="BulletList" EnableClientScript="False" runat="server" />

ASP

<asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" ValidationGroup="Test" ControlToValidate="txtReqDuration"
                   ErrorMessage="Enter a valid number" Display="None" ValidationExpression="^([\d]{0,2})$"></asp:RegularExpressionValidator>

Thanks.

Re: ValidationSummary not displaying RegularExpressionValidator results?

_Amy31-Jul-12 1:34

_Amy

31-Jul-12 1:34

Hi,
Set the DisplayMode="Dynamic" and remove EnableClientScript attribute from your ValidationSummary.

Read the article "Table Valued Parameters".

--Amit

I want to create a Word document with dynamic graphs inserted

Lmathew27-Jul-12 0:29

Lmathew

27-Jul-12 0:29

I want to create a Word document with dynamic graphs (OpenFlashChart which is a third party control) on the asp.net page.

Is it possible to do it in asp.net.ON bank sites, i have seen different graphs get generated for each quarter in a word document.

SQL QUERY

rock_monu26-Jul-12 20:04

rock_monu

26-Jul-12 20:04

how to fire two select query together on empid basis with inner join..???

Re: SQL QUERY

Sandeep Mewara26-Jul-12 21:14

Sandeep Mewara

26-Jul-12 21:14

Use SQL Transactions or Stored Procedure to execute multiple queries in a batch.

Sandeep Mewara
[My last article]: Server side Delimiters in ASP.NET[^]

Re: SQL QUERY

vvashishta1-Aug-12 3:38

vvashishta

1-Aug-12 3:38

Clearify your question again.. give us the scenario.

- Happy Coding -
Vishal Vashishta

Re: SQL QUERY

Vijay Selvaraj27-Aug-12 0:23

Vijay Selvaraj

27-Aug-12 0:23

you can use subquery..

Intelligencia.UrlRewriter

Jassim Rahma26-Jul-12 10:43

Jassim Rahma

26-Jul-12 10:43

I am using Intelligencia.UrlRewriter to rewite URLs, it works fine with root folder but with my sub folder /r it it doesn't work.. here is an example:

this is for my root about.aspx:

<rewrite url="~/about" to="~/about.aspx" />

and that's working perfect..

and here is my about.aspx in my arabic folder /ar/about.aspx:

<rewrite url="~/ar/about" to="~/ar/about.aspx" />

and when i try www.rmc.bh/ar/about it should go to www.rmc.bh/ar/about.aspx but it's actually going to www.rmc.bh/about.aspx

where is the problem?

Re: Intelligencia.UrlRewriter

Deflinek30-Jul-12 4:53

Deflinek

30-Jul-12 4:53

url part is handled as regualar expression. Try to set explicit boundaries for it using ^ and $ characters:

HTML

<rewrite url="^~/about$" to "~/about.aspx" />
<rewrite url="^~/ar/about$" to "~/ar/about.aspx" />

--
"My software never has bugs. It just develops random features."
http://www.naszeklocki.pl

best way to url rewrite

Jassim Rahma26-Jul-12 8:25

Jassim Rahma

26-Jul-12 8:25

Hi,

I am new to URL rewite, I want to know how and what's the best and easiest way to do it?

Are there any APIs or components which does the job or it's pior coding?

Re: best way to url rewrite

fjdiewornncalwe26-Jul-12 9:12

fjdiewornncalwe

26-Jul-12 9:12

Is google not working where you are today?
url rewrite[^]
got me 4.4 million results and looks like a great way to find reliable information.

I wasn't, now I am, then I won't be anymore.

Re: best way to url rewrite

Jassim Rahma26-Jul-12 9:35

Jassim Rahma

26-Jul-12 9:35

in this case this forums should be closed because google has answers for all questions here!

Re: best way to url rewrite

jkirkerx26-Jul-12 12:35

jkirkerx

26-Jul-12 12:35

I could of swore you asked a similar question somewhere else in CJ. I think it was a quick question, it which you were using asp.net framework 4.0, and you were not able to partially implement url rewriting.

There's no magic wand for url rewriting. It's difficult to implement, and requires full planning from the start, you can't just drop it in and go, for it is a combination of your asp.net code and work on behalf of server IIS 7.5 and up.

The server has to be able to pick up the rewrite, and your code has to translate it, and then your code has to create it, and pump it back out to the server. It's bi-directional in design.

I gave you some of the pieces for it, to get started, but help for full implementation requires more time than I'm willing to give here on the CJ, short of just writing a complete how-to on it.

conboxbox in formview control

rachel_m26-Jul-12 6:45

rachel_m

26-Jul-12 6:45

I am trying to determine how to accomplish my requirement in an existing C# 2010 formview control. In 3 separate rows in a formview control, I have 3 different combo boxes that are not functioning right now. The user is suppose to be able to select yes or no from any of the 3 combo boxes. If the user selects yes from any of the 3 different combo boxes, a box is suppose to display so the user can enter a date that needs to be corrected. The place to enter the dates is not suppose to display until the user selects the yes from the combobox.

Right now the formview control default mode is set to edit so the user can edit the dates right away. Also There is another combo box that updates a database column with yes or no.

I know that I want to use the click event of the yes/no combo box to start the extra entry line(s) to be displayed. However can you tell me how to have these extra lines be displayed?

javascript in web app

rachel_m26-Jul-12 6:42

rachel_m

26-Jul-12 6:42

In a C# 2010 web application, I have avoided using javascript and jquery. I have been totally relying on server side validation since only a few users have access to those web pages. Now I will be adding web form pages where a large volume of users will have access to those web pages.

Thus can you tell me and/or point me to references that are good examples of how to start using javascript and/or jquery in web form 2010 applications?

Re: javascript in web app

R. Giskard Reventlov26-Jul-12 7:12

R. Giskard Reventlov

26-Jul-12 7:12

Ironic Response[^]

BTW: jQuery [^] is JavaScript so you should just be able to use it.

"jQuery is a fast and concise JavaScript Library" form the front page.

"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

Re: javascript in web app

Paul Conrad13-Sep-12 9:09

Paul Conrad

13-Sep-12 9:09

mark merrens wrote:
Ironic Response

Wow, word for word and a whole different name as poster...

Am I the only one who suspects the OP is also dcof[^]?

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

range validator 2010

dcof26-Jul-12 6:07

dcof

26-Jul-12 6:07

I have a couple of questions about using a range validator on a C#.net 2010 web application. I am validating dates that must be between 01/01/2000 and 12/31/2020. My range validation works, however a couple of issues have shown up which includes the following: 1. a user can enter a date like 07.15.2012 and the date is accepted with no error. Why do this occur? My company wants to force the user to enter a date like 07/15/2012 and not accept a date like 07.15.2012. Can you tell me how to force this edit? Do I need to use regular expressions?
2. When the user enters a wrong date, the error message shows up for like a couple of seconds and goes away. This occurs before a user hits the 'enter' button to proceed to the next web page. Can you tell me how to make this error message display longer and/or only display when the user clicks the next button?

Re: range validator 2010

jkirkerx26-Jul-12 12:44

jkirkerx

26-Jul-12 12:44

dcof wrote:
My range validation works

See below comment

dcof wrote:
a user can enter a date like 07.15.2012 and the date is accepted with no error. Why do this occur?

Your range validator doesn't work

dcof wrote:
Can you tell me how to force this edit?

You can force the edit, by replacing the . with a / using Javascript, or just take the value and post it, then alter the value to the flavor that you prefer.

no code samples because you have to decide what your going to implement first.

[EDIT]
I didn't test this, but I think I got it right for Javascript

var startDate = "7.1.2012";
startDate.replace(/\./g, "/");

modified 26-Jul-12 19:03pm.

ajax calendar control only render sundays

amit sahu2026-Jul-12 0:08

amit sahu20

26-Jul-12 0:08

I have a ajax calendar control , i want that calendar render with only past Sundays else date should be disable

SQL query result sent to aspx page to be used by Jquery

zapovjednik25-Jul-12 21:59

zapovjednik

25-Jul-12 21:59

Hello,
I have a question and I thank everyone for helping me in advance.
I am using Visual Studio 2010, ASP.NET and C#.

I have a table in SQL server DB.
Server page (news.aspx.cs) is collecting all the data from the table (

SQL

select * from news

).

Using

container.Controls.Add(new LiteralControl(news.ToString()));

I am sending the query results to front page (news.aspx).
Now, I have that data put in separate DIV tags, one news in one DIV tag, and my idea was to hover over one div and to expand that same DIV with one small picture and more text (small picture url and the text are all stored in the same SQL table news.)

When I hover over a div, it expands, but it shows only the picture and the text that is stored in the first row ,n the SQL table.

Question:
How do I make it, that when I hover over one DIV and get the details belonging to that row, not the first row??

Thank youuuu Smile | :)

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.