|
hi all,
in my application im having code to convert the datagrid values to excel sheet but when it is saving it is taking .html extension instead if .xls, pls help me to sort out.
Response.Clear()
Response.Buffer = True
Response.AddHeader("content-position", "attachment;filename=FileName.xls")
Response.Charset = ""
Response.Cache.SetCacheability(HttpCacheability.NoCache)
Response.ContentType = "application/vnd.ms-Excel"
Me.EnableViewState = False
Dim stringwrite As New System.IO.StringWriter
Dim htmlwrite As System.Web.UI.HtmlTextWriter = New HtmlTextWriter(stringwrite)
Dim da_GetAllBooks As SqlDataAdapter = New SqlDataAdapter("GetAllBooks_Proc", Con)
da_GetAllBooks.SelectCommand.CommandType = CommandType.StoredProcedure
da_GetAllBooks.Fill(_dataSet, "AllBooks(0)")
Dim index As Integer = 0
For index = 0 To dg_AllBooks.Columns.Count - 1
dg_AllBooks.Columns(index).SortExpression = True
Next
dg_AllBooks.DataSource = (_dataSet.Tables("AllBooks"))
dg_AllBooks.DataBind()
dg_AllBooks.RenderControl(htmlwrite)
Response.Write(stringwrite.ToString())
Response.End()
help me
|
|
|
|
|
Your code is confusing. You seem to be trying to i) output an Excel file and ii) display a DataGrid at the same time. You can't do both - your page can't return binary content and HTML at the same time. To dynamically build an Excel spreadsheet, do a search on CodeProject or Google for the JET OLE Provider. You should find plenty of examples.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
HI all
I want help on following issues its a vb.net application
1) want to open excel application inside my form
2) want to create number of excel sheet which depends on a number specified in a text box.
3) want to name the sheets as for example sheetname1, sheetname2......
Pl help me out.opening the excel application is biggest problem i am facing with lots of exception
Regards
Prakash Mishra(Banglore,India)
|
|
|
|
|
I want to search Google[^] first.
Steve Jowett
-------------------------
Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'
|
|
|
|
|
Hi,
I wonder if it is possible to display text in the row headers (not column headers), I have fixed size of 6 rows, is it possible to display some kind of a title for each row?
for example:
I have a grid 6x6.
Columns are: Object 1, Object 2, Object 3, Object 4, Object 5, Object 6
The text in the rows headers would be : Data 1, Data 2, Data 3...
Thanks!
|
|
|
|
|
Check into the HeaderCell property of the Rows collection of the DataGridView.
DGV1.Rows(0).HeaderCell.Value = "Test..."
|
|
|
|
|
I added a new table to my database and have to make some changes to my existing tables. When I added the new table to my database I am not able to get the dataset to recognize it. How do I do this?
Also, I tried to create a new connection to the database file in the data folder and it said that it can't access the file because another application is already using it.
Greg
|
|
|
|
|
AAGTHosting wrote: I added a new table to my database and have to make some changes to my existing tables. When I added the new table to my database I am not able to get the dataset to recognize it. How do I do this?
Have you changed the query that fetches the data to populate your DataSet?
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
I completely rebuilt the dataset and also the database explorer does not show the new table.
What query are you talkign about? Do you mean the query for the tableAdapters for each table?
|
|
|
|
|
Of course the changes you made to the database don't show up. What did you do when you originally created the DataSet?? You told the designer which tables and columns in those table to include in the dataset, didn't you?? Well, unless you change that SELECT query, any changes you made to the database, even changing the type of a column, will NOT be reflected in the DataSet, unless you go back and change the query the DataSet is using.
Click on the DataSources tab and right click the DataSet you want, then click on "Configure DataSet with Wizard..." to go through the same process you went through before to initially setup this DataSet.
|
|
|
|
|
I tried to reconfigure the data set with the wizard and when I look at all the tables that come up in the wizard the new table I added is not there. So, I tried to create a new data set and when I looked at the tables in the wizard when trying to create that data set using the wizard the new table I created still was not there. Also the table does not show up in the database explorer. Why does it not show up in the wizard or the database explorer?
|
|
|
|
|
AAGTHosting wrote: Also the table does not show up in the database explorer. Why does it not show up in the wizard or the database explorer?
The only reason this would happen is because the Explorer is showing you one copy of the database and you made changes to another copy somewhere else.
Perhaps this is an Access database?? Did you make changes to the copy found in the build folder (Release or Debug)??
|
|
|
|
|
I have a textbox control whose multiline property is set to true.
I have some text in that textbox control.
For the first time I printed those textbox content program through my program.
And secondly, when i copy that exact same content in the notepad, and printed it,it prints differently.I want to print those textbox content like the printing from the notepad.
Do I have to change any setting in the textbox property so that the textbox content will be printed
in the same way that the notepad prints?
I think notepad automatically formats the spacing but the textbox control doesnot.So the textbox content doesnot print in the format that i want.
I printing using the code:
..........
e.Graphics.DrawString(txtPrnt.text, New Font("Tahoma", 8, FontStyle.Regular), Brushes.Black, e.MarginBounds.X, e.MarginBounds.Y)
...........
|
|
|
|
|
I am not very clear as what differences you see, however there would definitely be some difference between the print taken from an application like notepad and from a control like textbox.
Any text editor has codes written behind it to format text before it is sent to the printer. Therefore if you need any specific type of formatting in text, you should –
1) Take text value of text box in a string object.
2) Perform whatever formatting you want on this string by writing your code.
3) Send this string object to the printer.
I hope this clarifies the scenario.
-Dave.
Dave Traister,
ComponentOne LLC.
www.componentone.com
|
|
|
|
|
As per this article[^] you need to pass a [b]StringTrimming[/b] class to the Graphics.DrawString call to get the text to wrap appropriately.
|
|
|
|
|
In my program I have alot of objects that are linked together directly and indirectly sort of like a database. I want to use serialization to save these objects.
My question is when I tell it to serilize the object will it serialize just that object or will it also serilize objects that it is directly or indirectly linked to? And if the answer is the latter does this mean I would end up with duplicate copies being saved of the same object if I save more than 1 entry point for this group of objects?
thanks,
Mike
|
|
|
|
|
This depends on which version of .NET you're using. Under .NET 1.x, you'll have to write your own serializer. This is easy considering there are hundred examples of it all over the web. All you have to do is Google for "VB.NET serialize linked list" to find them.
Under .NET 2.0, this is even easier if you use the generic LinkedList class for your collections. It's already serializable and can be used with the existing .NET serialization classes.
|
|
|
|
|
Is it possible to amend, add and delete the items of a listbox during runtime?
|
|
|
|
|
|
ListBox is one of those Controls that offer an Items collection, which you can
use and abuse at all times.
Luc Pattyn [Forum Guidelines] [My Articles]
This month's tips:
- before you ask a question here, search CodeProject, then Google;
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get;
- use PRE tags to preserve formatting when showing multi-line code snippets.
|
|
|
|
|
Especially abuse. In situations i never even imagined.
|
|
|
|
|
I have managed to change the TabPage Color but I don't know how to change the background color of TabControl. I tried to put following code in Form paint event but still I coudn't remove the grey color of Tab Control.
For Each ctr As Control In frm.Controls
If TypeOf ctr Is TabControl Then
Dim rect1 As New Rectangle(ctr.Location.X, ctr.Location.Y, ctr.Width, ctr.Height)
Dim brush As New SolidBrush(Color.Green)
grph.FillRectangle(brush, rect1)
End If
Next
I would appreciate for your help.
Nas
|
|
|
|
|
There is no such direct way of setting backcolor property of Tab Control. However after setting DrawMode property of tab control to OwnerDrawFixed, we may draw tab control using our custom code.
Put following line of code on form load event –
Me.TabControl1.DrawMode = TabDrawMode.OwnerDrawFixed
Put following code in DrawItem event of Tab control-
----------------------Code Start---------------
Private Sub TabControl1_DrawItem(ByVal sender As Object, ByVal e As System.Windows.Forms.DrawItemEventArgs) Handles TabControl1.DrawItem
Dim f As Font
Dim backBrush As Brush
Dim foreBrush As Brush
If e.Index = Me.TabControl1.SelectedIndex Then
'''''If its the tab page which is selected
f = New Font(e.Font, FontStyle.Regular)
backBrush = New System.Drawing.Drawing2D.LinearGradientBrush(e.Bounds, Color.AntiqueWhite, Color.LightSkyBlue, System.Drawing.Drawing2D.LinearGradientMode.Vertical)
foreBrush = Brushes.Black
Else
'brush for unselect tab pages
f = e.Font
backBrush = New SolidBrush(e.BackColor)
foreBrush = New SolidBrush(e.ForeColor)
End If
Dim tabName As String = Me.TabControl1.TabPages(e.Index).Text
Dim sf As New StringFormat
sf.Alignment = StringAlignment.Center
''''Draw tab rectangle
e.Graphics.FillRectangle(backBrush, e.Bounds)
Dim r As RectangleF = New RectangleF(e.Bounds.X, e.Bounds.Y + 4, e.Bounds.Width, e.Bounds.Height - 4)
'Draw text of tab pages
e.Graphics.DrawString(tabName, f, foreBrush, r, sf)
sf.Dispose()
If e.Index = Me.TabControl1.SelectedIndex Then
f.Dispose()
backBrush.Dispose()
Else
backBrush.Dispose()
foreBrush.Dispose()
End If
End Sub
---------------------Code End---------------
I hope this helps.
-Dave.
Dave Traister,
ComponentOne LLC.
www.componentone.com
|
|
|
|
|
Hello.
I'm working on an problem for an week now and i'm getting nowhere.
When I make an setup and deploy it on another PC i can't use the Access database.
The error that i get is:
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.Data.OleDb.OleDbException: No error message available, result code: -2147024770(0x8007007E).
at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OleDb.OleDbConnection.Open()
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at Test_VBiB.TestDatabaseDataSetTableAdapters.tNamenTableAdapter.Fill(tNamenDataTable dataTable)
at Test_VBiB.oAccessData.oAccessData_Load(Object sender, EventArgs e)
at System.Windows.Forms.Form.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
Test_VBiB
Assembly Version: 0.0.0.0
Win32 Version: 0.0.0.0
CodeBase: file:///C:/Program%20Files/EwR%20Development/Setup/Test_VBiB.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Data.SqlServerCe
Assembly Version: 3.5.0.0
Win32 Version: 3.5.5386.0
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Data.SqlServerCe/3.5.0.0__89845dcd8080cc91/System.Data.SqlServerCe.dll
----------------------------------------
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
Microsoft.VisualBasic
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualBasic/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.EnterpriseServices
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
<configuration>
<system.windows.forms jitdebugging="true">
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
I hope someone can help me.
I've been looking on the internet for this week and can't find any thing that should help me.
Thanks.
Erich.
(Dutch).
|
|
|
|
|
Hi Man
Is the Computer of the Client has .NET installed ?
Try to Install Microsoft Data Access Components 2.7 on that Computer, i have been using Access as my back-end but i have never came across a Problem.
Hope it helps
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|