Answer Questions

• FassaBortolo How to do with wildcard search!

  Hi all! I was looking to biuld sql statemenet where a wildcard search should be included on one of the criteria/field. For example if I gave words like " search " " searchs " and " search's " it should return all the values under that specific field having all or two or one of these words. Would you mind helping me how to construct the sql statemenets please Thank you in advance. Use the like operator: http://msdn.microsoft.com/library/default.asp url=/library/en-us/tsqlref/ts_la-lz_115x.asp Select * FROM MyTable Where (TheSearchField Like "search%") Than you for your response but still the problem is: What if you didn't know what is going to be given as an input ...Show All

• Faisalee ListBox Control

  Hi All I want to insert the listbox items in the database table using a Stored procedure. Any help will be useful Thanks!!!!!!!1   Hi Thanks for replying, but I want to do it using a Stored Proc. But I am not able to do it, as the data type of var0 and var1 is int and from here it is picking up string, and it just picks up the 1st value from the listbox Dim attr0param, attr1param As SqlParameter Dim objCmd As New SqlCommand objConn.Open() objCmd.Connection = objConn objCmd.CommandType = CommandType.StoredProcedure objCmd.CommandText = "s_Proc" Dim  i As Integer For i= 0 To lbNames.Items.Count - 1 attr0param = objCmd.Para ...Show All

