Visual Basic

Mekong River16-Aug-07 0:19

Mekong River

16-Aug-07 0:19

Ok, I will try and let you know the result. But what I suspect that the problem because I didn't give any value to set in the autonumber column. Thank for your help Smile | :)

Tom Deketelaere16-Aug-07 0:32

Tom Deketelaere

16-Aug-07 0:32

like stated before:

the problem cannot be because you don't give a value to the autonumber colomn (if it is a autonumber colomn) because this column does not accept any input just try and give in a value straight into access it will not work so you error has a differant cause to find out what do what Christian Graus suggested

Christian Graus16-Aug-07 11:50

Christian Graus

16-Aug-07 11:50

Yeah, that's the point. I suggested trying to give that column a value, just in case he's wrong in thinking it's set to be an autonumber column.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Problem with Combobox Populating And Sorting

Vimalsoft(Pty) Ltd16-Aug-07 22:20

Vimalsoft(Pty) Ltd

16-Aug-07 22:20

hi Kanel

Sometimes you need to epen a Query analyzer before passing an SQL statement to a command object

the Following is you statement.

.CommandText = "INSERT INTO tblOrgInfo (OrgName, Address) VALUES ('" & Trim(txtOrgName.Text) & "', '" & txtAddress.Text & "'")

if you insert a new record in a table that has an identity Row, you have to do it like this

.CommandText ="INSERT INTO tblOrgInfo 
VALUES ('" & Trim(txtOrgName.Text) & "', '" & txtAddress.Text & "'")

Forget about the first column, pretend as if its not there, you can never do anything to it, or update it. i have not look at your code that much but i stoped looking at this line, and this was not correct

Vuyiswa Maseko

Vimalsoft(Pty) Ltd15-Aug-07 21:48

Vimalsoft(Pty) Ltd

15-Aug-07 21:48

i have Combobox,And i have Populated it like this in my form load

<br />
cmbconfidence.Items.Add("1")<br />
cmbconfidence.Items.Add("2")<br />
cmbconfidence.Items.Add("3")<br />
cmbconfidence.Items.Add("4")<br />
cmbconfidence.Items.Add("5")<br />
cmbconfidence.Items.Add("6")<br />
cmbconfidence.Items.Add("7")<br />

And Later i decided to Add more options to it and my code looks like this now

<br />
   cmbconfidence.Items.Add("0")<br />
        cmbconfidence.Items.Add("1")<br />
        cmbconfidence.Items.Add("2")<br />
        cmbconfidence.Items.Add("3")<br />
        cmbconfidence.Items.Add("4")<br />
        cmbconfidence.Items.Add("5")<br />
        cmbconfidence.Items.Add("6")<br />
        cmbconfidence.Items.Add("7")<br />
        cmbconfidence.Items.Add("8")<br />
        cmbconfidence.Items.Add("9")<br />
        cmbconfidence.Items.Add("10")<br />
        cmbconfidence.Sorted = True<br />
  cmbconfidence.DropDownStyle = ComboBoxStyle.DropDownList<br />
       <br />

But in my list when i run my application its not Sorted. Option 10 is not the last one and option 0 is not the first one. i need to put them in Order.

How do i archive this?

Thanks

Vuyiswa Maseko

Re: Problem with Combobox Populating And Sorting

Luc Pattyn16-Aug-07 0:10

Luc Pattyn

16-Aug-07 0:10

Hi,

when Sorted=true, the combobox will sort the items alphabetically, which means
10 goes in between 0 and 2 (just like bbbbb goes in between aa and cc).

Now if you are specifying the items as literal strings, in the order you want them,
then I suggest you don't set Sorted true, since that will mess it up for you.

If you need to populate dynamically and have a special sort order in mind, the
best thing to do is first populate some collection (say an ArrayList), then
call its Sort method (providing a IComparer object), then do databinding from the
collection to the combobox.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

this weeks tips:
- make Visual display line numbers: Tools/Options/TextEditor/...
- show exceptions with ToString() to see all information
- before you ask a question here, search CodeProject, then Google

Re: Problem with Combobox Populating And Sorting

Vimalsoft(Pty) Ltd16-Aug-07 0:16

Vimalsoft(Pty) Ltd

16-Aug-07 0:16

Thank man you are a Star

its working

Vuyiswa Maseko

The SourceCode Manage

codelinks15-Aug-07 21:21

Re: The SourceCode Manage

15-Aug-07 21:21

hi Guys
Is there any live application to search for code, we have lots n lots of sites to get the source codes, why cant we make a web application with a good search engine to search pure text source code, anything related to code.
For eg. store procedure's, HTML, ASP codes, technical text, code-behind, javascript, java codes,
only pure text should be stored, its should be a very simple application with no links, only to maintain and retrieve, there will be no data editing for the users.
uploading of files are not allowed since many technical websites are providing this feature,

The plan
Here the users can store information taken from the internet(pure text) when he/she visits for reference, later he/she need not come to this same link to take the specific code, instead he/she can search the code in this new Code Manager portal,
the user will have to provide the description of code or technical text and each source code should be allocated under different sets,
for eg. if its HTML code, the language should be set as HTML for this source code

How the search works
A search with different criteria should be given..
based on desciption
based on language
based on date stroed
based on unique words,
base on tags

we should make this application very simple to handle

winnie

winnie

Dave Kreskowiak16-Aug-07 3:08

Dave Kreskowiak

16-Aug-07 3:08

Do NOT spam the site by posting the same question in multiple forums. Pick ONE and stick with it.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Re: The SourceCode Manage

codelinks16-Aug-07 3:13

how can i get the domain Name/IP under which my mahine works

16-Aug-07 3:13

ok dave

winnie

koolprasad200315-Aug-07 21:01

koolprasad2003

15-Aug-07 21:01

hello to ALL,

I am using VB 6.0

how can i get the domain Name/IP under which my mahine works,

Let me explain in depth,

suppose my machine is under BHAHBLAH domain then programatically how can i get that doamin Name/IP

please help...any Hint/link ?

thankx in advance

regards,
koolprasad2003 Smile | :)

