Comments by sv sathish (Top 64 by date)

My /etc/resolv.conf file content is

# Automatically generated by myCloud (3.0.8)
#domain localdomain
#nameserver 206.123.64.245
#nameserver 206.123.64.4


127.0.0.1 localhost.colud.choicefone.com localhost

sir please tell me how to check this, i was try many ways but mail is not going

showing Mail log

Aug 20 03:19:38 SERVER07 sendmail[21314]: NOQUEUE: SYSERR(apache): can not chdir(/var/spool/clientmqueue/): Permission denied

thank you...

okay how to get a form controls from another form, Send your good idea.

i know how to add the controls in panel in same form. my question is how to add the form in panel from another form. It's possible or not???

You test this code?? Your Comments not helpful me... please post any another ideas..

Nandy i am using another method,i remove the first column in excel using (Data Table .Rows.RemoveAt(0))Code. now my problem is solved.
Thank you for your comments..

I want c# code Nandy..

Thank you sir

Sir i could not understand your answer pls clarified your answer...

sir the gridview column index is not permanent,because month wise the day is changing so the gridview column index also changed..

windows apps

Backcolor

Thank you so mush sir;)

Sir i want another help
You See the same table,the credit_id=5 means the result is NULL.
i want the result,For example the credit_id is 5 then

SUM(Amount) where credit_id=`5` - SUM(Amount) where debit_id=`5`;
i expected result is 20...
how it's possible...

Thank you sir:)

thanks for your replay...
but it's not use for me,i want print the group box contents without groupbox... that's all

Thank you sir.. it's work..

Thank you so mush sir..

where i put the body content from database in this code?????

Sir i am using MS Access database.

Sir I am using visual Studio 2012. so Query option is not in dataset. And i right click the dataset there are only one option is there,that is General, in this General only use for choose the dataset. So please tel me a another way to write the query in SystemReportFilterByID.

Sir where i write the query in SystemReportFilterByID.
i am creating the SystemReportFilterByID parameter in report,and right click the SystemReportFilterByID and go to parameter properties there are 3 tabs is display
(1)-General
(2)-Available Values
(3)-Default Values.

only this tabs are display i don't where i write the query in SystemReportFilterByID.


please tel sir where i put the query in SystemReportFilterByID.

Sir pls Tel me Where i write the query "Select * From [table name] where ClientID=@ClientID"
In Form ? or SystemReportFilterByID..??

pls send your ideas sir..

Truly saying i am not touch this process, because i have no idea for how to do this.I am creating RDLC using parameter passing methods only,But in this Case is different, so only i am stuck this report Generating...

I am using vb.net sir so pls send vb.net code.

Thank you for your response Sir but it's not clear for me,Because I am beginner of the coding, so pls send easy way to understandable code me Sir.
And i want vb.net code sir.

this case i want to Group by
Invoice id,
Client id and
Client name

Thank for smart and simple answer

Thank you sir but in this link's not help full to me, because i am a beginner of the vb.net.
so pls send the easy code.

U want like this
-----------------------------------------------
Name | Fruits | Snacks | Vegetables | Total
-----------------------------------------------
xxxx | 2 | 2 | 2 | 6
yyyy | 1 | 1 | 1 | 3
-----------------------------------------------

the error show in "SmtpServer.SendMailAsync(mailMessage)" line the error is

"A recipient must be specified."

sir Null means the output is not coming...

i help you but your question is not understandable so update your question in easy manner.
what is use of "Total" in Gridview1.

It's showing error in Create Report Data Source. in this code what's mean by ("Product,data")

i try this code but the problem is not clear..

Public Sub Display()
Dim con As OleDbConnection = New OleDbConnection("Provider=Microsoft.jet.oledb.4.0;data source=D:\Programs\sathish\invoicedb.mdb")
con.Open()
cmd = New OleDbCommand("select MAX(invoiceid) from invoice ", con)
adp = New OleDbDataAdapter(cmd)
ds = New DataSet
adp.Fill(ds, "invoice")
TextBox1.Text = (ds.Tables(0).Rows(0).Item(0)) + 1
con.Close()
End Sub

the same problem is here, the database is already fill then in this code is good but the data field is empty then it's not working..

Sir it's not working it's showing error.. the code and error is below

Dim i As Integer
i = DataGridView2.CurrentRow.Index
If DataGridView2.Item(0, i).Value <> DBNull.Value Then
TextBox12.Text = 1
Else

TextBox11.Text = DataGridView2.Item(0, i).Value.ToString
TextBox12.Text = Val(TextBox11.Text + 1)
End If


