Im using Visual Studio 2008 and i have created a GridView which displays data from an SQL Table, how could i export this data into an Excel sheet on click of a button.
View 1 Replies
I have list of tables in my database.
how to retrieve list of tables including data into databound control and
how to export the tables data to excelsheet individually..
a)Gets the list of tables within the database
b)Gets data
c)Exports the data to excel worksheets (there are 2 methods defined (1) range method (2) cell by cell
d.) Saves the excel sheet
I want how to upload the excel sheet data and that data will save in Sql Server 2008(table).
View 2 RepliesI've got an .rdlc report which I print from my .net app (C# Visual Studio 2005), where I use a RemoteReportPrinter object. I give it as parameters the server name, report name, report parameters, etc. Works fine. My question is, I would live to do an analagous export of that report to Excel. Set it up exactly the same, but have it export to Excel rather than print, probably using some other type of object than RemoteReportPrinter.
View 1 RepliesI have a custom control gridview:I have a filter row in the header of each column with a textbox and a button to filter. when the user clicks the filter button this is one of the blocks of code that get executed
Code:
Protected Overridable Sub ApplyFilterCommand(ByVal filterCommand As String)
Dim dsv As DataSourceView = Me.GetData
If (TypeOf dsv Is SqlDataSourceView) Then
[code]....this works. However, all rows from the datasource are exported. say the initial number of rows where 54. I then filter a column, the number of rows in the gridview are now 29.I then export to excel, and all 54 rows are exported.
I have the gridview inside another gridview, i want to sort that both gridviews, I don't know how to achieve using asp.net 3.5 visual studio 2008 c# code behind. Following are my aspx page,
<div
id="divclm"
runat="server">
<asp:GridView
ID="claimgrid"
runat="server"
AutoGenerateColumns="False" AllowSorting="True"
Width="100%"
AllowPaging="True"
CssClass="gareahead"
EmptyDataText="No Records To Display"
OnRowDataBound="claimgrid_RowDataBound"
OnRowCreated="claimgrid_RowCreated"
GridLines="Both"
OnPageIndexChanging="claimgrid_PageIndexChanging"
OnSorting="claimgrid_Sorting"
CaptionAlign="Right">
<Columns>
<asp:HyperLinkField
Text="<img id='upimg' src='Styles/Images/appschg.gif'/>"
ItemStyle-Width="10px">
<ItemStyle
Width="10px"
/>
</asp:HyperLinkField>
<asp:BoundField
DataField="name"
HeaderText="Name"
SortExpression="name">
<HeaderStyle
HorizontalAlign="Center"
/>
<ItemStyle
HorizontalAlign="Left"
/>
</asp:BoundField>
<asp:BoundField
DataField="code"
HeaderText="Code"
SortExpression="code">
<HeaderStyle
HorizontalAlign="Center"
/>
<ItemStyle
HorizontalAlign="Left"
/>
</asp:BoundField>
<asp:TemplateField>
<ItemTemplate>
</td></tr>
<tr>
<td
colspan="6"><div
id="<%#Eval("code") %>"
style="display:none;position:relative">
<asp:GridView
ID="Gdclmline1"
runat="server"
AllowPaging="True"
AllowSorting="True"
AutoGenerateColumns="False"
OnSorting="Gdclmline1_Sorting" BorderColor="Green"
BorderStyle="Solid"
BorderWidth="1px"
OnRowDataBound="Gdclmline1_RowDataBound"
OnRowEditing="Gdclmline1_RowEditing" Font-Names="Verdana"
Font-Size="8pt"
Font-Strikeout="False"
OnSelectedIndexChanging="Gdclmline1_SelectedIndexChanging"
OnRowUpdating="Gdclmline1_RowUpdating" PageSize="1000"
RowStyle-Wrap="false"
Width="100%"
CssClass="gareahead"
EmptyDataText="No Records To Display"
GridLines="Both">
<PagerSettings
Mode="NextPreviousFirstLast"
NextPageText="Next"
Position="Top"
PreviousPageText="Prev"
/>
<Columns>
<asp:TemplateField
HeaderText="phone"
SortExpression="phone">
<HeaderStyle
HorizontalAlign="Center"
/>
<ItemStyle
HorizontalAlign="Left"
/>
<ItemTemplate>
<asp:Label
ID="lblphone"
runat="server"
Text='<%#Bind("phone") %>'> </asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField
HeaderText="address1"
SortExpression="address2">
<HeaderStyle
HorizontalAlign="Center"
/>
<ItemStyle
HorizontalAlign="Left"
/>
<ItemTemplate>
<asp:Label
ID="lbladdress1
runat="server"
Text='<%#Bind("address1") %>'> </asp:Label>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<RowStyle
CssClass="gr"
Height="100px"
HorizontalAlign="Left"
Wrap="true"/>
<SelectedRowStyle
CssClass="gr"
/> <PagerStyle
CssClass="gareahead"
HorizontalAlign="Left"
Wrap="False"
/> <HeaderStyle
CssClass="ghead"
ForeColor="White"
Wrap="true"
/> </asp:GridView>
</div>
</td>
</tr>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<PagerSettings
Mode="NextPreviousFirstLast"
NextPageText="Next"
Position="Top"
PreviousPageText="Prev"
/>
<HeaderStyle
HorizontalAlign="Center"
VerticalAlign="Middle"
CssClass="ghead"
ForeColor="White"
/>
<RowStyle
CssClass="gr"
/>
<SelectedRowStyle
CssClass="gs"
/>
</asp:GridView>
</div>
that aspx page contains gridview that contain one more gridview inside in it.Now i want to sort out both the grid i.e)claimgrid and Gdclmline1 i want code in c#.
I have in my laptop VS 2003, VS 2005 and VS 2008. I am making some SMS application in which I am using some DLL which need asp.net 3.5 so I am making application VS 2008. Now in my application I am using DAL and BLL method where in I am making .xsd file with TableAdapted from that I am making BLL files.
I added Formview in my aspx page configure it with Objectdatasource . IDE was not invoking the wizard for objectdatasource after lot finding. I got from some forum that after removing bin folder from application. It will start working. This was the first problem now I add gridview in my aspx page now and configure with Object data source. But when I go property builder of gridview I cannot see Edit Template, I can see only Empty template and Pager Template. Here my question this is new in VS 2008 as when i was working with VS 2005 I could see all Template. Next thing when change anything through property builder, I can see changes in the design view mode but I cannot see any changes in HTML source view. Again when I switch back to HTML source view to design mode all changes will go away. Why is it so !! For more info I will put my aspx, aspx.vb page code here.
[Code]....
Is there any tool for Visual Studio 2008 which can reformat ASPX code to make it more presentable (eg insert line breaks, format the lines so they wrap when necessary, etc)?
View 5 RepliesHow can I export data from a Gridview to excel and once exported the data should be formatted in right to left (arabic) manner. How can I achieve this?
View 2 Repliesi use this code to export data into word.
Protected Sub Export(sender As Object, e As EventArgs) Handles btn_printexcel.Click
Response.Clear()
Response.Buffer = True
[Code]....
but the export docs will be downloaded into the user computer.
what should i do so that the exported docs is save into the server?
Can Visual Studio 2008 Gridview control do grouping? And how?
View 1 RepliesI am exporting a gridview in MS Excel as mentioned in the following link:
[URL]
I want to set orientation of excel pages as landscape. Is there any way to do that? Any header information to be added for file being exported to set orientation of pages as landscape?
is it possible to convert whole visual studio 2008 web site project to visual studio 2010 web site project
my current project references
i have a very annoying iis problem
iis server stops working until app pool is recycled
i am hoping that new visual studio (net framework 4.0) may solve this very annoying unsolveable problem
Anyone know if I can maintain a VS 2008 (.net 3.5) project by using the VS 2010 IDE ?
View 1 Repliesi have created a login.aspx file in visual web developer .now i want to connect the username and password details to SQL database
View 1 RepliesI have a requirement to read the excel sheet contents(with first row as header) and to populate it in a Datagrid. so as to manipulate the excel sheet data. But i get an error saying "Could not find installable ISAM". after a big struggle i came to know that the culprit is the "connection string". I tried with various connection strings and now i get the error " Format of the Initialization string does not conform to specification starting at index 121".
my code is
[code]....
I have a GridView in webform inside a DIV tag whose width is 920 pixels. I want to display all records from a database in the GridView using horizontal scroll.
View 1 Repliescan Visual Studio 2008 be All-In-One tool to integrate source code continuously from team members, build, unit test?
Having used Visual Studio Team Edition 2005, unit testing each method within VS itself. I strongly believe that it is feasible to add-on tools. Example ankhsvn tool to use SVN from Visual studio [URL]
In my investigating i have come across number of tools(shown below) to use with Visual Studio 2008 professional
Development tool:- Visual Studio 2008 professional using Subversion as source control tool. Continuous Integration:- Hudson or Cruise control Build tool:- NAnt Testing:- NUnit, Selinium As Visual Studio 2008 can be used for unit testing I think NUnit is out of consideration.
In the same way i would like to have any other tools/add-ons to Visual studio to implement continuous integration, building and unit testing. This process should be automated such a way source code between team members is continuously integrated, built and unit testing is done as configured.
Objective is to use few number of tools as add-on to Visual Studio or achieve most from Visual studio itself (example unit testing). Visual Studio should be all in one tool.
I am aware that Team Foundation Server best suits my requirement, but it is out of scope due to its cost.
I need to give users of my asp.net/vb.net web application the ability to click a button which will then send them an e-mail with the contents of a SQL query attached as an Excel e-mail attachment.
I can manage all of this apart from getting the contents of a VB dataset object into an Excel file on my server.
I know how to export a gridview to Excel at the client end, but my boss has been adamant that he wants the button to send an e-mail with the results attached - I have no need to display a gridview at all.
How to export the contents of a datareader or dataset directly into an Excel file at the server side?
I downloaded Visual Studio 2008 Professional Edition via torrent.
It was working fine for months & i formatted my comp & when i tried to reinstall it is not getting installed !
It shows the following error !
and the error log file seems to be like this...
BUT.,
I'm able to use Visual Studio & i'm able to work in it....
I'm re-installing since 2 days for more than 4 times...
I have VS 2008 Professional Edition.....I want to test a function like this:
public int getIdByName(string name)
{
var item=from x in DATAB
where x.name=name
select x.id;
.
.
return idValue;
}
now I test end I have:
[TestMethod()]
public getIdByNameTest()
{
string name="Bob"
int expected = 1;
int actual;
actual = ClassGET.getIdByName(name);
Assert.AreEqual(expected, actual);
Assert.Inconclusive("Verify the correctness of this test method.");
}
The error in "test run" is:
Failed ......[Class]....... Test method threw exception: System.ArgumentException: The specified named connection is either not found in the configuration that is not for use with the EntityClient provider or thought is invalid
How can I ensure that web application converted from 2003 visual studio to 2008 visual studio
to have two files as it is when create a web file in visual studio 2008.The web application is in Chsarp. I have converted these filesfrom 2003 to 2008 but they still have three files each.
I am using Ajax ConfirmButtonExtender Control in GridView for Deleting the Record. I am also Exporting the GridData to Excel using Render Method. But when i click on the Export Button, i am getting below error Extender control 'confirmID' is not a registered extender control. Extender controls must be registered using RegisterExtenderControl() before calling RegisterScriptDescriptors(). Parameter name: extenderControl
View 1 RepliesCan we export a gridview with a child gridview to excel?
View 1 RepliesThere was a string (1008901023816550000000) in the GridView somehow was saved as a scientific number (1.0089E+21) in Excel when I exported the GridView to Excel.I am using .Net 4.0.Here is what I tried, but they didn't solve the problem:
Added DataFormatString="{0:g}" to the BoundColumn tag.
Set the style after the RenderControl was called.
string style = @" .text { mso-number-format:@; } ";
