.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

script in clientside but why it refresh data?

Posted By:      Posted Date: October 11, 2010    Points: 0   Category :ASP.Net

 i have textboxs like these



Sub tru02(ByVal sender As Object, ByVal e

View Complete Post

More Related Resource Links

C# newbie stuck - trying to access column data in a SharePoint list in an SSIS script task

Hello, I'm sure this is the simplest question but I can't figure it out, even with Google's help. I am trying to stumble through some C# code in an SSIS script task and I am frustrated that I can't figure out how to do the easiest things.  I eventually want to find data in a column,and then use another list as a lookup to replace that value with another where the existing value matches a value in the lookup list.  So, the data in my (multiple choice) column might be "apples; bananas" and in another list I have a row that contains two columns, the first holding the value "Apples" and the second containing "Red Delicious" and my original column should read: "Red Delicious; bananas." But, alas, I can't even figure out how to see the data that is in a column. Here is my code: /*<br/> Microsoft SQL Server Integration Services Script Task<br/> Write scripts using Microsoft Visual C# 2008.<br/> The ScriptMain is the entry point class of the script.<br/> */<br/> <br/> using System;<br/> using System.Data;<br/> using Microsoft.SharePoint;<br/> using Microsoft.SqlServer.Dts.Runtime;<br/> using System.Windows.Forms;<br/> using Microsoft.SharePoint.Utilities;<br/> <br/> namespace ST_08becda4c05c49cd9f30ea76110076cd.csproj<br/> {<br/> [

SQLCE 3.5 connection from multiple application, data refresh

I have a native application (wm 6.5) using oledb to connect to a database. *******************************************************************************   result=CoCreateInstance(CLSID_SQLSERVERCE_3_5,0,CLSCTX_INPROC_SERVER,IID_IDBInitialize, (void**)&database);   ... // set properties  database->Initialize(); ******************************************************************************* This part of the app simply queries a single table for all records (query wrapped in a transaction of it own). I believe it is recommended that you keep a single connection for as long as possible, and therefore just create a new session each time I query the table. There is a second application (c#) which my application executes and then waits for. It updates and inserts new records. when the c# app closes and I get control back, my app then runs another query to see if anything has changed. My issue is that, the only way I can get the updated data is to un-initialize and re-initialize the database (IDBInitialize) interface created above.  Is there some properties I should be setting on the session/database in order for this to work. Or do I really have to spawn a new connection for every query?   Thanks in advance. Dylan

Calendar.aspx page Refresh only Once + Java Script

Hi Experts, Following script works perfect (refresh only once after 5 seconds and stops but for some reason if somebody clicks next month then it keeps refreshing for 5 seconds. Can you please put the following code in your calendar.aspx page and check if you can get rid of the continuous refresh if somebody selects next month otherwise it works fine. Please provide the updated script <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html;charset=utf-8"> <title>Refresh test</title> <script type="text/javascript">   window.onload=function(){     url = window.location.href;     qIndex = url.indexOf("?");     if( qIndex != -1 ){       getData = url.substr(qIndex+1, url.length-1);       if(getData != "refreshed=1"){         refresh();       } else {         myDiv = document.getElementById('content');         myDiv.innerHTML = "This is the second and final time the page loaded.";       }    

Error in Script component in the Data Flow Task

Hi, I need a small help. This is what i require. I need to generate a auto increment number using script component and assign it to target column. use db1 go create table src (name varchar(10) ) insert into src select 'A' union all select 'B' union all select 'C'   create table trg (id int, name varchar(10) ) while loading the trg table, i need to generate a auto increment number and then load it to target. Finally, my trg table data should look as follows id name 1  A 2  B 3  C This is what i have done inside the package. step1 : declared a global variable "tmp" of int32 step2 : created a connection manager pointing to "db1" database step3 : drag n drop data flow task step : inside the data flow task , i have the following        OLEDB Source  (select name from src)           |        Script Component (i have added a new Output column "v_id" of int datatype in INPUTS AND OUTPUTS page)           |        OLEDB Destination In the Script page in Script component , in ReadWriteVariables | User::tmp, I have chose Visual Basic 2008 and clicked the EDit script and inside the Editor this and inisde the below routine i have added only two

I need to create a script in SSIS which creates a data source that connects to an Access database.

I need to create a script in SSIS which creates a data source that connects to an Access database. The Access database file name needs to be set as a variable as it will change from month to month. I have no idea what I am doing can anybody give me some tips? Mr Shaw

How to refresh the data without having to click on F5?

Hi,My code:private void GetCardDetails() { // Update these variables to values whatever you are storing in your table // If you are storing as CARD NUMBER, update this Card Number Attribute Name to CARD NUMBER string strCardNumberAttributeName = "Credit card number"; // string strCardTypeAttributeName = "1"; string strExpiryDateAttributeName = "Expiry date"; MembershipUser myObject = Membership.GetUser(); string UserID = myObject.ProviderUserKey.ToString(); DataTable dtPaymentDetails = new DataTable(); string queryString = "SELECT tbl_payments.ID, tbl_PaymentDetails.AttributeName, tbl_PaymentDetails.Value, tbl_Payments.PaymentType FROM tbl_Payments INNER JOIN tbl_PaymentDetails ON tbl_Payments.ID = tbl_PaymentDetails.PaymentId WHERE ATTRIBUTENAME IN ('" + strCardNumberAttributeName + "','" + strExpiryDateAttributeName + "') AND (tbl_Payments.UserId = '" + UserID + "') AND (tbl_PaymentDetails.UserId = '" + UserID + "') ORDER BY tbl_Payments.PaymentType DESC"; using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand(queryString, connection); connection.Open();

How to refresh data in the DataGridView by using a Timer?

Hi all I am refreshing my DataGridView by calling using the code below: protected void Timer1_Tick(object sender, EventArgs e) { UpdatedTime.Text = DateTime.Now.ToLongTimeString(); FillDataGridView(); } protected void FillDataGridView() { DataSet objDs = new DataSet(); SqlConnection myConnection = new SqlConnection(WebConfigurationManager.ConnectionStrings["Test"].ConnectionString); SqlDataAdapter myCommand; string select = "SELECT * FROM TableLogging"; myCommand = new SqlDataAdapter(select, myConnection); myCommand.SelectCommand.CommandType = CommandType.Text; myConnection.Open(); myCommand.Fill(objDs); GridView1.DataSource = objDs; GridView1.DataBind(); } However I want to use templates in the DataGridView like this: <asp:TemplateField HeaderText="InstanceID" SortExpression="InstanceID"> <ItemTemplate> <asp:Label ID="lblInstanceID" runat="server" Text='<%# Eval("instanceID") %>' /> </ItemTemplate> </asp:TemplateField> So I would NOT be calling FillDataGridView() from Timer1_Tick. My question is: what do I have to add inside Timer1_Tick so that it will refresh my DataGridView (the one with the templates) Thank you! 

Excel Services no refresh data & no error logs

Hi! I'm trying to publish an Excel workbook which loads data from SQL Server. The result is: no data loaded in the workbook and no error logged on Sharepoint logs. Notice that if I try to refresh the workbook in Office Excel all works fine! I try to set up Windows Authentication, None (to use unattended account) and with .odc file but with no result! The procedure I follow is: 1) create a new Excel file and create new data connection to the database (SQL Server 2008) 2) upload the file in the trusted file location 3) open the file in a web part and click on the "refresh all" button I used the same unattended account which I setup for this purpose with BCS and it works fine! I also try to set with PowerShell the Application ID created ("ES"): "set-spexcelserviceapplication -identity 6d871d92-19dd-4421-b33b-0012f9a5ea18 -unattendedaccountapplicationid ES" with no result. I noticed that the identity of the Excel Service application shown in the Central Administration isn't in the IIS Application Pool list: could it be the problem? I also tried to delete / re-create the application but the two IDs remains disequal! Have someone of you already worked with Excel Services and could give me any help? Thanx in advance, Elena

Force report viewer to refresh through java script

I have a Report Viewer in Modal Popup Extender and I need to call refresh on the report viewer or simulate a postback. I have hidden fields tied to the Report viewer parameters, so I put my the report viewer in an update panel. And I need to find a way to refresh the report. My code is below...thanks for helping.

Writing XML data from URL to Object in SSIS Script Task

I have this URL where there is XML data. I have to extract that data from URL and dump it into DW table. I am using SSIS Script Task for that.

This is how the data looks like:
<cname>United Arab Emirates Dirhams</cname>
<cname>Afghanistan Afghanis</cname>
<cname>Albania Leke</cname>

This is the code i'm using to load it into some Object type or something. But i dont know how to do that.

public void Main()
   String URLString = "http://www.xe.com/dfs/datafeed2.cgi?beeline";
   XmlDocument doc = new XmlDocument();
   XmlTextReader reader = new XmlTextReader(URLString);

   XmlNodeList currencynodes = doc.SelectNodes("currency");
   foreach(XmlNode currency in currencynodes)
    XmlNode csymbol = currency.SelectSingleNode("csymbol&quo

workbooks inside of sharePoint site has data refresh error


We have workbooks inside of our SharePoint site, using NTLM authentication and Excel Services connectors. They correctly display graphs when the page is first opened, but all of them throw an error when users try to trigger an update. The error message sayss "Excel. An error occurred during an attempt to establish a connection to the external data source. The following connections failed to refresh: [name of any data cube in use]. Learn more about data refresh." We are not using Power Pivot (which may make it easier, but is not authorised for use by our server administrators yet).

Visio service data refresh help


I have created Visio 2010 diagram hwich gets the data from SQL 2008 server. vsd diagram works fine on the client, data is refreshed when I click Refresh from Visio 2010.

I have published it as vwd using "Share" option of Visio 2010 on SharePoint 2010 server in Shared Documents site library. It opens fine in browser, you see the diagram, but data is not refreshing, although I force it with dedicated SharePoint Refresh button on the top of the page. No errors, just the data is not updating.

SQL 2008 server is actually on the same Windows 2008 server where the SharePoint 2010 server is. The question is how it connects and works fine from the client PC but cant refresh the data on the server. I am admin on all boxes.

Do I need to publish ODC file on the SharePoint 2010 server too ?

Any help is appreciated.



How can I avoid entering Output columns manually (with their data types) in the Script Transformatio

I created a wrapper to a WCF web service that is returning many datasets with hundreds of columns.  The destination database schema matches the source schema exactly.  When i make the connection on a ADO.NET destination object to my database it auto-generates my list of columns.  I understand that the script component could output anything so it can't autogenerate at this point, but is there any way to copy and paste the Column definitions from somwhere else and paste them in?  I'd like to avoid spending hours entering all these manually.

How to Refresh Gridview data from update panel in specified time


hello frnds,

i have some search criteria.

after filling all criteria when i press search button the result arrives in gridview nw when searchbutton pressed after that every 20seconds i want 2 update gridview data which is in update panel

refresh stored data into table


hi all,

i have create a form in asp.net & C# using SQL server..

after i click save button data will stored in table..

if i click refresh in browser it save my data again into table..

what is the problem actually?

data Flow Script Component

Hola, estoy en un data Flow y en el Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer) quiero validar si la columna de tipo fecha es realmente es fecha, en el caso contrario debo interrumpir la ejecución del ETL, pero en estos Script de transformación no he podido indicar un Dts.TaskResult = ScriptResults.Failure ... como lo puedo hacer? Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer) If IsDate(Row.FECHAINGRESOVENTA) Then Row.FECHAINGRESOVENTA = parseFecha(Row.FECHAINGRESOVENTA) Else Dts.TaskResult = ScriptResults.Failure End If gracias

duplicate data on page refresh


I m working on ASP.Net database related project. I have one form including one Button, On ButtonClick I m inserting data into database.

It is working fine but when I m refreshing the page then again it is inserting same record into database.

I dont want this, so suggest me what  is the problem.

Thank's in advance.



ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend