I am using "ASP .Net 2.0" with "SQL Server 2005". What is better and preffered approach towards making a sqlconnection to interect with database?
1. To open new connection each time we need to interact with DB and then close the connection
2. Or to make a shared database connection for whole web application.
'i'm working with visual studio 2005 asp.net c#. and i want to bind my website to my database with the "sqlConnection"
how do i get and set details from the database to the website fields with the sqlCommend and ect...
i have 5 methods in classA. each and every methods i have open the sqlconnection and close it, instead of that is there anyway to create a sqlconnection at one time if its opened then no need to create a new connection, if its closed then we have to connect.
View 5 RepliesIs it possible to use a pre-existing ConnectionString in this construction?
myConnection = New SqlConnection("server=localhost;" & "database=pubs;Trusted_Connection=Yes")
Regards -Penn
I have a whole bunch of data access methods where in each one I am doing this
[Code]....
and them moving on with my SqlCommand and SqlDataReader and so on.Is this creating to many instances of an SQLConnection?I was thinking doing this instead. Creating a SqlConnection Manager which would look like this
[Code]....
and then in my database access methods
[Code]....
Is this a good or bad idea and why?Also would this even be neccesary?
i am making a simple cms system
but I have a problem when updating some information
here is the code
[Code]....
and in the page load everything is fine
[Code]....
'SqlConnection' is not defined in the behind code as follows:
Source Error:
[Code]...
Source File: I:WebsitesCMPHostFox BackupDefault.aspx.vb Line: 24
Snippet reads as follows:
[Code]...
can capture return value from a SQL by using SqlConnection SqlCommand
[Code]....
I'm trying to determine whether it is better to declare the connection outside with it's own using statement or to create it inside the sqlcommand itself. This is in regards to a single command interaction with the database (no loops).
[Code]....
Or
[Code]....
I know you can point to a OnSelecting event on the aspx page datasource. But I've created my SqlDataSource in the code behind. Is there any way to point to a selecting event in the code behind (I need this to provide the parameters)? Or should I just include all my logic in the Page_Load event (where I keep my SqlConnection)Here's what I have so far:
protected void Page_Load(object sender, EventArgs e)
{
SqlCommand myCommand = new SqlCommand();
[code]...
on the basis of above interact with database i also want some animated output to appear such as "smile should increase if student secure above 90 marks"or if not then "smile should decrease" hough i know it all need a huge knowledge of actionscript and asp.net along with c#...
View 3 Repliesi am coding fr taking databse backup frm my asp.net web application
i get the backfile in .bak form. how do i zip it. make it in zip form
I have a searchbox where i ask for information to a table, but i want to rewrite the code so i can search from several tables.
Here is my temporary select command which works great when using only one table:
[Code]....
HDSK_AUTO HDSK_ID HDSK_CASEDESC
1 TC1 pc spoil
2 TC2 problem
Action table:
ACT_AUTO ACT_HDSK_ID ACT_DATE ACT_TIMEIN
ACT_TIMEOUT ACT_ACTIONS ACT_STATUS
[code]...
How do I go about doing this in SQL? I need to return 3 columns: ID, the stuff combined into a single field, and the latest status of each ID. (by latest I mean the most recent entered record's ACT_STATUS. this could be based on the ACT_AUTO I think, which is the auto-increment number)
i am making a quiz system in asp.net using C# vs 2008.having one equestion per page,with previous and back button.each question have four options with only one correct answer.The options are in a radio button list.I have a database which has two columns as QuestionID,CorrectAnswer.
For viewing previous answer the user can click on previous button,so that he can see his previous marked answer and if feel he had marked the wrong option then he can mark the other one.
Some Problems:-when clicking the previous button the option which was marked in radio button list got unchecked!!So,the user is unable to know which he/she had marked before.I want that the option remains checked so that the user knows what he/she had marked previously.After completing the quiz how can the answers selected by the user be compared with the CorrectAnswer stored in database and can be displayed in the result page having four columns as QuestionID,CorrectAnswer,UserAnswer,Right/Wrong in a grid view. Though i am able to display the QuestionID and the CorrectAnswer in a grid view in the result page.
I have a database table column consisting of text URLs [URL] In my LINQ-to-SQL-driven gridview, I want to make this a clickable link programmatically, with differing link text (e.g. "Link text"). I'm getting close but am missing some key concept. Here's the core of the .vb codebehind:
Dim dctx As New ResourceMod.ResourceModDALDataContext
Dim eleResObj = From eleRes In dctx.Resources Where eleRes.Type = "url" Select siteurl = eleRes.Website
GridView1.DataSource = eleResObj
GridView1.DataBind()
This displays the raw URL in the gridview (i.e. non-clickable). I've experimented with adding an explicit hyperlink column a la [URL](setting AutoGenerateColumns false etc.), but haven't yet figured out how to assign the asp:hyperlink Text and NavigateUrl fields with the anonymous-type object eleResObj. Using a field construct such as Text='<%# Eval("siteurl") %>' isn't working, presumably a scope issue. Is a LinqDataSource needed in this case, and if so, how would that affect the original LINQ query?
I'm currently facing a performance problem with creating POCO objects from my database. I'm using Entity Framework 4 as OR-Mapper. The whole application is a prototype for now. Let's assume I want to have some business objects like classes 'Printer' or 'Scanner'. Both classes inherit from a BaseClass called Product.
The business classes exist.
I try to use a more generic database approach. I don't want to create tables for "Printer" nor "Scanner". I want to have 3 tables: One called Product, and the other Property and PropertyValue (which stores all assigned values to a specific Product). In my business layer I do create a specific object like this:
public Printer GetPrinter(int IDProduct)
{
Printer item = new Printer();
// get the product object with EF
// get all PropertyValues
// (with Reflection) foreach property in item.GetType().GetProperties
// {
// property.SetValue("specific value")
// }
return item;
}
This is how the EF model looks like: Works fine so far. For now I'm doing performance tests for retrieving multiple sets. I've created a prototype and improved it several times to increase the performance. It is still far away from being usable. I takes 919ms to create 300 objects who only contain 3 properties. The reason for choosing such DB design is to have a generic database design. Adding new properties should only be done in the business model.
Am I just being too stupid to create a performant way of retrieving xx objects or is my approach totally wrong? As far as I understand OR-Mapper, they are basically doing the same?
Consider the following scenario: Page written in classic ASP or PHP, which is rendering a data report (series of HTML tables for simplicity). There is one main database query and then multiple sub queries as the page renders. The report is split into sub panels, which correlate to a sub query. Therefore:
Main database query. Loop over result. For each row, execute sub query and render report panel. How would you architect a similar report using the MVC pattern? This can be split into two parts: Efficiency at database level of multiple queries, which are dependent on values from an outer query. If all data was processed and prepared in the controller, would this also be deemed inefficient if looping within the controller and then again in a view to render. Could sub controllers be used or sub panels, which encapsulate smaller sections of logic i.e. loading data and rendering report panel.
Im using some animationExtenders in my project. The thing is, the objects to be animated are created programmatically, hence i need to also build programmatically the javascript code that will interact with them.
It runs properly but, when i interact with these animated controls and the javascript functions are supposed to get to work, i keep getting the usual run-time error saying that the javascript functions are not defined. But, if i check the final html code generated, i can see how all the controls i built programmatically are there ,as well as the script.
Tried both RegisterStartupScript and RegisterClientScriptBlock, no luck.
I'm trying to automate system login by using webbrowser control and do some processing after i have login-ed.
Normally, after login into the web, it will pop up a new windows. But then, i faced a problem,if automate login with WebBrowser control, the pop-ed up new window will ask me to login again. So i have searched for the solution, MSDN suggest to use axWebBrowser and ppdisp in order to keep track of the session.
private void axWebBrowser1_NewWindow2(object sender, AxSHDocVw.DWebBrowserEvents2_NewWindow2Event e)
{
Form2 frmWB;
frmWB = new Form2();
frmWB.axWebBrowser1.RegisterAsBrowser = true;
e.ppDisp = frmWB.axWebBrowser1.Application;
frmWB.Visible = true;
}
Now the problem is, i have no idea how to control the axWebBrowser1 to get the HTML ID and set attribute towards the elements in the axWebBrowser page.
I can set value to the element using webBrowser control, as below:
HtmlElement criteria = webBrowser2.Document.GetElementById("searchFields0");
but i cant set it like this with axWebBrowser control... is that anyway that i can use webBrowser control and also maintain the session without using axWebBrowser control?
Here it goes, I've been asked here to create a WebService that will work on .NET framework 1.1 so other project can interact with it to get the job a little .dll(1.1 also) can do.
The main idea behind this is to be able to upgrade the application and the rest of the projects while being able to use this old .dll through the WebService.
Is it possible to comunicate with a WebService that works on the framework 1.1 from an ASP application working on 2.0 or higher.
Actually, what I've tried raise an error like so : The request failed with the state HTTP:401 : Access Denied.
But when I access the webservice(asmx page), it does work, the page shows all the method available. Also the project build perfectly.
So I'm completely new to web development, but I hope to reach a level of knowledge on how to build a Web Server that can interact with my TCP program, like a chatbox basically. How can I achieve this and where should I start learning?
View 3 RepliesI have on site three textbox controls, RequiredFieldValidator with each textbox and button (without any code). I have problem, when I set autopostback property of textbox controls to true. Regardless, that EnableClientScript sets to true or false, validation error dissapears - or show only few seconds. Helps only set CausesValidation property of textbox to true. And my question - if autopostback is set to true, should I set causesvalidation to true too to make proper validation process? Why it doesn't work?
View 7 RepliesI'm trying to figure out if it's possible to transfer records from SQL central database (who has a public IP address) into SQL local database (who doesn't have a public IP)?
or if it's not possible can I use a centralized website instead to pass some data into the local website? (but i'm not sure if it will have some security concerns)..
Creating a system with web front end and SQL backend (microsoft obviously). I have tried using the asp.netsqlprovider but i can;t as i am only allowed one database on the server, so i then tried to update my current database with the triggers to input the schema into the already existing database.Next step i create my own table with two simple fields of username and password and try and authenticate that way, i can't get that to work either.
I ahve limited permissions on the network as i am a University Student. I really don't know what to do. Never had to create a log on system before and i thought it would be far simpler than this. I ahve used Microsoft's sqlprovider schema before and it worked fine. I have also authenticated via IIS and AD too before. I can't do any of those two in this instance it seems.I need an alternative for logging in users, if needs be in can be crude. I also still need to have some kind of two different views too for logged in users and not logged in users, but that can change if needs must.Don't let me down people, haha. Think this posts in the correct place, i could not find another one i thought could be more relevant.