C#

FirstPrevNext

Re: Web service in asp.net using c# BobJanova15-Apr-11 2:27 BobJanova 15-Apr-11 2:27  Indeed. Both connection strings are absolute paths to things that are on the local machine, and almost certainly won't be in the same place when hosted. Make sure the connection strings in the uploaded version point to where the database actually is (your host should be able to tell you this). And indeed, connection strings should be in a configuration file, so your code base can be the same for testing and deployment. Re: Web service in asp.net using c# akosidandan15-Apr-11 17:29 akosidandan 15-Apr-11 17:29  Hello, I fix now the problem it seems that one causing the error is the bin file of my webservice. I notice that although I edit the code of my asmx file and even if its a working code but if I did not re upload the the bin file of my webservice.The website still load the past code of my asmx rather than the new one. Thanks everyone, DAN Re: Web service in asp.net using c# Dave Kreskowiak15-Apr-11 1:57 Dave Kreskowiak 15-Apr-11 1:57  This code shouldn't even compile. You've got the exact same method (getData) defined twice, with no difference between the two method headers. There has to be some way to deifferentiate the two either by name or by the parameter list. A guide to posting questions on CodeProject[^] Dave Kreskowiak Re: Web service in asp.net using c# akosidandan15-Apr-11 2:05 akosidandan 15-Apr-11 2:05  Hello, Sorry for the confusing part. I was trying to test only if how it work by commenting other or vice versa in that time thats why I have the two methods. Thanks for the reply. Any help are kindly appreciated. Thanks, DAN Re: Web service in asp.net using c# akosidandan15-Apr-11 17:30 akosidandan 15-Apr-11 17:30  Hello, I fix now the problem it seems that one causing the error is the bin file of my webservice. I notice that although I edit the code of my asmx file and even if its a working but if I did not re upload the the bin file of my webservice.The website still load the past code of my asmx rather than the new one. Thanks everyone, DAN Re: Web service in asp.net using c# Prasanta_Prince15-Apr-11 8:13 Prasanta_Prince 15-Apr-11 8:13  Have a look on the connection string of the MDB file. or use Server.Mappath to get actual path of the mdb file. Re: Web service in asp.net using c# akosidandan15-Apr-11 17:27 akosidandan 15-Apr-11 17:27  Hello, I fix now the problem it seems that one causing the error is the bin file of my webservice. I notice that although I edit the code of my asmx file and even if its a working but if I did not re upload the the bin file of my webservice.The website still load the past code of my asmx rather than the new one. Thanks also for the server.mappath if was a great help to map the path of my files. Thanks everyone, DAN database path arkiboys14-Apr-11 7:27 arkiboys 14-Apr-11 7:27  Hi, On my local machine, I have developed a c# application which reads from a sql server express database. Now I want to install these (The application and the sql server express) on the client machine. On the client machine, with the login I have, I can only have access to the U drive. Questions: 1- Can I install the appplication on the U drive or does it have to be the C drive? 2- I also have to install the sql server express on the client machine. Can It be installed in the U drive? 3- The application has a config file which is used to access the sql server i.e. ./sqlexpress, etc... What should the config file path be if both the application and the sql server express are installed in the U drive? Thank you Re: database path Not Active14-Apr-11 10:03 Not Active 14-Apr-11 10:03  You can install the application where ever you would like, however, there may be components, especially with SQL Express that will require administrator rights. The connection string for SQL Express would be .\SQLExpress, where the dot is shorthand for local. I know the language. I've read a book. - _Madmatt Re: database path arkiboys14-Apr-11 10:50 arkiboys 14-Apr-11 10:50  Yes, the installation of sql server requires the admin rights but does it have to be installed locally into c drive or can I point it to u drive? Thanks Re: database path Not Active14-Apr-11 11:40 Not Active 14-Apr-11 11:40  Once again, you can install the application anywhere. That includes SQL Express, it will default to the c: but you can change that. I know the language. I've read a book. - _Madmatt Re: database path arkiboys14-Apr-11 20:26 arkiboys 14-Apr-11 20:26  Once I install the sql server express on the U drive, then will I be able to access the management studio window from any machine which does not have sql server express installed in it's c drive? Thanks Re: database path Pravin Patil, Mumbai15-Apr-11 0:45 Pravin Patil, Mumbai 15-Apr-11 0:45  Yes, you can... Re: database path Dave Kreskowiak15-Apr-11 1:54 Dave Kreskowiak 15-Apr-11 1:54  No. Every PC that is going to manage that database with the management studio has to have the studio installed. You cannot just install the studio once and run it from anywhere. There are more than a few components that have to be registered on each PC that's going to run the management studio. Once the studio is installed, you can manage the database on the U: drive. A guide to posting questions on CodeProject[^] Dave Kreskowiak Re: database path Prasanta_Prince15-Apr-11 8:15 Prasanta_Prince 15-Apr-11 8:15  If you have the administrator right you can instal at any drive. Re: database path arkiboys15-Apr-11 10:21 arkiboys 15-Apr-11 10:21  Thank you all. beginner question ace30014-Apr-11 7:16 ace300 14-Apr-11 7:16  how can i creat a report button for databse i have in c# Re: beginner question gavindon14-Apr-11 9:08 gavindon 14-Apr-11 9:08  I think a little more information is needed. What do you mean by report button? a button that you click and see a ssrs report? or a report built from gridviews? or crystal? Programming is a race between programmers trying to build bigger and better idiot proof programs, and the universe trying to build bigger and better idiots, so far... the universe is winning. Re: beginner question BobJanova14-Apr-11 22:53 BobJanova 14-Apr-11 22:53  Add a button to your form. Caption it 'Report for Database'. Add an event handler that creates a report. (Seriously, you need to at least make the effort to determine what your problem is. No-one is going to write a reporting system for you.) Re: beginner question Prasanta_Prince15-Apr-11 6:30 Prasanta_Prince 15-Apr-11 6:30  There are two process for report,- 1) Report for Database. . 2) Report for Front end. http://msdn.microsoft.com/en-us/library/ms225593%28v=vs.80%29.aspx[^] http://msdn.microsoft.com/en-us/magazine/cc188691.aspx[^] May be these link helps you. varchar(max) in database - how to put the size in ADO.NET Member 779716714-Apr-11 5:54 Member 7797167 14-Apr-11 5:54  Hi, I have field in database and it is defined as Varchar(max). And in the front in ADO.NET I am trying with the options AddParamToSQLCmd(sqlCmd, "@Comments", SqlDbType.VarChar, -1, ParameterDirection.Input, pArg.Comments); SqlDbType.NVarChar, -1 SqlDbType.VarChar, -1 SqlDbType.NText, -1 and nothing seemed working. I am trying to insert over some 48000 charecters but it is storing only 43500 some charecters. Not sure if I am missing some thing. Am I doing it right or can some one please help me how to get around this issue. Thanks in advance L Re: varchar(max) in database - how to put the size in ADO.NET Ennis Ray Lynch, Jr.14-Apr-11 7:24 Ennis Ray Lynch, Jr. 14-Apr-11 7:24  Varchar max is 8000, Nvarchar is 4000. If you need more than that use text. http://msdn.microsoft.com/en-us/library/ms176089.aspx[^] http://msdn.microsoft.com/en-us/library/ms186939.aspx[^] Need custom software developed? I do custom programming based primarily on MS tools with an emphasis on C# development and consulting. I also do Android Programming as I find it a refreshing break from the MS. "And they, since they Were not the one dead, turned to their affairs" -- Robert Frost Re: varchar(max) in database - how to put the size in ADO.NET Member 779716714-Apr-11 8:46 Member 7797167 14-Apr-11 8:46  I tried with the Text but the same thing it can't store more than 43567 charecters. I also tried updating the Text database field that I just created for testing in the management studio but no luck. For some unknown reason it is storing only 43567 charecteros of text. Any inputs towards fixing this issue is greatly appreciated. Thanks, L Re: varchar(max) in database - how to put the size in ADO.NET jschell14-Apr-11 9:38 jschell 14-Apr-11 9:38  Ennis Ray Lynch, Jr. wrote: Varchar max is 8000, Nvarchar is 4000. If you need more than that use text. Both of those links specifically mention 'varchar(max)' which takes 2 gigs. And the OP is already successfully storing more than 8000 as well. Re: varchar(max) in database - how to put the size in ADO.NET Ennis Ray Lynch, Jr.14-Apr-11 9:52 Ennis Ray Lynch, Jr. 14-Apr-11 9:52  Huh, never actually noticed. I could have sworn MAX was a synonym for 4000 and 8000 respectively. Learn something new everyday. Need custom software developed? I do custom programming based primarily on MS tools with an emphasis on C# development and consulting. I also do Android Programming as I find it a refreshing break from the MS. "And they, since they Were not the one dead, turned to their affairs" -- Robert Frost

Last Visit: 31-Dec-99 18:00     Last Update: 1-May-24 15:23 Refresh ᐊ Prev1...2599260026012602260326042605260626072608 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.