Kiran Pillai's Q&A profile
.NET Development Create table access database?
I have access database,one table Table1 and I wont to create another table but with the same structure as the table Table1 (columns: Broj iksice,Prezime,Ime,Broj indeksa,Broj pohadjanja). I used this code: Dim veza As OleDb.OleDbConnection = New OleDb.OleDbConnection(Global.Diplomski1.My.MySettings.Default.Studenti1Connection) Dim comm As OleDb.OleDbCommand = New OleDb.OleDbCommand("CREATE TABLE Marko ([Broj iksice] DOUBLE PRIMARY KEY UNIQUE, Prezime TEXT(30) NOT NULL, Ime TEXT(30) NOT NULL, [Broj indeksa] TEXT(20), [Broj pohadjanja] INTEGER)", veza) comm.ExecuteNonQuery() for creating table in the database. Code for creating table in the dataset Studenti1Data Private Sub Button6_Click(B ...Show All
.NET Development XmlInclude / SoapInclude error when trying to use custom header
I’m trying to create a .NET web service that talks to a Java web service. The Java web service requires two SOAP envelopes as input parameters and a custom header. I create a class called “qdoc” for the custom header, add a global variable “qdocHeader” ( public qdoc qdocHeader = new qdoc ();) and add the following attribute to my web method: [ WebMethod , SoapHeader ( "qdocHeader" , Direction = SoapHeaderDirection .In), System.Xml.Serialization. XmlInclude ( typeof ( qdoc ))] Every time I make a call to my web method through a browser, I get the following error message: There was an error generating the XML document. System.InvalidOperationException: There was an error generati ...Show All
SQL Server Can a column data type be changed on a replicated table?
On sqlserver 2000 transactional replication: How would I best go about changing a published table's column from smallint to int I could not find anything about it in BOL or MS.com. I do not think EM/Replication Properties allows the change. I suspect I have to run "Alter Table/Column" on the Publisher and each Subscriber the old-fashioned way. Is that true Thanks! In SQL 2000, the only way to do this is to drop the article column, make your change, then re-add the article column. You can do this via sp_repldropcolumn and sp_repladdcolumn. You can find more information about these two procs in Books Online. You can also drop the entire article, make your change, a ...Show All
Visual Studio 2008 (Pre-release) Quick NetMsmqBinding question
Hi guys, I have a quick question about the NetMsmqBinding. I knew the answer to this at one point but managed to forget and now I'm having trouble finding the answer again. For the NetMsmqBinding, the queue needs to be on the Service-side right Can you use a queue on the Client-side or on a third machine Thanks, Ting >>where the Server machine is actually off and the service queue is unreachable or does the Client just get an error about the queue being unavailable in that case MSMQ allows offline, reliable access. So if the Server machine is down it will be stored by the MSMQ infrastructure and later transmitted when the server is available. Journal Queues are what i guess is used to store the ...Show All
SQL Server replacing nodes and sub-trees
Hi, I have an table where I use XML data type to store documents. The following is an example of original document: <!---ORIGINAL DOCUMENT---> <ABC> <xyz>.....</xyz> <xyz>.....</xyz> <gef>.....</gef> <qew>....</qew> </ABC> <!---NEW DOCUMENT---> <ABC> <xyz>.....</xyz> <gef>.....</gef> <reb>....</reb> </ABC> My question is how to update the original document so that the two previous instances of xyz tag are replaced by the new single xyz tag, the original gef tag is replaced by the new gef tag, and the reb tag is added to the original document as it is not not present ...Show All
Windows Forms www.MicrosoftQA.com - Now Online
Be the first to come and join http://www.MicrosoftQA.com . MicrosoftQA is a new place for MCP's MCSA's MCSE's and other MS geeks. Come hang out, discuss and support each other. MicrosoftQA is not a Microsoft hosted website. ...Show All
Visual Studio Team System What Will Happen if a stored procedure is called from defferent client at same instance.
Can you please tell me What Will Happen if a stored procedure is called from defferent client at same instance. If you mean just calling a stored procedure, that should be no problem. If the procedure has to be recompiled it will be shortly locked, but the procedure can be executed by sereral people at the same time. HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All
Visual Studio 2008 (Pre-release) confused of creating an instance c#/xaml
Hi, I have a good grasp of OOP from my Actionscript 2.0 background although I am very new to c# and xaml. I am somewhat confused that I have to create an instance of an object in c# when it already exists in xaml. For example; I create a Storyboard in xaml and call it myStoryboard. If I want to access and manipulate myStoryboard in c# I have to create a new instance of Storyboard before I can set it = to myStoryboard. Why do I have to do this if the instance already exists as it seems to me that I now have an instance of an instance Sorry for the nub question but I just can't seem to fully appreciate the 'why' of this process thank you thank you for your patience the example has been storyboard but I guess this ...Show All
Visual Studio Team System Perforce TS convertor
Hi All, Does anybody know how much work involved to write a Perforce to Team Foundation Version control convertor I don't think such convertor exists yet. Can this be done by use VS SDK Or I will need to write to database directly Any comments would be help. Thanks you all in advance. Hi Robert, Was curious to know whether you have a migration tool from Perforce to TFS. Initially thought of migrating from Perforce to VSS and then migrating it from VSS to TFS, but I couldn't find any such tools. Then I went through this blog and am curious to know whether you have met with any luck Even was thinking about Perforce to Clearcase to TFS methodology, but i had to rule out clearcase for certain rea ...Show All
Visual Studio Sandcastle - How to prevent generation of C++ and VB syntax?
Hello, Is there a way to prevent generation of C++ and VB syntax Thanks a lot! Jose Have you tried removign it from the sandcastle.config file <component type="Microsoft.Ddue.Tools.SyntaxComponent" assembly="..\ProductionTools\BuildComponents.dll"> <syntax input="/document/reference" output="/document/syntax" /> <generators> <generator type="Microsoft.Ddue.Tools.CSharpDeclarationSyntaxGenerator" assembly="..\ProductionTools\SyntaxComponents.dll" /> <generator type="Microsoft.Ddue.Tools.VisualBasicDeclarationSyntaxGenerator" assembly="..\ProductionTools\SyntaxComponents. ...Show All
Windows Forms Recordset problem
Dim Dbase as Database Dim tmpRec as Recordset Set Dbase = OpenDatabase(DbasePath) Set tmpRec = Dbase.CreateRecordset(SqlSelectString) DesiredValue = tmpRec(DesiredField) How can I achieve this in 2005 without having to create and fill TableAdapters, BindingSources etc There are many times when I need to access a single field from the database to ascertain the current VAT percent for example and it appears that this once simple task has been made far more complicated than ever before. Can somebody please give me a simple method of doing this like the simple 5 line VB6 method above. I don't want to create a bindingsource for every table in the database just in case it needs to be queried at some point and I can't fin ...Show All
Visual Studio Express Editions Make my own file type
Hey I was wondering how can I make my own file type And how can I make the file type work with my programs See Creating a File Association for information including registering a file type. ...Show All
Software Development for Windows Vista Some sample about AcivityBind and WorkflowParameterBinding
Can u give me some sample about the usage of WorkflowParameterBinding and ActivityBind I can't any theme about this A WorkflowParameterBinding is used to bind to named parameters like the properties of an invoked workflow. ActivityBind is used to bind an Activity’s property to a variable or another activity’s property. For examples of both do the following: · Create a new workflow library project. · Right click on the default workflow and choose View Code. · Add a property to the workflow like below: string paramOne = string .Empty; public string ParameterOne { get { return this .paramOne; } set { this .paramOne = value ; } } · Add a ...Show All
Visual Studio Express Editions help a noob out!
Okay, here's my problem: When i start a project, then set it aside and work on a new project, I can't go back and edit the ui! anybody know why please help me! I spent 12 hours straight on my web browser to have it uneditable! after loading it drag 'form1.vb' into visual basic and the go edit>>view designer it should all be back and you don't need to do it twice for the same project if you start it again. i don't know why this happens. ...Show All
Visual C# Customizing FileDialog window
Hi all, I'd like to customize the Filedialog window with some new controls. I know I can't derive a form from Filedialog class because it is sealed. I which way I could obtain it Any suggestion or info about it is appreciated TIA, Dario Maybe this helps: http://www.codeproject.com/csharp/GetSaveFileName.asp df=100&forumid=96342&exp=0&select=962159 ...Show All