ASP.NET Discussion Boards

Christian Graus9-Jul-09 2:20

9-Jul-09 2:20

You probably should have said that, then. You should consider buying a book on ASP.NET instead of just relying on these forums. It will help you in the long run

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Custom paging in gridview by using row_number() function in SQL2005

cocoonwls8-Jul-09 23:59

cocoonwls

8-Jul-09 23:59

Hi all,

I am using asp.net 2.0 with C# and SQL Server 2005. I would like to use custom paging in my web application.I have study the row_number() function, but how could i implement it in my code? If i use custom paging, how to display the footer pager's number?

any helps and tips are welcome.

thanks in advance

regards
cocoonwls

Re: Custom paging in gridview by using row_number() function in SQL2005

K03069-Jul-09 0:38

K0306

9-Jul-09 0:38

Try this link

Custom Paging in ASP.NET using DataReader and Repeater[^]

Regards,
Karthik K...

please helpme

sivasampathkumar8-Jul-09 23:59

sivasampathkumar

8-Jul-09 23:59

<big>i am using sqlserver2000 when i updating datetime the following error occured</big>
<big><pre>"String or binary data would be truncated.\The statement has been terminated."</pre></big>

Re: please helpme

Manas Bhardwaj9-Jul-09 0:05

Manas Bhardwaj

9-Jul-09 0:05

First of all this is no ASP.Net question. It should be in SQL Server forum.

In between, did you even try to look for this error message on Google[^]?

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Re: please helpme

K03069-Jul-09 0:14

K0306

9-Jul-09 0:14

May be your input string exceed the length.
For example - any one of the field name "EmpName" - varchar(10) - for this you will input more than the specified length.

Regards,
Karthik K...

Re: please helpme

Abhijit Jana9-Jul-09 0:36

Abhijit Jana

9-Jul-09 0:36

sivasampathkumar wrote:
Subject: please helpme

Subject should not be like that. You should give proper subject line that every can understand that what is type of problem you have from the subject itself.

sivasampathkumar wrote:
i am using sqlserver2000 when i updating datetime the following error occured

"String or binary data would be truncated.\The statement has been terminated."

Post Formatting : We know CP Forum having a nice editor. But Use it properly.

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net
View My Recent Article

Re: please helpme

Kevin Heathfield9-Jul-09 2:58

Kevin Heathfield

9-Jul-09 2:58

Dude, check your string/DateTime format you inserting. The DateTime field in SQL 2000 does not have a length validator, but it might be expecting just the date. So from what i know is that one should always check to see if the DateTime input is being formatted correctly, this is because some asp.net dateTime members may be inserting a default time of 12:00 after the date itself. Also make sure that the field you are updating on SQL side is actually a Date field. Hope i helped you mate. Good luck. Gimmmme some cheese $Shucks | :-\$

Validating File Upload Control with Regular Expression Validator

meeram3958-Jul-09 23:49

meeram395

8-Jul-09 23:49

I have a fileupload control and a Regular expression validation control in my page. The requirement is user can upload only a word or pdf file, which is working fine. There is also a upload button, which when finishes with upload gives the message that 'Document Uploaded successfully'. This also working fine.

My issue is, if the user again clicks on browse button (after uploaded the file successfully) in FileUpload Control and checks any file other than doc or pdf file, both the messages are displaying:"Only doc or PDF file should be uploaded" and "Document uploaded successfully". This looks weird.

Any idea how to overcome this? I tried to write servevalidate events but it's not firing at all. Anybody provides any idea on this? Thanks for the help.

Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.

Re: Validating File Upload Control with Regular Expression Validator

Manas Bhardwaj8-Jul-09 23:52

Manas Bhardwaj

8-Jul-09 23:52

My guess is you do not return from the function if the validation fails.

But it would be nice, if you can post your code so that exact problem can be looked upon.

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Re: Validating File Upload Control with Regular Expression Validator

