Styjun

Does the fact that we can only measure the two-way speed of light undermine the axiom of invariance?

Why is this integration method not valid?

Computing elements of a 1000 x 60 matrix exhausts RAM

How to tease a romance without a cat and mouse chase?

How do I write real-world stories separate from my country of origin?

nginx conf: http2 module not working in Chrome in ubuntu 18.04

Are clauses with "который" restrictive or non-restrictive by default?

Is it normal to "extract a paper" from a master thesis?

why "American-born", not "America-born"?

How to make Flex Markers appear in Logic Pro X?

mmap: effect of other processes writing to a file previously mapped read-only

Is being an extrovert a necessary condition to be a manager?

How could Dwarves prevent sand from filling up their settlements

Proto-Indo-European (PIE) words with IPA

How would a physicist explain this starship engine?

Why is 'additive' EQ more difficult to use than 'subtractive'?

Is the default 512 byte physical sector size appropriate for SSD disks under Linux?

Why do testers need root cause analysis?

(For training purposes) Are there any openings with rook pawns that are more effective than others (and if so, what are they)?

Surface of the 3x3x3 cube as a graph

Efficient Algorithms for Destroyed Document Reconstruction

A nasty indefinite integral

Passport queue length in UK in relation to arrival method

Find this Unique UVC Palindrome ( ignoring signs and decimal) from Given Fractional Relationship

How to read 2 commands without closing the first one?

How does database indexing work?How can I prevent SQL injection in PHP?How do I enumerate an enum in C#?How to create Excel (.XLS and .XLSX) file in C# without installing Ms Office?How do I get a consistent byte representation of strings in C# without manually specifying an encoding?How do I UPDATE from a SELECT in SQL Server?How do I generate a random int number?Select first row in each GROUP BY group?There is already an open DataReader associated with this Command which must be closed firstHow to import an SQL file using the command line in MySQL?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

-2

0

i know the question seems a bit weird but ive looked at many videos,codes and still i couldnt find any solution. I am trying to check if username or email is taken or not.But i want to check them seperately.First username and secondly email. I am kinda beginner so i dont know the code i wrote is proper but this is what i coded. and it is also in a if-else statement like this.

http://prntscr.com/n1zzao

so how can i do this ? how can i read 2 sql commands without closing the first one ?

c# sql ado.net

share|improve this question

asked Mar 23 at 20:54

mryellow61mryellow61

12

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Please see the How to Ask help page and The perfect question blog post by Jon Skeet. We won't know how to make the changes to your existing code base without seeing your original code. Please post a Minimal, Complete, and Verifiable example, and fully explain what needs to be modified.
  
  – Patrick Artner
  Mar 23 at 20:56
  

  
  
  
  


• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  Use a Stored Procedure and btw STOP posting code as image
  
  – Rahul
  Mar 23 at 20:56
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  idownvotedbecau.se/imageofcode
  
  – Patrick Artner
  Mar 23 at 20:56
  

  
  
  
  

add a comment | 

-2

0

i know the question seems a bit weird but ive looked at many videos,codes and still i couldnt find any solution. I am trying to check if username or email is taken or not.But i want to check them seperately.First username and secondly email. I am kinda beginner so i dont know the code i wrote is proper but this is what i coded. and it is also in a if-else statement like this.

http://prntscr.com/n1zzao

so how can i do this ? how can i read 2 sql commands without closing the first one ?

c# sql ado.net

share|improve this question

asked Mar 23 at 20:54

mryellow61mryellow61

12

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Please see the How to Ask help page and The perfect question blog post by Jon Skeet. We won't know how to make the changes to your existing code base without seeing your original code. Please post a Minimal, Complete, and Verifiable example, and fully explain what needs to be modified.
  
  – Patrick Artner
  Mar 23 at 20:56
  

  
  
  
  


• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  Use a Stored Procedure and btw STOP posting code as image
  
  – Rahul
  Mar 23 at 20:56
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  idownvotedbecau.se/imageofcode
  
  – Patrick Artner
  Mar 23 at 20:56
  

  
  
  
  

add a comment | 

i know the question seems a bit weird but ive looked at many videos,codes and still i couldnt find any solution. I am trying to check if username or email is taken or not.But i want to check them seperately.First username and secondly email. I am kinda beginner so i dont know the code i wrote is proper but this is what i coded. and it is also in a if-else statement like this.

http://prntscr.com/n1zzao

