- Messages
- 243
- Reaction score
- 0
- Points
- 26
EDIT Again:
Pa help naman po I have this code below .
Ano po ang tamang code para sa InitialDirectory,
I mean like this my project located at,
Code:C:\Users\Mema\Documents\Visual Studio 2008\Projects\Inventory\
Then after clicking the button(w/ opendialog) automatic na po sya na dyan ang directory.
My point is kahit anong directory sya malagaay, pag iopen ulit dun lang din sa local directory.
Code:With OpenFileDialog1 .InitialDirectory = "C:\" .Filter = "All Files|*.*|JPEGs|*.jpg|Bitmaps|*.bmp|GIFs|*.gif" .FilterIndex = 2 End With If OpenFileDialog1.ShowDialog() = DialogResult.OK Then With PictureBox1 .Image = Image.FromFile(Me.OpenFileDialog1.FileName) .SizeMode = PictureBoxSizeMode.StretchImage End With End If
may property un opendialog
opendialog.RestoreDirectory = true
see reference here :
https://social.msdn.microsoft.com/F...-get-the-last-directory-after-open-filedialog
- - - Updated - - -
Paki sagot naman netong tanong ko sa stackoverflow mga ser
https://stackoverflow.com/questions/34264890/how-do-i-get-image-or-image-path-location-from-another-process
try mo gamitin un jetbrains decompiler
- - - Updated - - -
Hi Good day po,
Sino na po naka encounter nitong error na to?
kadalasan syang lumalabas after ko mag execute ng queries ko ng pag iinsert ng madaming records.
ang process ko, read text file, onload then iinsert sya sa database ko.
nag susuccess naman sya mag insert, pero after ng procedure lalabas yang error na yan.
SQL Problem kaya or sa memory ng mobile ko? madami pa naman ako extra space sa disk kaya sa tingin ko hindi ito sa disk space.
any comments or suggestion?
Code:Public Sub ReadMaster() If File.Exists("\Application\SOROSORO\IMPORT\Master.txt") = True Then Dim strItems_Data() As String Dim strItem As String Dim sqlceconn As SqlCeConnection Dim sqlsr As StreamReader = New StreamReader("\Application\SOROSORO\IMPORT\Master.txt") sqlceconn = New SqlCeConnection("Data Source = \Application\SOROSORO\SQL_DATA\DB.sdf ;Max Database Size = 4000 ;") sqlceconn.Open() 'Ignore the First Line - HEADER ' sqlsr.ReadLine() Do While sqlsr.Peek > -1 strItem = sqlsr.ReadLine.Trim strItem = strItem.Replace(Chr(34), Chr(32)) strItem = strItem.Replace(Chr(37), Chr(32)) strItem = strItem.Replace(Chr(38), Chr(32)) strItem = strItem.Replace(Chr(39), Chr(32)) strItem = strItem.Replace(Chr(44), Chr(32)) strItems_Data = strItem.Split(Chr(9)) insertMaster(strItems_Data, sqlceconn) Loop sqlceconn.Dispose() sqlceconn.Close() sqlsr.Close() End If End Sub
Code:Public Sub insertMaster(ByVal _data() As String, ByVal _myConn As SqlCeConnection) Dim _sqlcecmd As SqlCeCommand Try _sqlcecmd = New SqlCeCommand _sqlcecmd = _myConn.CreateCommand _sqlcecmd.CommandText = "INSERT INTO tbl_Master(Itemcode,ItemName,UomCode,ItmsGrpNam,Barcode" + _ ")" + _ "VALUES(@Itemcode,@ItemName,@UomCode,@ItmsGrpName,@Barcode)" _sqlcecmd.Parameters.Add("@Itemcode", SqlDbType.NVarChar, 50) _sqlcecmd.Parameters.Add("@ItemName", SqlDbType.NVarChar, 250) _sqlcecmd.Parameters.Add("@UomCode", SqlDbType.NVarChar, 50) _sqlcecmd.Parameters.Add("@ItmsGrpName", SqlDbType.NVarChar, 100) _sqlcecmd.Parameters.Add("@Barcode", SqlDbType.NVarChar, 100) _sqlcecmd.Prepare() _sqlcecmd.Parameters("@Itemcode").Value = _data(0).ToString.Trim _sqlcecmd.Parameters("@ItemName").Value = _data(1).ToString.Trim _sqlcecmd.Parameters("@UomCode").Value = _data(2).ToString.Trim _sqlcecmd.Parameters("@ItmsGrpName").Value = _data(3).ToString.Trim _sqlcecmd.Parameters("@Barcode").Value = _data(4).ToString.Trim _sqlcecmd.ExecuteNonQuery() _sqlcecmd.Dispose() Catch ex As Exception MsgBox("Insert" & ex.Message) End Try End Sub
Ano un error message?
sa tingin ko un connection mo...
try mo toh :
Dim _sqlcecmd As New SqlCommand
_sqlcecmd .Connection = _myConn
- - - Updated - - -
Sirs..Good day!
VB.NET newbie here.. with C++ knowledge lang..
I am planning to create an APP just like a reviewer sana.. where in sa 1st Form mo pwd ka mkapili ng Topic(e.g. MATH,ENGLISH,SCIENCE and the like), then it will automatically generate random question as you go throughout, then lalabas dun ung mga questions continually unless i-end mo na ung session mo.. Then it will give you your score, correct items tsaka ung mga mali mo.
Then meron nman specific Form pra mkapag update ka ng questions mo, mkadagdag ng questions, mag load ng questions..
I have question/s:
1. Is it possible na pwd mkasave ng data entries(i.e. Questions) sa local lang na station?
2. Is it simply means po ba na kapag may Microsoft Visual Studio ka, need mo din ng SQL,mySQL?( dpends on how they called it.) Medyo nangangapa pa kc ako sa VB.Net at SQL(?)
3. Would you give me advice kung anung approach ang dapat kong gawin with these scenarios?
4. If i don't have an SQL installed sa station ko, mkakapag save po kaya ako ng entries dun sa APP?
Hoping for your kind feedbacks.
Sa vb pede ka gumawa ng text file.... dun mo i-save un data mo.. formatted by comma or kaw bahala na mababasa ng program mo...
- - - Updated - - -
help po kasi susubukan ko mag publis hng file and then nag publish naman sya kaso di makita ung accdb ko...
paano po kaya yun? i also need to publish a folder named image... di kasi makita pagtapos kong mag install
pag publish gagamitin mo.. mag online installation yan, ngsave yan sa temp data folder... try mo magset-up ng offline installation package, para pede magconfige un save path
- - - Updated - - -
guys pahelp naman panu paganahin eto sa vb .. sa sql kasi gumagana pag inaaply ko na sa vb ayaw na "insert into voidreport select * from orderrecord where OrderNumber= 'ORN0000079'" gusto ko sana madelete ung mismong laman taz mapunta sa kabilang table ung mismong record na yan.. sample code nga po thanks
paste mo un complete code mo.. bka may kulang sqlcommand, sqlconnection or try catch mo.. para makita mo un error message
Last edited: