Is It Possible to Load XML File data into Adapter
Code:
protected void Page_Load(object sender, EventArgs e)
{
DataSet ds1 = new DataSet();
DataSet ds2 = new DataSet();
if (!IsPostBack)
[code]...
I have a CSS Adapter enabled Menu(having sitemap data source) which I have created using this tutorial Multi Level ASP.NET Menu with CSS Friendly Control Adapters. Now I want to load a div(containing contact info) on one of this menu item's onclick event. let me know how I can do this with jquery? Where should I add the code?
View 7 RepliesI'm new to .net... long time programmer though
I'm trying to return the full recordcount of a data adapter but I'm struggling.
This is a snippet of the code I am using
[Code]....
This works ok but it only returns the number of records I am actually filling into the dataset table.... So my query might return 700 records but because I am only returning 15 back into the dataset table (to paginate the results) then it only shows 15 records found.
Do I have to fill a 2nd dataset table with the full results set and count that? Should I return a count of records as a column in the products table.
What's the correct way of doing this (and what's the most efficient way of doing this)?
Just want to know if it is possible to Dynamically Populating a DetailsView with OleDb Data Adapter ? It has to be done on the Page_load because it has to display a users details that i must be able to edit!
View 4 RepliesCode:
SqlDataAdapter da = new SqlDataAdapter("select * from " + txtTableName.Text, DataStoreGeneral.GetConnectionString());
DataTable dt_app = new DataTable();
da.MissingSchemaAction = MissingSchemaAction.AddWithKey;
da.FillSchema(dt_app, SchemaType.Source);
da.Fill(dt_app);
SqlCommandBuilder build = new SqlCommandBuilder(da);
da.InsertCommand= build.GetUpdateCommand();
da.Update(ds.Tables[1].GetChanges(DataRowState.Added));
Problem: In my scenerio i had dataset with a table (in code->ds.Tables[1]) in rowstate added. I wanted update on database with this table so i changed insert command of adapter to update command of command builder, but no update got performed. When debugged in sql profiler i found that update command generated by builder is checking all columns in where clause and with parameter value of data table instead of from database column value.
exec sp_executesql N'UPDATE [ShopResources] SET [GROUP_RESOURCE_ID] = @p1, [SEQ_NO] = @p2, [SUB_RESOURCE_ID] = @p3, [EFFICIENCY_FACTOR] = @p4, [RUN_COST_PER_HR] = @p5, [RUN_COST_PER_UNIT] = @p6, [BUR_PER_HR_SETUP] = @p7, [BUR_PER_HR_RUN] = @p8, [BUR_PERCENT_SETUP]
= @p9, [BUR_PERCENT_RUN] = @p10, [BUR_PER_OPERATION] = @p11 WHERE (([GROUP_RESOURCE_ID] = @p12) AND ([SEQ_NO] = @p13) AND ([SUB_RESOURCE_ID] = @p14) AND ((@p15 = 1 AND [EFFICIENCY_FACTOR] IS NULL) OR ([EFFICIENCY_FACTOR] = @p16)) AND ([RUN_COST_PER_HR] = @p17)
AND ([RUN_COST_PER_UNIT] = @p18) AND ([BUR_PER_HR_SETUP] = @p19)
The problem I identified is parameter values inside where clause are from data table which is obvious that update condition will not be met. Is there some way to restrict where clause to primary key only in Command Builder?Or why is command builder taking where clause parameter values from datatable instead of command (query)?
or on one sql statement in VS 2008.
How to use two connection strings on one data adapter
I have a profile of member to be displayed. I am using a dataset with all the data table adapter to retrieve the information from database.
I have a memContact method which has NRIC and Number as a composition primary key. Thus, automatically, the table adapter has created a method called FindByICNum () for me. However, when I do the search to display the contents, i will only need to search by memberic instead.
Is there anyway to change the table adapter query?
My application is running fine locally when I deploy it it is giving me the above error saying
Description:
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
I've been attempting to walk through the "Creating a Data Access Layer" tutorial found [URL]I create the DB connection, create the typed dataset and table adapter, specify the sql, etc.When I add the code to the presentation layer (in this case a page called AllProducts.aspx) I am unable to find the NorthwindTableAdapters.ProductsTableAdapter class. I tried to import the NorthwindTableAdapters namespace, but it is not showing up. Looking in the solution explorer Class View confirms that there is a Northwind class, but not the namespace I'm looking for.
I've tried several online tutorials that all have essentially the same steps, and I'm getting the same results.Can anyone give me a push in the right direction?I'm getting error: Namespace or type specified in the Imports 'NorthwindTableAdapters' doesn't contain any public member or cannot be found. Make sure the namespace or the type is defined and contains at least one public member.I think I might need to add a reference OR they may be creating a separate class and importing it into their main project. If that's the case, the tutorials do not mention this.
SuppliersTest2.aspx.vb:
Imports NorthwindTableAdapters
Partial Class SuppliersTest2
Inherits System.Web.UI.Page
[code]...
how can i get a single row from strongly typed dataset table data adapter in c#?
View 2 RepliesI'm having difficulties getting XslCompiledTransform.Load method to take a server path. I googled around and found that I need to do something like:
xslt.Load(System.Web.HttpContext.Server.MapPath(xslPath), XsltSettings.Default, new XmlUrlResolver());
But it returned an error saying HttpContext is null.
I also tried:
xslt.Load(System.Web.HttpServerUtility.MapPath(xslPath), XsltSettings.Default, new XmlUrlResolver());
That also returned an error saying an object reference is required for the non-static field, method, or property 'System.Web.HttpServerUtility.MapPath(string)'
The xslPath has a path that points to a xsl file in Sharepoint Web. I just want XslCompiledTransform to load the xsl file with the server path. Is it possible? If so, what is the proper way or hackish way of doing it?
EDIT: I have access to a SPWeb object which contains the path to the xsl file. However when I check the ServerRelativeUrl, it just says "/MyTree/xsl.xsl". The problem here is I couldn't get the XslCompiledTransform.Load to load the file from SharePoint list.
I was having issues with a gridview and CSS so I posted my question here and received a wonderful answer which lead me to implementing CSS Friendly Adapters for all of my gridviews.I have a table nested in the EditItemTemplate that holds the textbox and the button for a calendar control where I want them, it inherits the CSS applied from the CSS Friendly Adapters. I don't want it to change the CSS so I have changed the CSS inline, with no success. More importantly...
I also have a Ajax calendarExtender control to change the date for that field. When the popup is displayed the table in which the calendar is shown in also inherits the CSS Friendly Adapters code. I have tried fixing this by creating a external css sheet for the calendarExtender's cssClass property and a blending of CSS occurs where the items not specified by the Friendly Adapter Code are set correctly by the calendar.css file that I created.Is there anything that I can do to force the tables inside of the gridview to ignore the inherited Friendly Adapter Code?
I am trying to test website on a remote server to see if I can read or write to a MySql Database.In VS Web developer 2010 Express edition, I created a new website and saved it via ftp on the remote host. I have added the 'Mysql.data.dll' to the website and placed it in the bin directory of the project.When I try to run the program i get "Could not load File or assembly MySql.Data, Version=6.3.5.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The system cannot find the file specified.
[Code]....
The remote server supports .Net v2, so I have made my application focused on v2 framework. I have tried similar code on my local machine and works fine.
How can I load data from xml file into MSSQL Server using sql xml bulk load? I had try some code but when I ran my application, I encounter below error msg
"Retrieving the COM class factory for component with CLSID ...... failed due to the following error: 80040154"
How can I go about solving this?
I'm using VSTS 2K8 and I've set up a Unit Test Project. In it, I have a test class with a method that does a simple assertion. I'm using an Excel 2007 spreadsheet as my data source.
My test method looks like this:
[Code]....
As indicated in the method decoration attributes, my Excel spreadsheet is on my local C:/ Drive. In it, the sheet where all of my data is located is named "Sheet1".I've copied the Excel spreadsheet into my project and I've set its Build Action = "Content" and I've set its Copy to Output Directory = "Copy if Newer".
When trying to run this simple unit test, I receive the following error:
The unit test adapter failed to connect to the data source or to read the data. For more information on troubleshooting this error, see "Troubleshooting Data-Driven Unit Tests" (http://go.microsoft.com/fwlink/?LinkId=62412) in the MSDN Library. Error details: ERROR [42S02] [Microsoft][ODBC Excel Driver] The Microsoft Office Access database engine could not find the object 'Sheet1'. Make sure the object exists and that you spell its name and the path name correctly.
I've verified that the sheet name is spelled correctly (i.e. Sheet1) and I've verified that my data sources are set correctly.Web searches haven't turned up much at all.
[Code]....
I'm a beginner with asp net 2.0 and ajax 1.0, we work with visualt studio 2005. i must to realize a simple page with a grid and a button, button isn't in the grid button is place beside the grid and when i click on the button i must to load a file that user selected on this computer and this file contains some data with a separator " | " => pipe
after load file i must to displays these data in grid view
my question is, how i can load a file in a control, with controls i must to use for to load file !?
I want to load the data from an EXCEL 2007 file to SQL Server 2008 database. I am geting following error.
The Microsoft Office Access database engine could not find the object 'Sheet1$'. Make sure the object exists and that you spell its name and the path name correctly.
Following is the complete source code. Kindly any senior member guide me what is the problem in the following code.
[Code]....
I am trying to create a control, but I need to load my formatting string from my web.config file, but every time I try to run the program I get an error one the formatting line. show me the correct syntax to load this data?
[Code]....
I've add MSChart to a webpage and I'm also using a Survey page I got from 4GuysFromRolla (http://www.4guysfromrolla.com/articles/061604-1.aspx). Both work on my development machine but when I move them to my hosting site there are issues.
With MSChart page the chart is not displayed although it's included the Page Source code:
src="/ClubInformationTracking/ChartImg.axd?i=chart_3d90c53b0f844807a2491a1d79a636a1_0.png&g=75fecf0f14cf4121b623691d383263aa" alt="" style="height:300px;width:700px;border-width:0px;" />
And when I try to open the Survey page I get this:Parser Error Message: Could not load file or assembly 'sstchur.web.survey' or one of its dependencies. The system cannot find the file specified.
Source Error:
<%@ Register TagPrefix = "sstchur" Namespace = "sstchur.web.survey" Assembly = "sstchur.web.survey" %>
<%@ Page Language = "C#" %>
Assembly Load Trace: The following information can be helpful to determine why the assembly 'sstchur.web.survey' could not be loaded.
WRN: Assembly binding logging is turned OFF.To enable assembly bind failure logging, set the registry value [HKLMSoftwareMicrosoftFusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.To turn this feature off, remove the registry value [HKLMSoftwareMicrosoftFusion!EnableLog].
The Hosting site is using Version 4.0 and the dll needed for the survey is in the BIN directory.
When I moved my files to the hosting site I had to change every instance when I referred to a file from:
"~/FileName"
To
"FileName"
I've tried all of the "fixes" I could find for the MSChart that involved changes to the web.config file but because of the error messages associated with the Survey page I'm guessing this is the issue.
How do I fix this error?
I'm running .NET Framework v4.0.30319 so the Framework shouldn't be an issue. I'm not using any DLL files or bin directories. How do I setup the IIS/Virtual Directory if I'm using Forms Authentication for the whole website using VS2010?
Description: An error occurred during the parsing of a resource required to service this request. review the following specific parse error details and modify your source file appropriately.
Parser Error Message: Could not load type 'ACAWebApplication.Pages.State_Carrier_Search'.
Source Error:
[code]....
[code]....
what i have is the following code.
[code]...
I am trying to update an access DB using a table adapter created within a vs 2010 dataset file. When i click my submit button nothing happens. Also using an insert method created the same way it works.... When I dubug using the immediate window i receive this message:
Argument not specified for parameter 'StockNum' of 'Public Overridable Function UpdateQuery(StockNum As String, Year As String, Make As String, Model As String, Color As String, Location As String, TiresNeeded As Boolean, StockIn As Date?, SvcRONum As String, UCIStartDate As Date?, UCIEstCompleteDate As Date?, Repairs As Boolean, CollisionRONum As String, Detail As Date?, Other As String, OnLot As Boolean, OffProperty As Boolean, Sold As Boolean, Original_RecNum As Integer) As Integer'
The PK column in this DB is recNum. Here is a snippet of the code:
Code:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
getData(Request.QueryString("param1"))
End Sub
Private Sub getData(ByVal user As String)
'declare variables to fill
[Code] ......
I am trying to add "Select Scope_Identity()" to my table adapter but vs2010 respond with "Unable to parse query text." error message.
Code for Insert SQL is -
INSERT INTO orders
(creditAutorizarionNumber, OrderName, OrderPersonPhone, OrderPersonEmail)
VALUES (@creditAutorizarionNumber,@OrderName,@OrderPersonPhone,@OrderPersonEmail)
I tried to add -
;Select Scope_Identity()
How can I use the Scope_Identity() withing a BLL table adapter ?
I have a strange issue. I have a XSD file where I have created some TableAdapters. When I have reopened the XSD file it seems like I am not able to create a new table adapter since all the options which will come when I right click on the XSD file are disabled. I have cross verified whether I am on debugging mode but...I was not..(I am not even able to drag and drop an adapter from the left toolbox menu either)I am getting the same issue when I open the same XSD file on somebody else machine but I am able to create TableAdaperts in other XSDs.Can somebody suggest me a solution for this
View 5 Repliesi have a store procedure that load data in a table of SQL SERVER 2008 from an excel file.the issue is, that the excel file have a column of DATE type, and i want that the system interprets the format in it, no matter what comes in it.dd/MM/yyyy mm/dd/yyyyi have an argue about this with my parnerts, cause i think is imposible, if you don't have a format before the process runs.
View 3 Replies