|
So, I have this project at work and I'm notsure the best way togo about it. Ihave to create some forms to publish on my intranet. Thedata that is input in the forms willneed to be submitted to a sql 2005 Database. I haveclose to500 computers at my company anddo not want to go through the headache of an ODBC connection on each pc...How doI get aroundthis? What program(s) should I use? Please help.... - Changed Typebherbert Wednesday, February 11, 2009 1:08 PM
- Changed TypeSteven.Yu Monday, February 09, 2009 2:10 AM
-
| | bherbert Tuesday, February 03, 2009 2:42 AM | Hi bherbert,
Based on my understanding, you'd like to have alll 500 computers could run the program and all of them could submit data to the database. If so, I advise you to deploy your database ona server, then all the computercouldconnect to the server andsubmit data to it.Could this way be helpful?
IfI misunderstood you, please feel free to let me know.
Best regards,
Steven Yu | | Steven.Yu Thursday, February 05, 2009 11:43 AM | Ok..My sql database is on a server running server 2003...When I finish the forms I am going to publish them on a seperate server...I have set up my SQLdatabase connections within my form...When I publish the forms, will the application remember the DataSource? I have Visual Studio installed only on my pc...Not on the server that the forms are going to be published on. Am I going to need to install it there as well? | | bherbert Thursday, February 05, 2009 5:22 PM | Hi bherbert,
You just need to write your connection string carefully to make the application connect to the dataSource.
The application runningon a local machinecould connect to a datasource on a server.
You could write your connection string like this:
"Data Source=yourServerName(or server IP);Initial Catalog=yourDatabase;Persist Security Info=True;User ID=userId;Password=password"
In this case, only a database on the server is enough. And only anapplication on separate client machine could work well.
If there's any problem, please don't hesitate to tell me.
Best regards,
Steven Yu
| | Steven.Yu Friday, February 06, 2009 5:19 AM |
Hi bherbert,
We are changing the issue type to “Comment�because we are not sure whether your problem has been solved. If you have more time to look at the issue and provide more information, please feel free to change the issue type back to “Question�by clicking options, choosing Change Type and changing the type. If the issue is resolved, we will appreciate it if you can share the solution so that the answer can be found and used by other community members having similar questions.
Thank you!
Best Regards
Stevem Yu | | Steven.Yu Monday, February 09, 2009 2:10 AM | Does any of this look correct....
| <%@PageLanguage="VB"AutoEventWireup="false"CodeFile="Default.aspx.vb"Inherits="_Default"%> |
|
| <!DOCTYPEhtmlPUBLIC"-//W3C//DTDXHTML1.0Transitional//EN""http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
|
| <htmlxmlns="http://www.w3.org/1999/xhtml"> |
| <headrunat="server"> |
| <title>UntitledPage</title> |
| <scriptrunat="server"> |
| SubButton_Click(sAsObject,eAsEventArgs) |
| DimconHelpDeskAsData.SqlClient.SqlConnection |
| DimstrInsertAsString |
| DimcmdInsertAsData.SqlClient.SqlCommand |
| |
| conHelpDesk=NewData.SqlClient.SqlConnection("Server=localhost;UID=sa;PWD=Pa55word;database=Forms") |
| strInsert="InsertintoMove_Totals(_branch,_date,_number)Values(@_branch,@_date,@_number)" |
| cmdInsert=NewData.SqlClient.SqlCommand(strInsert,conHelpDesk) |
| cmdInsert.Parameters.Add("@_branch") |
| cmdInsert.Parameters.Add("@_date") |
| conHelpdesk.Open() |
| cmdINsert.ExecuteNonQuery() |
| conHelpDesk.Close() |
| endsub |
| </script> |
| </head> |
| <body> |
| <formid="form1"runat="server"> |
| <div> |
| </div> |
| <asp:PanelID="Panel1"runat="server"Height="321px"Width="735px"> |
| <br/> |
| <br/> |
| <asp:TextBoxID="_branch"runat="server"></asp:TextBox><br/> |
| <asp:TextBoxID="_date"runat="server"></asp:TextBox><br/> |
| <asp:TextBoxID="_number"runat="server"></asp:TextBox> |
| |
| |
| |
| |
| <br/> |
| <br/> |
| <br/> |
| |
| |
| |
| <asp:ButtonID="Button1"runat="server"Height="36px"Text="Button"Width="136px"/></asp:Panel> |
| </form> |
| </body> |
| </html> |
| | | bherbert Wednesday, February 11, 2009 1:07 PM | Hi bherbert,
Sorry that I reviewed this thread so many days later due to personal issues.
Your code looks correct, you could make a test to validate it.
If there's anything goes wrong, please feel free to let me know.
Best regards,
Steven Yu | | Steven.Yu Friday, February 20, 2009 4:02 AM |
|
index > Windows Forms Designer > Submitting to database