Comments by soeun tony (Top 63 by date)

i want to display logout page when the code is error in controller.
Thanks

Hi Maciej Los,
Sorry for not clear about my question. In fact,in table(tblmix_sales_header_details) has many item. So i can' t do like your way. if i did like ur way, it means that i have 4 items.

Thanks

TONY

Hi Raimis9,
Thanks for ur reply. The path of image already store in database ( I have other application and that application store path of image only). So it means that i don't build application by myself but i can create CR and insert to that application.

TONY

Hi Bandi-Ramesh,
I try to use fileupload1.filename and fileupload1.postedfile.filename already
but it returns me the file name only.

Thanks

Hi Sergey,
I mean i want to call this store procedure in vb.net

Thanks

TONY

Hi Santhosh
It works now

Thanks

Hi Joan,
Thanks for your good idea.i'll follow you next time.

Hi Kenneth,
Sorry that don't input my code. Here is my code:
Dim MyConnection As OleDb.OleDbConnection,DA As OleDb.OleDbDataAdapter
MyConnection = New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Me.TextBox1.Text & ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'")
DA = New System.Data.OleDb.OleDbDataAdapter("select * from [Detail$]", MyConnection)
DA.TableMappings.Add("Table", "Tbl1")
DtSet = New System.Data.DataSet
DA.Fill(DtSet)
Me.DataGridView1.DataSource = DtSet.Tables(0)

Note:
My MS Office is : 2007

Thanks

TONY

Hi a4ashiq,
Your simple is very useful for me. Thank you so much for this posted.

TONY

Hi Wes Aday,
i said about combo box.So it means that i already created a project. Have you ever dropped a combo box without created project?. We need to created Project First.Am i right? Here is my query to display customer group "select code,name from customergroup". My question is how can i get the group code when i select group name in combo box?
Thanks
TONY

Hi aarti,
this way can be use when my datagrid already has columns.
but for my problem is that all value that display in datagridview will be shown when i click on Display Button.
It means that at design time my datagridview not yet set columns.
Thanks
TONY

Hi Kenneth,
It is an example that i made myself and the real information i got also like this.
Based on your link, it is in Visual Studio....but i want to do it in SQL Server.

Thanks

TONY

Hi Kamalakanta Nayak
Can Row_Number() use without Over(Order by[field])?

Thanks

TONY

Hi Sandeep,
You say about the local temporary database based on which client system.I don't understand about this.
You mean do we need to have 2 databases (One at server and one at client).
Thanks
TONY

Hi Sandeep,
Let me sorry for unclear information.I have one Server at the Head Office and 3 Clients at shop.
At the Head Office is often no electronic and at the client side,they can use normally.When the Server at head office is no electronic mean that the connection also disconnect.When the client send data to server,it will display an error message about the connection.My question is that how do client still work even the server is disconnect?
Note: The client is using POS System.

TONY

Hi Sandeep Mewara,
i follow your second link. but my report still the same.
Thanks

Hi RDBurmon,
My project will do like this in future.

Thanks

TONY

Hi losmac
I have followed with your idea.For your 1 Option,it displays include child item and father item and it doesn't display an item that not child or father(in example is item J)). For your 2 Option,It displays only the father Item and doesn't display item (J).

Thanks

TONY

Hi Losmac
Please go to this link then you will see the 2nd Solution.That solution is what i want to be.
http://www.codeproject.com/Answers/388358/Select-Statement-in-sql-server-2008-R2#answer2
Thanks
TONy

Hi Losmac,

Thanks

Hi all,
Here are my table structure.
table1(Code [int],itemcode[varchar(20)],itemname[varchar(50)],price [numeric(18,2)],qty[int],amount[numeric(18,2)])
table2(FatherCode[varchar(20)],ChildCode[varchar(20)],docdate[datetime])
Thanks

Hi all,
Here are my table structure.
table1(Code [int],itemcode[varchar(20)],itemname[varchar(50)],price [numeric(18,2)],qty[int],amount[numeric(18,2)])
table2(FatherCode[varchar(20)],ChildCode[varchar(20)],docdate[datetime])
Thanks

Hi Sandeep Mewara

-I use AxCrystalActiveXReportViewer control to display report.
-I add reference Crystal Report ActiveX Designer Design And Runtime Library 10.5
-I use Crystal Report Basic 2008 for SAP Business One Version 12.1.0.892
Does all of them match for each other?
Thanks

TONY

Thanks for your reply.
Yes of course. i have import some DLL file in my project.

Thanks

TONY

Thanks for your reply.
In this sample,they use range value between 1 to 100.but for my work,i don't care about the maximum value.i just care about minimum only.

Thanks
TONY

Thanks for your reply.
Let me sorry that my question not clearly.
infact my question is i want to write the string in text to textfile.
So Please help me about this.
Thanks
TONY

Thanks for your reply
Could you tell me the sample?
let me sorry for this but i really want to know about it.
Thanks

thanks for your reply
i want write image file to file.infact i can write the path of image to file but for this way when i delete the image mean that i can't display that image anymore
Thanks

Thanks for your reply
in my shell script, i will let user to input user name.
example: user input new user name is "jonh"
so i want to compare the new user name "jonh" with old user in system.
Thanks

Thanks for your reply
Could you tell mo how i can do about( changing the name of the image)?
Could you send me the link how to do that?
Thansk

No, This code is in button Save. i also use this code with saving data to MS SQL server and it still keep data long time.
Thanks

Thanks for your reply
I'll try to follow you
Thanks

Thanks for your reply
Now it is ok now
i use the same that you said above
Thanks

Thanks for your reply
Now it is ok
Thanks

Thanks for your reply
Do you mean use Form_KeyDown Event?
I use keyDown Event but i don't see e.keyChar.
what property should i use?

Best Regards,

Thanks for ur reply
I'll follow your idea.
This is a good idea that i forget to do.
Thanks

Thanks for your reply
i have link to your like http://www.codeproject.com/KB/cs/hard_disk_serialno.aspx
i also copy this code ManagementObjectSearcher searcher = new
ManagementObjectSearcher("SELECT * FROM Win32_DiskDrive");

foreach(ManagementObject wmi_HD in searcher.Get())
{
HardDrive hd = new HardDrive();
hd.Model = wmi_HD["Model"].ToString();
hd.Type = wmi_HD["InterfaceType"].ToString();
hdCollection.Add(hd);
}
to my application and i changed it to VB.NET Format like this:
Dim searcher As New ManagementObjectSearcher("SELECT * FROM Win32_DiskDrive")

For Each wmi_HD As ManagementObject In searcher.[Get]()
Dim hd As New HardDrive()
hd.Model = wmi_HD("Model").ToString()
hd.Type = wmi_HD("InterfaceType").ToString()
hdCollection.Add(hd)
Next
but it has problem coz of Dim hd As New HardDrive(). i already add referent and import System.Management. but it still error
Please help me
Best Regard,

Thanks for your reply
Could you tell me how i can make my table with the same character?
(customercode in customer table and customercode in purchase table have the same data type "nvarchar(10)")

Best Regards,

Thanks for your reply
I'll try to follow your idea
Thanks

Thank for your reply
Yes, This is what i want. Now i can modify my table.
Thanks for your help

Thanks for your reply
This is what i want to know.
Thank you so much for your help

Thanks for your reply,
For this way, it is used for start or stop service. but my purpose, when the service stop, i want to display message to let user to know that "Server has been stopped". this is my purpose (Just want to display message to let user to know only).
Best Regards,

Thanks for your reply
Yes of course my code is no exceptions because i want to test to see the result.later i'll use exception. it is not difficult to use exception.
Thanks

Thanks for you reply
my user is Built-in User (Administrator).
Best Regards,

Thanks for your idea,
For that idea, it is very good and i'll follow with your idea.
but for example, the user is using my application than the sql server service is stop by itself. in that case, i want to show message to user that "Service of Server has problem" to let the user know that the server has problem than they'll go to service.msc to start it again.

Best Regards,

Thanks for your reply
You say "DO NOT OPEN A CONNECTION TO THE DATABASE AND KEEP IT OPEN FOR THE LIFE OF YOUR APPLICATION!"
I don't understand what you refer.
Could you explain me more?
Best Regards,

Thank for ur reply
Do you mean like this:
Dim obj(3) as student
redim preserve obj(3)
obj(0).SetID=1
obj(0).SetName="A"
obj(1).SetID=2
obj(1).SetName="B"

Please help me,I really want to know about this. Cos i'm the new for vb.net
Best Regards,

Thanks for ur reply
This is for code that i used at form load event
ReDim Preserve obj(2)
obj(0).SetID = 1
obj(0).SetName = "A"
obj(1).SetID = 2
obj(1).SetName = "B"
obj(2).SetID = 3
obj(2).SetName = "C"
The error like this:"Object reference not set to an instance of an object."
Best Regards,

Thanks for your replied
normally, after we created datasource.it will created one dataset.at that time, when my text box link to field of the table in dataset at form loaded Event, it will display: myTableAdapter.Fill(Me.myDataset.myTable) code automatically.When i open my form, i will see any value on my text box and i also can move next, move last, move first....But for my purpose, i don't want to use myTableAdapter.Fill(Me.myDataset.myTable) at form loaded Event.so if i dont use it, when i open my form. it also don't display any value on text box too.
My purpose is: I don't want to use myTableAdapter.Fill(Me.myDataset.myTable) at form loaded Event but i can move next, move last,move first.......
Best Regards,

Thanks for your reply
but field code in that table can't be null or ""
coz it will be used to other table.
Best Regards,

Thanks for your reply.
if do like mean that in the datagrid can input only one time,i mean that normally for detail the user can input many time.Ex:detail table has ItemCode,ItemName, so the user can input 3 times of item in datagridview so SaleDetailCode also increase 3 automatically too. and when the user click on Save Button,The system will save Master Data and Detail(in GrideView 3 rows) to each table.
Best Regards,

Thanks for your reply.
if do like this. it means that we have 4 results(1 for datatable1 result,2 for datatable2 result,3 for datatable3 result,4 for datatable4 resutl). but i want to get only one result and that result will sum all columns of each datatable.
Best Regards,

Thanks u so much for ur code.
This is what i need.
Best Regards

Thanks for ur reply
I use GridView to display

Thanks for ur advice
but in fact, in my datasource has 8 columns already and when i drop it on my Sale Form, it also show 8 text boxs too(Each text box link to each field in table). but i delete 1 text box(that text box link to empcode in my table) from my form. because of that i want it to get value from Log In form(when i log in, i have variable to get empcode).So when i Click Save on the Sale Form, i want the variable(variable that store empcode at log in time) to save to my table too.

Best Regards,

Thanks for ur reply
This is what i want.