I have several Include files in asp classic that I would like to convert to the class in C#, I have bunch of variable, Constraint, functions, DB connection. Is class the best way to convert them?
View 2 Replies
I'm trying to create a class, DataCommon, to contain all my SQL Data manipulation functions. I've created a Subroutine called Init that initializes a SQLDataAdapter:
[Code]....
From my other classes I am creating an instance of DataCommon, calling Init, and calling another subroutine in DataCommon that pulls data from SQL and loads the data into my dataset. This part is working great -- no problems at all. I'm loading three different Datatables in the Dataset with no issues.
At this point, I'll perform my various manipulations on the datatables -- add/delete/modify rows -- again with no problems. All of this is creating postbacks...and this is where my problem begins. After I've done all my manipulations to the data and am ready to update my SQL tables, I have to re-initialize my SQLDataAdapter. I thought I could do something like:
[Code]....
But I get the error: Exception inserting Class. Thread was being aborted.
In my initial data load from SQL, each datatable is getting loaded from a single SQL table, so I was hoping to use the autogenerated Update/Insert/Delete statements by the SQLDataAdapter. As a test, as soon as I filled the dataset initially, I added a new row to one of the datatables and used the SQLDataAdapter.Update() method before a postback occurred, and it worked perfectly.
So, with all that being said, I guess my question is, how do I reconnect the table mappings between my SQLDataAdapter and dataset to autogenerate the updates after a postback occurs? I've tried researching this, but I get confused after reading about FillSchema vs TableMappings vs everything else I've read about.
For some unknown reason I suddenly am unable to create an object variable for a Linq Data Class. If I create a new project and try the process again with the same database everything works as advertized.The code I am using is Dim db As New RoggDataContext which gives me an error on the object variable "db": Overload resolution failed because no accessibility 'NEW' accepts this number of arguments.I have looked inside every file in the Web Project like the web config to check the connection string, gobal, and designer.vb looking for any errors whit no JOY. I also tried to create a new form and code behind with a button and received the same error.This is mind blowing because as I already stated, I can create a new Web Site and the problem goes away.
View 3 RepliesI have a member function that does not depend on any member variables of the class. (in my case the class is an ASP.Net Page)
The function is protected, I dont need it outside of this class. Its only purpose is to build an URL from an given object.
Should I make all my functions static if they dont depend on the class, even if they are not used outside of this class?
I have created class in C# i need to use objects from this class to add them to a databse table.
the information come from textbox go into the object of the class than from this object i want to preform databse function.
I have a base class called BasePage, and a master page called SiteMaster. All my content pages inherit BasePage using BasePage instead of System.Web.UI.Page. Now, I need to access some functions in BasePage from my master page SiteMaster, let's say, the function is called "DisplayClientName()". How can I do it? Searched the Web, have found tons of similar questions but not solid solutions.
View 2 Replies[Code]....
The variable is assigned a value in another class like this:
[Code]....
I want to create a common unit test function to check all functions based on parameter
for e.g
[code]....
what logic should i write inside this method so that by passing a actual function in parameter methodname and then the common method should execute that function and should return the output.
i am using entity framework for all functions which has been created in my project and now i dont want to create a separate unit test function for each function.just one function should do the job based on different parameters...
is that possible.. ?
I created a custom MembershipUser and added some values, like this:
[Code]....
How do to retrieve the value of one variable of this class?
i have just started to learn silverlight, and i'm using C# as code.
now i want to declerate a variable in one class "mainpage" and i want to change the variable in the class "mainpage"
but i wanna do it through another class called "contact"
using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Windows;
[Code]....
i now know that i can't change the variable "pageopen" because it's static, but i don't know how to fix it?
Google usually solves my problems for me, but this one has me stumped. I have a page with the following code, in which lstPayments is a listview control:
public partial class frmPerson : System.Web.UI.Page
{
protected bool paymentWarning = false;
protected void Page_PreRender(object sender, EventArgs e)
{
if (paymentWarning == true)
{
string alertText = "alert('Hello World');";
if (!ClientScript.IsStartupScriptRegistered("Alerter"))
ClientScript.RegisterStartupScript(this.GetType(), "Alerter", alertText, true);
}
}
protected void lstPayments_ItemInserted(object sender, ListViewInsertedEventArgs e)
{
paymentWarning = true;
}
}
As you can see, I'm trying to get an alert box displayed after a new payment is entered. As I expect, lstPayments_ItemInserted is executed first, and paymentWarning is duly set to true. However, when Page_PreRender subsequently executes, paymentWarning has been re-initialised: it's false again!
The only way I can get the class-level variable paymentWarning to retain it's value between the two event handlers is to declare it static, which I don't want to do for obvious reasons. There must be something I am failing to understand about how class-level variables work in aspx pages.
I understand the problem of the static variable inside a class in the web application, now I try to create a simple class to deal with SQL Server for example, so I created Static Method inside this class, this static method used in insert, update and delete from database, I wonder if this is safe, and there is no problems will appear ?
View 10 RepliesI have a user control in which I have declared a connection string as a private class variable.
I have a bunch of cascading dropdown lists in this control.
In one of my subroutines PopulateDdlPostalCodes I get an error "Connection was not initialized".
In all the other subs that use Conn, the class variable is being recognized.
If I duplicate the declaration of Conn in this sub then all works ok.
Why is this sub different than all the others?
[Code]....
How to access session variable in the class?
View 5 RepliesI'm having a hard time understanding why the following code doesn't work. I'm sure it's something remedial that I'm missing or not understanding. I currently have a page that asks for user input. If, based on the input and logged in user, I find data from this page already in the database, I need to update the existing records rather than creating new ones, so I set a class-level bool to true. The problem is, when MyNextButton is clicked, PreviouslySubmitted is still false. So, I'm not sure how to make the value of this variable persist.
public partial class MyForm : System.Web.UI.Page
{
private bool PreviouslySubmitted;
protected void Page_Load(object sender, EventArgs e)
{
MyButton.Click +=
(o, i) =>
{
q = from a in db.TableA
where (a.SomeField == SomeValue)
select a;
if(q.Any())
{
PreviouslySubmitted = true;
//populate the form's fields with values from database for user to revise
}
}
MyNextButton.Click +=
(o, i) =>
{
//the value of PreviouslySubmitted is false at this point,
//even if I made sure it was set to true the previous postback
if(PreviouslySubmitted)
{
//update database
}
else
{
//insert into database
}
}
In my base class:
[code]....
In my user control that inherits from BaseUsercontrol The ascx has:
<asp:Button id="btnTest" runat="server" OnClick="OnButtonClick" />
Why can't I use the hidden input variable this way?
I am looking for differences between those 3 ways of using static class in asp.net application scope.
Will all of these point to the same class?
Which one is preferable >object< defined declaratively inside global.asax or static class ?
examples:
<object runat="server" scope="application" class="classname" ID="objID"></object>
VS
public static class classname {}
VS
Application("a") = new classname();
I need to keep a global variable throughout the whole time the user is at my site, but do I use Application or a static class? The string variable should store a region name and my site makes a few changes depending on which region that has been set.
I read that Application was mainly for classic ASP, but I also read that a static class cannot be instantiated at runtime (e.g. when the user has logged in).
So, have I got something wrong here and which solution do I use?
Should we create a class for every form we create,that will us to do the validations etc etc?
View 1 RepliesHere are 3 scenarios:
namespace NS
{
public partial class A: System.Web.UI.UserControl
private Variable v;
protected void Page_Load(object sender, EventArgs e){
if (!Page.IsPostBack) v= new Variable();
....
}
}
namespace NS
{
public partial class A: System.Web.UI.UserControl
private Variable v = new Variable();
protected void Page_Load(object sender, EventArgs e){
}
}
namespace NS
{
public partial class A: System.Web.UI.UserControl
private Variable v;
protected void Page_Load(object sender, EventArgs e){
v = new Variable();
}
}
When does the variable "v" gets created every time for the 2nd scenario? Is the 2st scenario is equivalent to the 3rd one?
How to register a Java Script varibale in Server Side (Code behind ) and access at Client side (Javascript file ) , without a hiddenfield , Literal etc
View 4 RepliesI want to create dynamic integer variable for each role in this loop. Which I will user later for totaling item count in other logic.
Is this possible to create a runtime dynamic variable?
I'm building an application using MVC3 RC and I'm trying to add a session variable as soon as anyone logs on. The variable is an int which is retrieved from a database using User.Identity.Name to retrieve the relevant database record.
I'm using the MS AccountController and tried adding the session variable immediately after the line:
FormsService.SignIn(model.UserName, model.RememberMe);
Although this is the point at which the logon is validated the User.Identity.Name is still showing as null when I try to get it immediately after.
Does anyone know when User.Identity.Name is actually populated in the session and how I can intervene to grab it at that point?
I want to declare a variable in such a way that I can access that particular variable and its value in all the asp pages in the project. Can anyone tell me how to declare a variable in C# such that it has project-wide scope?
View 8 Replieshow to create variable with max size in pls/sql function
View 2 Replies
