Re: Gridview, Checkbox and SQL Parameters based on LoginName - ASP.NET Discussion Boards

I think we can not display the name of the file which is uploaded because property fileupload.filename is readonly and it can be set only if user browse the image

actually what im trying is to upload a image and display its thumbnail..
and then insert into into database..
but as once page is posted fileupload is empty there is no path to insert into database....
any other method....

Hi,

I have created a NumberBox Control usercontrol which is working fine.
in the numbox ,we have a feature for the number box.
i.e we are restricted the input based on the format.
Like if the format is (8,2),then the input is restricted beyond these locations.
i.e example:
12345678.88 :entry completly restricted ,
12345678 : enrty restricted till we enter a '.' (dot seperator),
.99 : entry restricted after the . dot seperator as the precesion is 2. but can enter before
dot seperator

this is working fine.

but the problem is when i select textbox and try to press the number, it is not clearing the numbers. which is a problem ..

i.e consider i enter 12345678.99 or .00 or 12345678 ,
and select the content it does not allow to clear when i enter a number, as the cursor position is in the end , and it has to restirict .

so is there any way i could aviod this .

i.e is there any way i could check in the script that if the data in textbox is selected or not ?

so based on which i could allow the input to be cleared.

thanks in advance,,,,

Thanks and Regards,
sriharsha

The Best way is to fire a JavaScript Function on 'OnBlur' event of the TextBox Where you can check the formats .

but onblur is once it comes out of the textbox.
we are trying to restrict it based on the format during the time of input.
i.e based on the format input is restricted , i.e it is a kind of masking.

but only when i select and try to input , it does not clear as the cursor position is in the end.

is there any way i could checkh if it is selected based on which i could clear onslect

Hello,

I am still learning ASP.NET, if you need additonal information or have questions please let me know.

I am creating a ASP.NET site (C#) in Visual Studio.NET that is utlizing a grid view to pull data from a SQL DB. I am using the ASP.NET membership provider model for the website authentication. Access to the site is only allowed with the correct username and password.

I have a webform call Document Checklist. The webform is connected to a SQL table called document_checklist. I need the Document Checklist webform to display only those documents that the logged in user has not approved. I need for the user to click on the checkbox for those documents that he has approved and click the submit button to update the SQL DB. The SQL DB contains the following columns user_name, document_name, document_url date_added, date_approved and checkbox.

I have been trying to work throught this and am not certain how to proceed.

1. I am not certain how to query the SQL DB against my LoginName I have tried a few things, but am not able to capture the value of the LoginName and compare it to user_name value of teh SQL DB field. (The formatting of LoginName from ASP.NET and user_name from SQL DB is identical.)

2. I do not know how to utilze checkbox to update the SQL DB.

3. I do not know how to capture the date that the checkbox was checked and insert it into date_approved

The code is below. I am not certain how to list the CheckBox_Changed in the code behind.

Thank you in advance for your help.

aspx C# code

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="document_checklist.aspx.cs" Inherits="members_document_checklist" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<h2>DOCUMENT CHECKLIST</h2>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1">
        <Columns>
            <asp:BoundField DataField="user_name" HeaderText="User Name" SortExpression="user_name" />
            <asp:TemplateField HeaderText="Document">
                <ItemTemplate>
                    <asp:HyperLink ID="Document" NavigateUrl='<%# Eval("document_url") %>' Text='<%# Eval("document_name") %>' Target="_blank" runat="server" />
                </ItemTemplate>
            </asp:TemplateField>
            <asp:BoundField DataField="document_type" HeaderText="Document Type" SortExpression="document_type" />
            <asp:BoundField DataField="date_added" HeaderText="Date Added" SortExpression="date_added" />
            <asp:TemplateField>
                   <ItemTemplate>
                       <asp:CheckBox ID="CheckBox1" runat="server" />
                   </ItemTemplate>
            </asp:TemplateField>
           </Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:board_loginConnectionString3 %>"
       SelectCommand="SELECT [user_name], [document_name], [document_type], [document_url], [date_added], [checkbox] FROM [document_checklist] WHERE ([checkbox] = @checkbox) AND ([user_name] = @user_name)" >
            <SelectParameters>
                <asp:Parameter DefaultValue="0" Name="checkbox" Type="String" />
                <asp:Parameter DefaultValue="@user_name" Name="User.Identity.Name" Type="String" />
           </SelectParameters>
</asp:SqlDataSource>
    <asp:Button ID="Button1" runat="server" Text="Cancel" />
    <asp:Button ID="Button2" runat="server" Text="Submit" />
</asp:Content>

Allison

Hi Alison,
I think you can 'user' property of HttpContext Current request
to get the info about currently logged in user .
Check out this link

Hello,

Thank you for your response. I am not certain how I would use that to compare that value against the Username data field in SQL to only display values where loginname is equal to Username (in SQL).

Below is my code for my aspx page.

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="document_checklist.aspx.cs" Inherits="document_checklist" Title="Document Checklist Report" %><br />
<br />
  <br />
<br />
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"><br />
    <h2>DOCUMENT CHECKLIST</h2><br />
    <br />
<br />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1"><br />
      <Columns><br />
            <asp:BoundField DataField="user_name" HeaderText="Username" SortExpression="user_name" /><br />
            <asp:BoundField DataField="document_name" HeaderText="Document" SortExpression="document_name" /><br />
            <asp:BoundField DataField="date_added" HeaderText="Date Added" SortExpression="date_added" /><br />
            <asp:TemplateField HeaderText="Document Read"><br />
                   <ItemTemplate><br />
                   </ItemTemplate><br />
            </asp:TemplateField><br />
<br />
<br />
          <asp:CheckBoxField DataField="checkbox" HeaderText="Document Read" SortExpression="checkbox" /><br />
        </Columns><br />
    </asp:GridView><br />
 <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:board_loginConnectionString3%>"<br />
        SelectCommand="SELECT [user_name], [document_name], [document_type], [date_added], [checkbox] FROM [document_checklist] WHERE ([checkbox] = @checkbox)AND ([username] = @username)"><br />
        <SelectParameters><br />
            <asp:Parameter DefaultValue='0' Name="checkbox" Type="Byte" /><br />
        </SelectParameters><br />
<br />
</asp:SqlDataSource><br />
<br />
</asp:Content>

Hi all,

I am trying to display 77000 records from Oracle Database to .NET DataGrid. So it is not displaying and getting Application Server Error.

Using OLEDB i did. Is there any way for solving this problem

Thanks
Murali

Why would you want to show 77000 records ?

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.

So the user can find the one they want!! Wink | ;-)

