|
Why do you want to do so by using GridView?
I think Repeater Control or List View would be more handy for you purpose.
|
|
|
|
|
<a href="newpost.aspx"> </a>
<div>
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False" CellPadding="4" DataSourceID="SqlDataSource1" ForeColor="#333333" GridLines="None" Width="676px">
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<Columns>
<asp:BoundField DataField="postid" InsertVisible="False" ReadOnly="True" SortExpression="postid" />
<asp:HyperLinkField DataNavigateUrlFields="postid" DataNavigateUrlFormatString="message.aspx?postid={0}"
DataTextField="subject" HeaderText="主题" />
<asp:BoundField DataField="posttime" HeaderText="发表时间" SortExpression="posttime" />
<asp:BoundField DataField="username" HeaderText="作者" SortExpression="username" />
<asp:BoundField DataField="views" HeaderText="浏览数" SortExpression="views" />
<asp:BoundField DataField="replies" HeaderText="回复数" SortExpression="replies" />
</Columns>
<RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
<EditRowStyle BackColor="#999999" />
<SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" ForeColor="#284775" />
</asp:GridView>
</div>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:SimpleBBSConnectionString %>"
SelectCommand="SELECT newpost.postid, users.id, newpost.subject, newpost.posttime, newpost.userid, newpost.replies, newpost.views, users.username FROM newpost INNER JOIN users ON newpost.userid = users.id ORDER BY newpost.posttime DESC">
</asp:SqlDataSource>
April
Comm100 - Leading Live Chat Software Provider
modified 27-May-14 8:52am.
|
|
|
|
|
Hi,
I tried to configured sql report server it was succeded, by the am trying to browse from IIS the created report server & report manager application i got this error as follows,
------------------------------------------------------------
The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\RSReportServer.config' is denied.
------------------------------------------------------------
can u please reply to this question...
regards,
kannak
kannak
|
|
|
|
|
Hi,
just check if the account used by the SQL Server ReportService has access to the path you provided.
Regards
Sebastian
|
|
|
|
|
Hi Sebastian,
Can u please clearly explain ...b'coz..
During Sql Report Server Configuration,
1) Server status - is configured
2) Report Server Virtual directory - is configured and created auto
3) Reprot Server Virtual directroy - is configured and created auto
4) Windows Service identity - used Build in Account (Local Account)
5) Web Service identity - not configured b'coz am using windows 2000 (operating system)
6) Database setup - using Sql Server Credentials and configured
7) Encryptional key - operational paramter
8) Initialisation - Not configured
9) Email Setting - Recomended configuration
10) Execution Account - Recomended configuration
Upto this i was configured..then I am trying to browse the like,
http://localhost/reportserver am facing this error.. i am not understand where is the problem hitting me...can u able to find please..
Error:
The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\RSReportServer.config' is denied
Regards,
kannak.......
kannak
|
|
|
|
|
Hi Kannak,
1. Does the Windows Service identity (Local Account) access to the file "RSReportServer.config"?
2. Hmmm... the web service identity is not set, don't know if this is a problem. Check if the account your webserver is using has access to the file.
Regards
Sebastian
|
|
|
|
|
Hi Sebastian,
Thanks for responding me... That to am using Windows 2000 professional OS , i came to know no need to configure Web service Identity it will take the MAchine Config file under the IIS by default.
Also Windows Service identity properties are as below,
Service Name - Report Server
Service Account - LocalSystem
Build-In-Account - Local System
Windows Account :
Account -
Password -
Here am using Build in Account not using Windows Account.
I dont know where is problem behind...can u clear this plz...
Thanks,
kannak.........
kannak
|
|
|
|
|
Ok, so let us try the following. Go to the folder where the config of the report server is located. Then grant full access to "Everyone". Try to connect via browser again. If this works, it is really a permission problem.
Did you enabled Windows authentication for the report web site? If yes, check if the windows account you are using when the website asks for an account has access to the file.
|
|
|
|
|
hi,
my project take a long time to build..especially "App_code". What could be the reason?????
|
|
|
|
|
Hi,
could be several reasons:
1. Your machine is too slow.
2. You have many dependencies for your website.
3. Your app_code folder contains a lot of source code.
4. You are creating an assembly from your app_code folder.
So "long time" is relative, does it take half an hour or only 30 seconds? How many dependencies do you have? Do you have many classes within the app_code folder?
Regards
Sebastian
|
|
|
|
|
Try building project after disabling an anti-virus software. If its fast then you need to add your Project directory and all the Sub-Folders in it to the Exclusion/White List in your anti-virus, so it will not scan the folder when you rebuilt the project.
or try De-fragment on the HDD.
or its time to upgrade the PC 
|
|
|
|
|
Hello all,
I'm a asp.net developer. I use C# language for project development. But Now I have a live project that is in vb.net . And I want to know the Vb.net syntax. Please suggest some websites to download some webbased projects in vb.net........
|
|
|
|
|
Use google.Ask speific question in the forum only.
Cheers!!
Brij
|
|
|
|
|
Hi
I am using sitemap. I want to bind my database value to RootNode and Childnode of site map directly.
I am not using web.sitemap file nor xml file.
Any Solution?
Thanks
|
|
|
|
|
Hello Friends,
If i disable javascript in browser then my gridview's Select command is not working. So is it any way to work without javascript.
|
|
|
|
|
Hi,
since actions with nearly every ASP.NET control work by postback (which uses javascript) it seems impossible. But you could use a HTML-Button for each row to select, which will force a submit, but this will be really ugly...
Regards
Sebastian
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
try to assign admin role to "asp.net user"
good luck.
Mehdi
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
