Re: Add new record - ASP.NET Discussion Boards

matsnas9-Sep-06 22:56

9-Sep-06 22:56

Just learning asp.net and have a basic question.

I have a list of records that I want to display 10 at a time. I have the SQL for it but how should I do in ASP.net to send the offset where I'm currently at?

Code:

   Private mNofRows As Integer = 10<br />
   Private mOffset As Integer = 0<br />
<br />
   Private Sub AddNavigationHandlers()<br />
    Dim vLinkButtonPrev As LinkButton = DirectCast(Me.Form.FindControl("EntryNavigationPrev"), LinkButton)<br />
    Dim vLinkButtonNext As LinkButton = DirectCast(Me.Form.FindControl("EntryNavigationNext"), LinkButton)<br />
    AddHandler vLinkButtonPrev.Click, AddressOf EntryNavigationPrev_Click<br />
    AddHandler vLinkButtonNext.Click, AddressOf EntryNavigationNext_Click<br />
<br />
    vLinkButtonPrev.Enabled = mOffset > 1<br />
  End Sub<br />
<br />
   Public Sub EntryNavigationPrev_Click(ByVal pSender As Object, ByVal pEventArgs As System.EventArgs)<br />
    mOffset -= mNofRows<br />
    GetRecords(mOffset, mNofRows)<br />
  End Sub<br />
<br />
   Public Sub EntryNavigationNext_Click(ByVal pSender As Object, ByVal pEventArgs As System.EventArgs)<br />
    mOffset += mNofRows<br />
    GetRecords(mOffset, mNofRows)<br />
  End Sub

I was hoping that I could have the member variables set at first time and then use them as shared to retain the value between postbacks, but this doesn't seem to work.

Should I be using the tag property of the LinkButtons?
Should I be saving the value in a session variable?
Should I be saving the value in a hidden control?
Should I be saving the value server side using a session object to hold the business tier object with state?

Re: next 10 records?

pphillips9910-Sep-06 16:38

pphillips99

10-Sep-06 16:38

Hi,

The best place for is when calling the SQL in the first instance, for example, your sql/stored procedure should only return 10 records instead of return all the record(s).

Re: next 10 records?

matsnas10-Sep-06 21:07

matsnas

10-Sep-06 21:07

I think you missunderstood me.

My SQL supports 2 parameters, number of records to return and offset from where to return records. EX: Nof=10, Offset=10 will return records 10-19. I will olny return the number of records that I need from the data-tier.

My question is when hitting the linkbutton "next 10 records" and the postback fires, how do I remember the offset variable. For each time I press the "next 10 records" I want to offset counter to increment by 10.

In old ASP I would have submitted the Offset parameter as an appended querystring parameter:
Ex: <a href="List10Records.asp?intOffset=10">next 10 records</a>. How should I do in ASP.net 2.0?

Re: next 10 records?

Amit Kumar G11-Sep-06 8:57

Amit Kumar G

11-Sep-06 8:57

use page data source. It has currentindex property.

I hope this help you.

Amit

Re: next 10 records?

matsnas11-Sep-06 14:48

matsnas

11-Sep-06 14:48

I should say that I'm not using databinding.

I'm surprised that I havn't got more replies to this as I thought that this would be a simple question.

I will look at the page data source control but I see this as a more general question, to retain a value between postbacks.

I tought the whole idea with code behind was to allow the programmer to utilize more of the same programing thechniques as when writing a WinForms application. I'm surprised that ASP.net cannot handle member variables. Why arenä't these stored and re-initalized by the view state as a controls properties?

invalid reportpath?

honeyman_can9-Sep-06 22:49

honeyman_can

9-Sep-06 22:49

Hi guys
What is wrong with this ReportPath: /Pages/ReportViewer.aspx?Website+Reportingfvisits&rs:Command=Render

FYI: ReportServerUrl: http://server/ReportServer/

I get the following error: The path of the item "/Pages/ReportViewer.aspx?Website+Reportingfvisits&rs:Command=Render" is not valid. The path must be less than 260 characters long and must start with slash. Other restrictions apply. (rsInvalidItemPath)

Add new record

Socheat.Net9-Sep-06 17:35

Socheat.Net

9-Sep-06 17:35

HOw can add new record with ASP.NET without using SQL Statement and Dataset?
Thanks

................

Re: Add new record

postmaster@programmingknowledge.com9-Sep-06 17:44

postmaster@programmingknowledge.com

9-Sep-06 17:44

see an example at http://www.programmingknowledge.com/simpleDataGrid.aspx[^]

