|
I want to create a table "Employee" with columns:empname,age and empcode(which takes two letters from employee name and append number to it.,e.g.:-ga1,om2 where ga stands for ganesh,om stands for omkar)
please help me with the empcode thing.
thank you
|
|
|
|
|
At the point in your code that adds the actual data to the DataTable, you are going to do something like this:
newRow[2] = Employees[i].Substring(0, 2) + i.ToString();
“I'm an artist: it's self evident that word implies looking for something all the time without ever finding it in full. It is the opposite of saying : 'I know all about it. I've already found it.'
As far as I'm concerned, the word means: 'I am looking. I am hunting for it. I am deeply involved.'”
Vincent Van Gogh
|
|
|
|
|
I need to know how to get data from finger printer scanner in c#.net and how to display (in textbox, in image form).
|
|
|
|
|
By using the SDK that comes with the fingerprint scanner and consulting the SDK documentation.
|
|
|
|
|
Solution:
1. Learn basic C# coding.
2. Learn basic C# gui code.
3. Find one or more scanners and determine what existing APIs those scanners have.
4. Pick a scanner
5. If necessary learn interop if the scanner picked does not already have a .Net API.
6. Put all of the above together.
|
|
|
|
|
what is memory management in C#
|
|
|
|
|
Plenty of details here[^].
|
|
|
|
|
Form activeForm = this.ActiveMdiChild as Form;
string title = activeForm.Text;
MessageBox.Show(title);
when i'm use this code the following is displayed "Object reference not set to an instance of an object." that point out the first line............please any one can help me.......
|
|
|
|
|
Sounds like you have a null value somewhere. Can you post the section of code that's giving you trouble?
|
|
|
|
|
If you step through this code in your debugger you will be able to see if there is a valid ActiveMdiChild to set into the variable.
Veni, vidi, abiit domum
|
|
|
|
|
based on what I see it must be that you activeForm has not be initialized and is null. Without more code can't be certain.
|
|
|
|
|
please help me,friend
i want enter key search in textbox then click on the button and display data in DataGridView
tank you friends
|
|
|
|
|
|
You forgot to ask how to save data in a database. I suggest you try the how to[^]'s and some tutorials; it won't be very fun to learn it by asking every task in a forum.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
please help me,friend
i want enter key search in textbox then click on the button and display data in DataGridView
tank you friends
|
|
|
|
|
Try this link:
http://msdn.microsoft.com/en-us/library/aeez5k4f.aspx
|
|
|
|
|
hi friends
i want display data from table(sql server) in the dataGridView
tanke you
|
|
|
|
|
|
hi friends
How i can delete data from data base(sql server) in C#?????
|
|
|
|
|
this is simple script to delete using webform asp.net C#
here is my code:
1. adding connection in Web.config
Web.config
==========
<connectionStrings>
<add name="myConnection" providerName="System.Data.SqlClient" connectionString="server=.\SQLEXPRESS;Initial Catalog=MyDB;Integrated Security=True"/>
</connectionStrings>
2. in default.aspx
default.aspx
============
added namespace:
using System.Data.SqlClient;
using System.Configuration;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string connProvider = ConfigurationManager.ConnectionStrings["myConnection"].ToString();
using (SqlConnection cnn = new SqlConnection(connProvider))
{
cnn.Open();
string userid = "1";
string query = "Delete Users Where UserID = '" + userid + "'";
using (SqlCommand cmd = new SqlCommand(query, cnn))
{
cmd.ExecuteNonQuery();
}
}
}
}
hope this help. (Update)= this code not recommended for develop, you can try it for learn and you can improve your code.
regard,
Ade Ruyani
modified 24-Dec-13 3:49am.
|
|
|
|
|
Reason for my downvote: Do not concatenate strings to build a SQL command. It leaves you wide open to accidental or deliberate SQL Injection attack which can destroy your entire database. Use Parametrized queries instead. Even in a simple example like this, it takes hardly any extra work to do it properly!
Never underestimate the power of stupid things in large numbers
--- Serious Sam
|
|
|
|
|
Thank you sam, this is just a simple code, whether they can improve they're code using store procedure or else.
|
|
|
|
|
Ade.Ruyani.Z wrote: this is just a simple code It is still a bad example, because it leads to careless coding.
Veni, vidi, abiit domum
|
|
|
|
|
int RowsAffected = 0;
using(SqlConnection cn = new SqlConnection(ConnectionStringHere))
{
cn.Open();
using(SqlCommand cmd = new SqlCommand())
{
cmd.Connection = cn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "Delete from tablename where id = @id";
cmd.Parameters.AddWithValue("@id",id);
RowsAffected = cmd.ExecuteNonQuery();
}
}
Every day, thousands of innocent plants are killed by vegetarians.
Help end the violence EAT BACON
|
|
|
|
|