Hi, Regards, Satheesh

Hi, We have a table in a SQl Server 2000 database which holds tasks for user generated by an application. We would like to somehow bring these tasks into the outlook tasks of the user. Trying to do this using outlook brings up all those security popup windows. Would anyone be able to tell me know i could do this by directly contacting to the exchange server? Many Thanks

I am trying to develop some code to allow me to enter a new record into an MSSQL table (code is below). Currently this code inserts a record and gives it a new autonumber but does not populate the Title, Firstname or Secondname fields. Any advise greatly appreciated. Protected Sub Button3_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button3.Click localsource.Inser

Hi, Regards, Satheesh

Well, as I often do, I could be missing something, but I don't see where the comparison is in that solution. I agree with doing the job in SQL though; preferably in a stored procedure. What I was going to suggest was to create an extra column via the sql query along the lines of: SELECT ID, DATE_LAST_MODIFIED, DATE_LAST_SENT, CASE WHEN DATE_LAST_SENT > DATE_LAST_MODIFIED

I think you misunderstand a little. You can write code to reorder your DataSet, if you want to. Here's an article about it: But this is all done on the server (the Web server). There is no way you can do it client-side that I know of. Peter -----Original Message----- From: DotNetDevelopment on behalf of shelleybobelly Sent: Tue 7/25/2006 6:45 PM To: DotNetDevelopment, VB.NET, C# .NET, ADO

My solution would be to forget about the service itself doing it. What you need, I think, is a Server activated object hosted by the service. The SAO would have a method that took the list of ids as a parameter and then iterated over the list of ids, creating the appropriate XML file for each iteration. It can either pass the XML back as the return value (maybe a FileStream, or a very long stri

Hi friend.......... Currently i meet many problem in Micorsoft vb dot net 2003.. 1-----My program can not running in window 2000.....Database Error Message Showing. <if i am install in User Window . ,XP...EveryisOk> ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,( i am already install dotnet frame work 1.1.) 2------Vb dot net default Crystal Report are not working ...when i am ins

thanks to all guys it workes!! its great to recieve so many suggestions and solutions.. finally i got able to install SQL SERVER 2000 on my pc.. AGAIN "THANKS TO ALL OF YOU" regards sandeep On 7/20/06, sandeep ahuja <ahuja.bangalore> wrote: Hi every one i installed .net2003 successfully(on my system..WINDOWS XP)..after that while going for installation for sql server2000

Hi, See the Sys Requirement on MS, Regards, Satheesh

Hi All, Installing Microsoft SQL Server 2000 on Windows XP Professional. I'm trying to install Microsoft SQL Server 2000 Standard Edition on a Windows XP Professional. During Installation, I received this message as shown below: "Microsoft SQL Server 2000 Standard Edition server Component is not supported on this operating system. Only client components will be available for installation.&qu

you need to: datagrid1.currentpageindex = e.newPageIndex where e is EventArgs for the OnPageIndexChanged event. then, you must rebind your datagrid. the way you have it set up would work if you bind your datagrid after you increment the current page index, but it would not allow you to go to previous pages

try this MySqlConnection conn=new MySqlConnection("Server=(local);DataBase=Northwind;User Id=root;Password=123456;Pooling=false;"); conn.Open(); Thanks Ravi.P ----- Original Message ----- From: "Amit" <gamitkumar> To: ".NetIndia" <TechdotNetIndia> Sent: Tuesday, July 18, 2006 1:30 PM Subject: Problem with stablish connection with stored procedure

Hello, I'm having some problems with a web application I hope someone can help me. I'm exporting some data to excel, so I used a simple class to do this. If I test the application in my computer (localhost) I don't have any problems to get file, but when I publish the site and I try to download the file it just pop up the Open/Save/Cancel dialog, click the Open or Save option and that's all. The

There might be a cleaner way to do this, but this is a simple way that I have done this in the past. Capture the grid's cell value changed event. What I would then do is cycle into each column to make sure that the user has entered a value. If each cell has a value, then take the row and enter it into the database. Make sure to refresh the values in the grid with the values in the database.

The namespace System.Data.OracleClient has all the objects you need to connect and call stored procedures. And in the property CommmandText you just have to put the name of the stored procedure, this assuming that the stored procedure it's already in the database.

IFAIK you are correct. The OP will also have to add the parameters to the command, I believe. Peter -----Original Message----- From: DotNetDevelopment Re: calling Oracle stored procedure in C#??? Please correct me if I'm wrong, but shouldn't the CommandText property refer to the name of the Stored procedure, instead of SQL statements, when you set the CommandType property to "StoredPr

Cerebrus is correct. You seem to be mixing up two different connections. If you use a MSDE, you can use SQL connections. But if you want to hit an Access database, OleDBConnection is the way to go. Examples can be deadly if you don't fully understand what the example is doing. Make sure you are not just a code copier...it will be your downfall.

Hi, i expecting ur solution. If i solve this problem i will revert back to u. Thanks and warm regards, Kalpesh Raj wrote: I am not sure about XSD but I'll try to find out more abt it. Btw if you find any solution please let me know. Raj

So if I am using sqlConnection with Pooling enabled then in my original example I will have 10 connections (?) Thanks to all!

Raj wrote: Add this line..... Response.ContentType = "application/ms-excel" Response.AddHeader("Content-Disposition", "inline; filename=yourFile.xsl" ); ---> TO STRAIGHT OPEN IN WINDOW OR Response.ContentType = "application/ms-excel" Response.AddHeader("Content-Disposition", "attachment; filename=Report.pdf" ); --->

Hello I have an application witch is detecting a lot of folders with the filesystemwatcher class, it's about 10000 folders and all changes is written to a database and stored. This application is running all the time, but in the night when it's a lot of activities (virus scanning etc) I get the buffer overflow event. Is there anyone who knows how I can reset the buffer during the application is

i have visual studio .net 2005 pro installed and ms sql 2005 server (not express edition). when i want to add new item - > sql database it says i don't have sql server express... visual studio works only with sql server express ?! (on another computer i have the same visual studio and sql server express and i don't have any problems). and another problem i have is when i try to use the 2005 S