so how can i do this ? how can i read 2 sql commands without closing the first one ?

c# sql ado.net

share|improve this question

asked Mar 23 at 20:54

mryellow61mryellow61

12

share|improve this question

asked Mar 23 at 20:54

mryellow61mryellow61

12

share|improve this question

asked Mar 23 at 20:54

mryellow61mryellow61

12

asked Mar 23 at 20:54

mryellow61mryellow61

12

asked Mar 23 at 20:54

mryellow61mryellow61

12

2 Answers
2

active

oldest

votes

0

// Check if username is taken
var command = new SqlCommand("SELECT * FROM YourTable WHERE userName=" userName , 
yourConnection);
var reader = command.ExecuteReader();

// Check if email is taken
var command = new SqlCommand("SELECT * FROM YourTable WHERE email=" email, 
yourConnection)
command.ExecuteNonQuery();

share|improve this answer

answered Mar 23 at 21:01

Nestor EduardoNestor Eduardo

11

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i am doing it in if else statement block so this doesnt help
  
  – mryellow61
  Mar 24 at 11:32
  
  

  
  
  
  

add a comment | 

0

Firstly, I am not sure why are you insisting on having to find the result in two separate queries and that too without closing command for first one (if that is what you mean by 'without closing the first one') while executing the second.

To me, it seems you would like to know if the name and email already exist in the database, if so are they taken by same person (found on the same record in db) or by different persons (found on different records).

You could achieve this by following one single query. You may get multiple records back and for every record the third column match_type will clarify the type.

select kullaniciAdi, [Mail Adresi], 'BOTH' as match_type from kullanicilar 
where kullaniciAdi = '<username text>' and [Mail Adresi] = '<mail address text>'
union 
select kullaniciAdi, [Mail Adresi], 'ONLY_USER' as match_type from kullanicilar 
where kullaniciAdi = '<username text>' and [Mail Adresi] <> '<mail address text>'
union
select kullaniciAdi, [Mail Adresi], 'ONLY_MAIL' as match_type from kullanicilar 
where kullaniciAdi <> '<username text>' and [Mail Adresi] = '<mail address text>'

Note Table and / or column names in query may have typos as it is error prone to type having looked at image.

share|improve this answer

answered Mar 24 at 0:33

GroGro

50549

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55318275%2fhow-to-read-2-commands-without-closing-the-first-one%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

// Check if username is taken
var command = new SqlCommand("SELECT * FROM YourTable WHERE userName=" userName , 
yourConnection);
var reader = command.ExecuteReader();

// Check if email is taken
var command = new SqlCommand("SELECT * FROM YourTable WHERE email=" email, 
yourConnection)
command.ExecuteNonQuery();

share|improve this answer

answered Mar 23 at 21:01

Nestor EduardoNestor Eduardo

11

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i am doing it in if else statement block so this doesnt help
  
  – mryellow61
  Mar 24 at 11:32
  
  

  
  
  
  

add a comment | 

0

// Check if username is taken
var command = new SqlCommand("SELECT * FROM YourTable WHERE userName=" userName , 
yourConnection);
var reader = command.ExecuteReader();

// Check if email is taken
var command = new SqlCommand("SELECT * FROM YourTable WHERE email=" email, 
yourConnection)
command.ExecuteNonQuery();

share|improve this answer

answered Mar 23 at 21:01

Nestor EduardoNestor Eduardo

11

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i am doing it in if else statement block so this doesnt help
  
  – mryellow61
  Mar 24 at 11:32
  
  

  
  
  
  

add a comment | 

// Check if username is taken
var command = new SqlCommand("SELECT * FROM YourTable WHERE userName=" userName , 
yourConnection);
var reader = command.ExecuteReader();

// Check if email is taken
var command = new SqlCommand("SELECT * FROM YourTable WHERE email=" email, 
yourConnection)
command.ExecuteNonQuery();

share|improve this answer

answered Mar 23 at 21:01

Nestor EduardoNestor Eduardo

11

// Check if username is taken
var command = new SqlCommand("SELECT * FROM YourTable WHERE userName=" userName , 
yourConnection);
var reader = command.ExecuteReader();

// Check if email is taken
var command = new SqlCommand("SELECT * FROM YourTable WHERE email=" email, 
yourConnection)
command.ExecuteNonQuery();

share|improve this answer

answered Mar 23 at 21:01

Nestor EduardoNestor Eduardo

11

answered Mar 23 at 21:01

