Comments by marieee - CodeProject

marieee 3-Aug-17 15:04pm View

Thanks! Just one more question. I have to write two different web.config files and save them in app folders?

marieee 3-Aug-17 14:39pm View

Yes, you understood correctly. I have SQL Server running on the same server as my web server, which is IIS. There is already one website with application connected to SQL Server. Now I want to add another application to it. I'm connecting remotely directly to VPS.
The problem with this website you send me like solution is host names. There is, for example, www.contoso.com or marketing.contoso.com. Only address that I have is server name, which is server.mydomain.com and I don't know how to change it in bindings.

marieee 3-Aug-17 11:32am View

Yes, VPS is running IIS. Hosting provider told me that I have to do it myself. Why do you think that my question is unclear?

marieee 1-Aug-17 15:04pm View

My problem is how to implement two app with two different databases in Default website on Virtual Private Server.

marieee 31-Jul-17 13:44pm View

Thanks!

marieee 31-Jul-17 12:38pm View

There is cPanel, but for original mydomain, not for VPS.

marieee 31-Jul-17 11:24am View

We have VPS with SQL Server installed. Hosting provider told me that I have to do it my self. How?! Through IIS and in one site with two app like folders?

marieee 31-Jul-17 5:40am View

Thanks! I have to call my provider.

marieee 25-Feb-17 9:51am View

Deleted

How to edit stored procedure in my question? I forgot to insert field from Table 3.

marieee 22-Feb-17 6:13am View

Now I want to add one listbox, that will display data from third table and insert into fourth (one field would be ID from main table and second is ID from third table). I can do that with datasource or with stored procedure. It's suppose to be multiple selection and problem is how to insert everything in code like this. Any hint?

marieee 21-Feb-17 6:21am View

It works fine, but when I insert data into web form and click on the button to insert into db, data won't clear from fields. Any idea why?

marieee 21-Feb-17 4:31am View

Would it be totally wrong if I insert one more table in this procedure and code?
y

marieee 20-Feb-17 16:05pm View

Thanks for your help.

marieee 20-Feb-17 16:04pm View

Thanks.

marieee 20-Feb-17 15:50pm View

Yes, it's primary key and autogenerated id. Thanks for all your help, I will deal with auto incrementing by 1000.

marieee 20-Feb-17 15:32pm View

I wrote FileUploadImage.SaveAs(Server.MapPath("image/" + FileName)); again and it works. Is there any logical explanation why my ID number is so high? It's suppose to be 20, but it's 1009.

marieee 20-Feb-17 15:16pm View

I don't know. I've tried to create new folder, there's no change. When I use brakepoint on var a = Server.MapPath("~/image/" + FileName); I have FileName, but a is null

marieee 20-Feb-17 13:36pm View

There is image folder,but without this image that I tried to insert.

marieee 20-Feb-17 12:46pm View

I've tried this without break point, it writes ID number where I want, but it's a wired number - 1009. Also, there isn't image in folder

marieee 20-Feb-17 11:59am View

IfI run my code, error is: Procedure or function 'TEST' expects parameter '@FileName', which was not supplied.

marieee 20-Feb-17 11:58am View

FileUploadImage.SaveAs(Server.MapPath("image/" + FileName));

marieee 20-Feb-17 11:53am View

The error is: Could not find a part of the path.

marieee 20-Feb-17 9:17am View

I will try it now.

marieee 20-Feb-17 9:17am View

If I use this procedure and the code that I wrote, error is missed values for fields and I can't use ID from first table in second as foreign key.

marieee 20-Feb-17 9:07am View

Do you have time to look at my code?

marieee 20-Feb-17 8:52am View

My sp works fine in database when I execute it and it's simmilar to yours, but the problem is code and how to write it there.

marieee 20-Feb-17 8:50am View

You think that the solution is to create 2 procedures for two tables and to return data to be stored somewhere using OUTPUT?

marieee 20-Feb-17 8:49am View

Deleted

You think that the solution is to create 2 procedures for two tables and to return data to be visible using OUTPUT? I'll try that.

marieee 20-Feb-17 8:46am View

How?

marieee 20-Feb-17 8:30am View

Stored procedure is functional in database and these two part of the code also, but in the second part of code I can't use Identity from first table and the error is: using of string as value, missed values for fields, too many fields in stored procedure.

marieee 20-Feb-17 8:27am View

They are in the second part of the code, where I'm trying to upload images. My problem is how to merge these two parts of code or to pass ID from first part to second.

marieee 20-Feb-17 8:22am View

This is my real procedure and I'm not sure what you mean. ID1 is output in first table, and value in second. What do you mean it's a problem?

marieee 20-Feb-17 8:16am View

"Your stored procedure is expecting parameters @FileName and @FilePath. But your C# code is not passing either of those parameters."
That's the problem. How to pass them with fields from first table, when I have to insert values into first table to get ID, because then I'm using this ID for second table? I can't insert values for both tables in the same time. Or can I?

marieee 20-Feb-17 8:11am View

There is ID1 in first part of stored procedure, as output.

marieee 20-Feb-17 8:10am View

Deleted

This is the code for one page of website. My answer is below.

Comments by marieee (Top 35 by date)