meeram3959-Jul-09 1:00

meeram395

9-Jul-09 1:00

Here is the code:

<tr><td><asp:FileUpload ID="DocumentFileUpload" runat="server" />
<asp:Button ID="DocumentUploadButton" runat="server" OnClick="DocumentUploadButton_Click"
Text="Upload" Height="21px" Width="80px" /></td>
</tr>
<tr><td><asp:CustomValidator ID="DocumentUploadedCustomValidator" runat="server" Display="Dynamic" CssClass="labeltext"
ErrorMessage="<"Document must be uploaded %>"
OnServerValidate="DocumentUploadedCustomValidator_ServerValidate" ></asp:CustomValidator>
<asp:RegularExpressionValidator ID="DocumentUploadExpressionValidator" runat="server" CssClass="labeltext"
ControlToValidate="DocumentFileUpload" Display="Dynamic"
ErrorMessage="<"Only PDF or Word files is allowed."%>"
ValidationExpression="[a-zA-Z\\].*(.doc|.DOC|.docx|.DOCX|.pdf|.PDF)$"></asp:RegularExpressionValidator>

</td>
</tr>

protected void DocumentUploadedCustomValidator_ServerValidate(object source, ServerValidateEventArgs args)
{
CustomValidator cv = (CustomValidator)source;
args.IsValid = !String.IsNullOrEmpty(System.Convert.ToString(ViewState["DocumentFileId"]));

}

protected void DocumentUploadButton_Click(object sender, EventArgs e)
{
PDFFilename = Path.GetFileName(DocumentFileUpload.PostedFile.FileName);
int FileExtensionIndex = PDFFilename.IndexOf(".");
PDFFilename = PDFFilename.Substring(0, FileExtensionIndex);
PDFFilename += ".pdf";
ViewState["PDFFilename"] = PDFFilename;
Guid g = AddFile(DocumentFileUpload.FileBytes, PDFFilename);
File.Delete(PDFSaveLocation);
ViewState["DocumentFileId"] = g;
DocumentUploadedCustomValidator.IsValid = true;

if (ViewState["DocumentFileId"] != null)
{
DocumentUploadedLabel.CssClass = "SuccessMessagesLabel";
DocumentUploadedLabel.Text = "Document Uploaded Successfully";
}
else
{
DocumentUploadedLabel.CssClass = "ErrorMessagesLabel";
DocumentUploadedLabel.Text = "Document Upload Failed";
}}

Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.

Re: Validating File Upload Control with Regular Expression Validator

Kevin Heathfield9-Jul-09 3:09

Kevin Heathfield

9-Jul-09 3:09

Hey man... are you using windows apps (OpenFileDialoge) or web app HTML File input? $Shucks | :-\$

How to specify Numeric Format i.e Numeric part and decimal part?

ansriharsha8-Jul-09 23:35

ansriharsha

8-Jul-09 23:35

Hi ,

i want to specify the maximum number of digits for numeric part and the Decimal part in a text box.

i tried specifying precision and maxlength of the text box but then it if we input the max length then the precesion cannot be inputted and it gets resetted to the maxamount which should not be possible.

like if Maxlength=8

precsion = 2

input required:123456.90 possible

input required : 12345678.89 which is not possible

so is there any way we could specify the format of the numeric part and as well the decimal part. which would restrict for only that particular input format.

like : dddddddd.dd

thanks in advance....

cheers,

sriharsha

Re: How to specify Numeric Format i.e Numeric part and decimal part?

Manas Bhardwaj8-Jul-09 23:56

Manas Bhardwaj

8-Jul-09 23:56

You can use regular expressions to do the validation.

In between, do you how to build a regular expression for this?

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Re: How to specify Numeric Format i.e Numeric part and decimal part?

ansriharsha9-Jul-09 2:30

ansriharsha

9-Jul-09 2:30

hi,
but what is the validation expression we need to give for it.