What is wrong with this code?

Kasic Slobodan9-Sep-06 16:39

Kasic Slobodan

9-Sep-06 16:39

Let me explain.
GetExcludeFolder() - Gets from XML folders that has to be excluded, that's ok.
To enable paging, first I have to fill the array and then display the data from an array as I did in foreach.

The problem code is if statesment.
It says if s.Name doesen't have any string that GetExcludeFolder() returns, then fill the array with this folder name otherwise dont fill array.

When I run this, I get all folder from wwwroot.
Iam confused, what Iam doing wrong?

protected override void Render(HtmlTextWriter writer)
{
    int i = 0, j = 0;
    DirectoryInfo dir = new DirectoryInfo(@"f:\inetpub\wwwroot\");
    DirectoryInfo[] d = dir.GetDirectories("*");

    foreach (DirectoryInfo s in d)
    {
        if (s.Name.IndexOf(GetExcludeFolder()) == -1) // folder filter
        {
            directory[i, j] = s.Name.ToString();
            directory[i, j + 1] = s.CreationTime.ToString();
            i++;
        }
    }

        Response.Write("<table cellpadding=\"0\" cellspacing=\"0\" border=\"1\" width=\"100%\">");
            Response.Write("<tr>");
                Response.Write("<td style=\"height: 25px; width: 50%;\">Folder name");
                Response.Write("</td>");
                Response.Write("<td style=\"height: 25px; width: 50%;\">Date created");
                Response.Write("</td>");
            Response.Write("</tr>");

            j = 0;
            for (i = currentPage * pageSize - pageSize; i < currentPage * pageSize; i++ )
            {
                Response.Write("<tr>");
                Response.Write("<td style=\"height: 25px;\"><a href=\"http://localhost/" + directory[i, j] + "/\">" + directory[i,j]); // folder name
                Response.Write("</a></td>");
                Response.Write("<td style=\"height: 25px;\">" + directory[i,j + 1]); // creation date
                Response.Write("</td>");
                Response.Write("</tr>");
            }
            Response.Write("<tr>");
                Response.Write("<td style=\"height: 25px\" colspan=\"2\">");

                Response.Write("1 2 3");

                Response.Write("</td>");
            Response.Write("</tr>");
        Response.Write("</table>");

    //base.Render(writer);
}

Re: What is wrong with this code?

Guffa9-Sep-06 23:10

Guffa

9-Sep-06 23:10

You use a lot of variables that you (hopefully?) have defined outside the method. For instance, where, when and how do you create the directory array?

What does the GetExcludeFolder() method return? Why do you use IndexOf to compare it with the Name property?

---
b { font-weight: normal; }

Re: What is wrong with this code?

Kasic Slobodan10-Sep-06 2:20

Kasic Slobodan

10-Sep-06 2:20

I said above what returns GetExcludeFolder()

GetExcludeFolder() - Gets from XML folders that has to be excluded, that's ok.

directory array is declared global to the class, like pageSize and currentPage.

I use IndexOf to see what folders I don't need to enter into the array so it checks if a s.Name is comprehended in string that GetExcludeFolder returns.
If so, don't add that folder name into the array.

One more thing. String that returns GetExcludeFolder is something like: aspnet_client;_vti_cnf;vti_pvt;_vti_script;_vti_text;

Hope this is understandable.

Re: What is wrong with this code?

Guffa10-Sep-06 2:31

Guffa

10-Sep-06 2:31

Kasic Slobodan wrote:
I said above what returns GetExcludeFolder()

GetExcludeFolder() - Gets from XML folders that has to be excluded, that's ok.

That information is not clear enough to determine the cause of the error. If the method actually returns more than one folder name, then your code doesn't make sense. That's also why I asked why you are using IndexOf.

Kasic Slobodan wrote:
One more thing. String that returns GetExcludeFolder is something like: aspnet_client;_vti_cnf;vti_pvt;_vti_script;_vti_text;

Then you should look in that string for the folder name, not the other way around.

---
b { font-weight: normal; }

Re: What is wrong with this code?

Dominic Pettifer10-Sep-06 2:37

Dominic Pettifer

10-Sep-06 2:37

One more thing. String that returns GetExcludeFolder is something like: aspnet_client;_vti_cnf;vti_pvt;_vti_script;_vti_text;

Then your code is basically running the following...

if (s.Name.IndexOf("aspnet_client;_vti_cnf;vti_pvt;_vti_script;_vti_text;") == -1) // folder filter<br />
                {<br />
                    directory[i, j] = s.Name.ToString();<br />
                    directory[i, j + 1] = s.CreationTime.ToString();<br />
                    i++;<br />
                }

It's looking for the entire string of 'aspnet_client;_vti_cnf;vti_pvt;_vti_script;_vti_text;' inside your folder name for each folder and obviouly not finding it, and thus return ALL directories. You need to put the excluded folder names in some form of array then iterate through the array inside your foreach (DirectoryInfo s in d) checking ifthe current directory has been excluded. Hope that makes sense. Smile | :)

Sunday Ironfoot

www.dominicpettifer.co.uk (work in progress)

Re: What is wrong with this code?

Dominic Pettifer10-Sep-06 2:49

Dominic Pettifer

10-Sep-06 2:49

Here's a rewrite of your code....

protected override void Render(HtmlTextWriter writer)
{
     int i = 0, j = 0;
     DirectoryInfo dir = new DirectoryInfo(@"f:\inetpub\wwwroot\");
     DirectoryInfo[] d = dir.GetDirectories("*");

     String[] excludedFolders = { "aspnet_client", "_vti_cnf", "vti_pvt", "_vti_script", "_vti_text" };

     foreach (DirectoryInfo s in d)
     {
          foreach(String folderToExclude in excludedFolders)
          {
               if (s.Name.IndexOf(folderToExclude) == -1) // folder filter
               {
                    directory[i, j] = s.Name.ToString();
                    directory[i, j + 1] = s.CreationTime.ToString();
                   i++;
               }
          }
     }

     // The rest of the code........
}

There may be a better way to write it rather than use multiple nested for loops, but that should work.

The 'excludedFolders' String array could get it's contents from your function ie.

String[] excludedFolders = GetExcludeFolder();

...making sure GetExcludeFolder() method returns an array of strings.

Sunday Ironfoot

www.dominicpettifer.co.uk (work in progress)

Re: What is wrong with this code?

Kasic Slobodan10-Sep-06 4:13

Kasic Slobodan

10-Sep-06 4:13

@ Guffa

When I write if like: if (GetExcludeFolder().IndexOf(s.Name) == -1)
then all folder that GetExcludeFolder return arent added to array except two.

Iam confused, becouse I have done this planty of time, but reverse, not to exclude, but to include and this worked perfectly with the IndexOf method.
I don't know why that doesent work.

This is that method i was telling you about:

tFileTypes.Text = .zip;.rar;.exe;

and this is if

if (tFileTypes.Text.IndexOf(fi.Extension.ToString()) >= 0) // fi is in foreach, FileInfo

And this works. Its the same method, but the other condition.

I will use your code becouse I dont have a patience to experiment anymore.

Thank you both.

Re: What is wrong with this code?

Dominic Pettifer10-Sep-06 4:39

Dominic Pettifer

10-Sep-06 4:39

When I write if like: if (GetExcludeFolder().IndexOf(s.Name) == -1)
then all folder that GetExcludeFolder return arent added to array except two.

That should work, maybe want to check the string variable contents, maybe a space or something is being added somewhere it shouldn't, does your IDE (Visual Studio etc) have a debugger?

The only problem with that though is that the GetExcludeFolder() method is being called multiple times, once in each 'foreach' loop depending on how many directories there are. If the 'GetExcludeFolder()' method is fairly resource intensive (reading the file system for instance), the code I gave you using string arrays may be more efficient since 'GetExcludeFolder()' method is only being called once.

Good luck! Smile | :)

Sunday Ironfoot

www.dominicpettifer.co.uk (work in progress)

Re: What is wrong with this code?

Guffa10-Sep-06 6:25

Guffa

10-Sep-06 6:25

What folders are excluded that you think should be included?

---
b { font-weight: normal; }

Re: What is wrong with this code?

Kasic Slobodan10-Sep-06 7:38

Kasic Slobodan

10-Sep-06 7:38

I made a typo Smile | :)

