Rahul_1980's Q&A profile

• .NET Development Database insert data problem

  SYMPTOMS The CommandBuilder object may rebuild a command that you try to modify during the next call to the DataAdapter.Update method, and your changes to the command may be lost. This problem occurs under the following circumstances: ? If you associate a CommandBuilder object with a DataAdapter object. ? If you use the GetInsertCommand , GetUpdateCommand , or GetDeleteCommand method of the CommandBuilder object to explicitly assign commands to the DataAdapter . ? If you modify one of the commands that CommandBuilder generates. When you try to call the Update method of the DataAdapter , you may receive the following error message: An unhandled exception of type 'System.Data.SqlClient.SqlException ...Show All

• Windows Forms Datagrid Paging alignment

  I have a problem. When i place a DataGrid on an aspx page in Visual Studio 2005 the page no comes to the extreme left of the page. I tried changing the alignment to right or center but still it is displayed in the same manner. If any body has a solution please let me know Hi, Thanx for having patience and answering a rite qn in a wrong place. The environmnet details are as follows: IDE:VS 2005 Dot Net version :ASP.Net 2.0 Browser: IE 6.0 OS:Windows 2003 server The sample code is as follows <asp:datagrid id="dgdArticles" runat="server" OnPageIndexChanged="ArticlePageChange" OnItemDataBound="FormatArticlesGrid" AllowPaging="True" BackColor=" ...Show All

• SQL Server Table Column Comparison Transform

  Is there a transform available which allows you to specify two different tables (same primary key) and compare columns (you identify which column(s) values need to be compared in the transform) between those two tables thanks Hi J.A.J. Simple answer: I am unaware of a transformation that accomplishes this. I usually accomplish this with two transforms: the merge join and conditional split. After loading the pipeline with rows from both sources, I use a merge join to build them into one long row. Then, in the conditional split you can compare each field with expressions i.e. Src.ColumnA != Dest.ColumnA. Hope this helps, Andy ...Show All

• Visual Basic Best Practices

  I was self-taught in programming client/server programs a long time ago. I'm to the point where I'd like to really follow some best practices where I think I am currently not. Please answer me a few questions. 1.) If I have program where certain parts are role based (such as users can only access certain reports depending on their level), do I assign global variables when the user loads the application or do I call the database at the time they try to access the report. In a sense, what are the best practices regarding global variables 2.) I use classes alot for processing data (encryption classes, validation classes, etc) But I don't use classes for storing data. Why do people use classes for storing data Wouldn't that be akin t ...Show All

• Visual Studio Express Editions Saving and Loading from a lot of textboxes

  I have around 100 or so textboxes that I need to save from. I have no clue how to save, and I've tried looking it up, but only ended up more confused. Thanks for any help. If they are single line textboxes, something like this may work for you: Private Sub Button2_Click( ByVal sender As System.Object, _ ByVal e As System.EventArgs) Handles Button2.Click Dim sbu As New System.Text.StringBuilder ' this example only uses 4 textboxes For x As Integer = 1 To 4 sbu.Append( Me .Controls( "textbox" & x.ToString).Text) sbu.AppendLine() Next ' Save to a file System.IO.File.WriteAllText( "c:\test.txt" ...Show All

• Visual C++ Export DLL to run with rundll

  Hi, I Want to export a function wrriten in C++ i write a simple program extern "C" __declspec( dllexport ) int  myFunc(int x){       x = x +1;       return x; }   when i run the command rundll32.exe dllName.dll,myFunc 5 I can see that the x is not 5 as i expected. How can I recice a arguments to the dll (not only int, can be char *) Please see the following link for information on how to define your entry point for use by rundll32: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=180170&SiteID=1 Ronald Laeremans Visual C++ Team ...Show All

• Visual Studio Express Editions need help

  Hi EXperts... i am new to vc++.i am using vc++ 2005.i want to draw graph using mschart. will some one help and guide me.i am compiling using Clr. Thank you all in advance. hello Re: need help Search "mschart" in MSDN or Google and hopefully you will get some hints. have a nice day bite ...Show All

• Visual Studio Express Editions Search a database with a textbox and button

  I have seen this question asked many times but none of the previous answers are helping me.   I would like to have a search page with a textbox and a button. When the button is hit the text entered in the textbox would search a result page with a gridview for items containing the textbox string. I am confused by the many ways to carry the data over from the first page to the next. As well as how to contruct the SelectCommand to filter using the textbox string.   My gridview uses a thing like this right now, ProviderName =" <%$ ConnectionStrings:Database.ProviderName %> " SelectCommand ="SELECT descript AS Description FROM master WHERE (descript LIKE '%' + + '%')"> < SelectParameters & ...Show All

