I have an sql connection in all pages of my web application project.I had used this line of code in each page for connection,
SqlConnection con = new SqlConnection("Data Source=servername;Initial Catalog=dbname;Integrated Security=True");
I want to reduce my code..I have the same connection in all of my pages..How can I create a class for sqlconnnection?..and how can I call the connection from each of my page?
how to jquery call a other call function other class is not static
[WebMethod]
public static bool Verify(string username, string password)
//Do your logic with username, password here
//I am just checking with admin/admin credentials
Console.WriteLine("Ritu");
[code]...
I have a WindowsForm that has a DataGridView that shows output of my app. The class with the button is DriveRecursion_Results.cs. I want it so that once the button is pushed by the user, my method FileCleanUp() in my SanitizeFileNames class is called. I'm not quite sure how to do this though.Here is the code for both classes:
public partial class DriveRecursion_Results : Form
public DriveRecursion_Results()
InitializeComponent();
private void listView1_SelectedIndexChanged(object sender, EventArgs e)
[code]...
I am beginner in web applications development. I started one little project and host it on source forge "https://homoco.svn.sourceforge.net/svnroot/homoco". And I started implementing authentication in this application to learn how it works. From my experience people never use out of the box things so I want to implement this stuff alone (like in real world projects). So some questions:
1) Is there any reason to use membership out of the box? To use database table schema, stored procedures etc. that tool generate for developer. I think that this lower control over code and I decided to implement it my self. I don't know if I am right.
2) Is my approach in this demo project good or bad (if someone have time I like to do just a little code review)? I created database based on business rules. Not using database schema that membership provider require. Extend "MembershipProvider" class to satisfy my needs. Implement queries to database myself.
3) Now, this question is a little wired but I have to ask it. If we make custom Membership Provider and do sql queries alone, implement all MembershipProvider class methods ourselves, and in application use Membership.blabla() why is this approach different from not extending MembershipProvider class and putting all this methods in some unique class and call its methods then? I hope that someone understand what I ask here.
I am sorry for three questions, but I really trying to find the best way to implement this feature in my demo project like it is a real world application.
I am trying to create the following stored procedure in sql server Lat and Lng are the parameters being passed from c# code behind .But I am not able to create this stored procedureit indicates with error saying undefined column name Lat,Lng
CREATE FUNCTION spherical_distance(@a float, @b float, @c float)
RETURNS float
AS
BEGIN
RETURN ( 6371 * ACOS( COS( (@a/@b) ) * COS( (Lat/@b) ) * COS( ( Lng/@b ) - (@c/@b) ) + SIN( @a/@b ) * SIN( Lat/@b ) ) )
END
sqlda.SelectCommand.CommandText = "select *, spherical_distance( Lat, 57.2958, Lng) as distance
from business
[code]...
To be able to implement paging i need to create a helper class (as mentioned on one example in the net ); so i have created a class that encapsulate the paging logic
public class PagingList<T> : List<T>
.
..
but when i reference this class in my view using the code below:-
Models.PagingList<Article>
The following error occurred. Server Error in '/' Application. Compilation Error Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. Compiler Error Message: CS0246: The type or namespace name 'Article' could not be found (are you missing a using directive or an assembly reference?) Source Error:
[Code]....
Source File: c:UsersMohannadAppDataLocalTempTemporary ASP.NET Files
oot1f3f505f568b8e69App_Web_index.aspx.82d38c66.ffjpt45i.0.cs Line: 172
Show Detailed Compiler Output:
So I have Test1.aspx, Test1.aspx.vb. The LocalResource files, in the App_LocalResources folder, Test1.aspx.resx and Test1.aspx.es.resx. I also have a class called TestTheData.vb in the App_Code folder.
Now what I want to do is call GetLocalResource("stringObjRes").ToString in the TestTheData.vb class. The method however is not showing up in Intellisense. When I try to type manually, I get the error lines in my code.
I've imported:
Globalization
Threading
Threading.Thread
Web
Web.UI.Page.
I have created one class and use in default.aspx page working well. But when i add new aspx page and trying to call there i am getting error.
Code:
Parser Error Message: 'project1._Inquiry' is not allowed here because it does not extend class 'System.Web.UI.Page'.
Below code is from default.aspx header.
k Code:
<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="Default.aspx.vb" Inherits="project1._Default" %>
Below is the code of second file where error appear.
ss Code:
<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="Inquiry.aspx.vb" Inherits="project1._Inquiry" %>
I'm trying to call a base class specifically; Release class into a Page_load method.The release class is linked to a baseclass which contains a method Dataset GetresultHow do i call from the release class into the page load and use GetResult.
View 12 RepliesI have a web form with lots of code behind a button. I want to create a class, put all the code form the button into the class. But how do you call routines in the button from the class?
View 2 RepliesI'm building a menu controller class and I have a database with the Controller/Action strings in it. I want to dynamically build a menu reading from the database and generating the URLs to use in the menu's <a href=''> HTML that the class renders. I can't use Html.Action() in my class. I've tried adding System. Web.Mvc, but this doesn't help. Is there a way to generate a page's URL when given the Controller and Action? Maybe referencing the MVC equivalant of HttpContext.Current like I used to do in WebForms?
View 3 RepliesI would like to know how I can create a class that consists of my database connection and then how I can call that class within my C# code. Consider simple database call as follows,
SqlConnection conn = new SqlConnection(
"Data Source=InOrder_Play;server=play;user id=web;pwd=mypass;Application Name=myap .NET Cart;Persist Security Info=False;Connection Timeout=90");[code].....
I have a class that is referenced in my application. I use it in the codebehind, but now I need to call it from javascript. Is this possible, and how would I go about doing this? Say I have ClassABC. Within the class is method called getNames(). How do I call the method getnames() from javascript.
View 3 RepliesI wants to create a class file which contains the information about the salary calculation and call it on my page. hra,da,medical every thing is defined in percentage in that class and on my web page when i insert the basic salary in a textbox and click the button it will show the whole salary on a label.
View 2 RepliesI want to call css class that load background-image, font style,font size and so on...at the same time the code will load the button dinamically from database.. so that i want to put the CSS class, to change their image button when it default also when it hover.
View 2 RepliesIf my class has NO destructor, an it goes out of scope. GC runs at certain time, now will it simply reclaim memory from my class OR will it call its destructor or Finalize () on it? And does the .net framework class like SQLConnection implement a destructor? I saw it has a Dispose () implementation but didn't see the destructor using "Go to definition".
View 6 RepliesI have create the following code
using System;
using System.Drawing;
using System.Drawing.Imaging;
using System.IO;
using System.Text;
using System.Linq;
namespace ImageProperties
[Code] ....
But I did call it into my pages . I am using this but not find the ExifUtil class ?
ExifUtil.EXIFReader exif = new ExifUtil.EXIFReader(@"c:pathtoimage.jpg");
Console.WriteLine(exif[ExifUtil.PropertyTagId.EquipMake].ToString());
Console.WriteLine(exif[ExifUtil.PropertyTagId.EquipModel].ToString());
Inside my application I created the following class
Code:
Public Class clsProject
Public Sub AddData(ByVal cproject As string)
...
end Sub
end Class
I want to call this procedure from a sub in a form. So in the code behind file I wrote
Code:
Imports TextMgmt.clsProject
Public Class WebForm1
Inherits System.Web.UI.Page
Protected Sub btnAddData_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btnAddData.Click
Call clsProject.AddData(txtInput.text)
End Sub
End Class
I get the following design time error: Reference to a non-shared member requires an object reference.I thought making things Public would make them visible.
I have created an extended method for DataTable. I want to generate a class automatically in my solution when i call that method while writing a code as Visual studio does when it doesnt find the method.e.g mytable.mymethod(); Generate a class
View 2 RepliesI got a ASP.Net website (webforms application in C# - .Net framework 2.0) with Master Page, webforms and a GlobalFunctions class in App_Data folder where i do have ErrorLog functions and few other generic functions. Everytime an exception is caught in my webform it calls this GlobalFunctions.Errorlog function to log the error in my database table. After the exception details are written to the database table, I also would like to redirect the user to my ErrorPage.aspx like
Response.Redirect("ErrorPage.aspx",false);
However since i am inside a class (GlobalFunctions.vb) and not a webform, I don't know how to redirect this to ErrorPage.aspx since i can't access Response class.
I am trying to export data to a csv file in my web application.
I have the following class to enable this but i want to know how to call the class on Page_Load?
public class CSVExporter
{
public static void WriteToCSV(List<Category> categoryList)
{
string attachment = "attachment; filename=PersonList.csv";
[Code]....
I am trying to open a modalpop of previous page from a class, but i am unable to find that control
[Code]....
I am porting my simple Role Based Auth to ASP.NET. It requires this check on each page:
[Code]....
If put in each page's OnLoad, it works fine. But when I add it to the masterpage, it doesn't work. Is there something about the ServerVariables or Session Object that would prevent using those in a masterpage? Is it an issue calling my class from a materpage?
is it possible to make an asynchronous call to a static class function?
View 3 RepliesI have an asmx web service, and every time I try to call a static method in another project (which is a class library), I get an internal server error 500.
View 3 Replies