I have an update statement here:
id is a long auto-increment integer.
UPDATE [table1] SET [icon] = Str([id]) & @file_ext where
id=@id;
after I execute this statement, there is a space in my access, such as " 1.jpg"
So I decide to hard-code the id:
UPDATE [table1] SET [icon] = '1' & @file_ext where id=@id;
It's work! the result is "1.jpg"
Is there sth wrong in my code? Thx!
I want to use sum function in access database (not MS SQL) to add array of items in a particular date.For Eg. The Access Database format like
Date
Prod. Name
Value
[code]...
I have a function called Public Shared Function get_userDB() As String in my MastePage.master.vb file that i would like to access from my users page that is connected to the master page.
I have tried with: me.master.get_userDB()
But that won't work. It says that my function is not a member of my masterpage. What im i doing wrong?
I want to set ASP.net custom validator error parameter text through client side javascript. How can access it via sender, args parameters in my function?
View 1 RepliesI am trying to create a chat application like Facebook
My chat windows are in the footer control of the website, and C# code also in footer's CS file, i need to call C# function from footer CS file into javascript included in my footer.aspx file,
i have tried it by ICallbackEventHandler, but WebForm_DoCallback(this,arg,RecieveMessage,"",null,false); simply postback my current page, but i need to postback footer.aspx only and call "public void RaiseCallbackEvent(String eventArgument)".
I have two functions (function1 and function2) in a javascript file called javaTest1.js
I am trying to link the javaTest1.js file so that I can directly call the functions in the javaTest file to my content page and Master page.
I have done the following in the header section of the Master Page
[Code]....
How do I now access the function in codebehind and javascript of both the Content Page and the Master page?
I have an access MDB database of latitude and longitude coordinates (x,y). I also have a function in VB similar to:
Public Function Distance (x1,y1,x2,y2) as Double
'Some code here
Distance = 'distance between x1,y1 and x2,y2
End Function
What I want to do is create a query that will show all locations contained in the table that are within 10 miles of user unetered coordinates (where LAT and LON are columns in the table and VarX and VarY are user proivided: SELECT *, Distance([LAT],[LON],VarX,VarY) as Dist FROM TableName WHERE Dist < 10
Obviously this doesn't work but I want to know how to accomplish this end result. Basically, I want to return a query of all locations within 10 miles of VarX and VarY. How do I incororate the Distance function into my query?
If it's not possible, what is the best workaround to accomplish this?
Using ASP.NET Visual Basic and a MS Access MDB
I have in my Models folder a Class named "Utilities".
I need to acces one method of that class inside a view, like <%if(IsASelectedCategory(item.categoryId, item.productId))%>
I am working on my company intranet and trying to integrate it with our existing MS Access applications.
I need to provide the ability to have the client click on a link/button from an aspx page and have it call a function in the MS access application to look up the corresponding record.
I came accross the thread [URL] but that is not really what I want as the ADP application will already be running on the client I just need to pass it a value.
Alternitively if I could start a new instance of the ADP passing it a parameter on open to find the correct record that would be a compromise.
how can i access a public function in an .ascx file using C#?
View 3 Repliesi have 2 aspx files . I need to access a public function in b.aspx from a.aspx. How can i do that in asp.net using C#
My function from a.aspx is the following:
<script language="C#" runat="server">
public String user()
{
return l1.Text;
}
</script>
In my application if I get an exception I catch it and send stackTrace through email. I also need the values of parameters passed to this function. I can get the names of function and parameters using MethodBase class of System.Reflection.
View 7 RepliesI need accessing the function in my masterpage.
I have a.master and b.aspx with the content page.
Now in the page load of my content page, I want to execute the an sql query which is in a function in my master page.
How can I access the function in my master page?
code in my master page:
public function info () as string
'SQL Query
end function
I have WCF method that opens and reads text file when I call it from WPF client, I do pass security credentials and it works fine, but when I try to put this method inside of BackgroundWorker I get Access to the path.
View 1 RepliesI have some ajax fucntions on my default.aspx that I use for saving data to my db. I have the form on my web control. When I try calling the function from my button which resides on the web control. I get an error.
I need to call that function from my registerform.ascx. How do I do that from within the registerform code behind?
function ShowAvailability() {
$.ajax({
type: "POST",
url: "Default.aspx/CheckEmail",
data: '{usermail: "' + $("#<%=subs_email.ClientID%>")[0].value + '" }',
contentType: "application/json; charset=utf-8",
dataType: "json",
success: OnSuccess,
failure: function(response) {
alert(response);
}
});
I have written the following functions(1 & 2) in a class file(say abc.vb) to execute a sql statement in code behind.
[Code]....
I have functions in a Master Page that I want to access in content pages. How do I do that?
View 9 RepliesI'm looking to write some script that checks that: The current user of whom is logged in has the correct authority credentials. NB: Script in C# before I continue. To give a bit more background. The SQL DB Table for AdminUsers has a field 'Authority' this is linked to another table (Authority) which has the values/different levels of authority in them. Thus, if aN admin user whose Authority level is just listed as 'user', for example, in the database and wants to edit information that requires 'Supeuser' authority level - it cannot be performed and is redirected to another page. In detail, my particular page, the operation is being done via a ASP Button within a ASP Repeater. Of each record that occurs there is the button that, once pressed, updates the field in the database (in this case for a Guestbook table which has a 'Moderated' field of 'bit/bool' data type, changing it from false to true (or 0/1)). To allow that entry to be displayed on the front-end for public viewing. All this can onyl happen on the basis of, as previously stated, their authority is of the appropriate level. Here is what my attempt was. The outcome of which simply redirects to the 'Unauthorised' page, despite the user logged in having the correct authority credentials.
ASP - GuestbookMod.aspx:
[Code]....
C# - GuestbookMod.aspx:
[Code]....
LINQ to SQL - Guestbook.cs 'Mod' Method:
[Code]....
I have designded a asp.net server control that have an embeded javascript file.
document.getElementById("div_Messages_Back").style.left = 0;
document.getElementById("div_Messages_Back").style.top = 0;
document.getElementById("div_Messages_Back").style.width = document.documentElement.clientWidth;
document.getElementById("div_Messages_Back").style.height = document.documentElement.clientHeight;
document.getElementById("tbl_Messages").style.left = (document.documentElement.clientWidth - 250) / 2;
document.getElementById("tbl_Messages").style.top = (document.documentElement.clientHeight - 120) / 2;
function btn_Close() {
document.getElementById("div_Messages_Back").style.visibility = "collapse";
document.getElementById("tbl_Messages").style.visibility = "collapse";
}
I want the first 6 line of my javascript file run at runtime. But I recieve error at runtime:
Error: Object Required.
I have a dropdown box in master and i would like to execute the content page function when user select any value from dropdown box.
View 1 RepliesI have a.master and b.aspx .
i have some functions in my aspx page.
how to access that functions in a.master page.
I have this import function which can be changed by the client in his desired way.Now I want to code such that if the client tries to import his own data on the page and doesnot give the tags in the order mentioned below his import function should be stopped.
It shouldn't make any changes unless the tags are in the right format because the problem now is if the tags are not in the right format when client changes then its importing over the existing files and directing to an error page which I dont want it should simply stop the import function if they are nt in the order.the code for this function is below
[code]....
i followed this link [URL] and i get selected value from dropdownlist using jquery
i created 3 partial views .
i need depend's on dropdownvalue redirect to partial page , so how can i implement in jquery with conditions?? or how can i implement in this function Public Function FetchData(ByVal dropdownValue As String) As ActionResult??
I would like to write a function to reuse some functionality that I repeat over and over...
For example:
[code]....
What's changing, in every field, is only the lambda function to get the current field to edit (Name, City, Address, etc...).
What is the best method? Or better: is there ANY method to extract a generic function?
<asp:LinkButton CssClass="button" ID="btnApply" runat="server" OnClick="btnApply_Click()" OnClientClick="Apply1('btnApply')" >
hi ihave this functin in .vb file
Protected Sub btnApply_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnApply.Click
end sub
and javascript function also in aspx
function ApplySummerization(id)
{
alert("hai");
}