when I said that there is folders that are excluded, but it's not.
There is no directory named vti_pvt and _vti_text it should be _vti_pvt and _vti_txt Smile | :)

.
Small typeo's, but makes a hell of a project Smile | :)

.
I did a detailed debug nd saw this irregularity.

I did listen to Ironfoot and move GetExcludedFolder() out of the foreach.
But I didn't do as Ironafoot said with two for's becouse it would be hard to create an array from one string that is read from Xml.
Replaced array with ArrayList becouse I need dynamic array and now code, that works, looks like this:

protected override void Render(HtmlTextWriter writer)
{
    string tmp = GetExcludeFolder();
    int i = 0;
    DirectoryInfo dir = new DirectoryInfo(GetWwwRootFolder());
    DirectoryInfo[] d = dir.GetDirectories("*");

    foreach (DirectoryInfo s in d)
    {
        if (tmp.IndexOf(s.Name) == -1) // folder filter
        {
            directory.Add(s.Name.ToString());
            date.Add(s.CreationTime.ToString());
            i++;
        }
    }

        Response.Write("<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\">");
            Response.Write("<tr>");
                Response.Write("<td style=\"height: 25px; width: 50%;\">Folder name");
                Response.Write("</td>");
                Response.Write("<td style=\"height: 25px; width: 50%;\">Date created");
                Response.Write("</td>");
            Response.Write("</tr>");

            for (i = currentPage * pageSize - pageSize + 1; i <= currentPage * pageSize; i++ )
            {
                if (i >= directory.Count)
                    break;

                Response.Write("<tr>");
                Response.Write("<td style=\"height: 25px;\"><a href=\"http://localhost/" + directory[i - 1] + "/\">" + directory[i - 1]); // folder name
                Response.Write("</a></td>");
                Response.Write("<td style=\"height: 25px;\">" + date[i - 1]); // creation date
                Response.Write("</td>");
                Response.Write("</tr>");
            }
            Response.Write("<tr>");
                Response.Write("<td style=\"height: 25px\" colspan=\"2\"><div align=\"" + GetPagingAlign() + "\" id=\"CustomPageAlign\">");
                Response.Write("Choose page: ");

                int mat = (int)Math.Ceiling((decimal)directory.Count / pageSize);

                for (i = 1; i <= mat; i++)
                {
                    // creating page links
                    if (i == currentPage)
                    {
                        Response.Write(i + " | ");
                    }
                    else
                    {
                        Response.Write("<a href=\"Default.aspx?Page=" + i + "\">" + i + "</a> | ");
                    }
                }

                Response.Write("</div></td>");
            Response.Write("</tr>");
        Response.Write("</table>");

    //base.Render(writer);
}

