How to SQL value store in varaiable

Question

1.00/5 (1 vote)

See more:

C#

MsSql = ""
MsSql &= "Select tsalesdump_gid,tsalesdump_date,tsalesdump_name,executivename_executive,tsalesdump_vch_no,tsalesdump_debit,tsalesdump_credit"
MsSql &= " from vsolv_tmp_tsalesdump as a"
MsSql &= " left join vsolv_trn_executivename as b on a.tsalesdump_name = b.executivename_particulars"
MsSql &= " where tsalesdump_gid = '" & lsRefid & "' and tsalesdump_isremoved = 'N'"
dtDumpBooking = Gobjdbconn.GetDataTable(MsSql)

MsSql = ""
MsSql &= " SELECT tsalesdump_date,tsalesdump_name,tsalesdump_vch_no FROM"
MsSql &= " ( SELECT tsalesdump_date,tsalesdump_name,tsalesdump_vch_no FROM vsolv_tmp_tsalesdump"
MsSql &= "  UNION"
MsSql &= " SELECT tsalesregdump_date,tsalesregdump_name,tsalesregdump_vch_no FROM vsolv_trn_tsalesregdump"
MsSql &= " ) A order by tsalesdump_vch_no asc; "
dtdumpsample = Gobjdbconn.GetDataTable(MsSql)

What I have tried:

how to variable to store in sql data

if the two sql data is same it ill be update and its not same its go to insert how can use it
asp.net vb

Posted 24-Apr-16 22:06pm

Bloodholder Ansih

Updated 24-Apr-16 23:01pm

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

v2

Add a Solution

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 25-Apr-16 4:51am

This is not clear. Please Improve the question and add more details about the issue.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

priyadarshini tv · Accepted Answer · 2016-04-24T23:01:00

Hi
Two ways are there to do this

1.You can use linq to get the data from datatable with your condition and store it in variable

2.You can create anonymous objects and store your data into it

C#

var obj1=new obj1
{
tsalesdumpgid=dtDumpBooking.rows[index][columnname].tostring(),
tsalesdumpname=dtDumpBooking.rows[index][columnname].tostring(),
executivenameexecutive=dtDumpBooking.rows[index][columnname].tostring()
};

var obj2=new obj2
{
tsalesdumpdate=dtdumpsample .rows[index][columnname].tostring(),
tsalesdumpname=dtdumpsample .rows[index][columnname].tostring()

};

if(obj1==obj2)
{
//your code

}

VB

Dim obj1 = New obj1() With { _
Key .tsalesdumpgid = dtDumpBooking.rows(index)(columnname).tostring(), _
Key .tsalesdumpname = dtDumpBooking.rows(index)(columnname).tostring(), _
Key .executivenameexecutive = dtDumpBooking.rows(index)(columnname).tostring() _
}

Dim obj2 = New obj2() With { _
Key .tsalesdumpdate = dtdumpsample.rows(index)(columnname).tostring(), _
Key .tsalesdumpname = dtdumpsample.rows(index)(columnname).tostring() _
}

If obj1 = obj2 Then
//your code
End If

The above code is just an example only