Search:

Type: Posts; User: zeus85

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Re: How to pass sub query result into RDLC table ???

    please any help i had done this method before but i forget how
  2. Re: How to pass sub query result into RDLC table ???

    please any help, ideas its a very urgent issue
  3. How to pass sub query result into RDLC table ???

    Hi every 1,

    I have some data to display in RDLC report which contain IIF function something like


    "select prod,iif(mink>0,mqty\mink,'0')as Carton from products"

    now, how can i pass the...
  4. Replies
    8
    Views
    3,559

    Re: Huge data manipulation with VB.NET ?

    well after trying the data table data filtering i found it very useful in my case code below show how to do some queries on datatables


    Dim dt As New DataTable ' Create DataTable...
  5. Replies
    8
    Views
    3,559

    Re: Huge data manipulation with VB.NET ?

    Woow, thanks man you had just give me more than 3 ways to solve my issue i will try them all and c what will fit with my app requirements and will post the best solution back.
  6. Replies
    8
    Views
    3,559

    Huge data manipulation with VB.NET ?

    Hi every 1,

    This my first time to deal with huge data that i get from some other application exported to .TXT file ,this data has over than million rows and 15 columns as max, many of those rows...
  7. SQL server Tables creating after installing my application on client pc ??

    hi every 1,

    i'm developing some accounting application using vb.net & sql server 2012 express edition as my DB , on the designing phase i made all the tables manually with SQL server management...
  8. Replies
    6
    Views
    1,152

    Re: import data from excel to access db

    any ideas plz ??
  9. Replies
    6
    Views
    1,152

    Re: import data from excel to access db

    this is my code


    Dim dtExcelData As DataTable
    Function ReadExcelFile()
    Dim da As New OleDbDataAdapter
    Dim dt As New DataTable
    Dim cmd As New OleDbCommand
    ...
  10. Replies
    6
    Views
    1,152

    Re: import data from excel to access db

    Ok my Friend,

    for example if i get the data from the first application with excel the result will be like below

    ID Name Age
    --- ------- ----
    1 AAA 24
    2 BBB ...
  11. Replies
    6
    Views
    1,152

    import data from excel to access db

    HI every 1,

    i have some data that i extract from an application by excel sheet and i have successfully import it to my access db to make some analysis on it using my vb.net app, my issue that the...
  12. Replies
    2
    Views
    5,919

    Re: Grouping and Row Details for DataGrid

    Xaml :


    <Grid>
    <DataGrid AutoGenerateColumns="False" Name="DataGrid1">
    <DataGrid.Columns>
    <DataGridTextColumn Header="Customer ID" Width="100"...
  13. Replies
    2
    Views
    5,919

    Re: Grouping and Row Details for DataGrid

    Hello!! .... any ideas !!
  14. Replies
    2
    Views
    5,919

    Grouping and Row Details for DataGrid

    Hi every 1

    Please i'm new with WPF, i have DB with 2 tables (Customers_details,Customers_Activities) and i want my WPF (vb.net) app datagrid to do the following :

    1- show the customers details...
  15. Replies
    8
    Views
    1,359

    Re: Help with SQL statement !!

    thank u very much for your replies and hints, iv figured out what is wrong with my statement its was in front of me all the time the modification is just like below hope to help some one :)


    ...
  16. Replies
    8
    Views
    1,359

    Re: Help with SQL statement !!

    I agree with u but the SQL statement include a vb code !!
  17. Replies
    3
    Views
    1,052

    Re: How to check and open connection?

    Do u mean something like


    If con.State = ConnectionState.Open Then
    con.Close()
    End If
  18. Replies
    8
    Views
    1,359

    [RESOLVED] Help with SQL statement !!

    Hi every 1,

    i have access DB with my VB App. contain users activation dates gust like below,

    SUBUSER ------------------ FDATE

    user1 ------------------ 02/02/2105
    ...
  19. Replies
    3
    Views
    1,031

    Re: Need help with drawing app ??

    Thank u very much my friend :) , u make my day :wave:
  20. Replies
    3
    Views
    1,031

    [RESOLVED] Need help with drawing app ??

    Hi every 1....

    i'm working on some paint application which draw some stuff (rectangles, circles,...etc) on my picture box,
    i use the mouse_down event to draw my graphics (e.g rectangle w:30 ,H...
  21. Replies
    2
    Views
    1,331

    Re: Need Help : error datagridview while saving

    Edit the following code and try



    Dim chk As New OleDbCommand("select * from userinfo where [user]='" & TextBox1.Text & "'", con)
    Dim dr As OleDbDataReader
    con.Open()...
  22. VS 2010 Re: Drawing a lines from a given point with a given vector in visual studio 2010

    Try something like



    Dim linesendpoints() As Point = {New Point(34, 150), New Point(55, 78),.......}
    Dim gr As Graphics = Panel1.CreateGraphics
    Dim orignalpoint As New...
  23. Re: problem with name buttons according to DB records ??

    thank u very much my friend




    Dim btnArray() As System.Windows.Forms.Button = {Button40, Button39}

    For i = 0 To dt.Rows.Count - 1
    btnArray(i).Text =...
  24. [RESOLVED] problem with name buttons according to DB records ??

    HI every one
    i have column (prodname) and 5 buttons on my form my idea was to name these buttons according to the records which the user will insert into the prodname column, i used below code and...
  25. Replies
    6
    Views
    1,138

    Re: Need help with DATEDIFF funnction

    i solve it thank u very much


    "SELECT prod from store where exdate <= #" & Date.Today.AddMonths(2) & "#"
  26. Replies
    6
    Views
    1,138

    Re: Need help with DATEDIFF funnction

    yes my friend its works but what about the products that has expiration date less than 2 months it wont show it,your code will show products only if the difference is 2 months exactly . what if the...
  27. Replies
    6
    Views
    1,138

    Re: Need help with DATEDIFF funnction

    Thanx for your reply,
    Actually i don't want the app. to get only the products which will expire exactly in two month (60 days) according to the difference of today date and the expire date in the DB...
  28. Replies
    6
    Views
    1,138

    Need help with DATEDIFF funnction

    Hi every one
    I'm using Access DB with VB.net i have a table contain the products name (prod) and the expire date (exdate)
    i tried to run a query to find the products that has 2montuth date left...
  29. Re: Plz need help with Datetimepicker and inserting to DB

    Thank u very much my friend i had just solve it by declaring mydate before the insert command so it will be updated with every button bush
    thank u again
  30. Re: Plz need help with Datetimepicker and inserting to DB

    what is going on !!!

    i tried to use

    Dim mydate As String = Now.Month & "/" & Now.Day & "/" & Now.Year & " " & Now.Hour & ":" & Now.Minute & ":" & Now.Second
    instead of the datetimepicker...
  31. [RESOLVED] Plz need help with Datetimepicker and inserting to DB

    Hi every 1

    i have a serious issue with my datetimepicker, i used the datetimepicker.value to insert date & time into my access database the issue is that if i run the program @ lets say 4/4/2014...
  32. Re: Filter database record with DateTimePicker: VB2005

    Thank u All
  33. Re: How to draw gradient transparent circle in vb.net ?

    come on guy's,plz any suggestions.
  34. Re: How to draw gradient transparent circle in vb.net ?

    Sorry i attached it now
  35. How to draw gradient transparent circle in vb.net ?

    Hi Every 1 :wave:

    I need your help with my painting application, the idea is that i can draw a small circle on picture box using the mouse down event and after drawing the required
    number of the...
  36. Need Help with seending SMS ..Modem send nothing ???

    hello every one
    i'm using huawei E1552 modem to send SMS from my app.
    and bellow is the AT commands procedure to send SMS in the PDU mode and the modem response also, every thing seems ok , but i...
  37. problem with deleting rows in datagridview using the delete key !!!

    hello every one

    i have a strange problem with my app datagridview ? when i select any row and press the delete key it just do nothing .
    the allow user to delete row propriety is set to true ,...
  38. Re: need help with printing with out preview dialogue ??

    help help
  39. Re: need help with printing with out preview dialogue ??

    thank u for your responding
    dear friend as you said to be clear .actually i want to press a print button on my form and the report goes directly to the printer with out any dialogue and i think...
  40. need help with printing with out preview dialogue ??

    hello every one :wave:

    i'm using vb.net2008 and the RDLC reports and MS access i have made my DB application and every thing was awesome .
    now i need for method to get rid of the print preview...
Results 1 to 40 of 68
Page 1 of 2 1 2



Click Here to Expand Forum to Full Width