How To Receive Data From Database And In A While Loop

Oct 15, 2010

i want to receive some data from my database and in a while loop. i use this code in the while loop

Code:
Dim sqlda As New SqlDataAdapter()
sqlda.SelectCommand = New SqlCommand()
sqlda.SelectCommand.Connection = con
sqlda.SelectCommand.Parameters.Add(paramar(0))
sqlda.SelectCommand.CommandText = "select images,creationdate,dimosieyseis from t_accounts where UserName=@un"
Dim ds As New DataSet()
sqlda.Fill(ds)

if i open and close the connection it becomes slow. if i use a general con and not open and close it then i receive an error

"There is already an open DataReader associated with this Command which must be closed first. "

then i tried to resolve this error with

MultipleActiveResultSets=True that resolves the problem but it is not faster because i think it does the open and close of the connection automatically

View 4 Replies


Similar Messages:

Data Controls :: Loop And Insert Data Of All Sheets In Excel File To Database

Apr 23, 2014

I want to insert data in sql server from sheet within excelsheet ,there are three sheets in the file which i want to upload in three different tables,currently i am doing by selecting an individual sheet and the table to upload thus doing it three times for three sheets can i do it in one go,like passing all the sheets to a function or something like that or how can i do it in a better way and also i cannot directly upload sheet into table as i have to map one column of excel to different table of database to get its value like i need statecode but statename is provided in the sheet so i map statecode to statename in a staging table and then i upload the data...

View 1 Replies

Data Controls :: Loop Through Parent And Child / GridView And Same Data To Database

Mar 3, 2014

 I have nested gridviews, in the outer grid I am displaying the question and in the inner grid 4 options are displayed in radiobuttons.  I have kept Lock Answer button inside Item Template in inner gridview , so this button is coming with each and every question and when i click on Lock Answer button in front of any question, its saving the corresponding answer in the database. For ex, if there are 10 questions this button is coming with all the questions, all the questions are on single page and all are multiple choice. Now everything is working mine, my requirement is that I need on 1 common Lock Answer button at the bottom of the page and not with all the questions. And when I click on that common button it should run for all the questions that are displayed on the screen at should fetch and update each unique answer corresponding to that question in the database. Below is my code:

<asp:GridView ID="gvouter" runat="server" GridLines="None" AutoGenerateColumns="False"
AllowPaging="false" OnRowDataBound="gvouter_RowDataBound" Width="100%" OnRowCommand="gvouter_RowCommand"
OnPageIndexChanging="gvouter_PageIndexChanging" >
<PagerSettings Position="Top" />
<Columns>
<asp:TemplateField>
<ItemTemplate>

[code]...

View 1 Replies

Loop Through Table Cells With JQuery And Send The Data To Database?

Feb 26, 2010

What's the best method for looping through a table, grabbing all the data in the cells, but skipping the <th>? Do I put the data in an array?

View 1 Replies

Forms Data Controls :: Loop To Create Controls Dynamically From Database?

Jun 21, 2010

I would like to find out if there is anyone who would know how to read from a database then returns the same number of records that a stored procedure returns and display those records on the webpage there after pass the ID of the record to a variable to another stored procedure that displays the data related to the record that was clicked, I tried doing this in a asp.net repeater but I can't seem to be able to reference the controls inside the repeater.

<Repeater HTML Code>
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="OpenLogs.aspx.cs" Inherits="OpenLogs" EnableEventValidation="false" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

[Code]....

View 1 Replies

Web Forms :: User Can Receive The Mail Form My Site But I Cannot Receive Any User Details Mail

Jul 22, 2010

I have developed simple user registeration application form in that after press submit button i am sending mail to user for welcome template as well as i am also get on mail for user details like name email id, and ip address.my problem is the user can receive the mail form my site but i am receive the any user details mail it doesnot shows any exception what is the problem i donno please

View 4 Replies

Loop Database Result In Groups?

Apr 2, 2010

I have a query that returns a pretty big result. I want to break the big set into several smaller sets to pass into a function. If i had a 100 records returned, how would i get 10 datasets?

View 1 Replies

How To Call And Receive URL Data

Jan 28, 2011

In asp.net (or vb) I must to call a page that only autenticates a user, returning the user data if the logon succed. This way, I would like to implement the sequence:

A blank page (mine) request the autenticator page (3rd part) automatically on load; The user logs in the autenticator page; My page reads the autenticator page results and do the actions.

I'm a very begginer in asp.net, and I'm using vb.net in the environment for coding the page "onload" event. I'm trying to use the "redirect('url')" method to call the autenticator's page, but in this way, obviously, I can't receive the result. How can I implement this sequence?

View 1 Replies

Create API In C# To Push Or Receive Data?

Mar 23, 2011

I would like to create an API for my website to send and receive data.
For example I need my customers to upload products, single or multiple items. Product feeds can be send daily, weekly or monthly.

Product Name:
Product Color:
Product Weight:
Product Images:

Also I need functionality to send this data to another server. And it should be user friendly.

where to start, what technology to use to make it simple and sufficient.

I have background in Asp.Net, C#. It would be great to see an example how to approach it.

View 4 Replies

Web Forms :: How To Loop Through Checkbox And Insert Values Into Database

Jan 23, 2011

I am at my wits end (again).

(reservation system, guest signs up and at the same time checks checkboxes to indicate their wishes)

[Code]....

[Code]....

[Code]....

View 7 Replies

Web Forms :: Loop Through Database Entries And Create Text Box For Each One?

Jul 14, 2010

I am currently working on a project where I am trying pull a list of entries from an Oracle database depending on a selection that is made by the user via a Drop Down list. Then I want provide a user with a list of options that they can select that is related to the drop down option that they have selected. For Example:

First Drop Down from database: Honda, BMW, Ford

If user selects:

Honda -- options that are available in the separte table in the database for this entry are -- Type, Engine Size, Colour

BMW -- options that are available in the separte table in the database for this entry are -- Colour, Wheel Trims, Extra's

Ford -- options that are available in the separte table in the database for this entry are -- Extra's

What I wanted to do is have a form displayed to the user where thy can say select a car eg. "BMW" and then on the change of that drop downs index the site will do a call back and retrieve the entries for the BMW options in the seperate tabel, these being Colour, Wheel Trims, Extra's. Then it will put these details in a DataSet and then i wanted to create a new text box or input field for the users to enter details in. I have tried the below code with no success as I get an error on my for loop of looking through the options DataSet.

[Code]....

View 3 Replies

How To Send And Receive Data Using Web Service And JQuery

May 24, 2010

I want to run a web service method with parameters and get method return value back using JQuery.

ie.

client :

var result = dosomething(var p1, var p2, var p3 ....);

when do something accesses WebService with

dosomewebservice(int p1,int p2, string p3) { return "something" };
result == "something";

View 2 Replies

MVC :: Cannot Receive / Process POST Data Successfully

Jun 5, 2010

I have the following ViewModel:

[Code]....

This goes into a view like this:

[Code]....

Which as a result generates this:

[Code]....

Now, I'm trying to receive this data in a method so I can update stuff, like this:

[Code]....

But the above is not working. I've tried using [Bind(Prefix="user")] with no success. Before using this setup, I had all the user's properties directly in the ViewModel and the above method worked like charm.

What can I do to be able to process my POST request? I do not want to change my ViewData structure. I presume the answer to the question is not to difficult and lies only in adding something or changing some properties.

View 2 Replies

Programmatically Send And Receive Data Using Post Method?

Sep 16, 2010

I wish to make a script which programatically send the POST data to one server and then the other server receive the POST message and retrieve the information. How should make this work? I already successfully write the sender site, the code as follow:

string postData = "id=0&co=5";
ASCIIEncoding encode = new ASCIIEncoding();

View 4 Replies

C# - How To Find The Elapsed Time Between Send And Receive Data

Feb 28, 2010

I am using the System.Timers.Timer class. And I enable when I send a message and disable when I receive the message. How do I calculate how much time has elapsed. I have set the interval as 1 sec

Basically I retransmit data after 1000 sec again if I do not recive an ACK. I retransmit 5 times max until I get a Ack. If I receive and something before 150ms then I stop retrnsmission.

Here's the code:

timer1.interval = 1000;
port.Write(data)
timer1.enabled = true;