I don't have ADHD, I have ADOS... Attention Deficit oooh SHINY!!

Booger Mobile (n) - A bright green 1964 Ford Falcon - our entry into the Camp Quality esCarpade!!
Do something wonderful - make a donation to Camp Quality today!!

Better approach is put a search option , when the user puts a Search Criteria the appropriate results would be displayed ,
Because you could not expect a user to move through all 77000 records

Nishant Singh wrote:
Because you could not expect a user to move through all 77000 records

yes, but if he still wants all the records he can have paging enabled.

Padmanabhan
My Articles:
Articles[^]
My latest Article:
Word Automation[^]

Hi,

Yes but the problem the problem is if the paging is enabled also the page is not not displaying due to huge data i think .Is there a way to Display all the records(77000)

Thanks
Murali

have you calculated the time taken to fetch the data in which back end you are using... because if it takes long time in database then you have to follow indexing... and in the database if the query returns the value soon then there is prolem in your code... Any how can you send your code for further clearance....

Padmanabhan
My Articles:
Articles[^]
My latest Article:
Word Automation[^]

Hi ,

Search option is not accepted here. So is there any other way to display data.

Thanks
Murali

Murali

What do you mean by 'not accepted' ? Do you mean you have a client who wants to show 77000 records on one page of a website ? Can you think of a single website that shows this much information ? If not, how do you know it's possible, assuming it was at all advisable ?

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.

Hi All,

Please tell me how to write XML query in Asp.net.

I hav temple.xml file which contain data of temple.
now i want to apply search on it.

Well, this is not an ASP.NET question really, it's a C# or VB.NET question. You can use an XMLDocument and the DOM to search your XML, or I believe you can use LINQ, if you're using 3.5

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.

Hi Priya ,
U cannot directly Query an XML Decument in ASP.Net 2.0 ,
However you need to parse them to check for the desired result ,
It got significantly easier with LINQ introduced ,
As per your requirement if you are using ASP.net 2.0 create an instance of XMLTextReader and read thru the document

XMLDocument is far better for searching.

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.

Yeh Chris,
I was wrong i did some searching XMLTextReader is a fast forward way of reading data from an xmlDocument .
Much like DataReader ........

i am trying to apply linkbuttons of images in datalist with the help of these link buttons i want to show images with link buttons in same page.. could u help me plzzzz

You say you are trying. What have you tried ? Where are you stuck ? Why do you need to use a datalist ?

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.

i am learning dotnet dats y i am using......... i apply linkbuttons but on clicking link buttons images are not shown.. if u hav any sol. den tell me.