|
You're welcome!
It's worth considering breaking your app into three parts (either logically or physically using three projects in one solution) to separate what they are doing: Presentation (user interface in and out), Business Logic (the rules and classes that process them), and Data (access to the DB and / or other storage)
That way, you make a more "rigid" interface between the parts of your application, which makes it easier to understand and maintain later.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Thanks I am trying to use the CRUD system with C# and sql, but the syntaxs on what I want to do is too much. I do this as a junior programmer for a company that needs websites, but also a junior physicist trying to develop quantum computing machine learning for data analysis. So you can image all this crap that i have to learn now as a programmer. Much appreciated your help!
|
|
|
|
|
How to create alpha channel in PSD formatted images using C#.net ?
|
|
|
|
|
Most likely by writing some code. And if you have a problem with it the please feel free to post the full details here, so people can try to help.
|
|
|
|
|
I have a problem. I'm trying to get just a company Name from the database and place them in the listbox and when selecting the name the program would show the org. number and notes in text boxes next to the listbox (and later to be able to delete, add and edit companies). I'm already stuck in showing data in the listbox. I'm getting this error "listBoxOrg.Items.Add((tempRow["Name"]));" -->"Argument 1: cannot convert from 'object' to 'string'. I'm pretty new to this so I don't know how to solve it. Is the code all crap or what am I missing? Been wondering also if my database adress is correctly done.. Anyone that can help me out?
This is my code so far:
using System;
using System.Collections;
using System.Collections.Generic;
using System.Diagnostics;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Configuration;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Threading.Tasks;
namespace Scenario1
{
public partial class companies1 : System.Web.UI.Page
{
public static ArrayList Files = new ArrayList();
protected void Page_Load(object sender, EventArgs e)
{
string str = "Data Source=BIG-BAD-WOLF-CO\\SQLEXPRESS;Integrated Security=True;Connect Timeout=15;Encrypt=False;TrustServerCertificate=True;ApplicationIntent=ReadWrite;MultiSubnetFailover=False";
SqlConnection con = new SqlConnection(str);
string com = "select Name from Companies";
SqlDataAdapter adpt = new SqlDataAdapter(com, con);
DataSet myDataSet = new DataSet();
adpt.Fill(myDataSet, "Companies");
DataTable myDataTable = myDataSet.Tables[0];
DataRow tempRow = null;
foreach (DataRow tempRow_Variable in myDataTable.Rows)
{
tempRow = tempRow_Variable;
listBoxOrg.Items.Add((tempRow["Name"]));
}
}
}
}
modified 1-Dec-20 21:01pm.
|
|
|
|
|
First off, to identify what your problem is, we need to know exactly where in that code the error is being reported. This is not a good question - we cannot work out from that little what you are trying to do. Remember that we can't see your screen, access your HDD, or read your mind - we only get exactly what you type to work with.
Second, your connections string looks OK for yoru dev system - but we have no idea if it works as we have no access to your system to check. But it's unlikely to work in the real world, as it uses integrated security and SQLEXPRESS, and that's unlikely to be the case once you leave your dev machine.
You can try looking here: Simple SQL Connection String Creation[^] which will help you test it.
Third, Connection strings should never be hard coded: you should load them from the web.config file and keep separate web.config files for prod and dev.
Why not just use the DataTable as the DataSource for the ListBox?
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Hi! Thanks for answering. Like I said I'm pretty new... actually extremely new to this. Yeah I guess I was pretty unclear with the question. The error shows in the end:
listBoxOrg.Items.Add((tempRow["Name"]));
My Visual Studio 2015 gives that.
This is a work I'm doing for my own "company" and everything I've tried is from educational videos. I thought it just would be a fun thing to know how to do. I've mostly written html and done a bit of java programming. I just can't understand why this works for them in the videos and not for me.
I've tested the connection and it works.
Umm sorry for a stupid question but what do mean with using the DataTable as the DataSource for the ListBox?
modified 1-Dec-20 21:01pm.
|
|
|
|
|
Rather than answering your questions, can I make a suggestion?
"Picking it up as you go" is a bad way to learn anything, particularly when it's as complicated as a new language and / or framework. And trying to learn by looking at Java code and assuming it's the same in C# is just not going to work well at all! For example, ArrayList is fine in Java, but it was supperceded in .NET back in 2005 and certainly shouldn't be used for new projects - the type safe List<T> and other Generic Collections should be.
But learning as you are, you don;t know that, and probably aren't even aware that Generics exist, much less the specifics of List<T>, Queue<T>, and so on.
Get a book - Addison Wesley, Wrox, and MS Press all do excellent ones, and there is also the free Yellow Book[^] which will at least touch the basics.
All of them will introduce you to better ways of handling data that you are currently using, and will make your life a whole load easier in future!
Going on a course is an even better method - if you don't understand something the tutor can try different ways to explain, which books can't.
The worse way to learn is via YouTube videos. Most of them are created by people who have no idea how to make a video, how to teach, and in the majority of cases know little more about the subject that the people watching them ... There are good ones out there, but it's really hard to find the quality items in a sea of dross.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Yeah I guess you're right. It's just pretty sad that there isn't any courses available in where I live. The nearest school that teaches c# and .NET is over an hour away with a car. I guess I have to start reading books. Thanks for the help anyway. 
modified 1-Dec-20 21:01pm.
|
|
|
|
|
You're welcome!
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
listBoxOrg.Items.Add((tempRow["Name"]));
The message implies that tempRow["Name"] does not return a valid string (and we know it returns an object*), so you could try
listBoxOrg.Items.Add((tempRow["Name"].ToString()));
*as explained in DataRow.Item[String, DataRowVersion] Property[^]
|
|
|
|
|
That actually did work (atleast the debugger won't whine about it anymore) but I'm getting a new error at:
adpt.Fill(myDataSet, "Companies");
"An exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll but was not handled in user code
Additional information: Invalid object name 'Companies'."
I have created a database with two tables: Companies and Stores. So Companies exists.
modified 1-Dec-20 21:01pm.
|
|
|
|
|
Again, documentation... DataAdapter.Fill Method (System.Data.Common) | Microsoft Docs[^]
If you're going to fill a DataSet object, your 'myDataSet', you also need to supply a string next, which you did, but you also have to supply an IDataReader, and a couple of integers.
Don't. You don't need it. Just get rid of the "Companies" string.
|
|
|
|
|
The problem is with your connection string - you haven't specified the Database, so your queries aren't running against the correct database.
SQL Server connection strings - ConnectionStrings.com[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Hi Guys,
I'm new member with C#, i'm working project with windows form.
My idea is create new label when I click a button, and the label have just created can change location when click and move mouse. And I want save new label and it's location after close app window form. I havent know how to i do this. So Please support for me!
Thanks!
|
|
|
|
|
What have your tried?
Where are you stuck?
What help do you need?
Just saying "I want to do this" without explaining what part of it is giving you problems doesn't help anyone - we aren't here to just hand you a complete solution, so we need to know how far you have got already.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Thanks for your reply,
Here is my code. i just only create new label.
<pre>using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace Form1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
bool selected = false;
private void Form1_Load(object sender, EventArgs e)
{
}
int B = 1;
public System.Windows.Forms.Label AddNewLabel()
{
System.Windows.Forms.Label newLabel = new System.Windows.Forms.Label();
this.Controls.Add(newLabel);
newLabel.Top = B * 28;
newLabel.Left = 50;
newLabel.Text = "DOOR EXIT " + this.B.ToString();
if (B >= 5)
{
newLabel.Top = B * 28;
newLabel.Left = 100;
}
else
{
newLabel.Left = 50;
}
B = B + 1;
newLabel.BorderStyle = BorderStyle.FixedSingle;
newLabel.TextAlign = ContentAlignment.MiddleCenter;
if(newLabel.MouseMove)
{
newLabel.Location = e.Location;
}
return newLabel;
}
private void btn_Create_Click(object sender, EventArgs e)
{
AddNewLabel();
}
}
}
|
|
|
|
|
Yes, but that code won't even compile, much less run.
And if it did run, it wouldn't do what you wanted.
What is e?
Why are you testing an Event? They aren't bools!
Stop guessing, and look at your course notes: you should have covered dynamic label creation, and if they haven'y then you need to learn what to do properly.
As a suggestion, create a new project with a form. In the designer, add a label, and add handlers for the MouseDown, MouseUp, and Move Events. Then fill in those event handlers so that you can move the label around on your form.
When that works, look at your form.desigtner.cs file (go to your form constructor code and right click the call to InitializeComponent , then select "Go To Definition" and it's take you to the right place in the right file).
Look at what it does to create the label - that's the code you need to start thinking about.
Give it a try - it's not really complicated, it just takes a little thinking about instead of guessing and hoping! 
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Hi, i need developer a tool to <big>solve complex captcha using c#</big>, i created a tool to do this but the solution do not recognized many pics
Please a need a help.
The url to download the solution is here [URL DELETED]
:confused:
|
|
|
|
|
Captcha is there to prevent automated access to sites and apps: any attempts to bypass that is against the terms and conditions of the site or app, and that makes it malicious code.
We do not condone, support, or assist in the production of malicious code in any way, form, or manner. This is a professional site for professional developers.
If you want to know how to create such things, you need to visit a hacking site: but be sure to disable all firewalls and antivirus products first or they won't trust you enough to tell you.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
URL for site known for illegal downloads removed.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Hello dear friends
Windows Form C # project.
In a sense, I have four combo boxes and a text box.
I intend to include the text of the combo box when selecting combo box items. Otherwise the item will not be added.
Thanks
|
|
|
|
|
Sorry, but you are going to have to explain that in quite bit more detail: remember that we cannot see your screen, access your HDD, or read your mind - we only get exactly what you type to work from; we get no context other than that.
So stop trying to type as little as possible, and explain it to us in some detail - the better your question, the better our answer can be.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Do you have a question?
Social Media - A platform that makes it easier for the crazies to find each other.
Everyone is born right handed. Only the strongest overcome it.
Fight for left-handed rights and hand equality.
|
|
|
|
|
Project Description: By Using this Program User can able to do different following
operations using Arrays. 1. Insertion, 2. Deletion, 3. Sorting, 4. Searching, 5. Update, 6.
Retrieve, 7. Merging, 8. Append, 9. Exit. This Menu Driven Program will enhance the array
operations capability in c programming. In this program User can insert, delete, sort, search,
update, retrieve, merge, and append the elements in array with respect to the user choice.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