the error is:
Operator '<>' is not defined for type 'Integer' and type 'DBNull'.

with out # it's running sir

i do it sir: My code

Dim con As OleDbConnection = New OleDbConnection("Provider=Microsoft.jet.oledb.4.0;data source=D:\Programs\sathish\invoicedb.mdb")
Dim cmd As OleDbCommand = New OleDbCommand("SELECT productname, Totalamount,Amountpaid,BalanceAmount FROM(SELECT productname,Totalamount,amountpaid,BalanceAmount FROM invoice where invoicedate between " & DateTimePicker1.Value.Date.ToOADate() & " and " & DateTimePicker2.Value.Date.ToOADate() & " UNION ALL SELECT productname + ' - Total:' AS productname, SUM(totalamount) AS Totalamount,SUM(amountpaid) AS Amountpaid,SUM(BalanceAmount) As BalanceAmount FROM invoice where invoicedate between " & DateTimePicker1.Value.Date.ToOADate() & " and " & DateTimePicker2.Value.Date.ToOADate() & " GROUP BY productname + ' - Total:') AS T ORDER BY productname ", con)
con.Open()
Dim myDA As OleDbDataAdapter = New OleDbDataAdapter(cmd)
Dim myDataSet As DataSet = New DataSet()
myDA.Fill(myDataSet, "invoice")
DataGridView1.DataSource = myDataSet.Tables("invoice").DefaultView



now it's runing

i change my code for your idea but still the error is appeared pls send the full code for display the total amount in between two dates..

i already try it sir and the code is below:
Dim con As OleDbConnection = New OleDbConnection("Provider=Microsoft.jet.oledb.4.0;data source=D:\Programs\sathish\invoicedb.mdb")
Dim cmd As OleDbCommand = New OleDbCommand("SELECT productname, Totalamount,Amountpaid,BalanceAmount where invoicedate between " & DateTimePicker1.Value.Date() & " and " & DateTimePicker2.Value.Date() & " FROM (SELECT productname,Totalamount,amountpaid,BalanceAmount FROM invoice UNION ALL SELECT productname + ' - Total:' AS productname, SUM(totalamount) AS Totalamount,SUM(amountpaid) AS Amountpaid,SUM(BalanceAmount) As BalanceAmount FROM invoice GROUP BY productname + ' - Total:') AS T ORDER BY productname ", con)
con.Open()
Dim myDA As OleDbDataAdapter = New OleDbDataAdapter(cmd)
Dim myDataSet As DataSet = New DataSet()
myDA.Fill(myDataSet, "invoice")
DataGridView1.DataSource = myDataSet.Tables("invoice").DefaultView


i get the error in this methode, the error is " Syntax error (missing operator) in query expression 'BalanceAmount where invoicedate between 13-08-2000 and 13-08-2013'. "

sir how to use date time picker in this code. i want display the total amount in between two dates using date time picker.

thank you soooooo much sir.

i want separate total amount,and how to insert cells in data grid view in between cells..
pls send the code sir...

this code is display the first column Sbalance amount only display one textbox

Imports System.Data.OleDb
Public Class last
Dim sqlCount As String
Dim Cmd As OleDbCommand
Dim dReader As OleDbDataReader
Dim Con = New OleDbConnection("Provider=Microsoft.jet.oledb.4.0;data source=E:\data.mdb")
Private Sub last_Load(sender As Object, e As EventArgs) Handles MyBase.Load
sqlCount = "SELECT top 1 Sbalance FROM Table2"

Cmd = New OleDbCommand(sqlCount, Con)

Con.Open()

dReader = Cmd.ExecuteReader(CommandBehavior.CloseConnection)

If dReader.Read = True Then

TextBox1.Text = dReader("Sbalance").ToString

End If

Con.close()

End Sub
End Class




this code is display the top column of the database value i want last column value..

i try it this code also

Dim str As String = "select SUM(salary) from q where ID=" & TextBox1.Text
Dim cmd As OleDbCommand = New OleDbCommand(str, con)
cmd.Connection = con
Dim dr As OleDbDataReader = cmd.ExecuteReader()

While (dr.Read())
TextBox2.Text = dr("SUM(salary)").ToString()
' TextBox2.Text = str

End While
dr.Close()
' con.Close()

thank you for your answer sir...

i am using oledb sir

Thanks your answer, but sorry it's not working

i want only display the 2 fields in a data gridview the positions not a problem

i want code for send the e-mail for daily 8o clock in morning with some attachments

Thank you so much