|
How to call serverside function in JavaScript?
I am working on VS2008,ASP.NET,C#
|
|
|
|
|
This will get you started: Page Method[^]
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum
me, me, me
|
|
|
|
|
|
i have windows vista home edition & it is not supporting IIS 7.0....is there any other web server in which i can run my ASP pages??
|
|
|
|
|
Try Apache[^].
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum
me, me, me
|
|
|
|
|
Another alternative would be Cassini[^]
I are Troll
|
|
|
|
|
i try both servers but Browsers showing an error tht Failed to establish a Connection to the server...
i try many servers but itz not connecting....
it there any propeties which i have to set??
|
|
|
|
|
humais wrote: it there any propeties which i have to set??
No, shouldn't be required. You're connecting to localhost?
I are Troll
|
|
|
|
|
Yes i'm trying to connect with the local host but itz not connecting...
|
|
|
|
|
I can only guess at the problem at this point; Cassini won't install on this system. In theory you should be able to point your browser to 127.0.0.1 and at least serve some HTML files.
Is the Cassini-application running and visible in the system tray?
I are Troll
|
|
|
|
|
|
Hi folks,
I've created custom Membership provider and Role provider. Membership provider is working perfect but role provider is not working.
The error "The ConnectionString property has not been initialized" is thrown and line of error is shown in Web.config file like below:
<roleManager enabled="true" cacheRolesInCookie="true" defaultProvider="MyRoleProvider">
<providers>
Error is shown in the following line>>
<big><add name="MyRoleProvider" connectionStringName="MWXConnectionString" applicationName="MyApp" type="Company.Providers.Roles.MyRoleProvider, Company.Providers"/></big>
</providers>
</roleManager>
I tried to change the value of TYPE attribute to check if my assembly is working. When I change the value error comes to say "Cant load the assembly....", which indicates that TYPE attribute is correct.
I tried to debug and inserted break point in Initialize method, but its never called, hence cant break on the code.
NOTE: SAME CONNECTION STRING(NAME) IS WORKING FOR Membership provider AND PROVIDER PROJECT IS IN SAME SOLUTION AND WEBSITE PROJECT AND WEB PROJECT HAS REFERENCE TO THE PROVIDER PROJECT
Now I am confused, where is (which line causes) error. Anybody can tell me the reason or at least how to debug and reach the Initialize method??
Regards
Aftab Sindhi
.NET Application Developer
U.A.E
modified on Saturday, July 10, 2010 12:54 PM
|
|
|
|
|
Hi,
I am working on a simple user registration form in ASP.NET using C#.
I created a check for “UserID”, when user will click “Submit” button then my logic will check into database for UserID “Already Exist in database or not”
I tried this same login on “User ID” Textbox (textchange event), but it is not working , please let me know where to write this code for TextBox .
THanks
|
|
|
|
|
Hiiii Sr...Frank
Here is an Explanation for your problem.
Here is ur ui how it looks like.
FirstName : Text-Box
LastName : Text-Box
UserID : Text-Box
Email ID : Text-Box
Password : Text-Box
now whenever u press the button Submit take all the values of the textboxes and pass it as ur input parameters to ur stored procedure and write down the following query in ur Stored Procedure.
If Exist(select UserID from Users where UserID = @UserID)
BEGIN
SET @ErrorNo = 101
SET @ErrorMsg = "User ID already Exists"
return ;
END
Note : Here @ErrorNo and @ErrorMsg are local variables created in Stored Procedure.
|
|
|
|
|
|
1: No one will 'send' you any code.
2: DO NOT PUT YOUR EMAIL IN A POST: no one will use it except spammers: good luck with that.
Okay, the purpose of these forums is to help with a specific problem you find after having tried to solve the problem on your own: it is not here to supply you with a complete application. So, what have you tried? Where did you get stuck? What have you already done to address the issue?
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum
me, me, me
|
|
|
|
|
disabled buttons look enabled in firefox and chrome. i opened the same page in ie, firefox, chrome and this is the output
http://i48.tinypic.com/2f0a81t.jpg[^]
"DashBoard" and "Calendar" are disabled
"Agent Info" is enabled.
here im using normal asp buttons with css
what do i do?
|
|
|
|
|
Hiii sriharsha2410
Here is the solution for your problem...
Do one thing whenever you disable button apply a CSS to that button named "cssDisable" and in that css change the color of the button or background of the same button.
And Whenever you Enable that button apply another CSS to that buton named "cssEnable" and in that css change the color of the button or background of the same button as u want when it is enabled.
Thank you.
|
|
|
|
|
Hi folks,
I'm building a Data Access Layer that connects to an Oracle 9i db. Most of the SELECT queries with = parameters work fine, for example:
SELECT * EMAIL_ADDRESS, EMPLOYEE_NUMBER WHERE SURNAME = :sname
However, I need to carry out a filtered search using the LIKE clause and can't get it to work. Here is what I've for:
SELECT EMAIL_ADDRESS, EMPLOYEE_NUMBER, FIRST_FORENAME FROM [table name] WHERE (SURNAME LIKE '%:sname%')
This does not work, as the paramter gets lost within the '' and the value is treated purely as %:sname%
I've looked around the internet for clues and as yet have found nothing on the correct sytnax. Surely I'm not the first person to have to carry out a LIKE search on an Oracle db using a data set?
Can anyone help? Is there an alternative method that I can use?
Many Thanks,
Alan R
|
|
|
|
|
Been a few years since I worked with Orakle but it can't be that diferent to a proper database.
Try:
where [column] like '%' + :sname + '%'
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum
me, me, me
|
|
|
|
|
Thanks for your help, its very similar to what actually works:
WHERE (SURNAME LIKE '%' || :sname || '%')
Difference in the concatination.
Many thanks,
Alan
|
|
|
|
|
Ah yes, of course: forgot that the concatenation operators are a trifle bizarre in Orakle.
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum
me, me, me
|
|
|
|
|
hi,
i m facing problem in gridview updating. I m using sqldatasource to select and update the record.
In select of sqldatasource i m passing three parameter and in update i m passing 4 parameter. when i run my program, the select in sqldatasource works perfect. but when i update that record...its throws error...
" Function or stored procedure has too many arguments passed". Even though i m getting this error and my page crashes...i m still able to update the record, this i noticed when i stop the program after webpage crash and then run the program again. but i dont want my webpage to crash.
Here is my ASPX file code...
<asp:GridView ID="pattestsGridView" runat="server" CellPadding="2" GridLines="Vertical"
AutoGenerateColumns="False" BorderColor="#DEDFDE" BorderStyle="None" BorderWidth="1px"
ForeColor="Black" Width="100%" AutoGenerateSelectButton="True" Font-Size="Small"
AutoGenerateEditButton="True" OnRowUpdating="RowUpdating" DataSourceID="SqlDataSource1"
AllowPaging="True" AllowSorting="True">
<RowStyle BackColor="#EFF3FB" />
<Columns>
<asp:TemplateField HeaderText="SEND TEST" SortExpression="send_test">
<EditItemTemplate>
<asp:TextBox ID="sendtesttb" runat="server" Text='<%# Bind("send_test") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="sendtestlb" runat="server" Text='<%# Eval("send_test") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="PATIENT ID" SortExpression="PATIENT ID">
<ItemTemplate>
<asp:Label ID="patidlb" runat="server" Text='<%# Eval("[PATIENT ID]") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="TEST ID" SortExpression="TEST ID">
<ItemTemplate>
<asp:Label ID="testidlb" runat="server" Text='<%# Eval("[TEST ID]") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="TEST NAME" SortExpression="TEST NAME">
<ItemTemplate>
<asp:Label ID="testnamelb" runat="server" Text='<%# Eval("[TEST NAME]") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="PRIORITY" SortExpression="PRIORITY">
<ItemTemplate>
<asp:Label ID="prioritylb" runat="server" Text='<%# Eval("PRIORITY") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="DATE" SortExpression="DATE">
<ItemTemplate>
<asp:Label ID="dtlb" runat="server" Text='<%# Eval("DATE") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<FooterStyle BackColor="#CCCC99" />
<SelectedRowStyle BackColor="#CE5D5A" Font-Bold="false" ForeColor="White" />
<PagerStyle BackColor="#F7F7DE" ForeColor="Black" HorizontalAlign="Right" />
<HeaderStyle BackColor="#6B696B" Font-Bold="True" ForeColor="White" Font-Size="Medium" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
</div>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" SelectCommand="PatTestReqSelect;1"
SelectCommandType="StoredProcedure" UpdateCommand="PatTestReqUpdate;1"
UpdateCommandType="StoredProcedure" >
<SelectParameters>
<asp:Parameter Name="PatID" Type="String" />
<asp:Parameter Name="EmpID" Type="String" />
<asp:Parameter Name="Date" Type="Datetime" />
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="SendTest" Type="String" />
<asp:Parameter Name="PatID" type="String"/>
<asp:Parameter Name="TestID" Type="String" />
<asp:Parameter Name="Date" Type="DateTime" />
</UpdateParameters>
</asp:SqlDataSource>
Here is my VB.net code...
Private Sub searchbtn_Click(ByVal sender As Object, ByVal e As EventArgs) Handles searchbtn.Click
'################## FOR CONNECTION ################
Dim MySearchCon As DbConnection = providerFactory.CreateConnection()
MySearchCon.ConnectionString = connectionString.ConnectionString
'################### END OF CONNECTION ################
Dim sqlcmd As New SqlCommand
Dim adptr As New SqlDataAdapter
Dim ds As New DataSet
Dim strdt As String = Request.QueryString("dt")
Dim s As String = Me.pattestpatidtb.Text
Dim s1 As String = Me.refdocidtb.Text
If Me.pattestpatidtb.Text <> "" And Me.refdocidtb.Text <> "" Then
SqlDataSource1.SelectParameters("PatID").DefaultValue = UCase(pattestpatidtb.Text)
SqlDataSource1.SelectParameters("EmpID").DefaultValue = UCase(refdocidtb.Text)
If Request.QueryString("Date") <> "" Then
SqlDataSource1.SelectParameters("Date").DefaultValue = Request.QueryString("Date")
Else
SqlDataSource1.SelectParameters("Date").DefaultValue = DateTime.Now.ToString("yyyy-mm-dd hh:mm:ss")
End If
End If
End Sub
Protected Sub RowUpdating(ByVal sender As Object, ByVal e As EventArgs) Handles pattestsGridView.RowUpdating
'################## FOR CONNECTION ################
Dim MySearchCon As DbConnection = providerFactory.CreateConnection()
MySearchCon.ConnectionString = connectionString.ConnectionString
'################### END OF CONNECTION ################
Dim sqlcmd As New SqlCommand
Dim adptr As New SqlDataAdapter
Dim ds As New DataSet
If pattestsGridView.SelectedIndex < 0 Then
MsgBox("Please selected the record to update and then proceed.", MsgBoxStyle.Critical)
Exit Sub
End If
Dim uppatid As Label = pattestsGridView.SelectedRow.FindControl("patidlb")
Dim uptestid As Label = pattestsGridView.SelectedRow.FindControl("testidlb")
Dim updtlb As Label = pattestsGridView.SelectedRow.FindControl("dtlb")
Dim upsendtest As TextBox = pattestsGridView.SelectedRow.FindControl("sendtesttb")
MsgBox("Record successfully updated.", MsgBoxStyle.Information)
Dim dtlb As Date = updtlb.Text
Dim dttime As String = String.Empty
dttime = dtlb.ToString
Dim strst As String = Nothing
strst = UCase(upsendtest.Text)
If Not strst.Equals("Y") Then
If Not strst.Equals("N") Then
MsgBox("Please enter either 'Y' or 'N'.", MsgBoxStyle.Critical)
Exit Sub
End If
Else
'Exit Sub
End If
Dim updatecmd As New SqlCommand
//tried this too
'SqlDataSource1.UpdateParameters.Clear()
'SqlDataSource1.UpdateParameters.Add("SendTest", UCase(upsendtest.Text)).ToString()
'SqlDataSource1.UpdateParameters.Add("TestID", UCase(uptestid.Text)).ToString()
'SqlDataSource1.UpdateParameters.Add("PatID", UCase(uppatid.Text)).ToString()
'SqlDataSource1.UpdateParameters.Add("Date", UCase(updtlb.Text)).ToString()
SqlDataSource1.UpdateParameters("SendTest").DefaultValue = UCase(upsendtest.Text)
SqlDataSource1.UpdateParameters("PatID").DefaultValue = UCase(uppatid.Text)
SqlDataSource1.UpdateParameters("TestID").DefaultValue = UCase(uptestid.Text)
SqlDataSource1.UpdateParameters("Date").DefaultValue = dttime
SqlDataSource1.Update()
End Sub
My stored Procedure for select statement
CREATE PROCEDURE [dbo].[PatTestReqSelect]
@PatID nvarchar(16),
@EmpID nvarchar(16),
@Date datetime
AS
BEGIN
SET NOCOUNT ON;
SELECT SchedListTable.send_test,SchedListTable.pat_id AS [PATIENT ID],SchedListTable.test_id
AS [TEST ID],TestName.test_name AS [TEST NAME],SchedListTable.prior_lev AS [PRIORITY],
SchedListTable.dt AS [DATE]
FROM SchedListTable INNER JOIN TestName ON SchedListTable.test_id=TestName.test_id
WHERE pat_id=@PatID AND emp_id=@EmpID AND SchedListTable.dt=@Date
ORDER BY SchedListTable.dt DESC
END
My stored procedure for Updating the record
CREATE PROCEDURE [dbo].[PatTestReqUpdate]
@SendTest nvarchar(1),
@PatID nvarchar(16),
@TestID nvarchar(8),
@Date datetime
AS
SET NOCOUNT ON
BEGIN
UPDATE SchedListTable SET send_test=@SendTest
WHERE
pat_id=@PatID AND test_id=@TestID AND dt=@Date
END
modified on Wednesday, July 7, 2010 5:08 AM
|
|
|
|
|
Way too much code: you need to cut it down so that only the pertinent fragments are here. If anyone that answers needs more they'll ask.
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum
me, me, me
|
|
|
|
|
hi mominafiz,
can you post complete code of <asp:sqldatasource>
so that it is clearer to understand why your page is crashing?
HTH
Jinal Desai - LIVE
Experience is mother of sage....
|
|
|
|