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?
[Code]....
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">
</asp:ScriptManager>
<br />
<asp:UpdatePanel ID="UpdatePanel2" runat="server">
<ContentTemplate>
<asp:Label ID="Label1" runat="server" Text="Status"></asp:Label>
<asp:Timer ID="Timer1" runat="server" Interval="6000">
</asp:Timer>
<asp:GridView ID="GridView1" runat="server"
AutoGenerateColumns="False" DataKeyNames="Username"
DataSourceID="SqlDataSource1">
<Columns>
<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" />
</Columns>
</asp:GridView>
<br />
<asp:DropDownList ID="DropDownList1" runat="server"
DataSourceID="SqlDataSource2" DataTextField="Username"
DataValueField="Username">
</asp:DropDownList>
<br />
</ContentTemplate>
</asp:UpdatePanel>
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 = "email@email.com";//"Welcome " + System.Convert.ToString(Session["user"]);
generalTableTableAdapters.kurtula_generalTableAdapter generals = new
generalTableTableAdapters.kurtula_generalTableAdapter();
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
how to read data from the sqlDataReader .
sqlDataReader sdr = sql_comm.executeDataReader();
if(sdr.hasRows)
{
while(sdr.read)
i=0
[code]...
Whats the best way to read data from cvs file
View 2 Repliesi am trying to read data of from a sql database
the code that im using is as follows:
[Code]....
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
in ASP.net website C# code
example:
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 system.data.common.DbProviderFactories
this is so that I can read data from both sql server and mysql
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.
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 RepliesI 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 Repliesi'm quite new to asp.net 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.
I have an object datasource which is using Business object as a myconnection
The method i have defined under myconnection is
Publicstatic
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 .
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 )
BEGIN
set @tdebit=??
END
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
I have created a page with a gridview in asp.net 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.
Some say it is not a bug it is default in asp.net. 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 asp.net 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:
private
static string __VIEWSTATE_FETCH;
protected void Page_Load(object sender,
EventArgs e){
[Code]....
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 RepliesI 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:
[Code]....
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 RepliesIn 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?
[Code]....
i have a db with two simple tables:
tbl_events:
-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_ID=18
-Event_Name=My event name
-Event_Organiser= 15,31,109,21
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 RepliesI have used SqlDataReaders a million times. Someone, what is wrong with this code:
SqlConnection connection = new SqlConnection(connectionString);
try
{
connection.Open();
SqlCommand command = connection.CreateCommand();
[Code]....
I have checked this against similar classes and it is exactly the same, but this one doesn't work.
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?
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[Code]....
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