goflorin's Q&A profile

• Visual Studio Express Editions Is this Optimistic Concurrency

  Is this Optimistic Concurrency: Table Contain 3 Columns: Form Contain: 2 Grid Control ID Name St 1 A 10 2 B 20 3 C 30 4 D 40 5 E 50 Now, User 1 access the ID 1 and adding the 4 St into First Grid I am showing the detail of ID 1 into the Second Grid like below mention: ID Name St Exists 1 A 10 Rest 1 A 14 At the same time I am saving the Rest row into DataTable [ DtUpdate ] that would be update into Database using Store Proc ...Show All

• SQL Server SQL Server 2005 Replication to Internet Provider (Hoster)

  I have a question and bear with me because I am pretty new to this topic. I have a SQL SERVER 2005 with a Client Server Application. Now I want to add a Webinterface. Sinice there is no infrastructure for hosting our own server. I want to go to an external hoster/provider. Now my question is it possiple to replicate a snap-shot of the database to an web hoster If yes, what does my hosting package requieres beside SQL SERVER and ASP.NET. Any Services and open ports What about Security When I replicate via push Service from my local SQL SERVER do I have to have a tunnel to the provider Or external network access to my network via VPN. Or is there a way of doing it via HTTP HTTPS (I think I saw some settings about FTP replication. ...Show All

• Visual Studio 2008 (Pre-release) How to start ? Where to start?

  Hi all, .Net 3.0 RC1 is out and i was curious on how to start learning the new technologies such as avalon. So downloaded .net 3.0 RC1 and the Windows SDK corresponding to the release (still dowloading it .. it's HUGE .... :S. IS that all i have to do is there anything else i have to install anything for visual studio 2005 I've seen somewhere ... Visual Studio 2005 Extensions ..... do i need that Do i need anything else Thanks for the help! I have - visual studio pro version 8.0.50727-42 (RTM.050727-4200) - .NET 3.0 RC1 - Windows SDK I checked the sdk documentation and downloaded the Blackjac demo .. i tried to open it with VS ... but it doesn't work .. it says .. the project type is not supported by ...Show All

• Smart Device Development ActiveSync 4.0 + iPAQ hx2110 WM5 - not compatible

  Hi! I'm using: Win XP SP2, AS 4.0, iPAQ 2110 WM5. After plug-in iPAQ to USB ActiveSync activated and wrote "Connecting..." and this never finished; iPAQ recognized as "Network adapter" and visible in "My computer" like "Mobile Device", but I can't explore it. I turned-off Windows Firewall already but stil not working... Please see if this helps: http://www.microsoft.com/windowsmobile/help/activesync/default.mspx ...Show All

• SQL Server How to rebuild the master database.?

  Installed SQLSERVER 2005 EVAL copy in my server and trying to rebuild the master database and it is not working. I tried the following command. start /wait setup.exe /qn INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=RAJESH Any thoughts Thanks First off, can you help me understand why you need to rebuild master instead of restoring from backup Rebuilding master is typically done when it is too corrupt to allow the instance to start. If the instance is running, that would probably prevent the procedure above from working. It isn't intended for running instances. If your instance is down and it still doesn't work, please post the exact error message and we'll see what we can fin ...Show All

• SQL Server Add runtime rows to sql express database

  Hi All, I have a c# project with an sql express database which is bound to a datagridview via a dataset. I would like to allow the users to import data into the database from a text file. How does one go about adding rows and filling in the column data programatically Do I add the to datagridview the database the bindingsource Thank you, Paul hi Paul, it depends on your requirements.. you can direclty load the database via BULK INSERT statement like in http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=723808&SiteID=1 .... or you can read the flat file and parse it, loading a visual UI to be presented to the user for further manipulation, and finally load the destination database. ...Show All

• Visual Basic Can't kill Excel.Exe after using Excel component in vb.net

  Hi , I'm using Excel.Application generating excel report via vb.net 2003 , the problem is excel.exe process reminds even after generated excel report closed . I have been using the followed code to close or dispose the process , but it does'nt work either. thenks Dim procList() As Process = Process.GetProcesses() Dim k As Integer For k = 0 To procList.GetUpperBound(0) Step k + 1 If procList(k).ProcessName = "EXCEL" Then procList(k).Close() procList(k).Dispose() End If Next I strongly agree with Denton! Every other approach is a waste of time and energy. This is simple and effective. Denton wrote: Decl ...Show All

• SQL Server storing a list in a database table (messaging queue?)

  hey all you database guru's hopefully someone can lend some insight as to a little table design problem I have. Basically I've got a system in place to authorize users to access a website typical username password stuff. The table contains a list of users and there passwords plus the auth level and a few other tid bits that aren't really important enough to into detail about them here. What I want to do is add a messaging system to this, I think I could probably figure out a way to do this half decent if I setup a seperate table for each user to add a row to the table for every message entry than in my asp.net code have it delete everything but the last 10 entries every time a user logs on. However I would much prefer a way that I didn't h ...Show All

• Visual Studio Team System how to tf checkin multiple files

  Hi, Has anyone successful "tf.exe checkin" multiple files I get the following error when I try : "Target AfterCompile: "C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\..\tf.exe" checkin /noprompt C:\DMDB_CODE\MARS Branch Project\DailyBuild\BuildType\..\Sources\daily build\MARS_Platform\UnitTestFramework\TestSupportFramework\TestSupportFrameworkTest\Properties\AssemblyInfo.cs C:\DMDB_CODE\MARS Branch Project\DailyBuild\BuildType\..\Sources\daily build\MARS_Platform\UnitTestFramework\TestSupportFramework\TestSupportTest\Properties\AssemblyInfo.cs C:\DMDB_CODE\MARS Branch Project\DailyBuild\BuildType\..\Sources\daily build\MARS_Platform\UnitTestFramework\TestSupportFramework\Valid ...Show All

• SQL Server Setting up SQL Server 2005 with Source Safe

  My manager has asked me to install and configure Source Safe so that our team can check out stored procedures, (and other objects), and check them back in when we are finished working on them. I'm not familiar with Visual Source Safe. Does SQL Server 2005 work with Visual Source Safe in such a way that I can check out/in SQL Server objects such as procedures If someone knows the answer, or perhaps an existing thread that covers this, please let me know. Thank you for your time! Frank Yes you can configure source safe to work with the SQL Server 2005 system, the Management studio has ioptions to configure the source safe system to use. You can get to these options from the tools -> Opti ...Show All

• Visual Basic Saving into Excel. If exists Excel. How to open a worksheet. How to edit or format some cells in a worksheet.

  I know i can save text files into text documents, but can i save them into excel spreadsheets IceAngel89, I have no idea if you can save text into excel spreadsheets but you can get a excel spreadsheet built into your program and you'll be able to save it through that I believe. Not fully sure on it. Regards, AliQ ...Show All

• .NET Development Dataview.Sort not working.

  This is weird. I have a DataView that I create from a DataTable like this: ------------------------------------------------------- DataView masterDv = new DataView(masterTable); ------------------------------------------------------- Column #12 is called 'CLIENT': ------------------------------------------------------- masterDv.Table.Columns[12].ColumnName="CLIENT" ------------------------------------------------------- When I set the sort property of the DataView, the Dataview doesn't change. masterDv.Sort = "CLIENT"; ------------------------------------------------------- Am i missing something thanks. doug I cannot set the Defaul ...Show All

• SQL Server Access a database from a client application

  Hi all... I am writing a Windows Application which will be used by about 100 clients. (NT Authenticated) The application is going to be used in a LAN enviroment. User who have access will download a VB.NET application from a web site. Of course, I want to prevent any of the 100 users from using a tool such as Query Analysis or ODBC to connect directly to the database and modify data. So, it appears the way to go is to the "Application Roles". For this to work, the application roll password has to be saved in the application to execute the sp_setapprole procedure. Is there a way to secure this password I am worried about a user somehow extracting the password from the application and connecting directly. Am I on ...Show All

• Windows Forms How to deal with Apostrophe in access + C#

  hellow, Following is my code : BINDING DATA TO DROPDOWNLIST private void Page_Load( object sender, System.EventArgs e) { if (!Page.IsPostBack) { ddlcategoryname.Items.Add("<--Select Product Category-->"); conn.Open(); string query="select * from tblproducts"; OleDbDataAdapter da= new OleDbDataAdapter(query,conn); DataSet ds= new DataSet(); DataRow dr; DataTable dt= new DataTable(); da.Fill(ds); dt=ds.Tables[0]; for ( int i=0;i<=dt.Rows.Count-1;i++) { dr=dt.Rows ; ddlcategoryname.Items.Add(Convert.ToString(dr["productname"])); } conn.Close(); } } AND IN THE DROPDOWNLIST'S SELECTED INDEX CHANGE EVENT ...Show All

• Visual Studio 2008 (Pre-release) Exceptions and WCF

  Hey! I have read the msdn documentation on handling faults in WSF but can’t get it to work. I have the fallowing Interface fore the service: [ServiceContract(SessionMode = SessionMode.Required, CallbackContract = typeof(IChatChangeHandler))] public interface IChatChangePub { [OperationContract(IsOneWay = false, IsInitiating = true)] bool subscribe(string inNickName); [OperationContract(IsOneWay = false, IsInitiating = true)] void unsubscribe(); [OperationContract] [FaultContract(typeof(userListFault))] List<string> getUserList(string inNickName); [OperationContract(IsOneWay = true)] void publishChatMessage(chatMessage inMessage); } As you can see i am using a costum faultExcetion(userListFault) that lo ...Show All