|
Good day. I would like to create a simple API using C#.Net that read Oracle Database. Where must I start?
|
|
|
|
|
sellol wrote: Where must I start? At the beginning.
But seriously, what do you expect your API to do or, what features will it provide? The most likely starting point is probably to work on the basic design, and decide how many of the Oracle features you want to expose.
|
|
|
|
|
Hi. I want to create just a simple CRUD. Just want to create endpoints. Like myserver.com/v1/employees/all,
myserver.com/v1/employee/id/{1}
Etc
|
|
|
|
|
Sorry neither your original question nor this make any real sense. These forums are for technical questions, so you need to be much more specific. We cannot guess what your design requirements are. And the above URL is not valid; no idea what myserver.com is supposed to lead to.
|
|
|
|
|
Hi. Are you going to help me with creating basic API reading from Oracle?. If you cant please refer me to a specific link.
|
|
|
|
|
|
I'll be a little more specific than Richard - Google[^]
Only because he managed to get more detail out of you. API means you want to expose the capabilities of Oracle, CRUD is a solved problem!
Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP
|
|
|
|
|
sellol wrote: Where must I start?
Part 1
1. Learn basics of C#
2. Learn basics of accessing Oracle from C#
3. Create test application that includes both of the above.
Part 2
1. Learn basics of "web' process
2. Create code that provides basic UI screen.
3. Create test application that includes both of the above.
Part 3
1. Learn how a web application interacts with a server application
2. Optional: At least read up a bit on security (how to do a user login.)
Part 4
1. Decide on a minimal table to which you can create, update, query and delete entries.
2. Create a UI that allows you to do 1
3. Create a server side code that allows 2 to interact with it and that does the database actions.
Part 5
1. Put all of the above together to create your application.
|
|
|
|
|
Thank you very much man. You are a true leader.
|
|
|
|
|
Hi,
I have written a VS 2010 Windows application with SQL server 2014. Application works well on Windows 7 and above.
It cannot work on Windows XP.
Windows XP PC can access the Sql Server 2014 by using udl.
I hope can get some pointers on how to overcome this problem.
Thank you
ShanR
|
|
|
|
|
Member 13918184 wrote: I hope can get some pointers on how to overcome this problem. You need to provide some proper details of what happens on XP. No one here can begin to guess what your code is doing or trying to do. Please edit your question and add the required information.
|
|
|
|
|
Es posible recibir estatus de pago de una transaccion directamente en mi sitio web sin tener que ir al panel de control de paypal?
|
|
|
|
|
Good day everyone!
Please I need help in this issue as I have tried but the result am getting is not good enough to my satisfaction.
I know how to save and retrieve html tags to/from database but believe me doing it for codebehind is really tough for me.
Now, my request is that, how and what is the best way to display posted codebehind in asp.net just codeproject do to all content within code tag.
For instance, codeproject would identify the following function and even markoff comment line as visual studio does.
Public Function Something(val As Integer) As Integer
Return Something
End Function
How can I achieve this please.
|
|
|
|
|
It depends on how you're displaying the code. If you're displaying it in a web page, then the simplest option is to use a Javascript syntax highlighter. For example, highlight.js[^].
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
how can i do website using html javascript via visual studio 2017
|
|
|
|
|
You can't expect to learn such a massive topic from scratch by asking "How do I write a website?" on a forum. Get a book on ASP.net website development, or at least go through some "getting started" tutorials online. One you know the basics feel free to ask specific questions about specific problems.
|
|
|
|
|
Hi,
I have been given a project, which has Angular CLI code, but the project or solution itself is created at the time the Angular CLI is not released yet, so the package.json file is also created at that time only, now when I run the npm install command on that Angular folder, it gives me the below error:
gyp ERR! stack Error: Can't find Python executable "python", you can set the PYTHON env variable.
gyp ERR! stack at PythonFinder.failNoPython (C:\SourceCode\customerserviceweb\CustomerServiceWeb.Web\node_modules\node-gyp\lib\configure.js:483:19)
gyp ERR! stack at PythonFinder.<anonymous> (C:\SourceCode\customerserviceweb\CustomerServiceWeb.Web\node_modules\node-gyp\lib\configure.js:508:16)
gyp ERR! stack at C:\SourceCode\customerserviceweb\CustomerServiceWeb.Web\node_modules\graceful-fs\polyfills.js:284:29
gyp ERR! stack at FSReqWrap.oncomplete (fs.js:154:21)
gyp ERR! System Windows_NT 10.0.16299
gyp ERR! command "C:\\Program Files\\nodejs\\node.exe" "C:\\SourceCode\\customerserviceweb\\CustomerServiceWeb.Web\\node_modules\\node-gyp\\bin\\node-gyp.js" "rebuild" "--verbose" "--libsass_ext=" "--libsass_cflags=" "--libsass_ldflags=" "--libsass_library="
gyp ERR! cwd C:\SourceCode\customerserviceweb\CustomerServiceWeb.Web\node_modules\node-sass
gyp ERR! node -v v10.15.0
gyp ERR! node-gyp -v v3.6.2
gyp ERR! not ok
Build failed with error code: 1
npm WARN optional SKIPPING OPTIONAL DEPENDENCY: fsevents@1.2.7 (node_modules\fsevents):
npm WARN notsup SKIPPING OPTIONAL DEPENDENCY: Unsupported platform for fsevents@1.2.7: wanted {"os":"darwin","arch":"any"} (current: {"os":"win32","arch":"x64"})
npm ERR! code ELIFECYCLE
npm ERR! errno 1
npm ERR! node-sass@4.5.3 postinstall: `node scripts/build.js`
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the node-sass@4.5.3 postinstall script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.
npm ERR! A complete log of this run can be found in:
npm ERR! C:\Users\e09795\AppData\Roaming\npm-cache\_logs\2019-01-24T21_03_42_886Z-debug.log
I went into the log file, it displays the same message.
Is there any way to fix this package.json file to be able to work with angular cli without any interruptions.
After making this change I want to run npm install, ng generate component etc commands. Any help would be very very helpful - thanks a lot.
|
|
|
|
|
Look at the first line of the messages: "Can't find Python executable "python".
|
|
|
|
|
Yeah I thought that's true, but when I asked about it with my lead, he told me that this project initially was not created with Angular Cli but in AngularJs, but later it converted into Angular Cli project, hence some of the Angular Cli commands are not working, I am not sure how can I convert this into Angular Cli project, but if the effort is big then we will live with it creating components manually and writing the code, if there is any way if we find, then we will try to convert it into Angular Cli.
|
|
|
|
|
I seriously doubt this issue has anything to do with angular CLI. after all package.json is just a list of packages you use (also, sometimes the list of npm commands you use). So I agree with the previous commentator and see the issue with python.
I've encountered a similar issue once and as far as I remember it was some of npm's quirks so I've just updated it.
|
|
|
|
|
Now I am also doubting in that direction, I have installed the Python runtime and assigned the path, it fixed the issue, thank you so much.
|
|
|
|
|
Greetings experts,
I was looking for windows forms but didn't find one. I hope it is ok to post here.
I am trying to display records from the database so I can add/delete/update records.
The way I have this set up, clicking on a row of records populates the textboxes associated with the rows on the code below.
So far, when I click on any row, the textboxes are not getting populated.
My assumption is that I am not getting the correct rowindexes for each of the rows in DataGridView control.
Is there an easier way to find out which rowindex each of the rows belong to.
Better yet, is there a better way of displaying the records and when each row is clicked, the associated textboxes are populated?
The datagridview rows are getting populated. What is not working is clicking on a row and getting textboxes populated.
Your assistance as usual is greatly appreciated.
private void DisplayData()
{
con.Open();
DataTable dt=new DataTable();
adapt=new SqlDataAdapter("SELECT t.TransactionID,m.FullName,convert(varchar,m.registration_date,101) as registration_date," +
"m.enelope_number,Reg_Fee,t.Amount,t.AmountPaid,t.AmountOwed as Past_Due " +
"from dbo.Transactions AS t INNER JOIN dbo.Members AS m ON t .MemberID = m.MemberID INNER JOIN " +
"dbo.PaymentTypes AS p ON t .TypeID = p.PaymentTypeID", con);
adapt.Fill(dt);
dataGridView1.DataSource = dt;
con.Close();
}
private void ClearData()
{
Email.Text = "";
Phone.Text = "";
TransactionID = 0;
}
private void dataGridView1_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
TransactionID = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString());
memberName.Text = dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();
Email.Text = dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString();
Phone.Text = dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString();
Address.Text = dataGridView1.Rows[e.RowIndex].Cells[4].Value.ToString();
member_sex.Text = dataGridView1.Rows[e.RowIndex].Cells[5].Value.ToString();
date_member_registered.Text = dataGridView1.Rows[e.RowIndex].Cells[6].Value.ToString();
envelope_number.Text = dataGridView1.Rows[e.RowIndex].Cells[7].Value.ToString();
}
private void btn_Update_Click(object sender, EventArgs e)
{
if (Email.Text != "" && Phone.Text != "")
{
cmd = new SqlCommand("update Transactions set Name=@name,State=@state where transactionID=@id", con);
con.Open();
cmd.Parameters.AddWithValue("@id", TransactionID);
cmd.Parameters.AddWithValue("@amount", Email.Text);
cmd.Parameters.AddWithValue("@paid", Phone.Text);
cmd.ExecuteNonQuery();
MessageBox.Show("Record Updated Successfully");
con.Close();
DisplayData();
ClearData();
}
else
{
MessageBox.Show("Please Select Record to Update");
}
}
private void btn_Delete_Click(object sender, EventArgs e)
{
if(TransactionID!=0)
{
cmd = new SqlCommand("delete from Transactions where transactionID=@id",con);
con.Open();
cmd.Parameters.AddWithValue("@id",TransactionID);
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Record Deleted Successfully!");
DisplayData();
ClearData();
}
else
{
MessageBox.Show("Please Select Record to Delete");
}
}
Does anyone
|
|
|
|
|
samflex wrote: I was looking for windows forms but didn't find one.
Windows Forms Discussion Boards[^]
The RowHeaderMouseClick event[^] only fires when you click on the row header, not when you click on the row itself. There isn't an event that's raised when you click on a row, but you can use the CellClick event[^] to fake it.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Message Removed
modified 21-Jan-19 19:35pm.
|
|
|
|
|
Hi,
I am getting the above mentioned error when I am running my application, this application have been downloaded from my company Git location, I have installed Node and npm, those things are sorted out, except few components under npm folder are showing yellow sign that they are not installed yet. But I am not sure why is this error showing up when I am running the application. And another thing is I don't have Admin privileges on the same machine I am running the app, is it something because of that I have no idea - any help would be very very helpful.
Again the error message here:
The reference assemblies for framework ".NETFramework,Version=v4.6.2" were not found. To resolve this, install the SDK or Targeting Pack for this framework version or retarget your application to a version of the framework for which you have the SDK or Targeting Pack installed. Note that assemblies will be resolved from the Global Assembly Cache (GAC) and will be used in place of reference assemblies. Therefore your assembly may not be correctly targeted for the framework you intend. CustomerServiceWeb.Selenium.Test
|
|
|
|