|
Well Google[^] has many, many working solutions. The very first[^] one looks promising.
|
|
|
|
|
I did go through the google, but it was very confusing for me since I am very new to c#. I am not familiar with linq or xmldocument or....so couldnt exactly makeout which approach to take.
|
|
|
|
|
You actually need to try out some of this stuff for yourself though. If you see a result, look at it and try it out. Then you'll know if it fits your needs or not. And if you're new to C#, you might want to buy some basic books on it.
|
|
|
|
|
I wish I had that much time
|
|
|
|
|
I can't expect to find anyone doing your work for you...
|
|
|
|
|
How much time did you waste waiting for someone here to come along with the answer though? Bear in mind that, as volunteers, we answer questions when we can, so you could have waited hours before you got any answer.
|
|
|
|
|
I did try lot of things before i posted question here. what i meant was I wish i had time to go through the books now.
|
|
|
|
|
Can´t run before you walk.
XML can become pretty complex very soon so time or no time, my advice would be to complete a tutorial (a book, no website) reading, including excercises before diving into this.
C# and XML, I would recommend LINQ (to XML), but before diving into LINQ you need a thorough knowledge of .NET.
|
|
|
|
|
Different approach from Pete's answer is to use XMLSerializer deserialize[^]
Google has many examples that you could work from.
Every day, thousands of innocent plants are killed by vegetarians.
Help end the violence EAT BACON
|
|
|
|
|
Member 10264177 wrote: I am totally new to c#,
If you are totally new to programming as well then you might want to give up.
If you however experience in the SQL of your database then it is likely you can solve it using only that and much faster than learning enough C# to meet your "urgent" need.
|
|
|
|
|
If you use Linq To XML, you can do 90% of the processing with a single class: XElement. Linq To XML is elegant, and gives you (for example) IEnumerable lists you can process with foreach. It's my first choice for parsing XML.
|
|
|
|
|
I am Making one Window Form in visual studio 2010 using c# in this Form I want To Show Lost of Images and this images come form specific path or From folder
Example:
There is one hospital LeftHead side Patient List On click of PatientName in next panal I want show some related images of this patient so in this case what kind of tool i use to solve this problem
Thank You
Sanket
|
|
|
|
|
The Picturebox I believe.
PictureBox pictureBox1 = new PictureBo();
pictureBox1.Image = System.Drawing.Image.FromFile(@"");
With great code, comes great complexity, so keep it simple stupid...
|
|
|
|
|
Well, to handle the image management and display, I'd use the techniques I wrote about in this[^] article.
|
|
|
|
|
Hi!
I need to be connect to DB2 Database in my Project,it seem'd to be a easy task but i got some problems. I tryed to install IBM Add On for Visual Studio but i cant install it (like it could be only installed on normal visual studio but not on free express) It is a AS400 DB we connect using port 10 to address 192.168.52.10 on local server. I'm a newbie so please write in simple language Thanks Chris
|
|
|
|
|
Chris-Za wrote: I'm a newbie so please write in simple language Well, you haven't really explained what the problem is, apart from implying that you need an IBM addin. However, you may find http://www.connectionstrings.com/[^] a good place to look for some suggestions.
Veni, vidi, abiit domum
|
|
|
|
|
Hi Thanks for reply.
I try'd on the start the default OLEDB driver but cant menage the conn. string.
Got Error Message
base {System.Data.Common.DbException} = {"[DBNETLIB][ConnectionOpen (ParseConnectParams()).]Ungültige Verbindung."} (not guilty connection) ,ErrorCode = -2147467259
The Address and port are ok , vpn connection is fine.
Here are my connection string settings:
1)
string conn_str = @"Provider=SQLOLEDB;Network Transport Library=TCPIP;
Network Address=192.168.52.10:10;Initial Catalog=UDVM400DAT;
User ID=xxx;
Password=xxx;
2) second string
string connw = "Provider=SQLOLEDB;Server=192.168.52.10:10;Database=UDVM400DAT;UID=xxx;PWD=xxx;
Can You figure out whats wrong with the conn string? I had problems on running Toad for DB2, the Razor SQL is working but it use some java driver for AS400. Regards Chris
|
|
|
|
|
|
Chris-Za wrote: I need to be connect to DB2 Database in my Project,it seem'd to be a easy task but i got some problems. I tryed to install IBM Add On for Visual Studio but i cant install it (like it could be only installed on normal visual studio but not on free express) It is a AS400 DB we connect using port 10 to address 192.168.52.10 on local server. I'm a newbie so please write in simple language Visual Studio Express does not support Add Ons.
Still, one would not need a visual studio addon to simply connect to a database; your application will probably have to connect to a database sooner or later, without the help of visual studio or it's addons.
What you'd need is a "Data Provider" for IBM DB2. If none is present, use the OleDbProvider and it's related classes.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
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.OleDb;
namespace EmployeeAttendanceRegister
{
public partial class SignIN : Form
{
public SignIN()
{
InitializeComponent();
}
public OleDbConnection GetsqlCon()
{
string connstring = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:/Users/game/Desktop/3rd year/2nd Semester/INYM 328/EmployeeAttendanceRegister/EmployeeAttendanceRegister/EmployeeAttendanceRegister.accdb";
OleDbConnection mycon = new OleDbConnection(connstring);
mycon.Open();
return mycon;
}
public void getComm(string connstring1)
{
OleDbConnection sqlcon = this.GetsqlCon();
OleDbCommand sqlcomm = new OleDbCommand(connstring1, sqlcon);
sqlcomm.ExecuteNonQuery();
sqlcomm.Dispose();
sqlcon.Close();
sqlcon.Dispose();
}
private void button1_Click(object sender, EventArgs e)
{
try
{
string col1 = dataGridView1[0, dataGridView1.CurrentCell.RowIndex].Value.ToString();
string col2 = dataGridView1[1, dataGridView1.CurrentCell.RowIndex].Value.ToString();
string col3 = dataGridView1[2, dataGridView1.CurrentCell.RowIndex].Value.ToString();
string col4 = dataGridView1[3, dataGridView1.CurrentCell.RowIndex].Value.ToString();
string col5 = dataGridView1[4, dataGridView1.CurrentCell.RowIndex].Value.ToString();
string col6 = dataGridView1[5, dataGridView1.CurrentCell.RowIndex].Value.ToString();
string col7 = dataGridView1[6, dataGridView1.CurrentCell.RowIndex].Value.ToString();
string insert_sql = "INSERT INTO Attendance(Username,Lastname,Firstname,Cellnumber,Officenumber,DepartmentName,Passwrd) VALUES('" + col1 + "','" + col2 + "','" + col3 + "','" + col4 + "','" + col5 + "','" + col6 + "','" + col7 + "')";
this.getComm(insert_sql);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
|
|
|
|
|
First things first. Google for "SQL Injection Attack" to find out why building a SQL query string like you have is such a bad idea. I'll give you two hints: Security and Maintainability.
Then Google for "C# Access Parameterized Query" for what to do about it.
|
|
|
|
|
Alright thank you Dave I will.
|
|
|
|
|
"Username" is a reserved keyword[^], and a bad choice for a column-name. You'd have to escape it, probably by putting it in [username]. A better solution would be to rename the column.
You'd also want to be using "parameterizes queries" to prevent people like me from deleting everything in there. And instead of manually disposing, I'd recommend using a using clause.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
ya i agree
|
|
|
|
|
Thanks everyone for your responses,I managed to fix my code, now everything is fine.
|
|
|
|