vijil's Q&A profile
SQL Server error 4064 help me please
TITLE: Microsoft SQL Server Management Studio ------------------------------ No se puede abrir la base de datos predeterminada del usuario. Error de inicio de sesion. Error de inicio de sesion del usuario 'HOME\jortega'. (Microsoft SQL Server, Error: 4064) For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=4064&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ Have a look at the following thread: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=451657&SiteID=1 Thanks Laurentiu ...Show All
Visual Studio Tools for Office Help: How to add keyboard shortcuts to Excel Custom Menu and Menu Items
I can't figure out for the life of me how to assign a keyboard shortcut to a custom toolbar in Excel. I am using C# and have successfully added the toolbar with menuItems but can't find a method or property to allow me to accept the actual keyboard shortcut and execute code. Any ideas I am using CommandBar, CommandBarControl, and CommandBarButton. Cindy was absolutely right. In VSTO project: Set a shortcut key and attach a VAB macro to it: //Ctrl+E activates the macro: LoadEntityManager Application.OnKey(“^e”,”LoadEntityManager”); You can assign a shortcut key from Excel. Go to Tools -->> Macro -->> Macros..-->>Option. In VBA: Create the macro: LoadEntityMan ...Show All
Windows Forms TableAdapter Configuration Wizard Question
Hi, Why can't i use the "Create methods to send updates directly to the database" Can somebody tell what i'm doing wrong... My query is verry simple like SELECT * FROM table.... Moving from .NET Framework Data Access and Storage to Windows Forms Data Controls and Databinding . ...Show All
Windows Forms WebBrowser Using CSS
I have a webbrowser control, and I am passing it the following data: string HTML = "" ; HTML += "<html><head><title>Test Page</title><link rel=\"stylesheet\" type=\"text/css\" href=\"Style.css\" /></head>" ; HTML += "<body>" ; HTML += "<h2>Hello there</h2><br />" ; HTML += "<table><tr><td><a href=\"\">Row1 Col1</a></td><td>Row1 Col2...</td></tr></table>" ; HTML += "</body>" ; HTML += "</html>" ; web.Document.Body.InnerHtml = HTML; This works fine, and the page disp ...Show All
.NET Development Bad Data Error with Decryption
I'm using TripleDESCryptoServiceProvider to encrypt and decrypt Xml files that are generated on the fly in two different places. In one part I'm allowing a user to download file, an XmlWriter writes to my CryptoStream which writes straight to the Response.OutputStream. Before any writing I call the following Response.Clear(); Response.AddHeader("content-disposition","attachment; filename=myXml.xml"); Response.ContentType = "text/xml"; Response.BufferOutput = true; The browser prompts for download, and everything is fine. I can then upload the file and have an XmlReader read from my CryptoStream which reads from FileUploader.PostedFile.InputStream and everything works fine. Now in the other place, I have an XmlWriter write to my Cry ...Show All
Visual Studio Team System Scenarios assignated to iterations
Hi Independently of each iteration plan also includes a planning cycle in which the team revisits the plan and makes adjustments when I’m making the iteration 0 would I to planning all the scenarios and to set to each iteration If I don’t dot it How can I know if it possible to do all the scenarios in the time project Thanks Javier Hi Javier, If I could understand you correctly, you have some doubts about how to structure the iterations on a project. There is nothing special about iteration 0, only the fact that your team will be capturing more scenarios than later. However, the principle remains the same: you don't plan all the scenarios up front, but just enough to get done at each ...Show All
Visual Studio Express Editions Modifying SQL Data in VBe
Hi, I'm looking for the basic steps of connection to and editing(Add and deleting tables and data) for a SQL Database inside a VBe Project. I've looked around the net (and the MSDN Help Library) with little success on finding something of this nature that's usable. If anyone knows how to do this or a good tutorial showing how to learn to do this that's clear on ALL details, it would be extremely helpful. Hi, First, create the database: Project/Add new item/Sql database (.mdf). Double click on the database in the solution explorer to open it in the Server explorer. Expand the node corresponding to your db, right-click on tables and select Add new table. Then fill the grid with the columns you need and repeat for the other t ...Show All
Visual Studio Express Editions Connect vb express to existing sql2005 developer??
have searched all around can't seem to see how to configure a SQL2005 developer ed so I can use vb express to develop a local front end. keep getting "the user instance login flag is not supported on this version of sql server" I have configured the .net framework via aspnet_regsql.exe. Also I configured the "Machine.config" file. but so far no luck. Selecting sql2005 as the server thru the add new database connection in advanced area yields the error message surely there is away. Thank you both for responses, I have read that it ia possible to configure sql server to recognize "user instances" and that is the sole issue with making a NON_express server able to be used with ...Show All
Visual C# How to code my SQL String Manipulation App in C#
I would like to know the following in regards to my other thread on how I'd possible approach doing this same thing through C#. To me it seems like more work to do this if you are like me and haven't really done client C# and mostly used to ASP.NET C# code but I might as well start, as I could use regex or whatever to strip out stuff and instert or rearrange into our new table: http://forums.microsoft.com/MSDN/showpost.aspx postid=1087366&siteid=1 So I would like advice and specifics from your experience on the following: 1) What type of C# app should I do this in, console or windows form or other and why one vs. the other 2) Ok, fine, I create #1. Now, what type of controls should I use. I plan on reading the data from a s ...Show All
Visual C# how do I insert a row in a table that is in a database???
Hello, I have an existing access database that is integrated into my windows application and displays the current data in a grid view so I know it is connected properly. the dataset is called stockdataDataSet and the table is called stocks. I need the correct to to add a row. I am guessing it will look something like: insert stockdataDataSet.table(AAA,34,1/1/2005); However I can't seem to find the right information on how to do this. Anyone have the basic code snippet Thank you, Toben to add a row to what the dataSet or DataGridView http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=640012&SiteID=1 take a look at that post towards the end on how to add a row of data to the dataSet/DataT ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Texturing problem
Hello, I'm writing my own content importer for my maps. At the moment, I'm able to load all triangles and draw the map but i have a problem with textures. In my importer i load texture like this (it's just a test) : BasicMaterialContent material = new BasicMaterialContent(); String texturePath = Path.GetDirectoryName(filename) + "\\Textures\\wall.jpg"; if (!System.IO.File.Exists(texturePath)) throw new Exception("Texture not found !"); material.Texture = new ExternalReference<TextureContent>(texturePath); Then I apply my texture to a mesh : builder.SetMaterial(material); When I deploy it on xbox360 or run it on my pc, my mesh have a color similar to my texture but it's just a color! I ca ...Show All
Gadgets Capturing Shell.execute return?
Hello, I'm working on my first gadget and have a .exe file that returns a result. I was hoping the script could read that in, but Shell.execute doesn't seem to return anything. The only way around this that I can think of is to have the exe file write an xml file with the result, and then read that. Seems very kludgy. Is there another way Thanks, Frij Have a look at this thread. ...Show All
Visual C# How to transfer color images to grey images using C#
Hi, I am trying to use C# 2.0 and visual studio 2005 to compile a window app or web app. In this app, I have to transfer almost 2,000 colorful images to grey images. I do not know how to do that Anyone can provide a block of simple example for that Thanks a lot. Thanks a lot for your so quick response. The performance is very key for this project. Will "change image attribute to change to Grayscale pictures" be fast Any other ideas or other sample codes Thanks a lot again. ...Show All
Windows Forms tabpage autofill the lenght of the tabcontrol
Hi, I am wondering if anyone knows how to do set the all the tabs in tabcontrol to fit the length on the tabcontrol Here is example to attempt to explain what I mean. Let say I have two lines of tabs and the second line of tabs only has one tab. What I want to know is if it is possible to get that tab to cover all the space to the right or left of it (ie setting the tab to the length of the tabcontrol) Thanks No, that's meant for multi-row tabs. You'd need SizeMode = Fixed and recalculate the tab size based on the control width. Here's a subclassed TabControl that does that. Add a new class to your project and paste the code shown below. Build your program, then drop a FixedTabControl from the ...Show All
SQL Server Multiple rows into single column
I'm working on a Reports and I need to combine data from multiple rows (with the same EventDate) into one comma separated string. This is how the data is at the moment: EmployeeID EventDate 2309 2005-10-01 00:00:00.000 2309 2005-10-01 03:44:50.000 2309 2005-10-01 08:59:00.000 2309 2005-10-01 09:29:44.000 I need it in the following format: EmpID EventDate EventTime 2309 2005-10-01 00:00:00,03:44:50,08:59:00,09:29:44 There is no definite number of EventTime per Employee for a particular EventDate. And i don't want to use Iterative Methods. Thanks & Regards Rajan Another alternative might be something like: declare @mockup table ( EmployeeId integer, EventDate datetime ) insert into @mockup values ...Show All