load bcp utility from C# code? I need to do that for .NET 1.1.
I need to move data from a flat file to a database, I was suggested to use BCP. Are there any other options in .NET 1.1?
I am using xsd /c book.xsd to generate the a cs file. THe default cs file will be book.cs. I am wondering what swtich I can add so that i can name the generated cs file as document.cs instead of the default one. I attached the book/xsd and book.cs file, I am wondering why it generated two partial class? Should i name the generated file to match one of the partial class like BookForm.cs?
book.xsd:
[Code]....
Book.cs:
[Code]....
I wants to implement free text search utility for my web project,
to implement greate search utility for free text.
Also i have some knowledge of SQL SERVER 2005's FULL Text utility.
i have contineous data stream and saving in database. database size is growing. as per out data retention policy we have to archieve data and only keep last 6 month data on server.
if archieve data is required in future in current/live database so how do i bring it back.
I have SQL Server Standard 2008 installed on my machine, alongside Visual Studio 2008.
My current hosting provider (not a huge fan) requires me to access my db's remotely via SQL Server Management Utility. To date, I've been doing it by connecting remotely in VS2008. Their troubleshooting documentation/steps, though, are for the SQL Server Management Express 2008, and i'm having a lot of connectivity issues with them.
I followed the steps here: [URL] to "add additional features to an existing installation" - but when I did so, the setup wizard indicated that the Management Tools-Basic were already installed.
I am using 2 data tables one for comparing the i.item-id=dr[datacolumn] and one for storing the result i.item_guid,i.item_description_title. But getting an error at table2.Rows.Add(itemlist) {"Input array is longer than the number of columns in this table."}
DataTable table2 = new DataTable();
foreach (DataRow dr in ds.Rows)
{
foreach (DataColumn dataColumn in ds.Columns)
{
pfDataContext pf = new pFDataContext();
var itemlist = from i in pf.item_tbls where i.item_id == dr[dataColumn].ToString() select new { i.item_guid, i.item_description_title };
table2.Rows.Add(itemlist);
}
}
need to sanity check what I think is correct. If I have some LINQ entity relationships that I create in code thus:-
[Code]....
these would lazy load, by default - correct? And if the first link was changed to
[Code]....
this would also lazy load and defer loading until GetObjectLink() was called, yes?
If I have a DataTable (in-memory) read by my C# program from a flat file, and I want to create it as a new table in a SQL Server database... what is the simplest way to do that?
It seems like something like SqlBulkCopy with an option to create a new destination SQL server table would be on my line of thinking, but I dont see a way.
I am trying to load data from an existing DataTable into a new DataTable. Not sure how to get it started. Do not want to merely copy data, I need to load it in row by row.
protected DataTable GalleryByCat()
{
// GLinks is the new DataTable I want to construct and bind to a DataList, Repeater, ListView
[code]...
When using the DataTable.Load(SQLDataReader) method, if the datatable is a property of a class, the set method is not called to populate the object. For example...
MySQLDataReader = command.ExecuteReader();
if (MySQLDataReader.HasRows)
myObjDataTable.Load(MySQLDataReader); -- The result of this will be 0 rows returned. The "Set" method of the object is never called.
I have a SqlDataSource setup in the markup on my page. After some new requirements, I am trying to find a way to modify the SelectCommand before the data is filled for the first time. The SelectCommand below will now be used by default since we'll always have the first param. I am faced with a need to modify the SelectCommand though, adding a second session parameter along with it. I tried to override the OnInit method but it didn't seem to help...it still used the default query. Is there a best way to accomplish this? Here is the section of markup I am referring to:
[code]....
How to get these all details from an image in asp.net ?
View 1 RepliesI'm writing some software that I have to ensure can only be installed on one machine. The plan is to have them download the application. The first time the application is ran, the app will find this unique value on the machine, encode it, and instruct the client to send it to us to get their license number. Then, of course, the value they gave us will be used to construct a license number that will only work on that machine.
A unique value per machine would be the best, but I'd settle for a unique value per the installation of windows (XP) on their machine.
Is there a utility to combine querystrings? I'm looking for something like:
Input: Combine("test=a&test2=b", "test3=c") Result: "test=a&test2=b&test3=c"
Input: Combine("test=a&test2=b", "") Result: "test=a&test2=b"
Input: Combine("", "test3=c") Result: "test3=c"
And maybe some weird ones:
Input: Combine("&test=a&test2=b", "?test3=c") Result: "test=a&test2=b&test3=c"
I would like to create a webpage that collects a users search criteria. Then when they click a button, send the parameters to the Windows Explorer Search utility and run it. Can this be done? If so, how? I am using asp.net to create my webpages.
View 1 RepliesI think this may be a question for the architecture forum, but it feels a bit newb to me, so here goes.
I'm trying to write a utility class to use throughout my C# ASP.NET websites. I am having trouble getting intellisense to see the methods in my class. What I'm doing is creating a static class and putting it in a namesapce and with a using directive, importing that class into the code-behind of my web form. But it's not working. I would also like to minimize the visibility of the code i.e. use the least accessible access modifier necessary for use in my util class.
[code]....
Can the Microsoft TextTransform utility be used standalone? Since VS2010 is it still true as I can read: [URL] Preprocessed templates to allow embedding of template-based generation in arbitrary applications without a runtime T4 dependency. There is a new custom tool, new service APIs and new engine APIs to support this feature.
View 2 RepliesWhich method would you like to place in tyour common class in asp.net application? A common function which you use in almost all your asp.net project question.
View 5 RepliesI am looking for Backup and Restore . mdf file utility. Is there any opensource application/code available?
View 12 RepliesI have this method that I'm currently putting in each page I make, I know there should be a good way to move it to a single place for ease of maintenance and simplicity. I'm just not sure how I should handle the event handler. The event handler needs to be on each page, so how would I pass in a reference to the page properly so I can reference the event handler?
private void InsertLinkButton(string text, string id, UpdatePanel updateSummary)
{
LinkButton link = new LinkButton();
link.Text = text;
link.Click += new EventHandler(link_Click); <------
link.CausesValidation = false;
AsyncPostBackTrigger trigger = new AsyncPostBackTrigger();
trigger.ControlID = link.ID = "link" + id;
trigger.EventName = "Click";
Utils.Tag(link, placeHolderSummary);
updateSummary.Triggers.Add(trigger);
}
I need to implement Routing or Url-Rewriting in my application. So, is there any utility like logging utility Elmah. I dont want to write much code, I need to configure and start playing.
View 2 Repliesi have designed a website in my desktop and used WAT of visual studio 2008 from Website menu and then selecting ASp.Net configuration.
Now i have copied my website to a server in my local network, server name=isaserver.
i try to access WAT utility of my website at isaserver. when i change webconfig file to correct data source, utility is working but
if i create a user using my website's create user form, then that user appears in aspnetdb database of isaserver but i am not able to see that user using WAT utility.
if i create a user using WAT utility then i am not able to login into my website hosted at isaserver using that username.
no matter how i create a user, either through my website's create user form or through WAT which is mapped to isaserver, both the users will appear in aspnetdb database of isaserver.
I would like to encrypt the connectionstrings section in my web.config file using the : ASPNET_REGIIS utility However I'm running Windows 7 pro, that is without any IIS.
Is it possible for me to do it.
The path (on my local pc) to the website containing the web.config file is like this:
C:UsersmyUserDocumentsVisual Studio 2010ProjectsmyWebsitemyWebsiteWeb.config
I have a class named utility in my App_code folder that holds the logic to set a labels text.
public void Mgr_BreadCrumbs(string text)
{
Manager.MasterPages.Master master = new Manager.MasterPages.Master();
Label lblHeader = (Label)master.FindControl("lblHeader");
lblHeader.Text = text;
}
And then in each of my pages I was trying to set it like this:
utility u = new utility();
u.Mgr_BreadCrumbs("Categories");
I'm getting am object reference not set to an instance of an object on the lblHeader.Text = text; line of code.
I have update panel on the page to avoid postback and placed a dropdownlist control within that update panel. DrodownList is filled with Category names and also it's autopostback set to True.
Now whenever dropdownlist index change's on select, untill page loads complete data it should show mesage as "Loading.... in center and middle of the page and background should become bit transparent". And when page load completely with data then that background and message should get disappear.