I know this is a beginner question but I am struggling to find any clear tutorials etc on how I can create new records in a database table based on information added into text boxes on a page. Also what is the best way to do this LINQ, dynamic data website etc etc?
View 1 RepliesI made a website, 1 database; We have 4 cumputers, the 4 are using the same website and saving datas at the SAME TIME.
The problem that i have is that when 2 people click in the save button at the same time, only onces is in the database, but the others get lost.
Visual Studio 2010, Framework 3.5, MS-SQL 2008, C#.
The conecction is in c#, everthing is in c#.
I need to do an insert into a database table (SQL Server). I want to compute value of 1 column based on the existing data and then do an insert. How do I prevent another user from getting access to the database in the middle of this process?
View 2 RepliesI am attempting to write my very first ASP.NET application, it will simply display the contents of an SQL server database table in a Gridview. This is just a first step, my eventual intention is rewrite a set of VB6 applications I wrote some years ago. But I need to walk before I can run.
I have already created an SQL Server database containing all the tables used by the VB6 applications.
How do I link this database to my ASP.NET application. Previously (on another computer) I have simply opened "My Computer" and then navigated to the .mdf file (e.g. northwnd.mdf) and then dragged and dropped it into App_Data in Visual Studio. However when I try that on my own machine, with my own data, I get an "Access Denied" message.
How can I not have access to my own data on my own computer? What am doing wrong?
I am running Visual Studio 2008 on a Windows 7 Ultimate machine, with SQL Server 2005 Compact Edition (or which ever one installs with VS 2008).
I'm currectly tryin to access a specific value in my database in a specific column. I'm tryin to use the primary key of the table to access the actual value in the row of that ID.
The current code:
[Code]....
Just iterates through the table and looking for any row with the boolean 'checkin' value is True, then it takes the 'id' value of that row and stores it into an array. Is there a way that I can access a another entry, and only that entry, in the table with the 'id' stored in the array?
Like if my data base contained and int, primarykey, `id` value, a boolean, `checkedin` value, and a `time` value, is there a way to access, lets say, the row with `id` equalling 3 and and the checkIn value from that row?
I have stored a string value in a hidden field of a page. How to access it from a different webpage?
View 4 RepliesI've created ASP.NET pages in the past that sent emails using the .NET classes. However, I'd like to send an email from a webpage using the email software on the client computer.
My understanding is that the mailto: protocol allows for some arguments such as a subject and to address.
But I'm not sure which arguments are supported or how universal that support is. Also, are there other options that give me even greater control over the client's email software?
Ideally, I'd be able to specify more than one to address, the subject, and the email body, which the user could then review and modify before sending.
I have log files in different machines. Now i am developing a web page in my development machine (Windows XP, IIS 5.1 installed). In the web page i want to give a link(may be hyperlink or linkbutton). On clicking the link it should access the log file in the particular machine and it should give a popup with open and save option as given in the normal web applications. I am using the following code snippet but its throwing error "Cannnot resolve the URL"
Response.ContentType = "text/txt";
Response.AppendHeader("Content-Disposition", "attachment; filename=log.txt");
string str = ResolveClientUrl("\ip address\FolderName\logs\log.txt");
Response.TransmitFile(str);
Response.End();
Here FolderName is a shared folder in the machine(which ip address is mentioned).
I have a page called Article.aspx that takes content from the database. I would like to use the title of the content as the title of the page for a little SEO I am doing. I setup a literal on the aspx page that must take the value of the content title from the code behind, what is the best way about doing this? I'm guessing I need to open a data base connection to read the record from the table but I am still learning asp.net and not sure how to write it
View 22 RepliesI have a webpage that uses a formview. The formview gets the data from the objectdatasource which connects to a query in a table adapter.
I wanted to add a hyperlink in the page right below the formview that will "hyperlink" to another page passing parameters. Those parameters are values from the formview.
Can I just access the parameters of objectdatasource from outside the formview as follows?(it isn't working)?:
<asp:HyperLink
ID="HyperLink215"
NavigateUrl='<%# Eval("VIN", "Contact.aspx?Subject={0}") %>'
runat="server">Contact Us Regarding This Vehicle</asp:HyperLink>
If not, can I access those parameters in codebehind and do a redirect from there? How do I access the data of objectdatasource from codebehind? If I can do that, I could just put a button. Then in the button's click even, I could do the redirect.
Right now, I have designed my page that works great with an iphone screen, with the help of this meta tag:
[Code]....
Problem is, how do i detect what kind of phone that are acessing my page, and afterwards change this meta tag to fit it to that phone?
I have a single column returning SQL data source and I want to use the data for a simple if statement, but for the live of me I can't figure out how to do it. *oh for the old days, I wrote the same thing in simple asp in about 45 seconds*
[code]....
For the life of me I can't figure out how to get that data into a variable or any way to access it. I know its probably simple. I have tried functions, etc off the net but everything I try results in another error.
I have a gridview control that displays expenses claims received from clients. I have a template field that contains a checkbox - if this is ticked, a value from the gridview is added to a variable and this is outputted to a label control.
What I then want to do is to update the database according to which row has been ticked. I have so far the following code that adds each value to an array, which I was then hoping to access in the sql query i.e. Update table set value = value where id = (id's added to array)..
Code as follows - so far I'm just displaying the count of values in the array to make sure they are actually being added:
[Code]....
As the title sugests, I am missing a (basic?) concept as I teach myself asp.net, linq, and C#. It has been awhile since I've done anything object oriented, so I don't know how much that is impacting this gap in my understanding. Anyhow, here is what I am trying to do. I have three SQL Server tables: PERSON, POSITION, AREA. There is a 1 to many relationship between PERSON and POSITION, and a 1 to 1 relationship between POSITION and AREA. Given the following code I verify who the person is who has logged into the browser:
[Code]....
I want to be able to return all of the AREAs the person is able to access, based on the position they currently hold. I am able to easily do this in a SQL Server query, and I am sure I can do this with a SQL stored procedure once I pass the EMPLOYEE_ID to the procedure. However, I would rather do this in the page_load event, and load the returned results into gridview1 for the viewer. The issue I am running into is in building the LINQ query. When I try to build it, I can only get access to two of the three tables, depending on which table I select with db. Is it possible to access all three tables in the same query?
I'm programming a webpage in ASP.NET which displays a list of students not listed as participants in something, and upon clicking a student name shows you a brief summary of their details, so the user can ensure they're selecting the right person. Each student is identified by a unique ID.
My code currently correctly obtains their ID, adds it as a parameter to my stored procedure and executes the procedure;
[Code]....
However, when I try to access the results, with say dv.Table.Rows[0], I get the following error:
[Code]....
Upon debugging, there don't seem to be any results returned... when running just the stored procedure in SQL Server with the same data, it does return a single row, as expected.
I am new to using ADOMD for accessing SSAS cubes. I am having an issue with concurrency. I am using ADOMD to connect to SSAS 2005 in an ASP.Net 2008 application. When a user executes an MDX query and the ASP.net page opens an ADOMD connection, a second user that tries to execute an MDX query gets "a connection is already open" error. I don't understand how ADOMD works. Does it open only one connection for all users because ASP.Net is using a single account for all connections from the web server? I do not have this problem when using ADO.net in the same manner.
View 2 RepliesI want to run the SQL server Job from the web page.
I have created the SP. Now i want to run this SP By run the Job.
The Job should not be scheduled automatically. I should run this job from front end web screen.
If user clicks the button i want to run the job and return the response back to the screen.
The SP (calculation process) will run for nearly 10 minutes, thats why we are going for this method instead of calling SP directly.
I have a datalist and I am filling it using a dataadapter, dataset. So in my .ascx page, I have
<asp:datalist runat="server" id="dlProducts" repeatcolumns="2" repeatdirection="horizontal">
<itemtemplate>
<table border="0">
<tr><td><%# Eval("Item_Name") %></td></tr>
<tr><td>I have to add a picture here</td><td><%# Eval("First_Name") %></td></tr>
</table>
</itemtemplate>
</asp:datalist>
In the area where I have put a statement like "I have to add a picture here", I have write a big case statement. Like:
Case: 6 // show a picture from file1
case: 7 // show a picture from file2
Case 8: //show a picture from file3
So How do I do this here? Because I dont know how to access the datalist values from code behind.
Here is my code behind:
SQLString = "SELECT First_Name, Picture, item_name, item_id from table1 where item_id = " + request.querystring["iid"];
dataadapter daItems = new dataadapter(SQLString, "connection_name");
dataset dsItems = new dataset();
daItems.fill(dsItems);
dlProducts.datasource = dsItems();
//So at this point how do I populate the picture in the <TD> tag I mentioned earlier?
I am using a list of objects as a datasource and passing the object into a user control. I use the code outlined below
[code]...
When I try to access the object this way, it's null.
Funny thing, I can access the user control and all the control data in the user control, but the object (both in the gridview and passed to the user control) are null.
I'm developing an ASP.NET user control in VS2008 that writes to a SQL Server 2005 database. I've published the control to a SharePoint 2007 MOSS page using the SmartPart addon. The control consists of a few text fields and a submit button that writes the contents of the text fields to the database. When I test the control in the Visual Studio debugger, it works fine. When I try to submit data from the SharePoint page, I get the error shown at the end of this post. Last time I saw this, it was a database permissions error, but I've granted my site's default application pool read/write access to my database. Does anyone have any idea what else the problem might be? Also, how can I double-check the credentials that the SharePoint page is using to access the database, since I still suspect that this is a permissions issue?
[ERROR TEXT FOLLOWS]
Server Error in '/' Application.
Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[NullReferenceException: Object reference not set to an instance of an object.]
ConnectionHandler.ClientDataConnect() +103
ClientData.ClientData.Page_Load(Object sender, EventArgs e) +1426
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +24
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +41
System.Web.UI.Control.OnLoad(EventArgs e) +131
System.Web.UI.Control.LoadRecursive() +65
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2427
Version Information: Microsoft .NET Framework Version:2.0.50727.3053; ASP.NET Version:2.0.50727.3053
it's possible to access contrls on aps.net page like textbox from stored procedure in sql 2008.
so I get the value of the textbox on the page direct from stored procedure .
how to retieve images which are stored in database one by one and put them in webpage's table.
My project is shopping cart type project in asp.net and server is sql2003
I saved the image urls in database.
I'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)..
I have a web page that has a repeater bound to a data source. I beed to change a label inside the repeater based on the data that is in each repeater item. For instance, for the first item it might be one thing, and for the next item the label may be something else. I am currently doing some processing in the prerender event, but I don't know if I can or how to access the data source fields there. Where and how do I get access to the data in each item so I can change the label text?
View 3 RepliesCreating 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.