how read data from XML file?
ReadXml()
WriteXml()
ScanXml()
SHOW ANSWERhow create a new row in dataset?
Using datarow
Using tablerow
Using datasetrow
SHOW ANSWERAdvantage of Store Procedure?
Security
Speed of execution
1.Error checking
SHOW ANSWERin store procedure,queries are write into ?
Webform
Class file
Sqlserver
SHOW ANSWERSyntax to create new procedure?
create procedure procedure_name(parameters) as query
new procedure procedure_name(parameters) as query
create procedure_name procedure (parameters) as query
SHOW ANSWERwhich sqlclass is used to assign procedure name?
sqldataadapter
sqlcommand
dataset
SHOW ANSWERwhich property is used to assign procedure name in sqlcommand?
commandType
commandName
CommandText
SHOW ANSWERwhich property is used to assign connection in sqlcommand(store procedure)?
connection
commandName
CommandText
SHOW ANSWERhow pass parameters through sqlcommand (store procedure)?
parameters.AddWithValue(parameters)
parameters.AddValue(parameters)
parameters.WithValue(parameters)
SHOW ANSWERin 2 tier,which is the return type of execute nonquery function?
bool
string
double
SHOW ANSWERin 2 tier,sqlclasses are declare in which layer?
Application layer
data access layer
Business layer
SHOW ANSWERin 2 tier,the argument of execute non query function?
int value
string value
sqlconnection
SHOW ANSWERwhich keyword is used to join created procedure with query?
in
where
as
SHOW ANSWER