DataSource Controls :: Data In Sql Read Is Not Getting Refreshed?

Feb 1, 2011

I am running the code below to read a sql table and populate the values into a list. This works on the first run through, but after the data has been processed, and the process then re runs, if the sql table has been modified externally, the read of the records does not change. I imagine it is being cached somwhere but as I re dim the dData variable, shouldn't it all be dropped and run afresh?


View 2 Replies

Similar Messages:

DataSource Controls :: Binding Getting Refreshed At Page Half Refresh

Jun 1, 2010

yes i know half post ack occurs but it does occur right?so why doesnt the dropdownlist get refreshed when the timer ticks on?. for alternative i tried manually clicking a button to create postback but still no refresh of connection of th list

<asp:ScriptManager ID="ScriptManager1" runat="server">
<br />
<asp:UpdatePanel ID="UpdatePanel2" runat="server">
<asp:Label ID="Label1" runat="server" Text="Status"></asp:Label>
<asp:Timer ID="Timer1" runat="server" Interval="6000">
<asp:GridView ID="GridView1" runat="server"
AutoGenerateColumns="False" DataKeyNames="Username"
<asp:BoundField DataField="Username"
HeaderText="Username" ReadOnly="True" SortExpression="Username" />
<asp:BoundField DataField="Password"
HeaderText="Password" SortExpression="Password" />
<asp:BoundField DataField="Code" HeaderText="Code"
SortExpression="Code" />
<asp:BoundField DataField="Validated"
HeaderText="Validated" SortExpression="Validated" />
<asp:BoundField DataField="Silenced"
HeaderText="Silenced" SortExpression="Silenced" />
<asp:BoundField DataField="Full_Name"
HeaderText="Full_Name" SortExpression="Full_Name" />
<asp:BoundField DataField="Batch" HeaderText="Batch"
SortExpression="Batch" />
<asp:BoundField DataField="Department"
HeaderText="Department" SortExpression="Department" />
<asp:BoundField DataField="abuse" HeaderText="abuse"
SortExpression="abuse" />
<asp:BoundField DataField="Status" HeaderText="Status"
SortExpression="Status" />
<asp:CommandField ShowDeleteButton="True"
ShowEditButton="True" ShowHeader="True" ShowInsertButton="True"
ShowSelectButton="True" />
<br />
<asp:DropDownList ID="DropDownList1" runat="server"
DataSourceID="SqlDataSource2" DataTextField="Username"
<br />

View 1 Replies

DataSource Controls :: Sql DataAdapter - Read Data From Sql DB

Feb 24, 2010

i'm tring to read data from a sql DB, where is email == mystring - then display its name here is the code:

string mystring;
mystring = "";//"Welcome " + System.Convert.ToString(Session["user"]);
generalTableTableAdapters.kurtula_generalTableAdapter generals = new
generalTable.kurtula_generalDataTable genaraltab = generals.Getgeneral();
foreach (DataRow row in genaraltab.Rows)
if (Convert.ToString(row["email"])== user)
Label1.Text = System.Convert.ToString(row["name"]);

as you can see I'm a table adapter but is giving me the following error: i realy dont know what this error means - though i did a simular action using access DB (and it did work), where i had to user the following: using System.Data.OleDb; now because im using SQL DB im using: using System.Data.SqlClient; //sql server

View 3 Replies

DataSource Controls :: How To Read Data From The SqlDataReader .

Apr 18, 2010

how to read data from the sqlDataReader .

sqlDataReader sdr = sql_comm.executeDataReader();

View 3 Replies

DataSource Controls :: Read Data From Cvs File?

Mar 14, 2010

Whats the best way to read data from cvs file

View 2 Replies

DataSource Controls :: Read Data Of From A Sql Database?

Feb 24, 2010

i am trying to read data of from a sql database

the code that im using is as follows:


as you can see, im using table adapters - though when i run the page, it throughs me the following error, which i'm finding hard to understand

for my last project, i had to use the exact code, but at the time, i was using an access DB and now i'm uning sql D|B

the only difference from last time is that instead of using :

