Question { 6687 }

How to get oledb connection?

Answer

using OLEDB connection we can connect the MS-ACCESS,Sql
Server,Oracle.

here i given the coding for connect the oledb connection

OleDbConnection con = new OleDbConnection();
con.ConnectionString="Provider=Microsoft.Jet.OleDb.4.0;Data
Source=databasenamewithpath;";
con.Open();

then u can use the dataset or datareader
OleDbCommand cmd = new OleDbCommand(sql,con);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();


OleDbDataReader reader;
reader = cmd.ExecuteReader();


OleDbDataAdapter oda = new OleDbDataAdapter(sql,con);
DataSet ds = new DataSet();
oda.Fill(ds,"tablename");

i hope that these are enough.

Question { Infinite Computer Solutions, 19332 }

what is the differance between .DLL & .EXE

Answer

both are the executable files.But main difference is
that .exe can run independantly.But .dll can be part of
the .exe.
So dll is the superset of exe.

Question { Satyam, 5143 }

what you know about databases?

Answer

Database is the collection of tables.where table has the
collection of records.where records has the collection of
attributes.
Database is used to store the data.The relationship can be
maintained between the tables.

Question { Microsoft, 8630 }

Give coding for Exception Handling Techniques in ASP.NET?

Answer

The exception handling techniques very use full to display
the errors in meaningfull way.

The syntax of exception handling as follows.

try
{

}
catch(Exception )
{

}
catch(Exception )
{

}
finally
{

}
Here the set of codes executed if any error found in try
block the catch block will be executed.We may have any
number of exception in catch but it will only one executed
according to the type of error.But the finally block must
executed automatically whether error found or not.

try
{
SqlConnection con = new SqlConnection();
con.ConnectionString =" ----";
String sql;
sql = "---";
SqlCommand cmd = new SqlCommand(sql,con);
cmd.CommandType = CommandType.Text;
cmd.ExectuteNonQuery();
}
catch(FileNotFoundException e)
{
Console.WriteLine("Error:"+e.Message);
}
catch(SqlException ee)
{
Console.WriteLine("Error:"+ee.Message);
}
finally
{
Console.WriteLine("This program written by S.Senthil
umar");
}

if this is correct ok.otherwise correct me.

Question { 4516 }

Code for Getting Information About A File?

Answer

here we have the system.io base class in .net

FileInfo is the class which has the properties and methods
to display information about the file.
example code
FileInfo fi = new FileInfo("givepath");
Console.WriteLine("File Name:"+fi.Name);
Console.WriteLine("FullName:"+fi.FullName);
Console.WriteLine("Creation Time:"+fi.CreationTime);
Console.WriteLine("Last Access Time:"+fi.LastAccessTime);
Console.WriteLine("File Deleted :"+fi.Delete());

We can similarly know about the directory information using

DirectoryInfo di = new DirectoryInfo("path");

Question { Satyam, 14586 }

How to find the client browser type ?

Answer

we can identify the browser name using javascript

var brw = new navigator();
alert(brw.appname);
alert(brw.appversion);

Question { TCS, 71757 }

Difference between writing SQL query and stored procedure ?

Answer

compared with query, stored procedure is efficient and fast
execution.Because stored procedure is program once it
formed then execute as a program.

Question { Digital GlobalSoft, 27491 }

What is difference between interface inheritance and class
inheritance ?

Answer

In interface inheritance all the methods should be
public.but in class inheritance mey be user defined.

Question { Digital GlobalSoft, 5204 }

What are the collection classes ?

Answer

BitArray
ArrayList
HashTable
Stack
Queue

Question { Digital GlobalSoft, 4885 }

Error handling and how this is done ?

Answer

Error handling is the display the unknown error during the
runtime.here we can use the exception to handle the
error.we also have tje throw exception but its very
difficult to predict the place to identify the error.

try
{
//set of processing code
}
catch(Exception e)
{
Console.WriteLine("Error:"+e.Message);
}
finaly
{
Console.WriteLine("Example Program for the Error
Handling");
}

here set of codes will be executed if any error has found
it will throw the exception from catch block.But finally
will executed compulsarily whether error occured or not
event if you teriminate the control outside from block.

Question { Keane India Ltd, 12605 }

Write steps of retrieving data using ado.net ?

Answer

we can use two ways to retrieve the data from database
1 -> data reader
2 -> data adapter

when you use datareader
create connection object and open the connection
SqlCommand cmd = new SqlCommand(sql,con);
cmd.CommandType = CommandType.Text;
SqlDataReader sread = cmd.ExecuteReader();
while(sread.Read())
{
String data1 = sread.GetString(0);
int data2 = sread.GetValue(1);
String data3 = sread.GetString(2);
}

when u use the dataadapter

create the connection and open
SqlDataAdapter sda = new SqlDataAdapter(sql,con);
DataSet ds = new DataSet();
sda.Fill(ds,"customer");

then use can get the data in row wise or directly assign
the data to the controls through datasource.

i think its enough.If i did any mistake correct me.

Question { MMTS, 8110 }

Life cycle of ASP.NET page when a request is made ?

Answer

These are the steps in the asp.net life cycle
init()
load()
prerender()
unload()

Question { MMTS, 7899 }

About a class access specifiers and method access specifiers ?

Answer

Private
Public
Protected
internal

Question { MMTS, 7899 }

About a class access specifiers and method access specifiers ?

Answer

Class Access Modifier
---------------------
private
public
protected
internal
abstract
sealed

Method Access Modifier
----------------------
private
public
virtual
override
sealed

Question { MMTS, 5795 }

What is overloading and how can this be done ?

Answer

Overloading is the process of call the same method with
different parameter types,diferent order of parameters with
in the class.Its also applicable for the constructor.

here i give some example

class sample
{
public void display()
{
Console.WriteLine("display :1");
}
public void (int i,int j)
{
int s=0;
s = i+j;
Console.WriteLine("Result :"+s);
}
}

class Overload
{
public static void Main(string []args)
{
sample s = new sample();
s.display();
s.display(5,5);
}
}