Nestor EduardoNestor Eduardo

11

answered Mar 23 at 21:01

Nestor EduardoNestor Eduardo

11

0

Firstly, I am not sure why are you insisting on having to find the result in two separate queries and that too without closing command for first one (if that is what you mean by 'without closing the first one') while executing the second.

To me, it seems you would like to know if the name and email already exist in the database, if so are they taken by same person (found on the same record in db) or by different persons (found on different records).

You could achieve this by following one single query. You may get multiple records back and for every record the third column match_type will clarify the type.

select kullaniciAdi, [Mail Adresi], 'BOTH' as match_type from kullanicilar 
where kullaniciAdi = '<username text>' and [Mail Adresi] = '<mail address text>'
union 
select kullaniciAdi, [Mail Adresi], 'ONLY_USER' as match_type from kullanicilar 
where kullaniciAdi = '<username text>' and [Mail Adresi] <> '<mail address text>'
union
select kullaniciAdi, [Mail Adresi], 'ONLY_MAIL' as match_type from kullanicilar 
where kullaniciAdi <> '<username text>' and [Mail Adresi] = '<mail address text>'

Note Table and / or column names in query may have typos as it is error prone to type having looked at image.

share|improve this answer

answered Mar 24 at 0:33

GroGro

50549

add a comment | 

0

Firstly, I am not sure why are you insisting on having to find the result in two separate queries and that too without closing command for first one (if that is what you mean by 'without closing the first one') while executing the second.

To me, it seems you would like to know if the name and email already exist in the database, if so are they taken by same person (found on the same record in db) or by different persons (found on different records).

You could achieve this by following one single query. You may get multiple records back and for every record the third column match_type will clarify the type.

select kullaniciAdi, [Mail Adresi], 'BOTH' as match_type from kullanicilar 
where kullaniciAdi = '<username text>' and [Mail Adresi] = '<mail address text>'
union 
select kullaniciAdi, [Mail Adresi], 'ONLY_USER' as match_type from kullanicilar 
where kullaniciAdi = '<username text>' and [Mail Adresi] <> '<mail address text>'
union
select kullaniciAdi, [Mail Adresi], 'ONLY_MAIL' as match_type from kullanicilar 
where kullaniciAdi <> '<username text>' and [Mail Adresi] = '<mail address text>'

Note Table and / or column names in query may have typos as it is error prone to type having looked at image.

share|improve this answer

answered Mar 24 at 0:33

GroGro

50549

add a comment | 

Firstly, I am not sure why are you insisting on having to find the result in two separate queries and that too without closing command for first one (if that is what you mean by 'without closing the first one') while executing the second.

To me, it seems you would like to know if the name and email already exist in the database, if so are they taken by same person (found on the same record in db) or by different persons (found on different records).

You could achieve this by following one single query. You may get multiple records back and for every record the third column match_type will clarify the type.

select kullaniciAdi, [Mail Adresi], 'BOTH' as match_type from kullanicilar 
where kullaniciAdi = '<username text>' and [Mail Adresi] = '<mail address text>'
union 
select kullaniciAdi, [Mail Adresi], 'ONLY_USER' as match_type from kullanicilar 
where kullaniciAdi = '<username text>' and [Mail Adresi] <> '<mail address text>'
union
select kullaniciAdi, [Mail Adresi], 'ONLY_MAIL' as match_type from kullanicilar 
where kullaniciAdi <> '<username text>' and [Mail Adresi] = '<mail address text>'

Note Table and / or column names in query may have typos as it is error prone to type having looked at image.

share|improve this answer

answered Mar 24 at 0:33

GroGro

50549

select kullaniciAdi, [Mail Adresi], 'BOTH' as match_type from kullanicilar 
where kullaniciAdi = '<username text>' and [Mail Adresi] = '<mail address text>'
union 
select kullaniciAdi, [Mail Adresi], 'ONLY_USER' as match_type from kullanicilar 
where kullaniciAdi = '<username text>' and [Mail Adresi] <> '<mail address text>'
union
select kullaniciAdi, [Mail Adresi], 'ONLY_MAIL' as match_type from kullanicilar 
where kullaniciAdi <> '<username text>' and [Mail Adresi] = '<mail address text>'

share|improve this answer

answered Mar 24 at 0:33

GroGro

50549

answered Mar 24 at 0:33

GroGro

50549

answered Mar 24 at 0:33

GroGro

50549