using System.Data.OleDb;

Now im using: using System.Data.SqlClient; //sql server

View 4 Replies

DataSource Controls :: Read Data From SQL And Store Into Array

Mar 4, 2010

in website C# code


in SQL server, I have table TaxTable with column named TaxID, SalaryFrom like this:

TaxID SalaryFrom
1 1
2 2083.00
3 2500.00
4 3333.00
5 5000.00
6 7917.00

is there a way to store the values under salaryfrom column into an array?

note: In C# , Im using

this is so that I can read data from both sql server and mysql

View 2 Replies

DataSource Controls :: Read And Insert Data Into Database?

Mar 5, 2010

I m uploading a text file. I want to read that text file line by line and I want to save that data into database if there are no errors in that text file. I have 5 different columns in database and I want to take those 5 columns data in the text file and insert into respective columns.

For this, which is the best way to do. Can we read and insert data into respective fields in no time.

View 2 Replies

DataSource Controls :: Read And Upload (data) From Excel?

Jan 6, 2010

i have some issue and i need read and upload (data) from excel file to dbgrid threw ASPX page am using network server 2003

View 1 Replies

DataSource Controls :: Read Data From An Access Data File And Input Into The SQL Database?

Mar 10, 2010

I have a lot of members data to enter into the ASPNETDB database. How can I read this data from an Access data file and input into the SQL database. All data is for user Names and Password,

View 1 Replies

DataSource Controls :: How To Read Data And Perform Action From The Database

May 3, 2010

i'm quite new to and have been working on a simple way for users to send messages to each other....

the messages work fine, users can send and reply, however, i want a way to tell the users when they have a message and how many...

how to do this in simple terms and supply vb code if possible.

View 2 Replies

Forms Data Controls :: How To Read Data From Stored Proceedure And Display To Gridview Using Object Datasource

Dec 8, 2010

I have an object datasource which is using Business object as a myconnection

The method i have defined under myconnection is

DataTable getfn(String dtype,
String did,
String dprefix,
String dname)
datable table = new datatable(); then declared stored proceedure and defined parameters and assighned values

In the stored proceedure it has a query like select column1,coloumn2,coloumn3 As Call from table where
I need to take data from Call and display it to the gridview through object datasource .

View 1 Replies

DataSource Controls :: How To Read Data Values Of A Table Using Loop In Sqlserver

Feb 10, 2010

I am using vs2008, Sqlserver2008.

my table: PostGL having data like thi

AutoIdx TxDate Id AccountLink Description Debit Credit
3 2010-01-22 JL 2 bcb 0 35.09
5 2010-01-28 JL 2 g 3.51 0

select AutoIdx,TxDate,Id,AccountLink,Description,Debit,Credit,(Debit-Credit) as Actual from PostGL where Id='JL' and AccountLink=2

AutoIdx TxDate Id AccountLink Description Debit Credit Actual
3 2010-01-22 JL 2 bcb 0 35.09 -35.09
5 2010-01-28 JL 2 g 3.51 0 3.51

I am trying in view like this

declare @cnt int
declare @i int
set @budget=20
set @cnt= (select COUNT(*) from PostGL where AccountLink=2 )
set @i=1
WHILE (@i<=@cnt )
set @tdebit=??


I am taking count the no of rows having AccountLink=2
I need to read all debit,credit and add all debit into totaldebit,all credit into totalcredit independently from table.
then i need to show the totaldiff as Actual.
i need ....totaldiff=totaldebit-totalcredit

View 3 Replies

Forms Data Controls :: Page Deletes Records In Database When Refreshed?

Mar 10, 2010

I have created a page with a gridview in that displays the records of a database table and allows users to delete checked records by clicking on a delete button. After I delete a record and I try to refresh the page from the browser (I am using mozilla)I get the follow message:

"To display this page, Firefox must send information that will repeat any action (such as a search or order confirmation) that was performed earlier."

and if I click resend another record is deleted automatically. Even though I am reloading the gridview after the deletion the application executes again the onclick event of the delete button is executed and the gridview things that there is a checkedbox selected so the code executes my delete function again.