• Visual Studio Express Editions about sqlconnection?

  hi gud day ppol.... i have a problem regarding sqlconnection for example dim theConnectionString as new sqlclient.sqlconnection(" what's NEXT "no idea"") thx in advance... sorry for stupid question So u mean is i should input the corresponding connectionstrings depends on my database for example MSAccess OLE DB, OleDbConnection (.NET) " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = C:\mydatabase.mdb ; UserId = admin ; Password = ;" ...Show All

• Microsoft ISV Community Center Forums Getting Access Data into Excel

  I need to get a large number of Access 2000 Recordsets into Excel 2000 for evaluation. I have no problem setting up the connection and getting the entire table into Excel for testing by modifying the examples at   http://support.microsoft.com/kb/247412/EN-US/ using either the QueryTable or ADO code outlined there. The tables I need to access have over 200,000 records so getting the entire table is not an answer in this case. The SQL statement is complicated and changes 125 times in the course of the whole procedure. Sample SQL generated by Microsoft Query by building the Query in design mode and then changing to View SQL (The Access Query SQL is slightly different it the query is built in Access): ...Show All

• Visual C++ operator[](ptrdiff_t) and operator T* : ambiguity

  Hi All, I have the following simple code: class MyClassOne { }; template < typename _Ty> class MyClassTwo { public : operator MyClassOne* (); operator const _Ty* const (); _Ty& operator []( const ptrdiff_t index); }; int _tmain( int argc, _TCHAR* argv[]) { MyClassTwo< long > instance; instance[0] = 123; // example #1. will compile fine instance[0L] = 123; // example #2. will give the following C2666 error: /* Error 1 error C2666: 'MyClassTwo<_Ty>::operator []' : 3 overloads have similar conversions <skipped> test.cpp 22 */ return 0; } I am aware of the problem with ambiguity of overloading of T* and [] operators in C++ standard: that's why they introduced ptrdiff_t parameters fo ...Show All

• Visual Basic Which set of code is more efficient?

  Hi, I'm trying to optimize my code for a VB.NET/Microsoft Access Project and I'm wondering if someone could confirm for me which snippet of code is more efficient. Both snippets successfully do the same thing. Stored Procedures would probably be better if I was using SQL, but I don't think I can really use those in Access (although I could create a query, but would that be better ) A) counter4 = 0 For counter1 = 0 To DsPredicted.Predicted.Count If cboPredictedBloomName.Text = DsPredicted.Predicted.Item(counter1).BloomID And cboActualStartDate.Text = DsPredicted.Predicted.Item(counter1).StartDate Then strgotme(counter4) = DsPredicted.Predicted.Item(counter1).Location End If Next B) 'Connectio ...Show All

• Visual Studio file Checked in VSS has extra characters at the end of each line

  hi all, I encounter a problem when I do a build from the VSS. it shows there are lots of errors for file aa.aspx.cs. But the project runs well agains the VS 2005 (C#). I "view"(from VSS) that file in the VS 2005, and I found that at the end of each line there are two unknown characters, just like this: using System; using System.Collections; but if I use source safe editor to view this file, there's no such character in the file; but every character ocupies two spaces, and there is a empty line between two code lines, just like this: u s i n g ... ... there's a symbol "▲" in the file aa.aspx, and when I added this symbol and ran my project, a message showed that the file's coding format ...Show All

• Visual Studio Getting "EXECUTE permission denied on object 'sp_sdidebug', database 'master', owner 'dbo'"

  Hi, We just migrated to VS.Net 2005 and running into this issue during debugging. The problem is that when I run our app in debug mode, we get an error that says "EXECUTE permission denied on object 'sp_sdidebug', database 'master', owner 'dbo'". We never had this issue before when we worked with VS.Net 2003. I did some research about the issue. There are people believe that this is caused by having "Enable SQL Server debug" checked in the project property. But I double checked and none of our projects has that set. What's more strange is that when I go to the "master" table of the database I am accessing, there is no stored procedure named 'sp_sdidebug' in there at all! So I can't even add user/permissions ...Show All

• SQL Server RS Databases missing following successful install

  I've installed 2005 / RS on my testing server several times, no problem. My production server throws an error when Reporting Services is installed. There are a few threads on this error: Microsoft SQL Server 2005 Reporting Services -- Error 29528. The setup has encountered an unexpected error while Setting reporting service and share point exclusion path. The error is: Fatal error during installation. I've Googled several similar complaints which discuss any of: Ensure IIS default web site is set to "All Unassigned" Ip [/*] Delete the RS Web services pool and retry [/*] Install RS separately [/*] The first two do nothing for the problem. While installing RS separately doesn't generate an error, it also doesn't create the ...Show All