• AlexBB getting current element id node for select

  i have an xml file in my web project so i need edit some of them when user wants and i write codes like this; public void EditAnnouncement( int intAnnID, string strAnnTitle, string strAnnBody) { XmlDocument annDoc = new XmlDocument (); annDoc.Load( HttpContext .Current.Server.MapPath( "~/App_Data/Announcement.xml" )); string xpathExpression = string .Format( "//annPanel/ann[annID={0}]" , intAnnID); XmlNode ann = annDoc.SelectSingleNode(xpathExpression); if (ann == null ) { throw new Exception ( string .Format( "Element 'ann' with id ='{0}' not found" ), intAnnID); } XmlElement annTitle = ( XmlElement )ann.SelectSingleNode( "annTitle" ); annTitle.InnerText = strAnnTitle; Xm ...Show All

• Dark Pontiac Filling data from SQL

  Hi friends, In my  application, I use a DataTable called   "Objects" , I fill this table from a  data table called  "tblObjects"  which is in an SQL Server database. There are other users can access to this database and can make changes on the table "tblObjects".  Therefore everytime I work with the data table "Objects", I have to refill my "Objects" data table to ensure that i'm working with the current data. But this proccess takes a long time, it slows down my application, it brings extra weight to the network and the Server.  If I could check that if  the table  "tblObject" (from the server) is changed or not , I could avoid this extra weight. I ...Show All

• Akshay Saini Binding Data retrieved from text file to textbox

  In my following code example everything is running peachy except for when I'm trying to tie results[l] = rprtARR .ToString() I keep getting a null exception. I tried declaring string[] results = null; but that did no help to me. Obviously I'm a novice but I've been working my way through this thing. I am coming from developing in Visual Basic so I'm pretty rough around the edges. Thanks in advance for the help and here is the code: private void panelComboBox_SelectedChangeCommitted(object sender, EventArgs e) { using (StreamReader sr = new StreamReader(@"C:\LS.rpt", Encoding.GetEncoding(437))) { char delim = ' '; string entry; string panel = panelComboBox.SelectedItem.ToString(); st ...Show All

• bilalso Coding a for loop for multiple threading and automatically timing out long running threads.

  I know most programmers including me could work out a solution for this, but I was thinking that there may be features built into .net2005 which cover this functionality in a neat way. I haven't done much threading before but have a serious timescale pressure so any help you can give with this would be appreciated... I need the following pseudo code: dim th(10) as threading.thread for each obj in collection ' collection has perhaps 5000 elements ' terminate any threads that have been running longer than their timeout - say 60 seconds ' pick up the first available thread, or sleep if there are no available threads. ' execute that thread to process obj t.Execute(normal, AddressOf mysub, obj) next I was w ...Show All

• Logica Requirement on Html Anchors or Asp Hyperlinks using XML dynamically

  Hi, This is an requirement on my project. I am building all the .net controls dynamically by using an XML file and parsing it using an XSLT. Now i need to create a asp hyperlink or an html anchor. Am not very clear on how to proceed in creating anchor tags dynamically. Could any one please help me out so as how to create them in an XML file and parse it using XSLT. Thanks in advance. Regards, TIG. Can you explain what you mean What is your input (given, known data) What is the wanted output (result) Cheers, Dimitre Novatchev TIG_TIG wrote: Hi, This is an requirement on my project. I am building all the .net controls dynamically by using a ...Show All

• limssd Detect Console / Win app

  Is there a way to detect from a dll what was the calling ontext Was it console app or win app Thanks Avi I thought of another way, looking at the properties of the EXE's main window. Specifically the class name. If it is a console mode program, the main window's class name is "ConsoleWindowClass". I'm not sure how reliable that is but it is nice and quick: <DllImport("user32.dll", SetLastError:=True)> _ Private Function RealGetWindowClass(ByVal hWnd As IntPtr, _ ByVal lpString As StringBuilder, _ ByVal nMaxCount As Integer) As Integer End Function Public Function IsConsoleApp() As Boolean Dim proc As Proces ...Show All

• Jassim Rahma How to make comunication between two different EXE (or DLL) projects by COM+?

  Hi all, please does anybody knows how to create in VB.Net (or C#.Net) COM class which should make communication between two different projects I would like to have for example : App_A which will has something like : .... Dim objGate as object objGate = CreateObject("ComGate.GateOne") objGate.FoundError(err.description) ..... App_B which will has something like: Public Class AnalyseError private withevents objGate as ComGate.GateOne public sub Start() objGate = ("ComGate.GateOne") objGate.CatchAllError() 'After this row, will COM app start sending all errors which will found in App_A to App_B by OnErrorFound event end sub ...Show All

• Shan McArthur References :release vs. debug

  Background: I have a c++ class library with CLR support. It has been built for both release and debug. I added a reference to this class library from my C# windows application project by browsing to the class library's bin\debug folder and picking the class library's dll folder there. Once my C# windows app was ready for release, the references still point to the debug folder of my class library - no matter which configuration is the active one for my windows app. Question: How do I reference the debug class library from my debug windows app, and reference the release class library from my release windows app That's not how it works. Select the reference in References node of the Solution Explore ...Show All

• Greenstrike Read Write multi string into - from xml file

  Hi, i have an xml file which i read from and write to for example: <items> <item>MYVALUE</item> </items> now the things is that i want to keep in MYVALUE a couple of null terminated strings,but i dont want to keep them like this: <item>string 1</item> <item>string 2</item> i want them all in one item element. string[] myStrs = { "str1","str2" } how to: 1. write a string array into xml file 2. read a string array from xml file Best Regards. In creating an element for each item of a collection is not desirable, one can always use a single string which is <somechar-or-string-separated-list>. Examples are comma separated values (CSV), or using any other cha ...Show All

• Binumohan How to display text on imagebutton that contains image

  The text on image button will come dynamically... I totoly agreed with Indian Ocean's opinion,you can use text link while there is backgroud picture.I think maybe in this way you will get what you want. however ,this is ASP.NET question....... I think its not possible. But you can try overriding Render method. and may be it can help you to alter the rendered HTML to do your task, else i am not figuring out any other way. Also, this is ASP.NET question, so you should post this on http://forums.asp.net - may be someone can guide you better. HTH, Hi, One other idea would be creating image on the fly-dynamically which contains text itself.. if its possible in your case HTH, you can use the gdi+ method ...Show All

• Chris Honcoop Frame of 1024 bytes for HTTPWEBREQUEST

  Hello ! I develop a program which upload a file (max 10Mo) to a server with POST METHOD. For little files, there is no problem. But for files of 6Mo and more, the upload don't finish. I think that I upload data too quickly. With Ethereal, I saw my data. There is a frame of 1452 bytes, after a frame of 96 bytes (or diffrent size), another of 1452 etc... Another software (perhaps writted in C/C++) upload the data with frames of 1024 bytes. And it works perfectly. How can I change the data buffer of TCP in .NET 2 Can I make frame of 1024 bytes I can change the MTU in regedit, but I don't think that it's the solution. I tried to change the length of "content" of my stream "rs" but no change. I post a little part of my ...Show All

• Greg Akins What is the difference between AppDomain.CreateInstanceFrom and AppDomain.CreateInstanceFromAndUnwrap ?

  I'm new to appdomain programming and I have no experience with COM+. Could you please tell me what "unwrap" is Thank you very much. From the MSDN documentation for CreateInstanceFromAndUnwrap: "This is a convenience method that combines CreateInstanceFrom and ObjectHandle.Unwrap." CreateInstanceFrom returns an ObjectHandle reference, which wraps the underlying object. This ObjectHandle can be passed around, but to actually use the object you have created, you have to Unwrap it. CreateInstanceFromAndUnwrap combines these two methods. I see. Anyway, what is the advantage of ObjectHandle In which cases that we need ObjectHandle Does it has something to do with lifetime management in remote machi ...Show All

• Escobar4Life .NET Framwork 3.0

  After I install .NET Framework 3.0 update from MS site, I am unable to open my McAfee security center. I can’t even uninstall it from Control Panel (nothing happens when click change/remove button). Anyone knows why TX After a series of trials and errors, it is NOT the .NET Framework 3.0 update that causes the problem, it is the Root Certificate update for IE 7 that disables the McAfee Security Center and blocks internet access. Don’t download the Root Certificate update for now. ...Show All