Is there a right & wrong way of working with dbml files? - ASP.NET Discussion Boards

Illegal Operation20-Jan-10 12:19

20-Jan-10 12:19

Hi!

I have a Stored Procedure that groups information by date and calculate the amount of hours. On the Page_Load method I execute the Stored Procedure and then Display a GridView containing the Date and Total Hours.

The problem I am having is that I have added a button and when you click on it, it should get the value from the Date cell.

For example: If you click on the 20/01/2010 row then all the entries for that date should be displayed in another gridview.

Thanks for the help!

Illegal Operation

Re: GridView Row Selection

Pranay Rana20-Jan-10 17:38

Pranay Rana

20-Jan-10 17:38

so on itemcommand or selectionchange event of gridview fire one query with date criteria and try to bind your second grid view by fetching data form the database

hope this will work for you

Re: GridView Row Selection

April Fans24-Jan-10 16:21

April Fans

24-Jan-10 16:21

Hi,
Do you add a button in every row??
I think you can bind the data value to the button. Then you can do other things.

April

Comm100 - Leading Live Chat Software Provider

modified 27-May-14 8:51am.

Failed to update database "C:\BCPORTAL\APP_DATA\BCANCER.MDF" because the database is read-only.

ceiral20-Jan-10 10:11

ceiral

20-Jan-10 10:11

Hello.

I am working on a website. For now whenever I want to test it I would just run it from localhost using IIS. An error occurred after transferring the work to another laptop. Everything ran smoothly until came to the part where there is a need to update/insert data to the database. I got this error saying that I am not able to update the database because it is read-only.

Now the error only occurred when I ran the website from localhost using IIS. The process of updating/inserting when smoothly when I ran the website from Visual Studio.

I searched for every possible solution and found out several ones

1. Set the App_Data folder attribute to not 'Read-only'. - Done that but the folder automatically set back to 'Read-only' each and everytime.

2. Execute the following sql query

ALTER DATABASE bcancer SET READWRITE

- Done that also but still the database is in read-only mode.

Can somebody help me out on this? Thank you very much for your attention.

Re: Failed to update database "C:\BCPORTAL\APP_DATA\BCANCER.MDF" because the database is read-only.

kadaoui el mehdi21-Jan-10 8:21

kadaoui el mehdi

21-Jan-10 8:21

try to assign admin role to "asp.net user"

good luck.
Mehdi

How to implement asp.net AJAX ReorderList list?

jhTom20-Jan-10 9:18

jhTom

20-Jan-10 9:18

I have followed this [^] and also posted on the asp.net AJAX forum but so far no one seems to know why it's not working for me.

<asp:UpdatePanel ID="UpdatePanel1" runat="server">
                    <ContentTemplate>
                        <div class="reorderListDemo">
                            <ajaxToolkit:ReorderList ID="rdlPhotos" runat="server" 
                                SortOrderField="position"
                                DataSourceID="sqlPhotos" 
                                DataKeyField="photoID" 
                                PostBackOnReorder="true" 
                                CallbackCssStyle="callbackStyle"
                                DragHandleAlignment="Left" 
                                ItemInsertLocation="Beginning">
                                <ItemTemplate>
                                    <div class="itemArea">
                                        <asp:Image ID="imgImage" runat="server" ImageUrl='<%# String.Format("{0}{1}", Eval("filepath"), Eval("filename")) %>'
                                            Width="150px" />
                                    </div>
                                </ItemTemplate>
                                <ReorderTemplate>
                                    <asp:Panel ID="pnlReorder" runat="server" CssClass="reorderCue" />
                                </ReorderTemplate>
                                <DragHandleTemplate>
                                    <div class="dragHandle">
                                    </div>
                                </DragHandleTemplate>
                            </ajaxToolkit:ReorderList>
                        </div>
                        <asp:SqlDataSource ID="sqlPhotos" runat="server" ConnectionString="<%$ ConnectionStrings:classNotesConnStr %>"
                            DeleteCommand="DELETE FROM [classNotesPhoto] WHERE [photoID] = @photoID" InsertCommand="INSERT INTO [classNotesPhoto] ([albumID], [fileName], [filePath], [caption], [profilePhoto], [albumPhoto], [description], [position], [certify], [dateInsert]) VALUES (@albumID, @fileName, @filePath, @caption, @profilePhoto, @albumPhoto, @description, @position, @certify, @dateInsert)"
                            SelectCommand="SELECT * FROM [classNotesPhoto] WHERE ([albumID] = @albumID) ORDER BY [position]"
                            UpdateCommand="UPDATE [classNotesPhoto] SET [albumID] = @albumID, [fileName] = @fileName, [filePath] = @filePath, [caption] = @caption, [profilePhoto] = @profilePhoto, [albumPhoto] = @albumPhoto, [description] = @description, [position] = @position, [certify] = @certify, [dateInsert] = @dateInsert WHERE [photoID] = @photoID">
                            <SelectParameters>
                                <asp:QueryStringParameter Name="albumID" QueryStringField="album" Type="Int32" />
                            </SelectParameters>
                            <DeleteParameters>
                                <asp:Parameter Name="photoID" Type="Int32" />
                            </DeleteParameters>
                            <InsertParameters>
                                <asp:Parameter Name="albumID" Type="Int32" />
                                <asp:Parameter Name="fileName" Type="String" />
                                <asp:Parameter Name="filePath" Type="String" />
                                <asp:Parameter Name="caption" Type="String" />
                                <asp:Parameter Name="profilePhoto" Type="Boolean" />
                                <asp:Parameter Name="albumPhoto" Type="Boolean" />
                                <asp:Parameter Name="description" Type="String" />
                                <asp:Parameter Name="position" Type="Int32" />
                                <asp:Parameter Name="certify" Type="Boolean" />
                                <asp:Parameter DbType="DateTime" Name="dateInsert" />
                            </InsertParameters>
                            <UpdateParameters>
                                <asp:Parameter Name="albumID" Type="Int32" />
                                <asp:Parameter Name="fileName" Type="String" />
                                <asp:Parameter Name="filePath" Type="String" />
                                <asp:Parameter Name="caption" Type="String" />
                                <asp:Parameter Name="profilePhoto" Type="Boolean" />
                                <asp:Parameter Name="albumPhoto" Type="Boolean" />
                                <asp:Parameter Name="description" Type="String" />
                                <asp:Parameter Name="position" Type="Int32" />
                                <asp:Parameter Name="certify" Type="Boolean" />
                                <asp:Parameter DbType="DateTime" Name="dateInsert" />
                                <asp:Parameter Name="photoID" Type="Int32" />
                            </UpdateParameters>
                        </asp:SqlDataSource>
                    </ContentTemplate>
                </asp:UpdatePanel>

