Dot Net and SQL Server
This blog provide my experiences in Dot Net and SQL Server.
Tuesday, February 2, 2021
Wednesday, April 17, 2013
District Institutes of Educational Training - DIET CET - 2013
District Institutes of Educational Training - DIET CET - 2013
NOTIFICATION
Online applications are invited from candidates who intend to take admission into two year Diploma in Education (D.Ed.,) in Government District Institutes of Educational Training (DIETs) and Private Elementary Teacher Training Institutions in the state to be conducted by Department of School Education, Government of Andhra Pradesh on Friday, 31st May, 2013 in all 23 Districts of the State.
DIETCET will be conducted on 31st May 2013 in all the Districts of the State. The test will be conducted from 10.30 AM to 12.30 PM (2 hours)
NOTIFICATION
Online applications are invited from candidates who intend to take admission into two year Diploma in Education (D.Ed.,) in Government District Institutes of Educational Training (DIETs) and Private Elementary Teacher Training Institutions in the state to be conducted by Department of School Education, Government of Andhra Pradesh on Friday, 31st May, 2013 in all 23 Districts of the State.
Date and Timings of DIET CET
DIETCET will be conducted on 31st May 2013 in all the Districts of the State. The test will be conducted from 10.30 AM to 12.30 PM (2 hours)
Tuesday, March 26, 2013
Tuesday, July 12, 2011
How to correct spell mistake in SSC Certificate
Hi,
How to correct spell mistake in SSC Certificate
To correct you name in SSC certificate you need to submit the following documents to the Board
Submit the above documents in SSC board to concerned office. For each district there is separate block in SSC Board.
How to correct spell mistake in SSC Certificate
To correct you name in SSC certificate you need to submit the following documents to the Board
(Board of Secondary Education, Andhra Pradesh, INDIA)
- A letter from School Head Master
- NR Copy from School
- SSC Original Certificate
Submit the above documents in SSC board to concerned office. For each district there is separate block in SSC Board.
Tuesday, May 11, 2010
Query to Return All Columns of Table
This Query will returns the all columns of a specified TABLE.
SELECT *
FROM information_schema.COLUMNS CH
WHERE table_name='tblChMyLogins'
SELECT *
FROM information_schema.COLUMNS CH
WHERE table_name='tblChMyLogins'
How to get a list of SQL Server databases
There are multiple ways of getting a list of the SQL Server databases, the easiest one is to execute the sp_databases stored procedure, like in the example below:
System.Data.SqlClient.SqlConnection SqlCon = new System.Data.SqlClient.SqlConnection("server=venkateswarlu;uid=sa;pwd=1234");
SqlCon.Open();
System.Data.SqlClient.SqlCommand SqlCom = new System.Data.SqlClient.SqlCommand();
SqlCom.Connection = SqlCon;
SqlCom.CommandType = CommandType.StoredProcedure;
SqlCom.CommandText = "sp_databases";
System.Data.SqlClient.SqlDataReader SqlDR;SqlDR = SqlCom.ExecuteReader();
while(SqlDR.Read())
{
MessageBox.Show(SqlDR.GetString(0));
}
Monday, May 10, 2010
ASP.NET - GridView RowCommand get row index
if you did assign a value into the CommandArgument e.g. below, you need to use the #1 methond else #2
<itemtemplate> <asp:imagebutton id="imgUpdate" runat="server" commandname="Update1" commandargument="'<%#">' ImageUrl="~/icons/Update001 (2).gif" /></itemtemplate>
#1
VB
Dim selectedRow As GridViewRow = DirectCast(DirectCast(e.CommandSource, LinkButton).NamingContainer, GridViewRow)Dim intRowIndex As Integer = Convert.ToInt32(selectedRow.RowIndex)GridView.Rows(intRowIndex).BackColor = System.Drawing.Color.Blue
C#
GridViewRow selectedRow = (GridViewRow)((ImageButton)e.CommandSource).NamingContainer;int intRowIndex = Convert.ToInt32(selectedRow.RowIndex);GridView.Rows[intRowIndex].BackColor = System.Drawing.Color.Blue;
or #2
VB
Dim selectedRow As GridViewRow = GridView.Rows(Convert.ToInt32(e.CommandArgument))selectedRow.BackColor = System.Drawing.Color.Blue
C#
GridViewRow selectedRow = GridView.Rows[Convert.ToInt32(e.CommandArgument)];selectedRow.BackColor = System.Drawing.Color.Blue;
<itemtemplate> <asp:imagebutton id="imgUpdate" runat="server" commandname="Update1" commandargument="'<%#">' ImageUrl="~/icons/Update001 (2).gif" /></itemtemplate>
#1
VB
Dim selectedRow As GridViewRow = DirectCast(DirectCast(e.CommandSource, LinkButton).NamingContainer, GridViewRow)Dim intRowIndex As Integer = Convert.ToInt32(selectedRow.RowIndex)GridView.Rows(intRowIndex).BackColor = System.Drawing.Color.Blue
C#
GridViewRow selectedRow = (GridViewRow)((ImageButton)e.CommandSource).NamingContainer;int intRowIndex = Convert.ToInt32(selectedRow.RowIndex);GridView.Rows[intRowIndex].BackColor = System.Drawing.Color.Blue;
or #2
VB
Dim selectedRow As GridViewRow = GridView.Rows(Convert.ToInt32(e.CommandArgument))selectedRow.BackColor = System.Drawing.Color.Blue
C#
GridViewRow selectedRow = GridView.Rows[Convert.ToInt32(e.CommandArgument)];selectedRow.BackColor = System.Drawing.Color.Blue;
Subscribe to:
Posts (Atom)
-
Hi, How to correct spell mistake in SSC Certificate To correct you name in SSC certificate you need to submit the following documents to...
-
Introduction Group discussions are today an important part of the selection process to many entry-level executive jobs and management insti...
-
The nation observed the birth centenary of Swami Vivekananda recently to commemorate the great visionary. (Pandit Nehru called him "the...