It always helps me to see a bug if I talk to someone (forums, mails, etc.). I get a good code's that I can use and with talking, I can see some bugs that I could never see if I wasn't wrote this thread and ask you.

Thank you both for your time. I appreciated.

ASP.NET uploading images

Solly749-Sep-06 16:34

Solly74

9-Sep-06 16:34

How do i upload images on to specified web pages?

thank you Smile | :)

Nothing lasts but nothing is lost

Re: ASP.NET uploading images

postmaster@programmingknowledge.com9-Sep-06 17:47

postmaster@programmingknowledge.com

9-Sep-06 17:47

see an example at :
http://www.programmingknowledge.com/ImageUpload.aspx[^]

Re: ASP.NET uploading images

Britney S. Morales11-Sep-06 12:18

Britney S. Morales

11-Sep-06 12:18

Check this post

http://codeproject.com/aspnet/netimageupload.asp

Smile | :)

keep Learning...

Asp.net 2.0 + javascript ...please help

deepaks39-Sep-06 11:47

deepaks3

9-Sep-06 11:47

Hi
I have 2 chekboxes and a submit button in asp.net 2.0

on first checkbox onclick event i wrote a javascript , that will check the other checkbox to true and disable it.

now when i submit the page , before submmiting the page i get the other check box as checked = false; but acctually i have done it checked= true; using javasccript

please help why this is happening as i need to the other checkbox as checked = true using javascript

deepak

Re: Asp.net 2.0 + javascript ...please help

Guffa9-Sep-06 12:17

Guffa

9-Sep-06 12:17

If you disable a form field it won't be included in the data that is sent from the form.

---
b { font-weight: normal; }

problem regrading IIS(ASP.Net)

Mystic_9-Sep-06 11:13

Mystic_

9-Sep-06 11:13

i have installed IIS on my Windows XP normally.its working for
http://localhost/ but when i give a site like
http://localhost/paksite/Test.aspx
(its a test page i developed myself.name is obviously Test.aspx)
it give me back HTML and asp.net code as well. as u all know that server should not return asp.net code. it should only return html and html equivalent of asp.net code

Re: problem regrading IIS(ASP.Net)

minhpc_bk10-Sep-06 20:02

minhpc_bk

10-Sep-06 20:02

Normally, the IIS needs installing before the .NET framework, otherwise it does not work properly. Also, when the ASP.NET is not properly set up, it may also cause the iissue, and in this case you can use the Aspnet_regiis.exe tool to reset the ASP.NET.

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