i tried giving

<asp:regularexpressionvalidator id="regexpName"
runat="server"
errormessage="This expression does notvalidate." controltovalidate="TextBox5" validationexpression="^\d\d\d\d.\d\d$">;

but does not work properly.

Thanks and Regards,
sriharsha

Re: How to specify Numeric Format i.e Numeric part and decimal part?

Sun Rays9-Jul-09 3:44

Sun Rays

9-Jul-09 3:44

Hi,
you want the same ?

string strD= 1000.1234;<br />
int dI =strD.indexof(".");<br />
string DecimalVal=strD.substring(dI,dI+1);<br />
<br />
string strVal=strD.substring(0,dI);

Hope it will help you.. Blush | :O

Thanks,
Sun Rays

To get something you must have to try once.

My Articles

Re: How to specify Numeric Format i.e Numeric part and decimal part?

ansriharsha9-Jul-09 3:55

ansriharsha

9-Jul-09 3:55

hi,
actually i want to fix the max length of numric part and the decimal part.

thanks and regards,
sriharsha

Re: How to specify Numeric Format i.e Numeric part and decimal part?

ansriharsha17-Jul-09 0:46

ansriharsha

17-Jul-09 0:46

Hi ,

I used Regularexpression and its working fine.

as:

<asp:regularexpressionvalidator id="regexpName" runat="server"
errormessage="This expression does not validate."
controltovalidate="TextBox5"
validationexpression="^\d{1,8}(\.\d{1,2})?$" enableviewstate="true">;

in
controltovalidate : speicfy the textbox to validate
ValidationExpression: which validates the expression in the format (8,2)
otherwise gives error.

Thanks for all suggestions.

sriharsha

User Defined Ajax Based Callback Control.

vijay kharde8-Jul-09 23:11

vijay kharde

8-Jul-09 23:11

Hello Guys,
My question is,
Is it possible to develop user defined ajax based & callback based web control in ASP.NET 2.0 just like as Update Panel Control.If yes then how is it possible to achieve it.Please tell me about this.

Thanks in adavance,
-Vijay. Cool | :cool:

sql server 2005 remote connection not allowed

yogesh_kumar_agarwal8-Jul-09 22:51

yogesh_kumar_agarwal

8-Jul-09 22:51

Dear All

My Web-Application works very fine, but some time say 2-3 in 100 it give an error for

sql server 2005 remote connection not allowed

So what could be the reason and how to solve the same.

Thanks

Yogesh Agarwal

Re: sql server 2005 remote connection not allowed

Abhijit Jana8-Jul-09 23:58

Abhijit Jana

8-Jul-09 23:58

Which version of SQL Server are you using ? The server is local server or Network server ?

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net
View My Recent Article

Re: sql server 2005 remote connection not allowed

yogesh_kumar_agarwal9-Jul-09 0:19

yogesh_kumar_agarwal

9-Jul-09 0:19

Thanks for the reply

I am using sql server 2005 and it is a network server, available on my webserver, shared hosting.

Thanks

Re: sql server 2005 remote connection not allowed

Sun Rays9-Jul-09 3:46

Sun Rays

9-Jul-09 3:46

Hi,
try doing this steps again.

try[^]

Thanks,
Sun Rays

To get something you must have to try once.

My Articles

Search a file in a directory

souravghosh188-Jul-09 22:48

souravghosh18

8-Jul-09 22:48

In my application I want to search a file by name from a directory programatically.How to achieve this?

Re: Search a file in a directory

K03068-Jul-09 23:39

K0306

8-Jul-09 23:39

Try this code

public void test()
{
DirectoryInfo dir = @"c:\test\";
FileInfo[] files = dir.GetFiles();
foreach (FileInfo f in files)
{
string filename = f.Name;
if (filename == "index.aspx")
{
f.Delete();
}
}
}

Regards,
Karthik K...

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