Is there any way to get rid of these behavior. I have been trying quit a few things but nothing works for me.

View 2 Replies

Forms Data Controls :: Prevent Double Post Submit Where Page Is Refreshed?

Jan 25, 2011

Some say it is not a bug it is default in but for me it is a bug in logic. When you say refresh it should be reload the component that you are refreshing. But in i notice that they recalling all activity and viewstate like event and data that are triggered in the previous postback. My opinion it is a redo not refresh. this is only my observation on the issue dont hate me on this microsoft fan.

on aspx page:

static string __VIEWSTATE_FETCH;
protected void Page_Load(object sender,
EventArgs e){


View 12 Replies

AJAX :: How Another Updatepanel Can Be Refreshed Everytime When A Particular Updatepanel Is Refreshed

Aug 13, 2010

I am using two Updatepanels in ASP.NET AJAX and as soon as there is some event in first updatepanel, it will get refreshed at that time I want my second Updatepanel getting refreshed too. How can I do that ?

View 2 Replies

DataSource Controls :: How To Read A Single Row

Feb 5, 2011

I wanted to know is it possible to pass "SqlDataSource" data to a variable? if not how can i use datareader to do this?

i couldn't figure out how to pass SqlDataSource to a varialbe so i tried use datareader and i'm stuck in middle of it, also my query only returns one row and one column so i rather not to use array if possible. here is my code:


View 3 Replies

DataSource Controls :: How To Know Mail Is Read

Mar 27, 2010

I want to achieve that when a user click on the subject to open the email, then i want to update the database. I want to update the database on the click of the subject only.

View 2 Replies

DataSource Controls :: Read A Bit Value From DB With SqlDataReader?

May 2, 2010

In SQL Server 2008 bit is like boolean (true/false), but I tried to read the bit value (0 or 1) and got error. How can I read it?


View 1 Replies

DataSource Controls :: Read Or Write Array In Sql

Mar 30, 2010

i have a db with two simple tables:

-Event_ID int
-Event_Name varchar
-Event_Organiser varchar tbl_events_organisers
-Organiser_ID int
-Organiser_name varchar

In event_organiser of tbl_events i want to store the organiser_ID's of the second table in an array, so a record in the first table will like something like:

-Event_Name=My event name
-Event_Organiser= 15,31,109,21

View 4 Replies

DataSource Controls :: LINQ To SQL VB- Read Only Access?

Mar 29, 2010

I'm have two problems that I would appreciate feedback on:1. I added new fields to database, store procedure, and dataContext but the data Context is not showing up when I select the datasource in the Grid control.2. I have dbo access to the database but have read only access. When I add a grid to the app I only have the option to sort, page, select.

View 1 Replies

DataSource Controls :: DataReader.Read() Not Working?

Mar 16, 2010

I have used SqlDataReaders a million times. Someone, what is wrong with this code:

SqlConnection connection = new SqlConnection(connectionString);
SqlCommand command = connection.CreateCommand();


I have checked this against similar classes and it is exactly the same, but this one doesn't work.

View 4 Replies

DataSource Controls :: Can't Read A Word Document

Mar 24, 2010

im having a table with a column varbinary(max) data type,

there im storing all images,texts,pdf and word files in binary format.

i can read out images and texts programmatically but not with the case of word files and pdf files.

what is the possible technique so that a company can store in coming resumes in databases so that they can refer in furture purposes?

View 1 Replies

DataSource Controls :: Read Sequential Rows From A Table?

Mar 23, 2010

I would like to be able to read the first row of a table and then each successive row sequentially individually. So, is there a way to read the first row of a table, whatever the primary key may be, and then read the next sequential row in the table until the last row has been read? I need to be able to do this in order to create a list of column entries in each row for a listbox control that a user can select from.

View 3 Replies

DataSource Controls :: How To Use SqlDataReader To Read The Last Row Added To A Table

Jun 17, 2010


My question is how do i use SqlDataReader to read the last row added to a table getting the contents of a column and storing it as a c# varaible

View 2 Replies

Copyrights 2005-15, All rights reserved