As soon as I drop the item, it will automatically go back to its original position/order.

Any suggestion is much appreciated.

Re: How to implement asp.net AJAX ReorderList list?

jhTom21-Jan-10 3:59

jhTom

21-Jan-10 3:59

Does anyone have any suggestions? I wonder if it has anything to do with the updatepanel. I have seen that causes a few of my other project's functionality.

Is there a right & wrong way of working with dbml files?

Goalie3520-Jan-10 8:36

Goalie35

20-Jan-10 8:36

I'm just starting to get into database markup language (dbml) files in my projects but I'm curious as to if dbml is always the right approach...

So far, I'm really liking the dbml approach. Before using this, I usually called some classes within my data access layer which in turn called a stored procedure. The dbml file on the other hand, makes the process much cleaner.

My concern however, is what happens when I have a database with large amounts of data? For example, I currently have a news articles website. We currently have about 40,000 articles...and that number's rapidly rising. If I were to pull these articles via a dbml file, wouldn't the user (or more specifically, the web server carrying the user's info) have to carry around all that data? Every article's title, content, author, date created, etc? If we were to have 100 users on the site at the same time, wouldn't that really slow down the server (100 users x 40,000 article objects)?

Or am I not understanding how dbml files work?

Are there right & wrong times when to use & when not to use dbml files?

Thanks.

Re: Is there a right & wrong way of working with dbml files?

Manas Bhardwaj20-Jan-10 9:43

Manas Bhardwaj

20-Jan-10 9:43

Goalie35 wrote:
Are there right & wrong times when to use & when not to use dbml files?

What does it has to do with ASP.Net?

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.

To: Smitha Vijayan

Daniel Cohen Gindi20-Jan-10 8:06

Daniel Cohen Gindi

20-Jan-10 8:06

It is regarding my latest article, you have edited it, and made some important mistakes there... I have taken the HTML of your colored version and fixed it with the original meaning. Please contact me so I can send it to you, as there's no modify option for some reason, and there's no PM also so I can't contact you!
Thanks
Daniel

-----
Daniel Cohen Gindi
danielgindi (at) gmail dot com

Re: To: Smitha Vijayan

Brij20-Jan-10 8:17

Brij

20-Jan-10 8:17

why didn't you replied him at in your article itself.I dont think it'll help you if you post it in ASP.NET forum

Cheers!!
Brij

Re: To: Smitha Vijayan

Daniel Cohen Gindi20-Jan-10 12:26

Daniel Cohen Gindi

20-Jan-10 12:26

Yes I tried, here and in the article, and also replied to the email I received after my article was uploaded. But no response from her...

-----
Daniel Cohen Gindi
danielgindi (at) gmail dot com

Re: To: Smitha Vijayan

Not Active20-Jan-10 15:42

Not Active

20-Jan-10 15:42

Then don't waste our time Mad | :mad:

I know the language. I've read a book. - _Madmatt

Re: To: Smitha Vijayan

Daniel Cohen Gindi20-Jan-10 22:26

Daniel Cohen Gindi

20-Jan-10 22:26

Oh poor thing

-----
Daniel Cohen Gindi
danielgindi (at) gmail dot com

Re: To: Smitha Vijayan

loyal ginger21-Jan-10 5:39

loyal ginger

21-Jan-10 5:39

I have never posted an article on codeproject, but I can feel the pain you are having. The fact that there is no modify option is quite annoying. The author should be able to modify his/her article!!!

I think you should report this as a bug to codeproject.

By the way, I like all your articles. I've been using your stuff ever since I found them. Thanks!

Re: To: Smitha Vijayan

Daniel Cohen Gindi21-Jan-10 5:42

Daniel Cohen Gindi

21-Jan-10 5:42

Thanks man!
You might want to check my latest article on ResolveUrl. (And if you are actually reading the introduction, replace the words "if" by "unless" in your head, because Smitha has replaced all of my "unless"es into "if"s...

-----
Daniel Cohen Gindi
danielgindi (at) gmail dot com

problem of assembly in my Asp.net webapplication

nilesh_chile20-Jan-10 6:59

nilesh_chile

20-Jan-10 6:59

i have deployed my web application in my company's subdomain but it's showing ----
Parser Error Message: Could not load file or assembly 'CrystalDecisions.Web, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified.

can any one help me out i am a fresher, have just joined my new job.

Re: problem of assembly in my Asp.net webapplication

Estys20-Jan-10 7:07

Estys

20-Jan-10 7:07