try to use Sql-Update command ... bye

Hello Folks, Can anyone suggest me a good book to learn using the Microsoft Enterprise Library Application Blocks. I can only find two books on the net 1. The Definitive Guide to the Microsoft Enterprise Library by Keenan Newton. This book has yet not released 2. Effective Use of Microsoft Enterprise Library : Building Blocks for Creating Enterprise Applications and Services (Microsoft .Net Dev

hi group i want to use variables in my web dot net solution that uses sql server these variables will lindicate dbase tables and feilds , i want to do this and map from my own schema to other one that may be used..how to make this mapping..what kind of file should be written..if you know example please dont hasistat to tell me oabout,sample code thanks in advance

Hi Yuniel First simply install ODBC diver for MySQL in your system(that is available free. you can search on google.com), then using ODBCConnection object of ADO.NET you can connect with MySQL. Hope It'd be usefull to you. Cheers! Mridul

It sounds like you are looking for patterns & practices: Application Blocks /

I've searched pretty thoroughly for a solution to this but haven't had much luck. I have a stored procedure (SQL Server 2000) that returns 5 resultsets, and accepts up to 4 parameters. If I manually code a dataset with table mappings and execute the sproc, the tables fill fine. However, the fields are not available for binding to textboxes, etc. in the IDE. If I try to create a dataset using

im sorry. i cant read english.im frome vietnam.

I am a newbie in website development. I used Visual Studio 2005 to develop an ASP.NET website. The website connects to a SQL Server running locally on my machine. The SQL Server is configured with default settings. The website populates a TreeNode control from a SQL database by querying the SQL Server database locally. When I run my application from within Visual Studio (F5/Ctrl+F5), the website

In case anyone is looking for the same solution, I found one and am posting it here: lq Public Sub GetExcelData(ByVal strPath As String, ByVal intMaxQty As Long) Dim conn As New OleDbConnection Dim salesReader As OleDbDataReader Dim connString As String Dim cmd As New OleDbCommand Dim intCount As Long Dim strE As String Dim strColText As

I am very new to VB.NET so I apologize for my near utter lack of knowledge. I've been developing in VBA for a very long time so I'm hoping this transition won't be too difficult. In an Access mdb database I have created a link to an Excel spreadsheet and then referred to the linked name as if it was a database table, looping through rows in VBA to extract column data. Simple. Is there anyway in

hi group :) i am loking for free hosting wher i can upload my sql db and its related web iste files please if you know one tell me thanks again

Ok I looked at the string returned by the ds.getxml() and all the information is there. So if this is true then what you're saying is that it would be a datagrid property problem... However this is confusing to me because everyother statement like the one that isn't working does work. No settings on the datagrid are changed anywhere in the code, only assignment of a dataset...

Hi! Could you please explain it more precisely with examples. I would be able to help you then. Regards, Nilukshi.T.E From: "h1b" <amitsdeo>Reply-To: DotNetDevelopmentTo: "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" <DotNetDevelopment>Subject: one to many relations in a datagridDate: Fri, 07 Jul 2006 02:54:40 -0000>>hello>>

I'm not familiar with the report viewer control, but if it's a hyperlink, it'll show as a hyperlink in the HTML. Remember server controls just create HTML on the fly - because that's all your browser understands. Peter -----Original Message----- From: DotNetDevelopment Re: Reporting services - Navigation problem I am using a report viewer control. will it show me the link if i view the so

My goal is to apply data entered in multiple text boxes as parameters for sqldatasource filter bound to a datagrid control I have created an asp .net web page. To the page I added datagrid control. The datagrid control getting it's data from sqldatasource. The sqldatasource is defined as a straight select against one table. I have, also, added textbox control to the same page. I have defi

Bradley, Peter wrote: Please. Don't ever put unencrypted user information into config files. The best thing is to use Windows authentication, if that's possible, because that does not involve giving credentials at all. If you can't do that, the next best thing is to store the credentials, encrypted, in machine.config; but this assumes that you can have the same user defined on all your data

thanks.... a good insight ... very similar to that from a QA doctor

I am working on asp.net. I am required to display Username in textbox and Password in another textbox. When I click on username then the password textbox textmode should be changed to Password mode. Can anyone helpme Regards, Sunil

following the link you provided got me to download and install the express edition and all is working as expected now. where the admin tool is configured to look for a particular instance of SQL server, has still got me buffaloed though. at any rate....i appreciate your time....thanks! jen