I want to do is create a simple page which allows a user to post data into a data table. It should not allow them to view, update or delete any data.
Is there a good online tutorial which would guide me through how to do this in Visual web developer 2008?
I have connected a db, and can add "SELECT" controls to view forms, but I need to be able to INSERT to the table.
Hardware involved:
SQL Server 2000
Microsoft Server 2003 with IIS6 [code]...
The goal, from internal department (user) perspective:A department wants to "upload" an excel spreadsheet of data (product, term, rate, etc) to SQL (this will be from the internal network). The data is then saved to a webpage location for that department to view and approve. Once "approved," this data is displayed on the live web servers (public-facing website which is two load balancing servers).
Bonus:
The .NET application/SQL Server can send an email to the department reminding them to upload the latest rates (each weekday morning, then each Thursday afternoon) if rates have not yet been "approved."
From the development perspective, this is my general idea, but I may be wrong.There are three spreadsheets, each with one tab. The first spreadsheet is uploaded, and the .NET application puts it in a SQL table. I then need to display this table of data on a .aspx page for the department to approve before the .aspx page is pushed to the live web servers.
First, I need an interface for this department to upload Excel files. I need this application to save the data to SQL and display it in a .aspx page so that the department can look it over and approve it. The department needs a way to "approve" the page, and this action will push the data to the live web servers. Will this involve SQL data transformation services?
1)table student
studentno varchar(50)
hobby1 varchar(40);
hobby2 varchar(40);
hobby3Â varchar(40);Â
2)if record in data database such that
hobby1Â hobby2Â Â hobby3 in this maximum is one must be chose
like
here studentno hobby1 hobby2  hobby3
          1            cricket  null        null     Â
          2            null     hockey    null
          3            null      null       tennis
