Click here to Skip to main content
15,884,298 members
Home / Discussions / ASP.NET
   

ASP.NET

 
Questionuser authentication in asp.net Pin
Member 829494421-Oct-11 0:24
Member 829494421-Oct-11 0:24 
AnswerRe: user authentication in asp.net Pin
JacquesDP25-Oct-11 10:49
JacquesDP25-Oct-11 10:49 
QuestionInvalid postback or callback argument Pin
Amit Spadez20-Oct-11 20:37
professionalAmit Spadez20-Oct-11 20:37 
AnswerRe: Invalid postback or callback argument Pin
jkirkerx28-Oct-11 20:18
professionaljkirkerx28-Oct-11 20:18 
Questionpass values to 2010 control Pin
dcof20-Oct-11 12:19
dcof20-Oct-11 12:19 
AnswerRe: pass values to 2010 control Pin
Ibrahim Hebish22-Oct-11 2:45
Ibrahim Hebish22-Oct-11 2:45 
GeneralRe: pass values to 2010 control Pin
umeshdwivedi kanpur23-Oct-11 4:55
umeshdwivedi kanpur23-Oct-11 4:55 
GeneralRe: pass values to 2010 control Pin
Ibrahim Hebish23-Oct-11 23:07
Ibrahim Hebish23-Oct-11 23:07 
C#
DBConnection.ExecuteQuery("select p.Hnumber from dbo.Org o inner join Pl p on o.OrganizationID =p.OrganizationID where OrganizationName='orgname1'") 



you can make it like that :

C#
// You Can take a value from any control
// (textbox, dropDownList,.... , etc.)

string organizationName=_organizationNameTextBox.Text;


VB
string query="select p.Hnumber from dbo.Org o inner join Pl p on
              o.OrganizationID =p.OrganizationID where
               OrganizationName='"+organizationName+"'";


C#
DBConnection.ExecuteQuery(query) 


so you can pass any value to the "Where" Clause (it is simple way).


or
you can make a Stored-Procedure that makes the same Query &
takes a parameter for the Where clause and this is the (recommended solution).
Sincerely,

Ibrahim Hebeish | SoftwareDeveloper | Portal Services | EgyptNetwork(Com)
M: +201281744594
Email: i.hebeish@egyptnetwork.com

QuestionSend pdfs directly tro printer. Pin
vanikanc20-Oct-11 9:16
vanikanc20-Oct-11 9:16 
AnswerRe: Send pdfs directly tro printer. Pin
Richard MacCutchan20-Oct-11 21:31
mveRichard MacCutchan20-Oct-11 21:31 
QuestionJavascript Function not working in asp.net page Pin
Cyber_guY20-Oct-11 5:13
Cyber_guY20-Oct-11 5:13 
AnswerRe: Javascript Function not working in asp.net page Pin
Dennis E White20-Oct-11 5:53
professionalDennis E White20-Oct-11 5:53 
GeneralRe: Javascript Function not working in asp.net page Pin
Cyber_guY20-Oct-11 23:57
Cyber_guY20-Oct-11 23:57 
QuestionHuman Testing Pin
#realJSOP20-Oct-11 3:27
mve#realJSOP20-Oct-11 3:27 
AnswerRe: Human Testing Pin
jesarg20-Oct-11 5:29
jesarg20-Oct-11 5:29 
GeneralRe: Human Testing Pin
#realJSOP20-Oct-11 7:43
mve#realJSOP20-Oct-11 7:43 
GeneralRe: Human Testing Pin
jesarg20-Oct-11 8:19
jesarg20-Oct-11 8:19 
GeneralRe: Human Testing Pin
#realJSOP20-Oct-11 10:13
mve#realJSOP20-Oct-11 10:13 
GeneralRe: Human Testing Pin
jesarg20-Oct-11 10:59
jesarg20-Oct-11 10:59 
GeneralRe: Human Testing Pin
#realJSOP20-Oct-11 12:15
mve#realJSOP20-Oct-11 12:15 
QuestionMembership.ValidateUser port to user tables Pin
nitin_ion19-Oct-11 19:19
nitin_ion19-Oct-11 19:19 
AnswerRe: Membership.ValidateUser port to user tables Pin
Brij19-Oct-11 20:13
mentorBrij19-Oct-11 20:13 
AnswerRe: Membership.ValidateUser port to user tables Pin
rajendra pratap singh20-Oct-11 1:05
rajendra pratap singh20-Oct-11 1:05 
Questionasp.net web table problem Pin
classy_dog19-Oct-11 11:11
classy_dog19-Oct-11 11:11 
AnswerRe: asp.net web table problem Pin
Brij19-Oct-11 19:55
mentorBrij19-Oct-11 19:55 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.