I have this table called "students", with the columns :Name, ID, Faculty.
I want to display the info in my .aspx page in such fashion that the columns will appear on the left, the ID on the top, and the data populated properly.
So, basially, should look something like this:
ID 123 234 345 456 567 234 135 135
Name John Erick...
Faculty CS BIo ...
The problem is when am assigning my session table value to newly created table and if now am changing any coloumn name then the session table value also changing.
But my question is am assigning Session value to newly created table so how should session value should be affected?
for refference in my application
sessionState
mode="InProc"
i done one web application in this application i need to transfer the data from one table to another automatically when the time is 10.00PM. i need to write this function sepearte time function not in page load function.the user select any of page the data should be transfer from one to another without page load only using time control function..
View 5 RepliesI am building a little app to upload a picture and various downloads for different file types for the photos, but I also need be able to select the catergory they will go into. So I have two tables one that stores the catergory names and one that holds the paths to the photos and downloads the tables are related through the catergoryID.
What I need is those catergories to show up in the photo's and downloads table so that when I go to upload the photos I will be able to select the categories.
I have also built the DataSet and the Business Logic.
i have a dropdownlist contaning years..now i want to connect my database by dropdown selection.if i select 2013 it will connect 2013 database ,if i select 2014 it connect 2014 so on..
View 1 RepliesI am using profiles to store extra information about users. The thing that I want is that I am changing user name. But on the other side I have photo album gallery where I have stored the User name (Creator of album). These two tables (aspnet_Profiles and PhotoAlbum) are in different databases.
I have tried the following code while changing the user name
Private con As New SqlConnection(ConfigurationManager.ConnectionStrings("Photo").ConnectionString)
Dim updateSql As String = "UPDATE PhotoAlbum SET UserName = @UserName WHERE UserName = " & userName.Text
con.Open()
Dim myCommand As New SqlCommand(updateSql, con)
myCommand.Parameters.AddWithValue("@UserName", newUsername)
myCommand.ExecuteNonQuery()
con.Close()
Here newUserName is the new user name field and UserName is the previous name stored in PhotoAlbum table.
But it does not seems to work.On debugging it reports Invalid Column Name "userName"
Is there a good way to change the aspnet_Users, aspnet_Membership, aspnet_Applications and other table names which are generated by the ASPNET SQL Server registration tool -
[URL]
and change the reference to them in web.config or machine.config without breaking the default login, profiles and roles functionality that is provided by those tables?
I have the following table row on my .aspx page.
[Code]....
I can change the color of the return value based on conditional statements but cannot figure out the correct syntax to change the table cell back ground. My attempt is commented out.
How do I correctly declare the table cell? Findcontrol must not be the correct way.
In my form there are about 6 parameters and two of them have multiple values, upto 6. I'm imposed by the restrictions that I can't change the table structure. The table have 8 fields one for ID as primary key, one for foreign key and other to store data. The two fields which have multiple values are color and size. A size may have different colors and vice versa.
The programmer which have developed the site earlier used a stored procedure to store the data in database. And he implemented the above scenario one by one for each color/size. Now I have to put all in one.
How can I do this. As I can't change the table structure at current moment as this will disturb the whole E-commerce site.
I'm working on locking down some MySQL user accounts. At the moment I typically grant my user accounts execute privileges over the required stored procedures within a schema.Now I'm looking at the proc table in the mysql schema. The common wisdom that's quoted many times on various websites says "Stored procedures require the presence of the proc table in the mysql schema".By granting select access over the proc table stored procedures will work. But if I removed the above select privilege and grant the user execute privilege over the entire mysql schema the procedure will also work.
Does anyone have any ideas about the security issues by choosing one of the above over another?I would prefer to lock the proc table down all together so the user cannot see it cannot select from it.
If I use Microsoft.Jet.OLEDB.4.0 to retreive for example named range or sheet from Excel and use it as data source for some server control on the ASP page, everything works fine. But when I try to get table from Excel like this: "select * from [Table1]", debugger complains that database engine could not find object Table1. So how should I reference Table1 in Excel file so that the database engine could find it?
View 2 RepliesI am using PL/SQL Developer. I have a Table "C_PARTY_HXRF". Now I want see the Column Names and the corresponding Data types of this Table. Which Command should I Use?
View 28 RepliesI try to work with MYSql (because it's free) and I saw that the colums are different then when they are exployed in MS SQL?
Why is this? The most strange differents is that in MySQL there is no applicationId in the membership table.
This differents in tables cost me more time to do a export and import from MS SQL to MySQL.
Lets say i have assigned result of a query to dataset and now i want to change the headerText or field name in dataset, how do i do that?
View 1 RepliesI'm not so familiar with stored procedures but I'm interesting in moving most of my web selects to stored procedures. I'm working with .net based website and all my data access is something like this:
[Code]....
But now I want to improve some process and make tunings. For that I want to use stored procedures, so instead of the "SELECT ...." sentence I'll put stored procedure name. My problem is how to return a table from one.
now the system always prompts a error message about insert duplicate key into Sybase database.how can i prompt a message box instead of this error message when i insert duplicate key into sybase database table. any code can check what type of error then prompt different alert message.
View 1 RepliesI want to extract data from table into a view. MEans i have datatime field with value '12/31/2010 12:00:00 PM' in a table .
I want to change the field format in view to Date like '12/31/2010'.
Iam using oracle 10g.
i am very new to the programming and also asp.net. i have an assignment to create a table on webpage the information is coming from mysql database.
View 2 Replieshow can i create a backup table for my MySql base table.my base table name is FAB when ever user store the data into FAB table same records should be stored into back-up table automatically.how can i acheive this.i am really thank full to you if any one provide me solution.
View 3 RepliesI have applied audit trail to my webform/table its working fine.I am able to maintain the History(action,action_date) of the MySql database table from ASP.net but I want to save user name i.e action_by too so i will have history of who changed the data and when, how can i acheive to save username in history table.i have login webform in my application. History MySql Table.
View 1 RepliesMy site extracts data from a MS SQL db and then connects to a mySql db which it writes the data to. My site is working properly when connecting to a db in cPanel at a remote website.
However, I have a mysql db also hosted on my site, and I'm connecting to it ok, but the loop is failing. There are 2 tables, one stores the category, and the other stores link data.
For each category
write to the category table
for each link in this category
write to the link table
next
next
The tables are being created, and the very first category is written to the table, but then nothing gets written to the link table.
How can I make this generate an error message? My webhost doesn't know what to do about it and they just want to see an error message.
I tried this once already, and neither of my lines worked:
HttpContext.Current.Response.Write(lnkid & " " & url)
Why doesn't that get written into the source of the page on each iterance of the loop? How do I see the data that isn't being written?
[Code]....
We already have a complete Oracle database system where we have there as well a table (Oracle table name : "LTR_USERS") for usernames, passwords, emails, etc...
Now, we want to create an ASP.NET 4.0 website and we want to use the built in Login control (no need for the register / create user controls). However, we want this Login control to use that Oracle table ("LTR_USERS") to look for the username and password. How to do that?
i want to create a table for storing email like hotmail
I have 2 idea:
1-create table for for all user(user 1 has its table and user 2 also has its table)
2-create one table for all user and stor the email text in the field that used for email text and seperate the text by character like(, or - or ........)
I'd like to have to two tables Countries and states and make it so that any MySql user can access them for the purpose of building databiund drop down lists. What permissions do I need to assign the tables or what's the best way to do this?
View 1 RepliesOn one of our tables, a default clustered index is defined on the primary key by sql server 2005. The table also contains forign key columns and has got over 2 million rows. There are very frequent INSERT, UPDATE and DELETE functions on this table. Recently some of the SELECT queries which primary operate on the forign keys have become very slow (resulting in application timeout). To fix the problem, I defined an index on one of the primary keys which gave me very quick results. I don't know much about indexes.
1. Since I defined a new index (on the forign key) in addition to the existing default index, what kind of index (clustered or non-clustered) have I defined?
2. What performance impact does it have on the rest of the system? Is it going to break something else?
3. I read about fill factor. What is this and how does it effect the system?
4. Is the new index physically going to make any changes?
5. In case I delete this index later on, will the database return to the existing state or it will be a different state from now?