event handler for the received data.

timer1.enabled=false;

View 3 Replies

Configuration :: Adding Values To A Config File With Foreach Loop From Sql Database?

Sep 2, 2010

I have added the below tag in my web.config file;

<RewriterConfig configSource="configuration
ewriter.config"/>

It gets the rewrite vlues from another config file. I need to update this rewriter.config file dynamically.

I need to gets values inside it from sql databse. here is the look of the file

<?xml version="1.0"?>

View 3 Replies

AJAX :: Send Receive Data Between Server And Client Without Postback

Mar 7, 2012

as per my flow on every click i have a postback  without which i cannot store data to client or server.i have 2 ways of data storing one is client side in javascript variables in form of array(which can be lost on postback) the data to be stored are of differnt types some are numeric , some single characters some sepearted with comma other way is on each post back save the data in a session varibale on server & then access currently i have second way considering both the ways and in accrodance with the current flow which is best for maintenance & access speed reasking as i am notyet cleared abt the things.

View 1 Replies

Delaring A String Thats Within A Loop Within Another Loop

Jan 14, 2010

Im stuck with declaring a string which is in a loop within another loop.

Dim CompanyDetails As String = ""
Dim CompanyRow As DataRow
For Each CompanyRow In newdt.Rows
CompanyDetails += CompanyRow(1) & " " & CompanyRow(0) & "<br/>"...

How can I get this to see the GetInfo as declared..... since its in a loop within a loop?

View 9 Replies

Architecture :: WCF Service Be Used To Receive Data As Needed From A Remote Sender Or Service?

Feb 25, 2011

I am not sure which approach I should use. I have a web application that needs to get/receive data from a third party application that is in a secure remote network. The data needs to be secure during transport. The data layers cannot be exposed and the databases will not talk to each other. The data will be received from remote application on demand, or will get at scheduled intervals.

I have looked at WCF, but not sure if this will work. Can a WCF service be used to receive data as needed from a remote sender or service? Is this a secure way of doing it? I have also looked at SFTP using some XML/XSLT, but I don't think this is the right way to go. In addition, some data may be transported from my web application to the remote application (mostly reports at first). What protocols are used to transfer data between HIPAA compliant applications?

View 7 Replies

Loop Through The Datalist To Get Data?

Feb 3, 2010

I'm stuck in converting the rate in the datalist. My page contain one dropdownlist(currency converter), one datalist - inside contain the price of bags in labels. Now I uses the dropdownlist.selectedIndexchange

[code]....

Althought it did convert the rate, but it only convert the first row.

View 1 Replies

How To Loop Through JSON Data

Aug 16, 2010

I have an ashx page that returns the following JSON data that I would like to be able to loop through and add to values to a bunch of li's in a ul.

My question is how do I loop through to retrieve the values.

The data that is returned from the ashx look slike this

{"ImageCollection":
{
"Images":
[
{
"ImageID":"62",
"CatID":"1",......

I get a single alert that says undefined. What am I doing wrong?

View 1 Replies

Forms Data Controls :: Insert To Data Table Checkboxlist Items Within For Loop?

Jun 1, 2010

in my button4 click event, i want to insert checboxlist items to data table. first i want to delete all of the exisiting and then insert again.

my code is below but it is not working if you could explain anyone ?

in page load I have written code so that existing checkbox items are selected.

[code]...

View 5 Replies

How To Get From Loop Session On Data Reader

Nov 26, 2010

I am trying to send session on Loop and trying get .

[code]....

In above code, I just only get same SessionId on every news headings, how do I get next row session id?

View 2 Replies

Web Forms :: Add Data Value By Loop In Dropdown In C#?

Oct 29, 2010

how can add data value by loop in dropdown reply me soon

View 2 Replies

MVC :: Update Data From Foreach Loop?

Feb 21, 2011

I am trying to do some basic. Display customer testimonials in a table using foreach loop and have a checkbox on each row. Once checked, update the table.

I have a stored procedure of complex type in my entity framework. Here is my View.

[Code]....

Here is my model

[Code]....

[Code]....

[Code]....

[Code]....

[Code]....

[Code]....

[Code]....

[Code]....

[Code]....

[Code]....

View 5 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved