Database

<br />
set ANSI_NULLS ON<br />
set QUOTED_IDENTIFIER ON<br />
go<br />
<br />
<br />
<br />
<br />
<br />
<br />
ALTER    procedure [dbo].[apo_GetQuestionsByInqTransId]<br />
--Passing inventory id as input variable <br />
--Generate all the questions of it<br />
@InqTransId int,<br />
@appId int,<br />
@option nvarchar(20),<br />
@schema nvarchar(30)<br />
<br />
As<br />
Begin<br />
<br />
	if @option='All'<br />
		begin<br />
				select qm.QID,qm.[name],QM.ParentQID,itql.SequenceNo from QuestionMaster qm,InquiryTransaction it,<br />
				InquiryQuestionLinkage itql   <br />
				where itql.qid=qm.qid and it.InquiryTransId=itql.InquiryTransId<br />
				and it.InquiryTransId=@InqTransId order by QM.ParentQID<br />
		end<br />
	else<br />
		begin<br />
				declare @AnswerDetailTable as nvarchar(40)<br />
				set @AnswerDetailTable =@schema+'.AnswerDetalTable'<br />
				select qm.QID,qm.[name],QM.ParentQID,itql.SequenceNo<br />
				from QuestionMaster qm,InquiryTransaction it,InquiryQuestionLinkage itql   <br />
				where itql.qid=qm.qid and it.InquiryTransId=itql.InquiryTransId<br />
				and it.InquiryTransId=@InqTransId and qm.QID not in(select QID<br />
				from @AnswerDetailTable<br />
				where appId=@appId)   <br />
				order by QM.ParentQID<br />
		end<br />
<br />
End  <br />

<br />
private readonly string ACCESS_CUSTOMER_UPDATE = "UPDATE Customer SET Customer.Name = @Name,Customer.Age = @Age WHERE Customer.ID = @ID";<br />

        <br />
private string PARAM_ID = "@ID";<br />
private string PARAM_NAME = "@Name";<br />
private string PARAM_AGE = "@Age";<br />
<br />
private string connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Temp\\temp.mdb";<br />
<br />
private OleDbConnection connection = new OleDbConnection(connectionstring);<br />
<br />
public void UpdateCustomer(CustomerInfo customer)<br />
{<br />
           OleDbParameter[] parameters = new OleDbParameter[]{<br />
                new OleDbParameter(PARAM_ID,OleDbType.Integer),<br />
                new OleDbParameter(PARAM_NAME,OleDbType.VarChar),<br />
                new OleDbParameter(PARAM_AGE,OleDbType.Integer)};<br />
<br />
            parameters[0].Value = customer.ID;<br />
            parameters[1].Value = customer.Name;<br />
            parameters[2].Value = customer.Age;<br />
<br />
            OleDbCommand command = new OleDbCommand();<br />
            command.Connection = this.connection;<br />
            command.Connection.Open();<br />
            command.CommandText = "UPDATE Customer SET Customer.Name = @Name,Customer.Age = @Age WHERE Customer.ID = @ID";<br />
<br />
            for (int i = 0; i < parameters.Length; i++)<br />
            {<br />
                OleDbParameter parm = (OleDbParameter)parameters[i];<br />
                command.Parameters.Add(parm);<br />
            }<br />
<br />
            try<br />
            {<br />
                int x = command.ExecuteNonQuery();<br />
                Debug.WriteLine(x.ToString());<br />
            }<br />
            catch (Exception e)<br />
            {<br />
                throw new Exception(e.Message, e.InnerException);<br />
            }<br />
            finally<br />
            {<br />
                command.Connection.Close();<br />
                command.Dispose();<br />
            }<br />
}<br />