Re: gridview to Database table asp.net C# - C# Discussion Boards

Re: Need help. [modified]

14-Jul-09 22:21

Hi.
this is my coding

string MyString;
MyString = "Select * from timemgmt";
if (radioin.Checked == true)
{
cn = new OdbcConnection("Driver={Microsoft ODBC for Oracle};Server=orcl;UID=it;PWD=cr;");

cmd = new OdbcCommand(MyString, cn);
cn.Open();
cmd.CommandText = "insert into timemgmt values('" + textBox1.Text + "','" + label19.Text + "','" + label18.Text + "','" + label18.Text + "')";
cmd.ExecuteNonQuery();
cn.Close();

textbox1.text = employe ID
label19.text = System Date
label18.text = System Time

i want to do Accept employee ID in one time in a day 2nd time user give same Id in a same date not accepted
plzz give me some hints

thanks in Advance

Jawad Khatri

Blue_Boy14-Jul-09 22:30

Blue_Boy

14-Jul-09 22:30

This is SQL query

if(select id from timemgmt where id=@id)=0
begin
insert values
end

but be aware from SQL Injections

mjawadkhatri wrote:
"insert into timemgmt values('" + textBox1.Text + "','" + label19.Text + "','" + label18.Text + "','" + label18.Text + "')";

and rename controls by giving more meaningfull names.

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

modified on Wednesday, July 15, 2009 4:40 AM

mjawadkhatri14-Jul-09 23:48

Datagridview to Database table

14-Jul-09 23:48

Where i Put This Query???

5fingers14-Jul-09 22:10

5fingers

14-Jul-09 22:10

How can I load datagridview data to a database table
Thanks

Re: Datagridview to Database table

Vimalsoft(Pty) Ltd14-Jul-09 23:34

Vimalsoft(Pty) Ltd

14-Jul-09 23:34

Good Morning onyang2

You have to be carefull with the names.

There is a GridView and a Datagrid.

is this a Windows App or a Web App ?

Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.somee.com
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Re: gridview to Database table asp.net C#

5fingers14-Jul-09 23:37

5fingers

14-Jul-09 23:37

It is a web application

Re: gridview to Database table asp.net C#

Vimalsoft(Pty) Ltd14-Jul-09 23:47

Vimalsoft(Pty) Ltd

14-Jul-09 23:47

that is a gridview, you must asp such questions in the ASP.NET Forum next time.

here is a solution

http://www.dotnetfunda.com/articles/article131.aspx[^]

http://www.dotnetfunda.com/articles/article121.aspx[^]

How to get listbox items to string?

swetha_insoft14-Jul-09 21:04

swetha_insoft

14-Jul-09 21:04

listbox is having more than one value....
how to get those value to one string?

SeMartens14-Jul-09 21:09

14-Jul-09 21:09

Hi,

well you could iterate through the listbox-items and concat their text-properties. Just something like this:

StringBuilder oBuilder = new StringBuilder();
foreach(object oCurItem in myListbox.Items) {
  oBuilder.Append(oCurItem.ToString());
}
string sResult = oBuilder.ToString();

Let me know if this helps you.

Regards
Sebastian

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

stancrm14-Jul-09 21:11

stancrm

14-Jul-09 21:11

StringBuilder sb = new StringBuilder();
foreach (string s in listBox1.Items)
  sb.Append(s);

swetha_insoft14-Jul-09 21:21

swetha_insoft

14-Jul-09 21:21

string s = "";
for (int i = 0; i < lstSelected.Items.Count; i++)
{
if (s != "")
{
s = s + "," + lstSelected.Items[i].ToString();
}
else
{
s = lstSelected.Items[i].ToString();
}
}

But S-->is getting "System.Data.DataRowView" value instead of listbox item.

SeMartens14-Jul-09 21:26

14-Jul-09 21:26

Try to use

<br />
<br />
((System.Data.DataRowView) lstSelectedItems.Items[i]).Item[0].ToString()<br />
<br />

instead.

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

Blue_Boy14-Jul-09 21:53

Blue_Boy

14-Jul-09 21:53

StringBuilder s = new StringBuilder();

for (int i = 0; i < lstSelected.Items.Count; i++)
{
s.Append(lstSelected.Items[i].Text);
}

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

dule4327-Aug-09 15:07

dule43

27-Aug-09 15:07

foreach (DataRowView item in listBox.Items)
{
txtBox.Text += item.Row["RowNameYouWant"].ToString() + "\n";
}

random number generation

givya14-Jul-09 21:02

givya

14-Jul-09 21:02

i wanna know how to create random numbers in c#. in my application i need to provide a default password if the user forgets the password. i wanna give this default password in the form of random numbers. pls help...

SeMartens14-Jul-09 21:04

14-Jul-09 21:04

Hi,

the .NET framework provides a Random-class. Have a look here: http://msdn.microsoft.com/en-us/library/system.random.aspx[^]

Regards
Sebastian

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

Rajesh R Subramanian14-Jul-09 21:05

Rajesh R Subramanian

14-Jul-09 21:05

Hello Givya,

Have you tried searching[^]?

It is a crappy thing, but it's life -^ Carlo Pallini

himanshu256114-Jul-09 21:13

himanshu2561

14-Jul-09 21:13

Hi Use Random class like

Random r = new Random();

givya wrote:
in my application i need to provide a default password if the user forgets the password

IMO ,If possible try to provide forgot password functionality like [Hint Question or Alternate Email]...

himanshu

givya15-Jul-09 2:27

givya

15-Jul-09 2:27

I gave the following code to generate the random string(searched it on internet).
private string RandomString(int size, bool lowerCase)
{

StringBuilder builder = new StringBuilder();
Random random = new Random();
char ch;
for (int i = 0; i < size; i++)
{
ch = Convert.ToChar(Convert.ToInt32(Math.Floor(26 * random.NextDouble() + 65)));
builder.Append(ch);
}
if (lowerCase)
return builder.ToString().ToLower();
return builder.ToString();
}

Bt its giving the following error:

A using namespace directive can only be applied to namespaces; 'System.Text.StringBuilder' is a type not a namespace

I hav used this also: "using System.Text.StringBuilder;"

Pls help

Need help.

mjawadkhatri14-Jul-09 20:56

14-Jul-09 20:56

Hi.
i get system date in this format "mm/dd/yyyy" like "07/15/2009" now i want to change date format like this "15-JUL-2009"
how can i do??

thanks in Advance

jawad khatri

SeMartens14-Jul-09 21:01

14-Jul-09 21:01

Hi,

take a look at MSDN: http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx[^]

Regards
Sebastian

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

K030614-Jul-09 21:07

K0306

14-Jul-09 21:07

Try this

            DateTime dt = DateTime.Now;
            MessageBox.Show(dt.ToString("dd/MMM/yyyy"));
            <pre> 

<div class="ForumSig">Regards,
Karthik K...</div>

mjawadkhatri14-Jul-09 21:18

14-Jul-09 21:18

thanks