15,797,164 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Python questions
View PHP questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by sv sathish (Top 64 by date)
sv sathish
26-Feb-16 9:59am
View
this is my code for using that dll using assembly
Assembly DynamicAssembly = Assembly.LoadFile(_pathDetails);
string _propsVal = string.Empty;
string fileName = Path.GetFileNameWithoutExtension(_pathDetails);
object DynamicValObj = new object();
foreach (Type type in DynamicAssembly.GetTypes())
{
if (type.IsClass == true && type.FullName.EndsWith("." + fileName))
{
DynamicValObj = Activator.CreateInstance(type);
}}
sv sathish
26-Feb-16 9:56am
View
i want to unload the file from assembly.
how to do that
if i do that problem ill solve
sv sathish
26-Feb-16 9:55am
View
sir am editing the path for this post, so this is not a problem.
sorry for that code.
sv sathish
26-Feb-16 8:12am
View
i want kill the process from code
how to do that ???
sv sathish
11-Sep-14 7:02am
View
My problem was solved, am uninstall the postfix and install sendmail in my centos server,now the php mail function is working properly...
thanks for all.
sv sathish
11-Sep-14 2:35am
View
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
sv sathish
11-Sep-14 2:30am
View
sir please tell me how to check this, i was try many ways but mail is not going
sv sathish
20-Aug-14 3:31am
View
showing Mail log
Aug 20 03:19:38 SERVER07 sendmail[21314]: NOQUEUE: SYSERR(apache): can not chdir(/var/spool/clientmqueue/): Permission denied
sv sathish
11-Jul-14 0:14am
View
Deleted
sv sathish
15-May-14 2:45am
View
thank you...
sv sathish
7-Feb-14 6:59am
View
okay how to get a form controls from another form, Send your good idea.
sv sathish
7-Feb-14 6:30am
View
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???
sv sathish
7-Feb-14 6:27am
View
You test this code?? Your Comments not helpful me... please post any another ideas..
sv sathish
3-Feb-14 1:26am
View
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..
sv sathish
3-Feb-14 0:46am
View
I want c# code Nandy..
sv sathish
13-Dec-13 12:02pm
View
Thank you sir
sv sathish
13-Dec-13 5:03am
View
Deleted
Thank You spending time for me , but this code is not working...
please share another ideas..
sv sathish
12-Dec-13 11:20am
View
Sir i could not understand your answer pls clarified your answer...
sv sathish
12-Dec-13 11:11am
View
sir the gridview column index is not permanent,because month wise the day is changing so the gridview column index also changed..
sv sathish
12-Dec-13 11:03am
View
windows apps
sv sathish
12-Dec-13 11:03am
View
Backcolor
sv sathish
24-Nov-13 9:00am
View
Thank you so mush sir;)
sv sathish
24-Nov-13 2:32am
View
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...
sv sathish
24-Nov-13 2:00am
View
Thank you sir:)
sv sathish
18-Nov-13 14:47pm
View
thanks for your replay...
but it's not use for me,i want print the group box contents without groupbox... that's all
sv sathish
6-Oct-13 13:07pm
View
Deleted
Thank you sir,it's work.
sv sathish
6-Oct-13 13:06pm
View
Thank you sir.. it's work..
sv sathish
4-Oct-13 14:46pm
View
Thank you so mush sir..
sv sathish
20-Sep-13 0:51am
View
where i put the body content from database in this code?????
sv sathish
3-Sep-13 6:10am
View
Sir i am using MS Access database.
sv sathish
3-Sep-13 5:57am
View
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.
sv sathish
3-Sep-13 5:16am
View
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.
sv sathish
3-Sep-13 4:54am
View
Sir pls Tel me Where i write the query "Select * From [table name] where ClientID=@ClientID"
In Form ? or SystemReportFilterByID..??
sv sathish
3-Sep-13 0:49am
View
pls send your ideas sir..
sv sathish
2-Sep-13 15:40pm
View
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...
sv sathish
30-Aug-13 7:49am
View
I am using vb.net sir so pls send vb.net code.
sv sathish
27-Aug-13 6:25am
View
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.
sv sathish
27-Aug-13 6:18am
View
this case i want to Group by
Invoice id,
Client id and
Client name
sv sathish
16-Aug-13 13:52pm
View
Thank for smart and simple answer
sv sathish
16-Aug-13 7:00am
View
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.
sv sathish
15-Aug-13 10:59am
View
U want like this
-----------------------------------------------
Name | Fruits | Snacks | Vegetables | Total
-----------------------------------------------
xxxx | 2 | 2 | 2 | 6
yyyy | 1 | 1 | 1 | 3
-----------------------------------------------
sv sathish
15-Aug-13 10:49am
View
the error show in "SmtpServer.SendMailAsync(mailMessage)" line the error is
"A recipient must be specified."
sv sathish
15-Aug-13 10:42am
View
sir Null means the output is not coming...
sv sathish
15-Aug-13 10:39am
View
i help you but your question is not understandable so update your question in easy manner.
what is use of "Total" in Gridview1.
sv sathish
15-Aug-13 7:01am
View
It's showing error in Create Report Data Source. in this code what's mean by ("Product,data")
sv sathish
14-Aug-13 1:58am
View
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..
sv sathish
13-Aug-13 13:12pm
View
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'.
sv sathish
13-Aug-13 12:12pm
View
with out # it's running sir
sv sathish
13-Aug-13 6:17am
View
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
sv sathish
13-Aug-13 5:25am
View
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..
sv sathish
13-Aug-13 4:51am
View
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'. "
sv sathish
13-Aug-13 4:36am
View
sir how to use date time picker in this code. i want display the total amount in between two dates using date time picker.
sv sathish
13-Aug-13 0:56am
View
thank you soooooo much sir.
sv sathish
12-Aug-13 7:35am
View
i want separate total amount,and how to insert cells in data grid view in between cells..
pls send the code sir...
sv sathish
4-Aug-13 7:45am
View
this code is display the first column Sbalance amount only display one textbox
sv sathish
4-Aug-13 7:19am
View
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..
sv sathish
3-Aug-13 2:04am
View
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()
sv sathish
31-Jul-13 2:43am
View
thank you for your answer sir...
sv sathish
30-Jul-13 12:25pm
View
i am using oledb sir
sv sathish
30-Jul-13 12:23pm
View
Thanks your answer, but sorry it's not working
sv sathish
29-Jul-13 9:56am
View
i want only display the 2 fields in a data gridview the positions not a problem
sv sathish
29-Jul-13 9:06am
View
i want code for send the e-mail for daily 8o clock in morning with some attachments
sv sathish
29-Jul-13 9:06am
View
Deleted
i want code for send the e-mail for daily 8o clock in morning with some attachments
sv sathish
26-Jul-13 0:55am
View
Thank you so much
Show More