15,890,438 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 Visual Basic questions
View Python 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 basurajkumbhar (Top 52 by date)
basurajkumbhar
22-Feb-15 4:22am
View
Thanks for reply
I know these all i need suggestion like google
when we we first word it gives suggestion then second type it shows suggestion
like that..
basurajkumbhar
5-Feb-15 4:21am
View
Thanks for reply
I have tried all of this but in the integers it dosen't give any count
basurajkumbhar
18-Dec-14 7:54am
View
Thank's fro giving this help full link
Deepak....
basurajkumbhar
18-Dec-14 7:53am
View
Thank's a lot all of us for giving me reply it's working
Thank's a for specially 88388132 and Praveen Kumar
basurajkumbhar
18-Dec-14 7:23am
View
It gives error when load the page
Object Reference not set
basurajkumbhar
18-Dec-14 6:09am
View
When I click on the Generate Button then TextBox are created and when i click on the Calculate Button then
TextBox txt = (TextBox)Panel1.FindControl("tb" + i.ToString());
Here in the txt the vale is null,
ResultLabel.Text = txt.Text;
at this line line i am getting the error
Object reference not set to an instance of an object
What i want to do in my code to get the text value.
basurajkumbhar
11-Dec-14 1:52am
View
Thanks for reply but this is not working
I want to access the child page control on master page click event or page load
basurajkumbhar
2-Jul-14 1:23am
View
Thanks For Reply.
I appreciate your reply.
I want only do data fetching goes to fast, If there is any way to show the data immediately.
Please give me reply.
Once again thanks ...
basurajkumbhar
6-Mar-14 5:36am
View
dlg.InitialDirectory =""
here you can set where you want to get excel file.
Like
dlg.InitialDirectory="c:\"
basurajkumbhar
21-Feb-14 8:11am
View
Hi Sumit,
You have filed name id amount and you want the sum of the id amount ok..
go to your report right click on report and Insert then Summary and choose the filed which the you want the sum like "id amount"
I hope this will help you....
basurajkumbhar
5-Dec-13 8:03am
View
Thanks for reply..
But it gives error
like
Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index
basurajkumbhar
1-Dec-13 2:12am
View
Hi
Thanks for reply..
Please see the code..
Thanks.
basurajkumbhar
1-Dec-13 2:11am
View
HiThanks for reply
my problem is when i am store the date in database that time it is store by default 01/01/1900
i want to store current system date that is displayed in the date time picker.
I want to store the date time picker value or date.
basurajkumbhar
25-Nov-13 8:50am
View
hi,
i am tried "Math.Ceiling" but it gives out same as a "Math.Round"
basurajkumbhar
25-Nov-13 8:21am
View
Hi,
Thanks for reply,
I want round value when the entered value is greater than 1.01 then it show 2
i want like this ..
is it possible
basurajkumbhar
21-Nov-13 5:23am
View
Deleted
This is my complete class code
using Microsoft.VisualBasic;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Diagnostics;
using System.Data.Common;
public class General_function
{
internal System.Windows.Forms.DataGridView DG_ItemShow;
public static object Get_Single_Value(string SQLQuery)
{
try
{
object SingleValue = null;
DbConnection cn = database_Object.GetConnection(database_Object.Provider);
DbCommand cmd = database_Object.GetCommand(database_Object.Provider);
if (cn.State == ConnectionState.Closed)
{
cn.ConnectionString = My.Settings.Trasns_DataConnectionString;
cn.Open();
}
cmd.Connection = cn;
cmd.CommandText = SQLQuery;
SingleValue = cmd.ExecuteScalar;
return SingleValue;
}
catch (Exception ex)
{
Interaction.MsgBox("error in Get_Single_Value : " + ex.Message);
}
}
public static long get_Max_value(string tablename, string fieldname)
{
try
{
long maxvalue = 0;
DbConnection cn = database_Object.GetConnection(database_Object.Provider);
DbCommand cmd = database_Object.GetCommand(database_Object.Provider);
if (cn.State == ConnectionState.Closed)
{
cn.ConnectionString = My.Settings.Trasns_DataConnectionString;
cn.Open();
}
cmd.Connection = cn;
cmd.CommandText = "select max(" + fieldname + ") From " + tablename;
string res = null;
res = cmd.ExecuteScalar.ToString;
if (string.IsNullOrEmpty(res))
{
maxvalue = 0;
}
else
{
maxvalue = long.Parse(res);
}
return maxvalue;
}
catch (Exception ex)
{
Interaction.MsgBox("Error in get_Max_value" + ex.Message);
}
}
public static int Save_Record(ArrayList Al, string TableName)
{
try
{
int Retval = 0;
Trasns_DataDataSet ds = new Trasns_DataDataSet();
DataTable dt = ds.Tables(TableName);
ArrayList tal = new ArrayList();
foreach (DataColumn cl in dt.Columns)
{
tal.Add(cl.ColumnName);
}
DbConnection cnn = default(DbConnection);
cnn = database_Object.GetConnection(database_Object.Provider);
cnn.ConnectionString = My.Settings.Trasns_DataConnectionString;
cnn.Open();
DbCommand cmd1 = default(DbCommand);
cmd1 = database_Object.GetCommand(database_Object.Provider);
cmd1.Connection = cnn;
string n = null;
for (int i = 0; i <= tal.Count - 1; i++)
{
n = "@" + tal(i).ToString;
DbParameter pa = database_Object.GetParameter(database_Object.Provider);
pa.ParameterName = n;
pa.Value = Al(i);
cmd1.Parameters.Add(pa);
}
n = "";
string v = "";
string sqlstr = "insert into " + TableName + " (";
for (int i = 0; i <= tal.Count - 1; i++)
{
n = n + "," + tal(i).ToString;
v = v + ",@" + tal(i).ToString;
}
n = Strings.Right(n, Strings.Len(n) - 1);
v = Strings.Right(v, Strings.Len(v) - 1);
sqlstr = sqlstr + n + ") values (" + v + ")";
cmd1.CommandText = sqlstr;
Retval = cmd1.ExecuteNonQuery;
return Retval;
}
catch (Exception ex)
{
Interaction.MsgBox("error in Save_Record : " + ex.Message);
}
}
public static int Delete_Record(ArrayList AlNa
basurajkumbhar
21-Nov-13 5:13am
View
it give error like
Error The type or namespace name 'General_function' could not be found
basurajkumbhar
15-Nov-13 6:11am
View
ok
basurajkumbhar
8-Nov-13 1:58am
View
yes i am trying to do this but i am not getting the output which i want....
basurajkumbhar
8-Nov-13 1:25am
View
when i am convert the pdf file that time the world file is not as it is pdf file
what i want to do
basurajkumbhar
7-Nov-13 8:49am
View
thank you sir
for this reply
i don't know the freeze property datagridview..
thanks very much sir..
basurajkumbhar
6-Nov-13 0:51am
View
Thanks for response
Hi i have tried this it gives me group by it works well
SELECT Voter.*, temp100.YadiNo, temp100.CountHouseNo FROM temp100 INNER JOIN Voter ON (temp100.HouseNo = Voter.HouseNo) AND (temp100.YadiNo = Voter.YadiNo) WHERE (((temp100.YadiNo) Between " & txtpartno.Text.Trim & " And " & txtpartno1.Text.Trim & ") AND ((temp100.CountHouseNo) Between " & txtfamilymeb.Text.Trim & " And " & txtfamilymeb1.Text.Trim & "))order by voter.houseno;
I want to how much time group of house no is displayed.
ex
hose no
1
1
1
20
20
30
30
here is three group of house no
it
group of hose no
3
basurajkumbhar
30-Oct-13 6:03am
View
can you post your code.........
to see your problem...
basurajkumbhar
28-Oct-13 9:20am
View
e.g.
your table name is stud
open your dataset and from your server explore drag drop the your table stud in daset
and run your application.
basurajkumbhar
25-Oct-13 5:28am
View
i want to get milk fat direct in my application
basurajkumbhar
23-Oct-13 2:54am
View
It is not working sir..
basurajkumbhar
23-Oct-13 2:42am
View
Hello sir the given query is not give the output which is i want .
But thanks for solution...
basurajkumbhar
23-Oct-13 2:18am
View
Hi sir i update my question.
basurajkumbhar
19-Oct-13 9:50am
View
Try your self then ask .
basurajkumbhar
19-Oct-13 9:40am
View
Hi thanks for this code
i am convert this code in vb.
Dim dt As New DataTable
dt = ds.Tables(0)
For i = 0 To dt.Rows.Count - 1
ab = dt.Rows(i)("Houseno").ToString()
Dim tempStr As String = [String].Empty
tempStr = ab
MsgBox(dt.Rows(i)("Houseno").ToString())
If dt.Rows(i)("Houseno").ToString() <> tempStr Then
DataGridView1.Rows(i).DefaultCellStyle.BackColor = Color.Blue
tempStr = dt.Rows(i)("Houseno").ToString()
Else
DataGridView1.Rows(i).DefaultCellStyle.BackColor = Color.Red
End If
Next
But it still not give the result like me
thanks for code
basurajkumbhar
19-Oct-13 8:46am
View
Yes only two colors to separate group.
basurajkumbhar
19-Oct-13 8:26am
View
In my datagridview there is one column house no
in that column 16 house no is repeated three time then that row set the color red
if there is house no any number then that time set anther color as like alternet color .
thanks...
basurajkumbhar
19-Oct-13 8:23am
View
i don't want to set the color to every row.
basurajkumbhar
18-Oct-13 7:21am
View
How i am not getting any way to get count.
Can you please explain.
Sir.
Thank You,,,,
basurajkumbhar
7-Oct-13 5:04am
View
Thanks for it.
but
when user change the os time that bios date not change.
that's why i want to get Bios date
basurajkumbhar
5-Oct-13 3:38am
View
i am not getting what do you want to ask me?
basurajkumbhar
25-Sep-13 8:00am
View
yes i have already created setup.
but my client machine don't have .net or crystal report
i want to give it in my setup when i will create that time want to include that all the setups in my application.
basurajkumbhar
25-Sep-13 7:57am
View
I know how to create setup in vb.net.
I don't no how to include crystal report exe files and frame work file in that setup.
basurajkumbhar
25-Sep-13 7:49am
View
what do you mean want to say?
basurajkumbhar
23-Sep-13 3:59am
View
yes i tried your posted code in my code after then it gives me this error
after implemented your code.
<pre>
Me.ReportViewer1.Reset()
With Me.ReportViewer1.LocalReport
' Report path
.ReportPath = Application.StartupPath & "C:\Users\noble\Desktop\WindowsApplication2\WindowsApplication2\Report1.rdlc"
'ReportViewer1.LocalReport.ReportPath = "C:\Users\noble\Desktop\WindowsApplication2\WindowsApplication2\Report1.rdlc"
.DataSources.Clear()
End With
' ----------------------------------------------------
' Datasource for the main report (where price > 200)
' ----------------------------------------------------
Dim SQL As String = "SELECT Voter.SrNo, Voter.YadiNo, Voter.FullName, Voter.Gender, Voter.Age, Voter.HouseNo, Voter.Address, Voter.CardNo FROM Voter WHERE yadino=1"
Using da As New OleDbDataAdapter(SQL, My.Settings.trialConnectionString)
da.SelectCommand.Parameters.Add("@yadino", OleDbType.Integer).Value = 200
Using ds As New DataSet
da.Fill(ds, "voter")
' You must use the same name as defined in the report
' Data Source Definition
Dim rptDataSource As New ReportDataSource("dsReport_products", ds.Tables("voter"))
Me.ReportViewer1.LocalReport.DataSources.Add(rptDataSource)
End Using
End Using
ReportViewer1.RefreshReport()
</pre>
basurajkumbhar
23-Sep-13 3:42am
View
its working but i am gettign the new error
the source of the report definition is not specified
basurajkumbhar
19-Sep-13 5:58am
View
in table name and houseno are two column i want display the data which are same where
if
Name Houseno
abc k123
abc h123
abc k123
if this is the data in table
i want display the like this
name houseno
abc k123
abc k123
basurajkumbhar
7-Aug-13 1:48am
View
Windows Xp
basurajkumbhar
5-Aug-13 4:21am
View
Sql server 2005
basurajkumbhar
30-Jul-12 4:48am
View
Please help sir
basurajkumbhar
30-Jul-12 4:42am
View
how can bind the image and string
when the dropdownlist value changed then
basurajkumbhar
30-Jul-12 4:41am
View
<%s %>
this is declare varible which store the path of image and i have to pass this value to the below link but it not work
this is my problem
<asp:Image ID="Image1" runat="server"
ImageUrl="~/gallery/Necklace/necklace13.jpg" />
basurajkumbhar
30-Jul-12 4:35am
View
Deleted
How can i bind the string and image url
Because when the dropdownlist change the its value then the string value is change .
so...
basurajkumbhar
30-Jul-12 4:31am
View
I have store the image path in the string s which is public variable in vb.net code and this variable i have use to give the link path in the html script.
basurajkumbhar
30-Jul-12 4:26am
View
Problem is i am not understand to how pass the string value of "s " to the
to this link
basurajkumbhar
28-Jul-12 6:16am
View
I have displayed 8 images when i have click the below of the [pre 1 2 3 next] then this images box have new/next images display. Yet i am not use the datagrid view.
basurajkumbhar
28-Jul-12 6:16am
View
I have displayed 8 images when i have click the below of the [pre 1 2 3 next] then this images box have display new/next images. I am not use the datagrid view.
Show More