if i want to write function in mysql if i pass the studentno
i want to get the hobby of respective student
like select functionname(1)
your hobby is cricket
like select functionname(2)
your hobby is hockey
ike select functionname(3)
your hobby is tennis
More specifically, i'm trying to create a stored procedure that displays data from a table if the date column in the table matches a specific day of the week. (IE. Monday, Tuesday, ect...)
The date in my table is stored as MM/DD/YYYY.
I have a form free user feilds, some drop down which are populated by a database data and a button. I want to create a new line in a table when the user clicks on the button. the values for this new line will come from the Values (not visible content) of the drop box, the content of the text feild, the user ID that I should get from the connection and the current date... ie, I want do do a INSERT INTO table (userid, dropdown, text, date) values (how do I get the user ID from the session?, how do I get the value from the drop down?, how do I get the text from the text box?, how do I get the current date?)
View 6 Repliesi want my web page to display data from a table, but instead of the "id" fields displayed, i want to display more meaningful field names. these are stored in other tables. my select statement is as follows:
SELECT [tblRelationship].[individual_id_1], [tblRelationship].[individual_id_2],
[tblRelationship].[relationship_type_id], [tblRelationship].[relationship_id],
[tblRelationship_Type].[relationship_type_id],
[tblRelationship_Type].[relationship_type_description],
[tblIndividual].[first_name], [tblIndividual].[individual_id] FROM
[code]...
i have some survey in my site with 5 radiobuttonlist answers after user vote the answer send to sql table. i want to display the votes in very simple way (horizontal 5 lines by percents) can any one direct me to solution or article? please i need the most simple solution (no colors, no pie no complex graphs) just 5 lines (line for each answer) that long or short by percents......
View 2 Repliesi want to insert regular, strings in sqldatasource.
in the "sss" i put joe and in the saw i put 'no' and it doesnt work!
<asp:SqlDataSource
ID="sql3"
runat="server"
InsertCommand="insert
into inbox(message,title,sss,to,saw) values(@message,@title,'joe',@to,'no')"
SelectCommand="select
* from inbox"
ProviderName="System.Data.OleDb"
ConnectionString='<%$connectionstrings:
sql %>'>
<InsertParameters>
<asp:Parameter
Type="String"
Name="message"
/>
<asp:Parameter
Type="String"
Name="title"
/>
<asp:Parameter
Type="String"
Name="sss"
/>
<asp:Parameter
Type="String"
name="to"
/>
<asp:Parameter
Type="String"
Name="saw"
/>
I'm working with Front Page 2003 & ASP v. 1.5 For an online auction, I have created a table with 3 columns: username, amount, highbid ORDERED by Amount DESC.
I want to look at the 2nd record in the table, create a variable from the "amount" field, add 1,000 to it and post it in the first record's "highbid" field.
Then display on my web page the first record "username" and "highbid"
I have been stumbling around with trying to create a custom query in the database results wizard of FP 2003.
I'm assuming I need to use a pivot table from what I've found so far. However, every one that I've seen has not had the date setup like I have.
I have a Gridview on my page which I need to be populated like so
Date NCMR
1/1/10-1/31/10 #
2/1/10-2/28/10 #
I want to do this for 10 months... bottom record being the current month (or last month). I would also like the Date to format to January 2010 I used the above date format because that is how it is in the table. Basically, I need to know how to create the pivot table to search the table for 1/*/10, 2/*/10, etc
I´m looking for some advice on how to create an table showing bookings, a table containing mon-sun on the horizontal axis and times at the vertical. The admin is able to edit each days bookable times (first bookable time, last bookable time) - The slottime is constant.
What I want is let the admin click on eacha cell to remove it/add it when removed. And other features as well, like create an booking for a customer.
What would be the easiest way to achive this, at the moment I use dynamic links since I cant get asp:buttons to work and the code to create an dynamic asp:table row by row and this produces some ugly code.
So any advice on how to achive such an "schedule".
What backend c# code should I use to post data (i.e., First Name, Last Name) to sql database? Here is the web form code, below:
[Code]....
Here is the backend c# code, below:
[Code]....
I have this code but dunno how to get the data from the existing sqldatasource1 into the list.
ie the code for this line: ' Get Data from Database and Fill DataReader and we will pass values to List
The sqldatasource1 returns only one field of data called holiday which is a date field.
<%@ Page Title="" Language="VB" MasterPageFile="~/00_MasterPage.master" %>
<script runat="server">
Private Function GetPublicHolidays() As List(Of DateTime)
Dim list As New List(Of DateTime)()
' Get Data from Database and Fill DataReader and we will pass values to List
End Function
</script>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"></asp:SqlDataSource>
Basically i deal with two tables.i have a table T1 of the following format:id company_name i need to read this data and create a table T2 as followsi wrote the following code. it worked fine for retrieving data and modification but fails to insert the modified data into the 2nd table.the error is, it does not recognise the value for @token
ArrayList dynarr=new ArrayList(); // global variable
protected void Button2_Click(object sender, EventArgs e)
{
int row = 1; int i;
string strcmd = null;
string Connection = "Data Source=....";
SqlConnection conn = new SqlConnection(Connection);
string str = "select company_name from T1 where ID=@ID";
[code]...
I want to know how we can create a table (or a layout consisting of div's) and poulate it with data from the database. We do this generally using data controls like gridview, datalist etc. But i am restricted by these controls like there is no inbuilt paging with datalist and there is no repeat column in gridview. I just want complete control over the layout as well as the data that goes into it.
I dont know how to do this. Is there anyway of doing it without using the data controls.
May you tell me how can I transfer data from a table to another table, the condition of non-repetition rows
as a procedure in database MS QSL server 2005 ,Works in the first day of the month I use the first table in the prodation environment it is contain the employee data and the second to update first table only
i created a asp.net form for registration without using login controls and a table for storing information. the passwords in the password column in the table is clearly visible in text form i want it to be in encrypted form.
View 8 RepliesI am a student with non IT back ground. I got a request from my client to develop a simple form with 10 data elements and store it in oracle table.I have to use ASP.net to develop this application.
View 5 RepliesI'm attempting to create a simple menu user control just as outlined here.
The attached code results in an "Object reference not set to an instance of an object" error, but I can't figure out why.
<%@ Master Language="VB" CodeFile="MySite.master.vb" Inherits="MySite" %>
<%@ Register src="Controls/Menu.ascx" tagname="Menu" tagprefix="my" %>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">......
I want to show the user defined Data table created at runtime in code behind C# and i want the load the datatable values in the crystal report ....
View 1 RepliesI want to SELECT a user from a table using the WHERE clause. I know how to write the query, but how do I execute it and how do I match the UserId with the current one (how do I know what the current userid is using the login controls)? I basically want to display profile information by selecting the table and matching it to the userid.
View 2 RepliesI have ASP.NET enviroment (C#) with SQL 2008 backend. I am using the ASP.NET membership provider. I need to create a table that contains member name, member role and third coumn (called "Registered for Conference"). I am using a button to initiate the action to call a stored procedure to write the selected value in the "Registered for Conference" column for the respective member.I know how to write the stored procedure, how to determine which user has processed their selection and how to write it to the "Registered for Conference" column of the table.I know that I can pull member name and member role with the following statement.
SELECT dbo.aspnet_Users.UserName, dbo.aspnet_Roles.RoleName
FROM dbo.aspnet_Roles INNER JOIN
dbo.aspnet_UsersInRoles ON dbo.aspnet_Roles.RoleId = dbo.aspnet_UsersInRoles.RoleId INNER JOIN
dbo.aspnet_Users ON dbo.aspnet_UsersInRoles.UserId = dbo.aspnet_Users.UserId
I need to understand how to create the table that will contain the member name, member role and third coumn (called "Registered for Conference"). This table cannot be a static table. In other words, this table needs to refect any updates to roles or members
I have a query that gets all item attributes using the query:
SELECT AttributeName, AttributeValue, ItemName from ItemAttributes
But I will need to write .Net code to cross-tabify this query's data.
How can I cross-tabify the above query using SQL Server code so AttributeName appears as table heading and AttributeValue, ItemName as column values?
I single table in SQL Server having 50 columns col_1 to col_50 having type varchar(MAX)..The table is having nearly 2 crore data into it which is unstructured i.e. just put in by bulk copy. I have to perform search operation on this table. How to index the table so as to make the search fast? or any other way to make the search fast.
View 2 RepliesI have a strange issue. I have a XSD file where I have created some TableAdapters. When I have reopened the XSD file it seems like I am not able to create a new table adapter since all the options which will come when I right click on the XSD file are disabled. I have cross verified whether I am on debugging mode but...I was not..(I am not even able to drag and drop an adapter from the left toolbox menu either)I am getting the same issue when I open the same XSD file on somebody else machine but I am able to create TableAdaperts in other XSDs.Can somebody suggest me a solution for this
View 5 Replies