Search This Blog

Wednesday, March 5, 2014

Handle click event in Button Column in DataGridView

C#DataGridViewDataGridViewButtonColumn

Add DataGridViewButtonColumn to your DataGridView.
To handle button click use CellClickEvent.

Example

private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
  if (e.ColumnIndex == dataGridView1.Columns["Browse"].Index && e.RowIndex >= 0)
  {
               
  }
}





Call Statement VB.NET Example

VB.NET > Statements > Call


Call transfers control to a function or dynamic-link library.
Call keyword is used when the called expression doesn't start with an identifier.


Example:


Class mClass
    Public Sub Method()
        MessageBox.Show("Call statement")
    End Sub
End Class

Public Class Form1
    Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        Call New mClass().Method()
    End Sub

End Class





Tuesday, March 4, 2014

HttpResponse ASP.NET

ASP.NET > System.WebHttpResponse 

Encapsulates HTTP response information from an ASP.NET application.





ASP.NET System.Web

ASP.NET > System.Web

System.Web contains classes and interfaces that enable browser-server communication.





Rss Feed Reader Vb.net Example

VB.NET > XML > Rss Feed Reader






Example


 Dim url As String = "http://rss.cnn.com/rss/cnn_latest.rss"
        Dim rssFeed As HttpWebRequest = DirectCast(WebRequest.Create(url), HttpWebRequest)
        Dim response = rssFeed.GetResponse()
        Dim rssStream = response.GetResponseStream()

        Dim rssDoc As New XmlDocument()
        rssDoc.Load(rssStream)
        Dim rssItems As XmlNodeList = rssDoc.SelectNodes("rss/channel/item")
        Dim i As Integer = 0
        Dim dt As DataTable = New DataTable("table")
        dt.Columns.Add("title", Type.GetType("System.String"))
        dt.Columns.Add("link", Type.GetType("System.String"))

        While i < rssItems.Count
            Dim node As XmlNode = rssItems.Item(i).SelectSingleNode("title")
            Dim title As String
            Dim link As String
            If node IsNot Nothing Then
                title = node.InnerText
            Else
                title = ""
            End If

            node = rssItems.Item(i).SelectSingleNode("link")
            If node IsNot Nothing Then
                link = node.InnerText
            Else
                link = ""
            End If
            Dim dr As DataRow = dt.NewRow()
            dr("title") = title
            dr("link") = link

            dt.Rows.Add(dr)

            i += 1
        End While

        DataGridView1.DataSource = dt


#Region Directive Visual Basic Example

Visual Basic > Directives > #Region

Collapses and hides sections of code.

Example:

Public Class Form1
#Region "Person"
    Public Class Person

    End Class
#End Region
    Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load

    End Sub

End Class








Wednesday, February 26, 2014

Read XMLTYPE Oracle C#

C# > Oracle.DataAccess > Read XMLTYPE 

An OracleXmlType object represents an Oracle XMLType instance.

Example:


OracleConnection con = new OracleConnection() ;
con.ConnectionString = "Data Source=sid; User ID=xx; Password=xx; enlist=false; ";
con.Open();
OracleCommand xmlCmd = new OracleCommand();
xmlCmd.CommandText = "select xml from table ";
xmlCmd.Connection = con;
OracleDataReader poReader = xmlCmd.ExecuteReader();
OracleXmlType poXml;
while (poReader.Read())
{
     poXml = poReader.GetOracleXmlType(0);    
}

con.Close();