Be a good listener...Because Opprtunity knoughts softly...N-Joy

Re: how can i get the domain Name/IP under which my mahine works

Tom Deketelaere15-Aug-07 21:12

Tom Deketelaere

15-Aug-07 21:12

check this post of 2 days ago:

http://www.codeproject.com/script/comments/forums.asp?msg=2181483&forumid=1646#xx2181483xx[^]

how to populate data in the DDL

biswa4715-Aug-07 20:16

biswa47

15-Aug-07 20:16

i have table named emp
where empid and emp name are the colomns of the table.

now in the vs.2005.
i have taken a dropdown list and label.
in the drop down list i want to show the empid in dropdownlist and based up on the empid the corresponding empname shuld be populate in the label.

can you tell me how to write the code for it in vb.net

Re: how to populate data in the DDL

codelinks15-Aug-07 20:45

Re: how to populate data in the DDL

15-Aug-07 20:45

hi Biswa,
on the selected index changed of the DDL u can write this code,
make sure the AutopostBack is true for the DDL

protected void ddEmpID_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
string strEmpName = "SELECT empid,empname FROM tbl_XYZ WHERE empid = '" + ddEmpID.SelectedValue + "'";
SqlCommand comEMP = new SqlCommand(strEmpName, con);
SqlDataReader dr;
con.Open();
dr = comEMP.ExecuteReader();
while (dr.Read())
{
lblEmpName.Text = dr["empname"].ToString();
}
}
catch (Exception ex)
{
Trace.Write(ex.Message);
}
finally
{
con.Close();
}

}

winnie

codelinks15-Aug-07 20:48

15-Aug-07 20:48

if you want to make it as a AJAX based populate u can use AJAX Extensions.. to populate the DDL without a postback

winnie

class [modified]

nitin315-Aug-07 20:08

nitin3

15-Aug-07 20:08

hai all,

is there any way to write member function/sub procedures outside of a class declaration as in c++ ?

if its not possible please let me know
thanks

-- modified at 2:52 Thursday 16th August, 2007

Zia Ul Haq Soofi15-Aug-07 21:42

Zia Ul Haq Soofi

15-Aug-07 21:42

it is not possible honey

Be a part of solution, rather then be a part of problem

nitin315-Aug-07 22:14

nitin3

15-Aug-07 22:14

thanks

Christian Graus15-Aug-07 23:22

Christian Graus

15-Aug-07 23:22

Why on earth did you ask this in the VB forum ?

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )