Posts by Pgmer

Have you given proper instance name while installing? or any other Sql server version already there in your system?
can remove from control panel and try re installing?

Check you have permision on FTP to download the file.

It has not got installed properly or try restart ur system.

it will do 2011-2010
difference is 1 right?

Hi Jemz..

No Need of combbox. for a text box there is a property called autocompleteSoruce
you get all the text which u want to show in textbox when user enters a text from ur databse and bind it.
and set the proprty autocompletemode of text box, APPEND,SUGGEST.. whatever u want.

Hope this helps u

In database you want to achive?

Try this

Select EMpNAME,AMT,DEPTNAME from (SELECT tbl_employee.E_Name as EMpNAME,sum(tbl_Salary.Amt) as AMT,tbl_Dpt.DeptName as DEPTNAME
FROM tbl_employee 
INNER JOIN tbl_Salary ON tbl_employee.eid = tbl_Salary.eid 
INNER JOIN tbl_Dpt ON tbl_Salary.eid = tbl_Dpt.eid 
WHERE tbl_employee.eid ='E101'
GROUP BY tbl_employee.E_Name,tbl_Dpt.DeptName) as A

Hi debasis,
Thanks for reply..
The format is not same some times the data will be like

AB1A
AB2B

I think we cannot include this column in order by.
Any idea or suggestions?

Thanks

you need to pass the index of array element to remove. and in loop if u do it u will get error saying index out side the bounds of array, as element is deleted.

Hi All,
I have column which consist of data like

AB1
AB2
AC3
AD5
AB1
AB2

When i do order by this coulumn, its not ordering properly.
It should order like
AB1
AB1
AB2
AB2
AC3
AD5

Thanks

Good..Then please mark the thread as solved.. :)

Yes as debasis said, Have one column like Status or somthing, Update it to Incactive if attemt reaches to 3+ and check this status while ur doing validation when user hits on logon button. If Status is Inactive give message and exit..

Sorry u need months right? try this

resultdate = DateDiff(DateInterval.Month, date1, date2)

What is the field in database? and Call_Date is datetime datatye? it should be datetime. and instead of passing it as parameter u can use system.datetime.now.

Dim resultdate As Long

        resultdate = DateDiff(DateInterval.Year, date2, date1)

Try this...

Are you using any database? Are you keeping the details of user name and password in DB?

Before running the execute query statement, take the select statement and try to run in DB so u will come to know where and what is missing...

100 record is not bulk for sql..

Textbox1.text = DropDownList.text.tostring() Try this... Sumtines if u miss paranthysis for .tostring method it wont work

TextBox1.Text = DropdownListBox1.Text.ToStringTextBox1.Text = DropdownListBox1.Text.ToString()[

This should work man... :( i dont know whats the problem. can u paste ur code here if u can?

Add panel to form and cover the panel to form then add ur controls to panel and set dock property

TextBox1.Text = DropdownListBox1.Selectedtext.ToString

or

TextBox1.Text = DropdownListBox1.Text.ToString

try these two..

right click on a file and use "open with..." to open it with my program. How can I do it?
For this you need to install your application in the system. then you could see your application in the selection list.

Hi, This is the code given by debasis das in this forum for some one.
See if this can help you..

Public Function NumToWord(ByVal numstr As Object) As String

        Dim newstr As String
        Dim tempstr As String = ""
        numstr = CDec(numstr)

        If numstr = 0 Then
            NumToWord = "Zero"
            Exit Function
        End If

        If numstr > 10 ^ 24 Then
            NumToWord = "Number too big"
            Exit Function
        End If

        If numstr >= 10 ^ 12 Then
            newstr = NumToWord(Int(numstr / 10 ^ 12))
            numstr = ((numstr / 10 ^ 12) - _
            Int(numstr / 10 ^ 12)) * 10 ^ 12
            If numstr = 0 Then
                tempstr = tempstr & newstr & "Bilion "
            Else
                tempstr = tempstr & newstr & "Bilion "
            End If
        End If




        If numstr >= 10 ^ 6 Then
            newstr = NumToWord(Int(numstr / 10 ^ 6))
            numstr = ((numstr / 10 ^ 6) - _
            Int(numstr / 10 ^ 6)) * 10 ^ 6
            If numstr = 0 Then
                tempstr = tempstr & newstr & "milion "
            Else
                tempstr = tempstr & newstr & "milion "
            End If
        End If

        If numstr >= 10 ^ 3 Then ' thousand
            newstr = NumToWord(Int(numstr / 10 ^ 3))
            numstr = ((numstr / 10 ^ 3) - Int(numstr / 10 ^ 3)) * 10 ^ 3
            If numstr = 0 Then
                tempstr = tempstr & newstr & "thousand "
            Else
                tempstr = tempstr & newstr & "thousand "
            End If
        End If

        If numstr >= …

Hi Sandeep,

I also gave the same answer right? I just said Getdate() instead of exact date.

Where you are creating the folders? is user is having the fullcontrol over the folder?. after installing the application can you the folder got created where u want it to be?

U want to open in webbrowser? or u want to show the webpage in winform?.

Sorry i was wrong. here is the code.

select dateadd(month,2,getdate())

Maonths.Add function u have to use

Hi LUC001,

This makes the form to ocupy complete screen. i have MDI parent form
and i want my child form to fit within the boundaries of it.
Thanks for any help on this.

Hi All,

Can anyone throw idea to make the form as Resolution Independent?

Thanks..

Ur playing with grid without binding any records to it.:)
u myt be getting error if im right. first bind records before u start playing with grid...

Ur talking about two things here, Writing insert,update,delete query in class and stored procedure. both are differnt. you mean to say writing seperate class for handling database transactions?

If you publish your application also code can be viewed using reflector.
So you need to Obfuscation of code.. Look into this link for more info
http://www.dotnetspider.com/resources/664-What-Obfuscation.aspx

Try using Ajax update panel.. Only the controls which all are in ajax panel will get refreshed rather the complete page..

In combobox selected index changed event get the selected item and set it to textbox

In vb.net also for textbox there is a property called MAXLength u can set the length there..

Get the input from the user, If your using SQL server u can use fulltext index serach functionality. It will serch in table u mentioned for the words u pass and gives the result set.

Dim webAddress As String = "http://Google.com/"

        Process.Start(webAddress)

It will be dere under data tab. there will be tabs like Standard,Data,Validations etc..etc.. it will be there under Data tab.

Which framework are you using?

Drag and drop the gridview on ur page. it will write some code in the designer. read that code, and next time u write the code dont drag.:)
Assign the dataset to gridview as source wherever u want to.

you mean you want to show the IE in windows form?

which database ur using?

Made the copylocal proprty true. and see any error while accessing the client machine. Sometimes user will not be local admin and will not have access to some folders.

CREATE PROCEDURE [dbo].[pr_OutputPara,]            
                (            
                @test as varchar(10) 
                @out VARCHAR(10) OUTPUT          
                )            
AS  
BEGIN 
--Write  your business logic here
Select @out 
END

This is at the sp level..
In ado .net code

Dim output as string""
command.Parameters.Add("@Out", SqlDbType.VarChar, 10).Direction = ParameterDirection.Output
'After execution of query
 output = command.Parameters("@out").Value.ToString

Are your files are in debug folders when you build ur application?
in debug mode can u check?

If System.IO.File.Exists("Your file path") = True Then
        ' File exist do what you want
Else
         Messagebox.show("File does not exists")
        End If

The above code is vb.net syntax to check the file exist or not in specific location. may be simillar function may exist in vb6 also.

Which data base ur using? MDB? your application is copying database in the client machine?

Use output parameters..
like declare @result int
@result output.
In ADO.net method also u need to have one variable of same data type. and u have to use parameter.direcection method.