I have a website that displays information from my database into a gridview. The gridview has a checkbox, that once selected, is suppose to move a 'Y' into the field that has the checkbox selected. I have it generating the code, and displaying the code on my page to confirm, but the database is not being updated. Here is my code,
[Code]....
I would like to check my database for to see if a user name is available but my script isn't working.
I am taking input from a text box call unametextbox and i'm trying to extract any matching username from the database, this is my code.
[Code]....
It's probably something small but I can't seem to find what went wrong. I am trying to insert information into my database. It goes through the code just find but it doesn't insert into my database. Here's my code:
[Code]....
Here's my webconfig connection string:
[Code]....
Basically the main page has a couple of DataSourceObjects sucking information from a local database and displaying them on the page. The page is a form, which then generates an HTML email and fires it off using the SMTPClient. The problem is that I cannot seem to get the data from the database to be accessable from the code-behind. Attempting to get data from either of the ListViews results in a number of Null Exception errors, mainly when using the ExtractItemValues method. The OrderedDictionary that comes back always seems to be empty. So I figured I'd use one of the 3 Object Data Sources I already have set up, that queries the actual database, but cannot find any way of calling the Select statement present in either of them, let alone managing to store and access what comes back.
View 1 RepliesI'm using Content Management System, DotNetNuke for my dynamic website. DNN itself they have one database, I named it dnnDB. Inside the dnnDB they have the users table which have the list of users. I need to be able to pull this set of information or synchronize to my own database, myDatabase for development purposes. I do not want to incorporate my database into dnnDB, afraid that I may corrupt the system.
View 4 RepliesIn the table save your credit card.I want to encrypt all credit card information to be recorded in the database.
View 2 RepliesI build a webpage to edit the data entry, all the textbox wroks fine. However when I update the value originally took in using dropdown list , I get error and couldn't get correct update.
View 2 RepliesI have a gridview which sources information dynamically from database.
Here when i go for the default "AllowSorting" flag equal to true, i am able to achieve sorting of all displayed columns except the textBox control column whose values refreshes to zero.
I am using an SQL Express server hosted on a different machine and it is listed in my server explorer just fine. It is listed as my connection string in my web.config just fine as well and lastly it seems to sync just fine with my asp.net membership tables. My question is does it need to be listed in my app data folder of my site? Currently I have the ASPNETDB.mdf connection listed, which is apparently just a local sql express connection. The database I am using in my webconfig and other files is not listed so do I need to add it there?
Second question is about DAL, Data Access Layers. I have mostly been using presentation level SQL commands with my data presentation controls. Manually entering separate select, insert and update statements. I just went through a tutorial that stated the best way to interact with your database in asp.net is with DAL using table adapters. It mentioned that it gives you the ability to use strongly-typed references to each row. My question is can I use the same method multiple times on a single page. For instance a method inside an adapter named GetProductsByID(@ID) ? What if I want this bound to three different gridviews on a single page? Anyone have any other general things to point out about using DAL over presentation level commands?
I have some issues about retrieveing and storing date information to my database (ms sql server 2005).My data column is a DateTime, and i have set my web.config globalization culture is set to "en-gb"
When i retrieve date from the datebase it appears as dd/MM/yy, that's fine. But i cannot insert a new date as same format?! It will only accept MM/dd/yy or yy/mm/dd.Right now i'm using this code to correct the error:
[Code]....
Is it possible to change the date format on the database or something, so i dont need to use this code?
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'm using a gridview to show numerous artists. My query gets all the records I need, but when i bind it to the gridview the gridview shows only one record. I'm also using paging and sorting. The paging is not visible. The sorting works fine. But it still returns only one record. for example: first the record is Allan --> when i sort i get the record --> Zofie. This means that all my records are inside the gridview. Why does it only show one? My pagesize of the gridview is set on 10.
I have got a recordcounter above my gridview that shows the exact number of records that are present in the gridview for example (showing 1-10 out of 231 records).
This is my layout code:
[Code]....
I ahve a gridview and itemtemplate in which I have an URL field from the database. When I clicl on this URL, it should open in another browser the URL that we clicked on.
<asp:TemplateField
HeaderText="Website"
SortExpression="Dev_Company_City">
[code]...
I've created a SQL Server Express database to use with a program I'm working on in Visual Web Developer 2008. The connection works fine according to the Add connection-wizard in VWD. However there's a problem when I try to select data from the database and present the data in a gridview. The error message says that the gridview isn't connected to the database. The gridviews DataSource ID (source-mode) is the same as the name of the database. In design-mode, when I try try configure the datasource I get to a point where I have to configure the select statement, but I just want the connection to work in a way that let's me write the sql-statements in the aspx.cs-file.
View 4 RepliesBuilding an application on responsive design.
Is there a way to convert Gridview to responsive?
So that it should match with design.
Im trying to write a sql Procedure that will get information on the day a user specifies.
so far i have written:
set ANSI_NULLS ON
I'm using SQL server 2005 and Visual Webdeveloper 2008 express.
I have a database created and I've successfully connected to it. My question is, would it be possible to do something like search the first column of a table for a value, get the index of that row and use the index to get the value of each column? Sort of like you would with an array.
Are there are good tutorials out there that I could use, everything I found shows you how to display your information in a datagrid, which I've already done, but I can't find anything on how to get an individual row's information.
i'm new to programming and i'm doing a project of ana e-store, i have a data gridview that brings data from a data base and it have to more templeate files one a textbox and the other one is a label. and i have a button outside the grivdview. what i need that when i press on this button it will take the values from the grid view and insert them into a new sql table.
[Code]....
and here is the VB code that i'm trying to use with no luck : [Code]....
I am sure I am not the first to ask this question but I cannot find an answer in these or any other forums. I guess I am not wording the question right. In short I have a gridview populated but a database via an SQLDatasource. I have an Edit column in the datagrid and an updatequery in the datasource. When the Edit is click the line goes into edit mode, the user then clicks Update and I get an error. Could not find control 'DropDownList1' in ControlParameter 'Frequency'. The only complication is that there is a drop down control when the "EDIT" column is selected. The dropdownlist gets it list from another SQLDatasource. This all works fine. Here is the code snip:
<asp:GridView ID="GridView1" runat="server" AllowSorting="True" AutoGenerateEditButton="True"
As the subject says, i display a gridview filtered from 3 dropdownlist, wich all the items are from a local Data base, once i display this gridview i want to select a row with a button then and add, modify or delete data from it and then this new info is saved on the data base, so when i display the grid again i will see the new info. Im working on visual studio 2010, i dont use code behind, all is in asp .net.
[Code]....
I'm working on a web application in Visual Studio 2008. I'm using gridview to pull data from our database (I'm using a SQL Datasource) . I have a template field with a checkbox function and it allows you to check certain rows and disable them. What I am trying to do is send the enabled rows aka the non selected rows to a seperate table in our database. I'm assuming its just some kind of insert statement but I'm stuck on specifics..I am getting a object reference not sent to an instance of an object error. The line that is higlighted is, cmd.Paramters.AddWithValue("[Wrk_Pgrm_ID]" txt1.Text);
Below is the code i recieved from an earlier thread that I have modified.
[code]....
How can I retrieve information from delete rows. I delete some rows from table in dataset, then I use method GetChanges(DataRowState.Deleted) to get deleted rows. I try delete rows in original table on server side, but it finished with this errors. I try get value of columns from row, which was deleted
[Code]....
I have a C#/Asp.net web application which caches SQL DB schema information. Is there a way that I can determine what child relationships a given table has? I have looked into using the DataTable.ChildRelations property, but it is never populated with items unless i manually create a relationship using the .add property. I also have access to DataColumn information for each column in the database.
View 4 Repliesi 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]....
I have Gridview on my webapplication and it is getting filled with multiple rows . When clicked on Save I want to Insert all rows without calling multiple database hits.
Is there any way I can insert all rows by single db hit?