|
Hi,
try this way...
SET @num_of_user = SELECT COUNT(*) FROM tb_user
WHERE useremail = @username AND userpassword = @password)
RETURN @num_of_user
Kiran Kumar.CH
(MCP)
|
|
|
|
|
Hi Kumar,
I'd tried, but the result is still the same, it returns the same value no matter what I type my username and password are.
J Liang
|
|
|
|
|
CREATE PROCEDURE IsValidLogin<br />
(<br />
@username varchar(15) = NULL,<br />
@password varchar(12) = NULL ,<br />
@num_of_user INT = 0 --This means that it's an input parameter<br />
)<br />
Try
CREATE PROCEDURE IsValidLogin
(
@username varchar(15) = NULL,
@password varchar(12) = NULL ,
@num_of_user INT = 0 OUTPUT
)
--Your SET statement here
--No need for a RETURN statement
(OR)
In your C# code
int retVal;<br />
retVal = myCommand.ExecuteNonQuery();
Remember:
If you want any custom output from your SP, use an OUTPUT parameter. By default an SP returns 0 if it was successful and non-zero in case of failure. This must be used exclusively for error checking.
SG
|
|
|
|
|
Hi i_like_tintin,
I tried your way and the retVal keep on returning -1 value. So I tried to display the objParam3.Value which I declare as objParam3.Direction = ParameterDirection.Output; and it return '0' to me no matter my username and password are correct.
|
|
|
|
|
Execute your SP in Query Analyzer and check if it works without errors for different sets of input.
SG
|
|
|
|
|
Hi using place holder & literal control,i created textbox in runtime...,
That code is:
In page load event:
Dim intcount As Integer
If Not IsPostBack Then
ViewState("BookFieldCount") = 1
ElseIf viewstate("BookFieldCount") > 1 Then
For intcount = 2 To viewstate("BookFieldCount")
addbookfield(intcount)
Next
End If
And in button click event:
viewstate("BookFieldCount") += 1
addbookfield(viewstate("bookfieldcount"))
and in "addbookfield" call procedure:
Sub addbookfield(ByVal strfieldnum As String)
Dim litlabel As LiteralControl
Dim txttextbox As TextBox
litlabel = New LiteralControl
litlabel.Text = "
Mark " & strfieldnum & ":"
plhbookfields.Controls.Add(litlabel)
txttextbox = New TextBox
txttextbox.ID = "txtproduct" & strfieldnum
plhbookfields.Controls.Add(txttextbox)
End Sub
After this code
if click the button u will get runtime textbox in ur screen...,
Now my ques is:
In runtime textbox if i enter values, how to add those values to my database?,
Normally with the id of the textbox we can add the values to tables...,
But in runtime textbox where we will get the id and how to add those values to my tables...,
Plz help me...
Magi
|
|
|
|
|
Hi,
When we are creating text box at runtime.
We can use the the object the text box.
but here You used same object "txttextbox" so you can
use "FindControl" method and assign it to a textbox and retrieve the
value.
Magh_M wrote: txttextbox.ID = "txtproduct" & strfieldnum
here u are assigning id to text box.U can use this ID inside FindControl.
To succeed, we must first believe that we can.
Sherin Iranimose
|
|
|
|
|
If u dont mind plz explain some what more...,
How to do that?
Magi
|
|
|
|
|
Hi,
I dont know what control is ir "plhbookfields"
U can use
Dim MyText as TextBox = plhbookfields.FindControl("YourTextboxID")
Now you can access the value by using
MyText.Text
If there are many text box you should make a loop.
"YourTextboxID" is the ID you assigned to text box.
To succeed, we must first believe that we can.
Sherin Iranimose
|
|
|
|
|
ya that only me to finding here,
For Each SubGRD As PlaceHolder In plhbookfields.Controls
Dim t1 As TextBox = CType(SubGRD.FindControl("txttextbox"), TextBox)
next
ya i given like this but i am not getting properly...,
Magi
|
|
|
|
|
Hi,
Here txttextbox is not the id of text box.
txttextbox.ID = "txtproduct" & strfieldnum
You used the above code in your program to generate id.
So use the same mechanism to get id and fin the control.
To succeed, we must first believe that we can.
Sherin Iranimose
|
|
|
|
|
Then whats the id of the textbox??
Magi
|
|
|
|
|
When page is posting I think you can get that on posted values. Means using request.form["TextBoxId"] 
|
|
|
|
|
No i didnt get what ur trying to say?,
Plz hlp me...,
Magi
|
|
|
|
|
On page load try writing
Response.Write(Request.Form["YourTextBoxId"]))
If that is not working then try replacing textbox id to name
Last modified: 5mins after originally posted --
|
|
|
|
|
Hi i think u didnt get my probs clearly,
If i know the textbox id probs will be solve...,
See my code in previous msg,in place holder i create textbox at runtime...,
So we want to find first textbox id,
then if more than one textbox will be create in place holder we want to find each and every textbox id...,
Then with that id we can get the values from that textbox...,
So then its not big matter at all to store the database...,
Magi
|
|
|
|
|
Magh_M wrote: If i know the textbox id probs will be solve...,
See my code in previous msg,in place holder i create textbox at runtime...,
So we want to find first textbox id,
I think you know it.
Read your first post. In that you are creating textbox id
|
|
|
|
|
ya i am creating the textbox id...,
But i dont know how to get it..,
Becoz its in placeholder...,
And more than one textbox will be there how u can get each and every textbox id and those values?,
Magi
|
|
|
|
|
Dear all
i am using asp.net2.0, C# and sql2005.
I was trying gridview using templatefield to customize gridview.
My question is how to get selected dropdownlist item value that is used in gridview templatefield..say suppose gridview template populate countries and how to get programtically value of selected country.
thanks
regards
imran khan
|
|
|
|
|
For Each SubGRD As DataGridItem In DDList.Items
Dim Quant As dropdownlistbox = CType(SubGRD.FindControl("txtAddQty"), dropdownlistbox)
next
The DDList is the datagrid id name...,
Now what u have selected that value will be in that Quant variable ,
Magi
|
|
|
|
|
Hello all. Can anyone tell me why this works?
I dynamically create a bunch of Dropdownlists, and every time I do I add them by this.Controls.Add(), but I also add them to a Page.List<dropdownlist> that I made. This is all within Page_Load. I was trying to figure out a way to check the SelectedIndex of each list after Postback.
So after postback, all the dropdownlists stored in my List actually contain accurate SelectedIndex values. How can this be? My List only contains copies of my dropdownlist objects right? And I built the List before their view states should have been updated. Am I missing something?
So basically this works like I wanted, but I don't know why 
Thanks!
John
|
|
|
|
|
What is stored in your list is a pointer so it is not a copy but the actual object. So when the object is updated on the post back your pointer is pointed to the updated object.
To store a copy you would have to clone the dropdown and store the pointer to that.
Ben
|
|
|
|
|
Wow really? I'm confused then. What about this:
List<string> dinosaurs = new List<string>();
dinosaurs.Add("Tyrannosaurus")
Err, my point being that the list can't store a pointer to "Tyrannosaurus".
Thanks
John
|
|
|
|
|
There are some items that are stored directly by value. That would be the common types like Strings, int, etc. Any object will always be stored by reference which is a pointer.
Ben
|
|
|
|
|
Hi there,
I'm brand new to ASP.net...currently building my first data-driven site. I've created my database and successfully connected to it. When the data is displayed, however, all my html tags that are in the database record are written out rather than being interpretted as html. For example, I want "<br>" to produce a line break, but it just displays "<br>". Is this by design? I have some ColdFusion experience and CF does not behave in this manner. I expect the same would be true for ASP, but I haven't been able to find any information about it.
I'm connecting to a SQLExpress database on my local machine. I am using a details view to display the information...don't know if that matters. I'm also using a dataset currently, but a direct connection to the database yielded the same results. Here's the code:
<asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False"
DataKeyNames="Content_ID" DataSourceID="ObjectDataSource1" BorderWidth="0">
<Fields>
<asp:BoundField DataField="Content_ID" HeaderText="Content_ID" InsertVisible="False"
ReadOnly="True" SortExpression="Content_ID" Visible="False" />
<asp:BoundField DataField="Content_Title" HeaderText="Content_Title" ShowHeader="False"
SortExpression="Content_Title" ItemStyle-CssClass="mainhead" ItemStyle-VerticalAlign="Top" />
<asp:BoundField DataField="Content_Text" HeaderText="Content_Text" ShowHeader="False"
SortExpression="Content_Text" />
</Fields>
</asp:DetailsView>
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" DeleteMethod="Delete"
InsertMethod="Insert" OldValuesParameterFormatString="original_{0}" SelectMethod="GetData"
TypeName="GTGDataSetTableAdapters.ContentTableAdapter" UpdateMethod="Update">
<DeleteParameters>
<asp:Parameter Name="Original_Content_ID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="Content_Title" Type="String" />
<asp:Parameter Name="Content_Text" Type="String" />
<asp:Parameter Name="Original_Content_ID" Type="Int32" />
</UpdateParameters>
<SelectParameters>
<asp:Parameter DefaultValue="2" Name="Content_ID" Type="Int32" />
</SelectParameters>
<InsertParameters>
<asp:Parameter Name="Content_Title" Type="String" />
<asp:Parameter Name="Content_Text" Type="String" />
</InsertParameters>
</asp:ObjectDataSource>
Is there anyway of getting this to work the way I want? Thanks in advance for your help. It's much appreciated.
Scott
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
