Comments by vijay_bale

vijay_bale 11-Apr-23 9:42am View

yes as you said above, one time only. just change that into this format and forget about that. Otherwise I have to do it manually and it will take some time to open that adjust date/time and go next and after go other like that and after changing press ok to take effect of changes and press ok in all windows to close to come back

vijay_bale 11-Apr-23 9:20am View

not connected with any network. All systems are individual systems only

vijay_bale 11-Apr-23 9:17am View

I am changing this because some people are not changing. That is our Country's(India) format. They are not changing because some other softwares not working properly of this problem so they are changing when ever they are loading like unilever, dabur and other companies. At loading time they are checking and if wrong format detected they are changing. This format only running in government offices and other places. curreny only that hardware people are changing because currency not changing then calculation will go wrong. our curreny is rupee in system they are changing that from dollor to rupee.

vijay_bale 11-Apr-23 8:36am View

That is the format of our country/region. Some hardware people, after formatting system they don't change the system date format. 4% of my clients like that only.

vijay_bale 11-Apr-23 8:22am View

I developed a billing app in that that date format is required. in some clients systems that date format maybe in other like yyyy-MMMM-dddd or any other. But we won't take that. so when ever I ran this I just changing the date format to dd/MM/yyyy which is our country/region format. For that purpose only I wrote this one not as part of that project but individual one.

vijay_bale 14-Dec-22 5:28am View

Deleted

These three commands in a batch file I started my ms-SQL server

vijay_bale 14-Dec-22 5:25am View

Using these three commands I got admin privileges and started my ms-SQL server using the DOS net start command which I succeeded in the DOS batch file. There I am not checking whether my ms-SQL server service started or not. just I am running this.

vijay_bale 14-Dec-22 4:40am View

yes

vijay_bale 10-Nov-19 4:36am View

@OriginalGriff. I already took one web based DB service for SQL server which is down from 2 days and I tried to contact them but failed. I am facing some problems from customers. I already spoke with my service provider for static IP. So that's why I thought to convert my one system as server. I am not using default user id sa in SQL server to connect data base.

vijay_bale 9-Nov-19 6:00am View

Only 20 MB data or more from customers. I installed already windows 10 and Ms-SQL server 2015. Windows 10 is having inbuilt firewall so didn't installed any internet security software. RAM is 8 GB and 150 GB SSD only for C drive and 500 GB sata HDD for other Drives like D,E & F. Is that enough for that ?

vijay_bale 26-Oct-19 4:22am View

Ms SQL Database stored in server. So I want to access that database and insert some records, modify and delete some records

vijay_bale 24-Oct-19 7:14am View

I asked how and where to define Connection string in android so that i can use that in every java class of my project.

vijay_bale 11-Feb-19 8:09am View

Above stored procedure is for opening balance of that person

I am calling that stored procedure from c#
// I am reading pername from dropdown list from that I am reading perid from personDB.
var searchachist = "personid=" + perid + " and pdate<'" + DBDate(acdt2) + "'";//taking the ending date and calculating the amount as opening

var accopy1 = new System.Data.DataTable();
using (var cmd = new SqlCommand("repaccopy1data", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@searchparam", SqlDbType.Text).Value = searchachist;
var da = new SqlDataAdapter(cmd);
accopy1 = new System.Data.DataTable();
da.Fill(accopy1);
con.Close();
}

vijay_bale 11-Feb-19 6:53am View

above stored procedure for the payment how much we gave to that mediator person for registrations ( paymentDB) and how many sites he registered (regstDB) in some in between dates (for that I used searchparam as parameter)

above stored procedure showed some wrong results like he got paid sum of 15000 and registrations done 2 means 2*3000=6000 but that store procedure give results like 15000 2 times so I used other stored procedure for that regstDB(registrations) purpose. Here in this procedure I put in comments lines like --regstDB.siteid
--,regstDB.rdate
--,regstDB.rpid
--,regstDB.totamt
--,regstDB.rperson

now I am getting the correct results when I execute that 2 procedures. If I came to know where we can use "where" condition then I can use only one stored procedure maybe.

with one stored procedure i am getting only payments means how much we paid him. and second stored procedure only for registrations. so that we came to know how many site he registered.

vijay_bale 11-Feb-19 6:17am View

Thanks. But I think you didn't read my question total. In my question i asked where I can "Where" clause in my procedure?

vijay_bale 11-Feb-19 4:51am View

Deleted

Actually my problem is not that sales and purchase one. I created that to ask here clearly. Maybe my English is not good. that's why. I will explain my Problem here clearly. I am writing one application for cellphone towers registrations. There some amount we will give to that person like 6000. he is third party registration person like mediator between cell company and site owner. company will take lease site from owner. that mediator person will do the work like registration that lease and all. For that he will charge 3000 like that. some sites are able to register and some not. to calculate the account copy of that mediator like how much amount he took and how much he charged for which site he charged and hoe much balance is like that I have to show. for that I wrote some store procedures to achieve. first I wrote one store procedure to get that result. but not came so I wrote total 7 store procedures for that.
1 for opening balance of that person and 1 for registration and 1 for damage(if registration is not possible he will take expenses) and 1 for opening registrations count and 1 for opening damages site count and one for amount when we gave to that person and how much . all stored procedures with starting and ending dates.

Using union maybe I can reduce that count of procedures.

here my doubt is where i can use union in my store procedure with where clause

below I am giving my one store procedure. Here that "@searchparam" I used for dates

USE [registrationDB]
GO
/****** Object: StoredProcedure [dbo].[repaccopy1data] Script Date: 11-02-2019 03:17:26 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[repaccopy1data]
@searchparam VARCHAR(MAX) =''

AS
SET NOCOUNT ON

DECLARE @SqlString VARCHAR(MAX)
set @SqlString='select paymentDB.personid
,paymentDB.pname
,sum(paymentDB.pamount) as [amount]
,regstDB.siteid
,regstDB.rdate

,regstDB.rpid
,regstDB.totamt
,regstDB.rperson

from paymentDB with (NOLOCK) inner join personDB on paymentDB.personid=personDB.pid '

if LTRIM ( RTRIM (@searchparam))<>''

begin

exec (@SqlString + ' where '+ @searchparam+' group by paymentDB.personid,paymentDB.pname' )

end

else

begin
EXEC (@SqlString+' group by paymentDB.personid,paymentDB.pname')
PRINT (@SqlString+' group by paymentDB.personid,paymentDB.pname')
end

print @SqlString + ' where ' + @searchparam+' group by paymentDB.personid,paymentDB.pname'

vijay_bale 11-Feb-19 4:49am View

Deleted

Actually my problem is not that sales and purchase one. I created that to ask here clearly. Maybe my English is not good. that's why. I will explain my Problem here clearly. I am writing one application for cellphone towers registrations. There some amount we will give to that person like 6000. he is third party registration person like mediator between cell company and site owner. company will take lease site from owner. that mediator person will do the work like registration that lease and all. For that he will charge 3000 like that. some sites are able to register and some not. to calculate the account copy of that mediator like how much amount he took and how much he charged for which site he charged and hoe much balance is like that I have to show. for that I wrote some store procedures to achieve. first I wrote one store procedure to get that result. but not came so I wrote total 7 store procedures for that.
1 for opening balance of that person and 1 for registration and 1 for damage(if registration is not possible he will take expenses) and 1 for opening registrations count and 1 for opening damages site count and one for amount when we gave to that person and how much . all stored procedures with starting and ending dates.

Using union maybe I can reduce that count of procedures.

here my doubt is where i can use union in my store procedure with where clause

below I am giving my one store procedure. Here that "@searchparam" I used for dates

USE [registrationDB]
GO
/****** Object: StoredProcedure [dbo].[repaccopy1data] Script Date: 11-02-2019 03:17:26 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[repaccopy1data]
@searchparam VARCHAR(MAX) =''

AS
SET NOCOUNT ON

DECLARE @SqlString VARCHAR(MAX)
set @SqlString='select paymentDB.personid
,paymentDB.pname
,sum(paymentDB.pamount) as [amount]
,regstDB.siteid
,regstDB.rdate

,regstDB.rpid
,regstDB.totamt
,regstDB.rperson

from paymentDB with (NOLOCK) inner join personDB on paymentDB.personid=personDB.pid '

if LTRIM ( RTRIM (@searchparam))<>''

begin

exec (@SqlString + ' where '+ @searchparam+' group by paymentDB.personid,paymentDB.pname' )

end

else

begin
EXEC (@SqlString+' group by paymentDB.personid,paymentDB.pname')
PRINT (@SqlString+' group by paymentDB.personid,paymentDB.pname')
end

print @SqlString + ' where ' + @searchparam+' group by paymentDB.personid,paymentDB.pname'

vijay_bale 11-Feb-19 4:39am View

Deleted

Actually my problem is not that sales and purchase one. I created that to ask here clearly. Maybe my English is not good. that's why. I will explain my Problem here clearly. I am writing one application for cellphone towers registrations. There some amount we will give to that person like 6000. he is third party registration person like mediator between cell company and site owner. company will take lease site from owner. that mediator person will do the work like registration that lease and all. For that he will charge 3000 like that. some sites are able to register and some not. to calculate the account copy of that mediator like how much amount he took and how much he charged for which site he charged and hoe much balance is like that I have to show. for that I wrote some store procedures to achieve. first I wrote one store procedure to get that result. but not came so I wrote total 7 store procedures for that.
1 for opening balance of that person and 1 for registration and 1 for damage(if registration is not possible he will take expenses) and 1 for opening registrations count and 1 for opening damages site count and one for amount when we gave to that person and how much . all stored procedures with starting and ending dates.

Using union maybe I can reduce that count of procedures.

here my doubt is where i can use union in my store procedure with where clause

below I am giving my one store procedure. Here that "@searchparam" I used for dates

USE [registrationDB]
GO
/****** Object: StoredProcedure [dbo].[repreghistory] Script Date: 11-02-2019 02:49:10 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[repreghistory]
@searchparam VARCHAR(MAX) =''

AS
SET NOCOUNT ON

DECLARE @SqlString VARCHAR(MAX)
set @SqlString='select regstDB.siteid
,regstDB.rperson
,regstDB.rpid
,(regstDB.regamt+totamt) as regamt

from regstDB with (NOLOCK) inner join personDB on regstDB.rpid=personDB.pid '

if LTRIM ( RTRIM (@searchparam))<>''

begin

exec (@SqlString + ' where '+ @searchparam )

end

else

begin
EXEC (@SqlString)
PRINT (@SqlString)
end

print @SqlString

vijay_bale 11-Feb-19 4:13am View

Deleted

Ok I got that. Thanks for your help.

vijay_bale 11-Feb-19 4:04am View

@ CHILL60, that above code also giving wrong results
four records from sales what i am having (all are different ids means items) and 2 records from that purchase what i am having. Here Were clause I have to mention in which place ?

vijay_bale 2-Dec-18 3:32am View

Thanks for your interest to solve and to help.

vijay_bale 4-Nov-18 4:12am View

Deleted

I read that documentation but some doubts came that's why I asked.

vijay_bale 4-Nov-18 3:06am View

There also I posted same question and waiting for replay. in that time I posted here.If you don't know that answer then better you should not give advice.Maybe my words are hurting you but this is the fact.

vijay_bale 5-Oct-18 11:02am View

I am creating some tables every time but that time some default values are missing(I Am creating filelds with not null and default values.but default values missing).While inserting some data I am getting error because not null but no default value. So I created this procedure

vijay_bale 5-Oct-18 10:55am View

@Dave Kreskowiak

C# code

using (SqlCommand cmd = new SqlCommand("SPNULL", con))
           {
               con.Close();
               con.Open();
               cmd.CommandType = CommandType.StoredProcedure;
               cmd.ExecuteNonQuery();
           }

vijay_bale 5-Oct-18 10:51am View

@digimanus
first I checked in ssms.no problem. in c# I debugged that code also

vijay_bale 5-Oct-18 10:49am View

@Dave Kreskowiak

USE [inventoryDB]
GO
/****** Object:  StoredProcedure [dbo].[clearinv]    Script Date: 05-10-2018 18:42:11 ******/

GO

GO

ALTER procedure [dbo].[SPNULL]

(@errorstat as int = 0)

as

while @errorstat = 0

begin

Begin try

update suppDB set ldgrid = 0 where ldgrid is null
ALTER TABLE suppDB ALTER COLUMN [ldgrid] INTEGER NOT NULL
alter table suppDB ADD CONSTRAINT sldgrid  DEFAULT 0 FOR ldgrid

if @@ERROR <> 0 or @@ERROR = 0
begin 
print '0'
end

END try
begin catch
Print '1'
end catch
end
go


declare @errorstat as int = 0

while @errorstat = 0
begin
Begin try

update suppDB1718 set ldgrid = 0 where ldgrid is null
ALTER TABLE suppDB1718 ALTER COLUMN [ldgrid] INTEGER NOT NULL
alter table suppDB1718 ADD CONSTRAINT sldgrid1718  DEFAULT 0 FOR ldgrid

if @@ERROR <> 0 or @@ERROR = 0
begin 
print '0'
end

END try
begin catch
Print '2'
end catch
end
go



if @@ERROR <> 0 or @@ERROR = 0
declare @errorstat as int = 0

BEGIN try

update suppDB1819 set ldgrid = 0 where ldgrid is null
ALTER TABLE suppDB1819 ALTER COLUMN [ldgrid] INTEGER NOT NULL
alter table suppDB1819 ADD CONSTRAINT sldgrid1819  DEFAULT 0 FOR ldgrid

END try
begin catch
Print '3'
end catch
go
if @@ERROR <> 0 or @@ERROR = 0
declare @errorstat as int = 0

if @errorstat = 0
BEGIN try

update suppDB set jvno = 0 where jvno is null
ALTER TABLE suppDB ALTER COLUMN [jvno] INTEGER NOT NULL
alter table suppDB ADD CONSTRAINT sjvno  DEFAULT 0 FOR jvno

END try
begin catch
Print '4'
end catch
go
if @@ERROR <> 0 or @@ERROR = 0
declare @errorstat as int = 0

if @errorstat = 0
BEGIN try

update suppDB1718 set jvno = 0 where jvno is null
ALTER TABLE suppDB1718 ALTER COLUMN [jvno] INTEGER NOT NULL
alter table suppDB1718 ADD CONSTRAINT sjvno1718  DEFAULT 0 FOR jvno

END try
begin catch
Print '5'
end catch
go
if @@ERROR <> 0 or @@ERROR = 0
declare @errorstat as int = 0

if @errorstat = 0
BEGIN try

update suppDB1819 set jvno = 0 where jvno is null
ALTER TABLE suppDB1819 ALTER COLUMN [jvno] INTEGER NOT NULL
alter table suppDB1819 ADD CONSTRAINT sjvno1819  DEFAULT 0 FOR jvno

END try
begin catch
Print '6'
end catch
go

//This is SQL server storeprocedure code

vijay_bale 24-Jan-18 9:44am View

OK. I will look again as you told. creation time what value I stored, that is only there.Date I am able to store in hexadecimal and able to read that.This int value is problem giving.This int also I am trying to store as string also. But no use.

vijay_bale 24-Jan-18 9:38am View

You have to do nothing. Just I told.As experienced programmer, may be you can give any idea. Thats why I told.

vijay_bale 24-Jan-18 8:02am View

I m able to store settings but unable to read from that file.

vijay_bale 24-Jan-18 7:43am View

I changed that also.Same problem.I changed my code above.

vijay_bale 24-Jan-18 6:38am View

I did What You told. But same error.

vijay_bale 24-Jan-18 6:36am View

I am checking at the top if the key exists or not. if not I am creating key.If exists,
simply I am coming out of loop and going to next step checkService();

vijay_bale 24-Jan-18 6:04am View

OK taking settings from other file, I will try for that.

What you told maybe right. But my login is admin login only. already one sub-key I am creating and adding. I am running visual studio also in admin mode.

vijay_bale 19-Jan-18 7:55am View

Not for my downloading purpose. I want to upload a file with customers information. That information i want to read with the help of my software which I developed in c#. That software i will give to my clients and when ever they will connect to the net (my software also open that time), software will access that file and read that. In that file only I will put some software checking for trail like that.

vijay_bale 19-Jan-18 0:32am View

I know how to download and upload files. I want to read the file which stored in google drive. not download and read.

vijay_bale 31-Oct-17 9:57am View

In client side, in which drive system will create that folder

vijay_bale 17-Oct-17 10:57am View

I already debugged.It is showing values also. but not storing in database.

vijay_bale 17-Oct-17 6:44am View

In debugging mode no values will come for store procedure na. Because here I am passing values from devx banded grid like below
cmd.Parameters.AddWithValue("@itmtax", SqlDbType.Float).Value = Convert.ToDouble(item["GAmount"]);
cmd.Parameters.AddWithValue("@itmtot", SqlDbType.Float).Value = Convert.ToDouble(item["NetAmount"]);
//cmd.Parameters.AddWithValue("@itmqty", SqlDbType.Float).Value = Convert.ToDouble(item["Qty"]);
cmd.Parameters.AddWithValue("@itmqty", SqlDbType.Float).Value = Convert.ToDouble(item["NewQty"]);
cmd.Parameters.AddWithValue("@cblno", SqlDbType.Int).Value = Convert.ToInt32(txtBillNo.Text);
cmd.Parameters.AddWithValue("@ItemId", SqlDbType.Int).Value = Convert.ToInt32(item["ItemId"]);
cmd.Parameters.AddWithValue("@itmusrcode", SqlDbType.VarChar).Value = Convert.ToString(item["itmusrcode"]);
cmd.Parameters.AddWithValue("@itmunit", SqlDbType.VarChar).Value = item["itmunit"].ToString();
cmd.Parameters.AddWithValue("@itmbyp", SqlDbType.Float).Value = Convert.ToDouble(item["itmbyp"]);

vijay_bale 16-Oct-17 2:17am View

testing system is having sql2016 and server system is having sql 2014express

vijay_bale 16-Oct-17 1:00am View

visual c# and sql server express2014

vijay_bale 6-Oct-17 13:00pm View

it is showing error near some stored procedures which i am using to display data and update some data. Below one of the stored procedures I am pasting

USE [inventoryDB]
GO
/****** Object: StoredProcedure [dbo].[StockUpdate] Script Date: 06-10-2017 09:44:41 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[StockUpdate]
@SearchParam VARCHAR(MAX) =''

AS
SET NOCOUNT ON

DECLARE @SqlString VARCHAR(MAX)

SET @SqlString ='
select fullname,
ItemId,
SUM(PurchaseQty) AS [PurchaseQty],
SUM(SalesQty) AS [SalesQty]
From (
select fullname,
ItemId,
SUM(itmqty) AS [PurchaseQty],
SUM(0.000) AS [SalesQty]
from invDB WITH(NOLOCK)
LEFT JOIN itemDB WITH(NOLOCK) ON itemDB.itmcode=invDB.ItemId
Group By fullname,ItemId

UNION

select fullname,
ItemId,
SUM(0.000) AS [PurchaseQty],
SUM(itmqty) AS [SalesQty]
from salesDB WITH(NOLOCK)
LEFT JOIN itemDB WITH(NOLOCK) ON itemDB.itmcode=salesDB.ItemId
Group By fullname,ItemId)a Group By fullname,ItemId
'

IF LTRIM ( RTRIM ( @SearchParam ) ) <> ''
BEGIN
EXEC (@SqlString + ' WHERE ' + @SearchParam )

END
ELSE
BEGIN
EXEC (@SqlString)
PRINT (@SqlString)
END

PRINT @SqlString + ' WHERE ' + @SearchParam

vijay_bale 6-Oct-17 10:53am View

that same application with same data i am running in my system and everything is running fine.

vijay_bale 6-Oct-17 10:49am View

I gave connection string in appconfig file like below
<add name="connectionstr"
connectionString="Password=test1234;Persist Security Info=True;User ID=test;Initial Catalog=inventoryDB;Data Source=m3\SQL2016"
providerName="System.Data.SqlClient" />

And I am reading this like below

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["connectionstr"].ConnectionString);

When I ran this, databse is connecting, but error is coming "Arithmetic overflow error converting numeric to data type numeric."

vijay_bale 6-Oct-17 6:35am View

yes abviously

vijay_bale 6-Oct-17 6:17am View

I removed that provider key, now it is connecting

vijay_bale 6-Oct-17 5:31am View

I don't know what to do sir.

vijay_bale 6-Oct-17 5:00am View

I tried In debugging mode and I am getting belo error
"Keyword not supported: 'provider'."

vijay_bale 6-Oct-17 4:49am View

Is that ok sir? Is anything I have to change or add?

vijay_bale 6-Oct-17 4:48am View

to read that connection i am using in my app forms
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["connectionstr"].ConnectionString);

I already added asembly reference of comfiguration and in also i added
using system.configuration.

vijay_bale 6-Oct-17 4:37am View

Now I tried with connectionstring file UDL. I changed ip to system name also. but getting same error
<add name="connectionstr"
connectionString="Persist Security Info=False;User ID=test;Initial Catalog=inventoryDB;Data Source=m3\SQL2016"
providerName="System.Data.SqlClient" />

vijay_bale 6-Oct-17 4:17am View

As You told I created one new user and give connection string in config file like below
<add name="connectionstr"
connectionString="Data Source=192.168.1.10\SQL2016;Initial Catalog=inventoryDB;User ID=test;Password=***********"
providerName="System.Data.SqlClient" />

I have to try that udl connection string what you told. First I did like this next I will do that also

vijay_bale 6-Oct-17 3:53am View

I added connection string in appconfig file like below
<add name="connectionstr"
connectionString="Data Source=192.168.1.10\SQL2016;Initial Catalog=inventoryDB;Persist Security Info=True;User ID=sa;Password=***********"
providerName="System.Data.SqlClient" />

vijay_bale 26-Aug-17 5:27am View

that is only one company, one category.companyDB for company and catDB for category.Example Unilever I am storing in companyDB, toilet soaps is a category I am storing in CatDB.Here I am displaying companyDB and catDB both for two times one for create brand and second for editing existing brand purpose. means user can move that brand for one company to other company and user can change the category also.

Here I am posting a View
http://imgur.com/a/jBTRk

Here Screenshot of that error
http://imgur.com/L4qjgch

vijay_bale 26-Aug-17 4:14am View

This is my code to display that names in dropdown.
string que = "SELECT compname FROM companyDB ";
string query = "SELECT compname FROM companyDB";
string quer= "SELECT catname FROM catDB";
string qu="SELECT catname FROM catDB";
SqlDataAdapter da = new SqlDataAdapter(que, con);
SqlDataAdapter sda = new SqlDataAdapter(query, con);
SqlDataAdapter dp = new SqlDataAdapter(quer, con);
SqlDataAdapter sdp = new SqlDataAdapter(qu, con);

DataSet ds = new DataSet();
DataSet sds = new DataSet();
DataSet de = new DataSet();
DataSet sde = new DataSet();

da.Fill(ds, "companyDB");
sda.Fill(sds, "companyDB");
dp.Fill(de, "catDB");
sdp.Fill(sde, "catDB");

combocomp.DisplayMember = "compname";
combocomp.ValueMember = "compname";
combocomp.DataSource = ds.Tables["companyDB"];

comboncomp.DisplayMember = "compname";
comboncomp.ValueMember = "compname";
comboncomp.DataSource = sds.Tables["companyDB"];

combocat.DisplayMember = "catname";
combocat.ValueMember = "catname";
combocat.DataSource = de.Tables["catDB"];

comboncat.DisplayMember = "catname";
comboncat.ValueMember = "catname";
comboncat.DataSource = sde.Tables["catDB"];

combocomp.SelectedIndex = -1;
comboncomp.SelectedIndex = -1;
combocat.SelectedIndex = -1;
comboncat.SelectedIndex = -1;
if special character is there in companyDB or catDB, then it is showing some thing like system . like that. If I remove special character from there every thing is coming perfectly

In drop down It is showing now.I created there for testing purpose in CompanyDB son's.
now i came where i am calling that as a drop down, there it is showing son's. If i select that, error is coming that incorrect syntax near s.

vijay_bale 26-Aug-17 1:45am View

Deleted

I had code. code is just insert one nothing else

vijay_bale 26-Aug-17 1:44am View

crystal reports

vijay_bale 23-Aug-17 8:09am View

same is coming like before 31-07-2017 12:00:00 AM

vijay_bale 23-Aug-17 4:23am View

how to export that date as a date ?

vijay_bale 23-Aug-17 4:23am View

so what to do now with that date?

vijay_bale 18-Jul-17 1:45am View

I am trying to copy sum of quantity of a column of a one file to other column of other file

vijay_bale 4-Jul-17 6:11am View

Thankyou

vijay_bale 28-Jun-17 10:51am View

thanks. It Worked for me

vijay_bale 28-Jun-17 5:47am View

Can I post A new Question For that?

vijay_bale 28-Jun-17 5:24am View

Ok I will look for that what you told. But anyhow how to enable that

vijay_bale 28-Jun-17 4:37am View

I gave below one to re enable constrain
SqlCommand md=new SqlCommand("exec sp_MSforeachtable @command1 = 'print' '?', @command2 = 'ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all'",con);
md.ExecuteNonQuery();

But It Gave "incorrect syntax near '?'.

vijay_bale 28-Jun-17 4:28am View

thank you. It worked. I took the last one you told. But how I enable the constrains after updating record.

vijay_bale 27-Jun-17 10:07am View

I did like that only. thanks

vijay_bale 10-Jun-17 3:42am View

Your solution worked.

vijay_bale 8-Jun-17 2:38am View

I am using visual studio community 2015

vijay_bale 6-Jun-17 5:04am View

Why it is showing like that in my project only. If I take new form out of my project then reports are coming. problem here only.

vijay_bale 6-Jun-17 5:02am View

From the begining of the project maybe 3 months back I installed only sql2016 and I created database in this sqlserver only.

vijay_bale 31-May-17 3:46am View

I installed SSMS 17. It installed but one problem came. I am unable to connect database of SQL from my visual studio C#. I tried to create connection but one error came."Unable to add data connection.Could not load file or assembly. Microsoft.SqlServer.Management.Sdk.Sfc, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dc8080cc91 or one of its dependincies. The system cannot find the file specified". So I googled for that error and downloaded and installed sqlserver 2016 feature pack. But problem not solved.

vijay_bale 30-May-17 2:28am View

I tried Already but, same problem

vijay_bale 30-May-17 2:22am View

@ Suvendu shekhar Giri
That Setup Bootstrap folder already in my C:\Program Files\Microsoft SQL Server\130

vijay_bale 24-May-17 8:58am View

It Works for me
private void textBox1_KeyDown(object sender, KeyEventArgs e)
{

//Se apertou o enter
if (e.KeyCode == Keys.Enter)
{
//enter key is down

this.doSomething();

e.Handled = true;
e.SuppressKeyPress = true;

}

}

vijay_bale 24-May-17 8:11am View

default sounds from system. I want to mute in my application only.

vijay_bale 18-May-17 9:01am View

not using crystal reports.

vijay_bale 18-May-17 7:27am View

yes I want to print bills as I showed in image. Like that I want to generate some bills what I am giving in the text boxes as starting and ending bill numbers. For example if I give 2 in starting bill number text box and 5 in ending bill number text box that all bills should generate like the image showed above.
Like below image I am getting now.
http://i.imgur.com/fOP40xL.jpg

vijay_bale 16-May-17 5:12am View

I will give the starting and ending bill numbers. According that report will generate like above image.Two bills per page. First I want to generate. Single bill I am able to generate.

vijay_bale 11-May-17 6:34am View

Deleted

This Below code what I wrote for backup.
string drive = Path.GetPathRoot("D:"); // e.g. K:\ if (!Directory.Exists(drive)) { MessageBox.Show("Drive " + drive + " not found or inaccessible", "Error", MessageBoxButtons.OK); con.Open(); CreateIfMissing("C:\\billback"); string query = string.Format("BACKUP DATABASE BillingDB TO DISK = 'C:\\billback\\Billing{0}.Bak' WITH FORMAT, MEDIANAME = 'dbName', NAME = 'Full Backup of dbName';", DateTime.Now.ToString("hhmmssddMMyyyy")); SqlDataAdapter sda = new SqlDataAdapter(query, con); //SqlCommand cmd = new SqlCommand("BACKUP DATABASE [InventoryDB] TO DISK = 'd:\\testback\\data.bak' WITH NOFORMAT, NOINIT, NAME = N'data-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10",con); sda.SelectCommand.ExecuteNonQuery(); con.Close(); return; } else { con.Open(); CreateIfMissing("D:\\billback"); string query = string.Format("BACKUP DATABASE BillingDB TO DISK = 'D:\\billback\\Billing{0}.Bak' WITH FORMAT, MEDIANAME = 'dbName', NAME = 'Full Backup of dbName';", DateTime.Now.ToString("hhmmssddMMyyyy")); SqlDataAdapter sda = new SqlDataAdapter(query, con); //SqlCommand cmd = new SqlCommand("BACKUP DATABASE [InventoryDB] TO DISK = 'd:\\testback\\data.bak' WITH NOFORMAT, NOINIT, NAME = N'data-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10",con); sda.SelectCommand.ExecuteNonQuery(); con.Close(); }

vijay_bale 11-May-17 6:27am View

I removed that code. I am doing like that link what you gave.

vijay_bale 11-May-17 4:32am View

That one ok. I am trying that. But here where is syntax error. I want to know even my writing method is wrong. Can you tell me that. I wont repeat that in future.

vijay_bale 4-May-17 1:00am View

Attach to sql server.I have already Sql database copied from other computer.

vijay_bale 3-May-17 11:27am View

I checked event viewer. "SQL server Agent successfully stopped" message is there

vijay_bale 3-May-17 11:02am View

without installing sql server management studio, how to connect to database.

vijay_bale 3-May-17 11:01am View

I reinstalling sqlserver 2014 express.

vijay_bale 3-May-17 4:57am View

All are individual and in different places. All are on windows platform only.If he has already sql installed then can I use that sql for my database? My software is not working with any dynamic connection strings.

vijay_bale 3-May-17 4:46am View

For me maybe 10 clients will be there(individual clients). so can I install sqlexpress2016 in their system?

vijay_bale 3-May-17 4:33am View

sqlexpress2016 we can install in client system na.No problem right

vijay_bale 3-May-17 4:15am View

so only sqlserexpress

vijay_bale 3-May-17 2:43am View

I downloaded sqlexpresslocalDB 2016. Is that enough? As you told I have to install this saparately on usersystem right?

vijay_bale 1-May-17 6:26am View

where I have to add this code?

vijay_bale 29-Apr-17 8:30am View

ok I opened new question for that

vijay_bale 29-Apr-17 4:31am View

ok solved.Thanks. I have another problem. Can I ask here or raise one new question?

vijay_bale 22-Apr-17 10:30am View

yes. I checked twice that one.

vijay_bale 20-Apr-17 8:45am View

I copied My query result into a database file and from there I am generating reports.

vijay_bale 19-Apr-17 4:35am View

I divided total sales transaction into two parts. under first part, date, customer name, bill number, gross amount, discount, net amount will come. I am saving all these in salesH database file. Under second part, item name, quantity, price, item wise total will come. I am saving all these in sales database file. I put reference of these two file one common field billno. In salesH, billno is having index key and identity. In sales billno is having Foreign key relation with salesH.billno

vijay_bale 19-Apr-17 4:11am View

For first empty databse only it is coming. If I am having data and delete some data and re enter no prob.if I delete all data, re enter and trying save that time only this problem is comimg. How to solve this. For deletion of records I am using CASCADE DELETE so in both files related data will be deleted automatically but prob on saving first time.

vijay_bale 16-Apr-17 8:16am View

sure. I will try. But I am not Good That much. Because English is not my first language.
ex:-I have 2,3,4,6,7,8 sno(index number) records(1,5 I already delete) but this displaying numbers 1,2,3,4,5,6. That is what i want. But When I try to delete 2 record it is not.because no 2 is existing in both. but i tried to delete 5th record it will delete. because that 5th sno(index number) record index is not in database file but is there in this list what you told, so it will delete and numbers also updated from begining. Maybe be I am thinking I explained as much as I can.

vijay_bale 16-Apr-17 7:30am View

It is not working exactly.This sequence numbers are not equal to what I am maintaining in sno Field that records only deleted.

vijay_bale 16-Apr-17 6:59am View

running in c# so all will run in a singal batch na.
My code is
con.Open();
SqlCommand cmd = new SqlCommand("SELECT COUNT(*) FROM tempsales",con);
cmd.ExecuteNonQuery();
Int32 rowcount = (Int32)cmd.ExecuteScalar();
MessageBox.Show(rowcount.ToString());
SqlCommand cd = new SqlCommand("DBCC CHECKIDENT ('tempsales', RESEED, @rowcount)", con);
cd.ExecuteNonQuery();

vijay_bale 16-Apr-17 6:40am View

yes It is Giving but I want to display all in datagridview so that every time if user delets the record it will recount

vijay_bale 16-Apr-17 6:27am View

I did Exactly what you told. But error is coming "Must declare the scaler variable "@rowcount"

vijay_bale 15-Apr-17 9:43am View

@NotPolitcally, It is worked now. Updating. But if I edited one value of one field and click on button for update one new record is adding not updating current record. Where I did wrong.If I touched value of that field only this is happining.

vijay_bale 15-Apr-17 8:34am View

defaullt date time picker so it is string maybe

vijay_bale 15-Apr-17 8:34am View

@NotPolitcally, Please tellme some example for what you told.

vijay_bale 15-Apr-17 8:32am View

Deleted

defaullt date time picker so it is string maybe

vijay_bale 14-Apr-17 1:08am View

I removed that currency symbol. Now it is converted.thankyou so much for your help and telling me the problem.

vijay_bale 13-Apr-17 11:48am View

http://tinypic.com/r/2rdu3ow/9
http://tinypic.com/r/2r3ci2p/9

here I put the images of debugging also. just take a look

vijay_bale 13-Apr-17 10:02am View

convertion will be single line one na.
double.TryParse(txtitemtotal.Text, out b);
I cahnged that txtdisc.text with txtitemtotal.text
thinking that maybe prob with that textbox. so I changed.

vijay_bale 13-Apr-17 10:00am View

txtdisc value is 156.

vijay_bale 13-Apr-17 9:54am View

I changed the text box thinking that maybe problem with that text box. so other one is showing here.

vijay_bale 13-Apr-17 9:48am View

This is the code I am calculating datagridview cells sum value and finally I am converting and storing that into a textbox.
public void totalsum()
{
int i = 0;
double j = 0.00;

for (i = 0; i < dataGridView1.Rows.Count; ++i)
{

j += Convert.ToDouble(dataGridView1.Rows[i].Cells[5].Value);
Math.Round(j, 2, MidpointRounding.ToEven);
//return (int)Math.Floor(j + .49);
//MessageBox.Show(j.ToString());
}
txtitmtotal.Text = j.ToString("c");

vijay_bale 13-Apr-17 9:44am View

@ dave, I am converting a double value to string and displaying in textbox. that textbox value only I am trying to convert into double.
this tells you NOTHING then what you want to know just tell me.

vijay_bale 13-Apr-17 9:39am View

@ Dave
just i am calculating some datagrid cells valu and storing in a variable double type.
that value i am converting into string and displaying in that textbox.That textbox only I am converting in to double and want to do some calculation with it and dsiplay output.

vijay_bale 13-Apr-17 9:23am View

Deleted

False Is coming.

vijay_bale 13-Apr-17 9:22am View

I saw that value. False is Coming.

vijay_bale 13-Apr-17 9:16am View

IsDoubleValue False Is coming.
bool IsDoubleValue = double.TryParse(txtitmtotal.Text, out b);
double d=b* 10;
var doubleTypeValue = IsDoubleValue ? Convert.ToDouble(txtitmtotal.Text) : 0;

MessageBox.Show(d.ToString());

vijay_bale 13-Apr-17 8:47am View

@NotPloitically,
double.TryParse(txtdisc.Text, out b);
thats it. Nothing to hide form you people, who are trying to help me.

vijay_bale 13-Apr-17 8:31am View

@ vinod, I tried What you gave here.but value 0 is coming to b.that textbox value is 156.

vijay_bale 13-Apr-17 8:13am View

I checked. Here TryParse return value is 0.But in textbox value is there 156.

vijay_bale 6-Apr-17 6:17am View

Yes AS you told below in solution it is showing value what i stored in that cell

vijay_bale 6-Apr-17 6:10am View

@ karthik, As you told in solution, that value came as I stored.

vijay_bale 6-Apr-17 6:03am View

other error came. Unable to cast object of type System.Windows.Forms.DataDridviewTextBoxCell to type System.!Convertable. I think Problem With My Casting.

vijay_bale 6-Apr-17 5:41am View

so I have to convert all datagridcells while I am saving. Is that right

vijay_bale 6-Apr-17 5:24am View

@ karthik some mapping error can i change it from dataGridView1_RowLeave. if yes then in which event I wrote this.

vijay_bale 6-Apr-17 5:21am View

No mapping exist from object type System.Windows.Forms.DataGridviewTextboxCell to a known managed provider native type

vijay_bale 5-Apr-17 7:15am View

I don't know how to create in c#. for signal select rname from routeDB where rname="area name". for multiple how to do that.

vijay_bale 5-Apr-17 7:12am View

@ afzal. I will tell you in detail. I am having some area names in one database file. that file is related to other databse file which is having some shop names in it. so I want to select multipul areas so that report can show the shop names of that multipuk areas only. I already created report for single area and all areas. So I want report for multi select areas.

Comments by vijay_bale (Top 130 by date)