---------------------------------------------------------------------------------------------
Public Class frmStillPendingVehicles
Private Sub btnGenerate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnGenerate.Click
Dim strsql As String = ""
strsql = "select trasactionID,VehicleNumber,VehicleType,format(INDATE,'dd/MM/yyyy') as VehicleINDATE ,format(INDATE,'HH:mm:ss') as VehicleINTIME from tblcollection where OUTDATE is NULL" ' and INDATE>=#" & DtFrom.Value.Date & "# and INDATE<#" & DTto.Value.AddDays(1).Date & "# "
Dim m_ds As New DataSet
Dim m_db As New CDataAccess
m_ds = m_db.getdata(strsql, strconnection)
If Not m_ds Is Nothing Then
DataGridView1.DataSource = m_ds.Tables(0)
Else
MsgBox("No Records found", MsgBoxStyle.Information)
End If
End Sub
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim m_excel As String = ""
If SfdlgDownload.ShowDialog() = Windows.Forms.DialogResult.OK Then
ExportDataToExcel(SfdlgDownload.FileName, DataGridView1)
End If
End Sub
Public Sub ExportDataToExcel(ByVal FilePath As String, ByVal DataGrid As DataGridView)
Dim _mFileStream As New IO.StreamWriter(FilePath, False)
Try
_mFileStream.WriteLine("")
_mFileStream.WriteLine("")
_mFileStream.WriteLine("
_mFileStream.WriteLine("
_mFileStream.WriteLine("
_mFileStream.WriteLine("
_mFileStream.WriteLine("
_mFileStream.WriteLine("
_mFileStream.WriteLine("
_mFileStream.WriteLine("
_mFileStream.WriteLine("
For x As Integer = 0 To DataGrid.Columns.Count - 1
_mFileStream.WriteLine("
Next
_mFileStream.WriteLine("
For i As Integer = 0 To DataGrid.Columns.Count - 1
_mFileStream.WriteLine("
_mFileStream.WriteLine(String.Format("
_mFileStream.WriteLine("
Next
_mFileStream.WriteLine("
For intRow As Integer = 0 To DataGrid.RowCount - 2
_mFileStream.WriteLine(String.Format("
For intCol As Integer = 0 To DataGrid.Columns.Count - 1
_mFileStream.WriteLine("
_mFileStream.WriteLine(String.Format("
_mFileStream.WriteLine("
Next
_mFileStream.WriteLine("
Next
_mFileStream.WriteLine("
_mFileStream.WriteLine("
_mFileStream.WriteLine("
_mFileStream.Close()
_mFileStream.Dispose()
_mFileStream = Nothing
Catch ex As Exception
_mFileStream.Close()
_mFileStream.Dispose()
_mFileStream = Nothing
MessageBox.Show("Error While Exporting Data To Excel. Error : " & ex.Message)
End Try
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Me.Close()
End Sub
End Class
----------------------------------------------------------------------------------------
Best Regards
Gyana sumanth gondu
Riddhi ValechaPosted Aug 11, 2014, 1:22 PM
sorry dear... I am a bit slow in VB.NET...
There are many code converters tools available.
http://www.developerfusion.com/tools/convert/csharp-to-vb/
Try this. It may help.
Naidu AMMANPosted Jul 31, 2014, 5:41 AM
Riddhi ValechaPosted Jul 31, 2014, 3:28 AM
I have the code in C#--
#region ExportMethod
public override void VerifyRenderingInServerForm(System.Web.UI.Control ctrl)
{
}
private string GetString(object o)
{
if (o == null)
return "";
return o.ToString();
}
private void ExportDataTable()
{
try
{
DataTable table = new DataTable();
GridView grd = new GridView();
table = dbf.ExportMISReport(); //Datatable.
grd.DataSource = table;
grd.DataBind();
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("content-disposition", "attachment;filename= Report.xls");
Response.Charset = "";
this.EnableViewState = false;
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHTMLTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
grd.RenderControl(oHTMLTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();
}
catch(Exception err){err.Message.ToString();}
}
--------
GridViewDataSource - Datatable.
Hope this helps.