Comments by babli3 (Top 168 by date)

sorry i mean app.config.
Ok Thanks alot

Thank you. My windows forms contains only a grid and connection string is in web.config.
But the users where this exe will be installed will not have sqlserver installed at all.
Do i still need to attach my db?

I didnt attach any database to the set up ...do i need to attach the database aswell?

Hi Thanks.
I tried this earlier , its not working either.

userid is (int) in this format 0x0000000000000576

My combo box has all employee names (a-z).Thanks

It is a string . I want that string to be converted as binary

i tried
private void dgvReport_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e)
{

var Processstartinfo = new ProcessStartInfo
{
FileName = "cmd"
};
Process process = Process.Start(Processstartinfo);

}

I want to open the command prompt with that particular path.

Thanks

Thank You :)

Hi Kumar

This is the query which i used before and was giving me output with 0.
output:
27, 0, PL1 1DQ

I dont want this 0 to be displayed.

Many Thanks

Hi

Its throwing an error
Msg 8114, Level 16, State 5, Line 2
Error converting data type varchar to numeric


Thanks

Thank You

I Changed the query

select (CAST(ISNULL(BuildingNumber,0) AS NVARCHAR(20)) +', '+ ISNULL(BuildingName,0) +', '+ ISNULL(Postcode,0)) as CompleteAddress from AddressRecord
where( CAST(ISNULL(BuildingNumber,0) AS NVARCHAR(20)) +' ,'+ ISNULL(BuildingName,0) +' ,'+ ISNULL(Postcode,0) )like '%PL1 1DQ%'

But now the output I am getting is with 0 aswell.

output:
27, 0, PL1 1DQ

Please can u suggest me as I dont want this 0 to be displayed.

Many Thanks

If one of the column is null then it is not displaying anything.
Please could you suggest how to resolve this.Thanks

Thank You it's working:)

Hi
Thank You .
But when I am running this query it's giving me empty result.
But I do have values in the database for this postcode.

Many Thanks

Hi richard! Thanks for the reply.
The details are stored in a database and Pivotal CRM system access the same database.
We have credentials to connect to the system.
Thanks

I still couldnt resolve it.
I am trying different things but none of them working.
If you find any solution please do post it.
Many Thanks

Hi Thanks for the reply
Yes I am accessing the web service remotely.
Can you please post me sone examples to write firewall rules as I am new to WCF.
Thank You

Thanks alot

it is the value from the data reader

it is decimal

Hi Thanks
but in the same script i need to even add if it exists then alter the column .
How Do I do that? Thanks

Thank you so much...its working...u solved my big problem.thanks once again

Thank u so much for your help:)

H THis is updating all the rows thats fine. But in my table there are 3 stages where each stage is having they own set of questions.
Assume: Stage1
question1 .......question10

Stage2
Question1......Question5

How can I updatedelending on each stage.

Thank you so much.

Ok Thank you I will try this.

Thanks

Thanks

ok

Hi Its a jquery popup

hi thanks and what about classic asp?

thanks

thank u

thanks

HiIs this right .... I am assigning the above session values for the different(2nd page) page
sYear = Session["Year"].ToString();
sNo = Session["no"].ToString();

Thanks

HiIs this right .... I am assigning the above session values for the different(2nd page) page
sYear = Session["Year"].ToString();
sNo = Session["no"].ToString();

Thanks

ok thank you :)

Hi

I cannot assign the actual values because the values changes according to the project...

Hi

I want these query string values to be used in my another page....Thanks

Yes sorry ! I was not clear actaully..

I have one master page from where we will get these query string values and then I have to store these values into session so that these can be accessed in another pages.... thanks

Yes sorry ! I was not clear actaully..

I have one master page from where we will get these query string values and then I have to store these values into session so that these can be accessed in another pages.... thanks

Yes Mona I did... thanks....

Thank You ....
Its working now ...Actually it didnt require any break...as it was executing line by line.Thank You for your help:)

Thank You

Hi Adarsh
Its throwing me an error...

Thank you ...I will try this

But if I want to have a break keyword in this function how can I do that...sorry I am bit new to sql server functions...

ok thanks

I want this statement to execute one by one... so I want to add a break keyword to this function.Thanks

I want this statement to execute one by one... so I want to add a break keyword to this function.Thanks

Thank You...

Ok

Ok Thanks

Thanks ! Actually if I try to upload the same file again then it should delete the old one and update the new one...
Do I need to remove the unique nonclustered index ...sorry i am quite new into development. Thanks

Can you please suggest me , do I need to change the Stored procedure or table because I am quite new into development... so thought someone could guide me on this.
Thanks

ok thank you...

Thank you

ok thanks I will share my code....

I changed the web.config file aswell... is there any way I can check the business layer code in my test server.

HI
Can you pls advice.... I changed few things in business layer...so i copied the dll's and pasted in respective bin folder(test server) and then changed the web.confog aswell.
Do I need to do anything else? sorry i am a fresher...thanks

yes i changed it and its inserting properly but it rolls back after sometime....I only changed my code in business layer...so i copied and pasted the respective dll's. Thanks

Thank you

ok thanks

ok thanks

I have a test server and my changes are in business layer, so please can you tell me how can i apply them to test on test server. thanks

thanks...I have a test server and my changes are in business layer, so please can you tell me how can i apply them to test on test server. thanks

thanks

ok sorry i am a fresher... i thought it is same as svn... I have used svn before but not source safe.
Thanks

Thank you so much

Thank you so much

Thank you so much

ok thanks i am going to remove them and run the code again....

ok thanks i am going to remove them and run the code again....thank you

But my table has all 23 parameters ...will it make any difference if my table has 23 parametrs...sorry i am a fresher...thanks

When i debugged this exception i got
" Procedure or function IMS_NB_EMRUP_Client_Insert has too many arguments specified"...


Thanks

When i debugged this exception i got
" Procedure or function IMS_NB_EMRUP_Client_Insert has too many arguments specified"...


Thanks

Ok I will thanks

Thanks the error is gone when i restarted the IIS. Thanks for your help :)

thanks alot

Hi I have debugged my code and found this error
I could not understand why i got this error....
please can you help

""DataPortal.Update failed (System.ApplicationException: An error occurred whilst open a connection to a database. System.Data.SqlClient.SqlException: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)

Yeah I understand thanks

Hi,
Sorry still couldnt fix the problem. when i debugged i found _fileGuid has null value... please help if you can...Thanks

Ok thank you

Thank you

Thank you

hi I did google it but couldnt actually understand as i am a fresher. So thought someone from this blog can give me better view. Thanks

Thanks I will check that.

Hi It works fine when i run the stored procedure in sql management studio.
But when I am debugging in visual studio , I found the exception "Update fails in inserting the values". Thanks

Thank You

HI i am using the following namespaces

using System.Collections;
using New.Business.eMRUpload;
using System.Threading;
using New.Business.Core.Security;
using System.Collections.Generic;

if (temp.Completed != -1)
{
completedClients += temp.Completed;
}

hi i am getting error here...

I am getting the error when i upload my file. It says 50% uploded and then says 100% complteed and gives me the error "upload fails and file rollbacks.thanks

Hi thanks. I have updated the code where i am getting this error. Please help.thank you

I have posted my code.Thanks

I have posted my code.Thanks

I have posted my code.Thanks

Thanks

Thank You

yes i did

yes I have this in my LoadDetailsmethod(). But still its inserting the default values only.

Hi Tushar
Thanks

The above code displays the default data on page load but , it is inserting only the default values into the database. Its not inserting the new values i m selecting.Thanks

Thank You...

Really sorry to bother you...

Now getting this error:

'DropDownList1' has a SelectedValue which is invalid because it does not exist in the list of items.
Parameter name: value

Hi
I just posted my code. Thank you

Assume my default values are 3,india
and i want to insert 5, uk

But 3, india (default values) are getting inserted into the database...thanks

yes

Hi Zafar
Thanks
This code is working fine . But when I am trying to enter any values in text box or dropdown
list, its not taking those values and instead inserting the default values in the database.

Hi Zafar

Thanks the code you gave me is working for default if there is nothing in database.
But when i am trying to insert new values , its inserting the default values in the databse.

Thanks

HI ,
I tried this code but
I am again getting this error "Invalid attempt to read when no data is present"

Thanks

HII am again getting this error

"Invalid attempt to read when no data is present"

Thanks

Hi
With this code its showing the default values on pageload even if i have data in the database.

I want to show the default values on pageload only if there is no data in the databse ortherwise it shoud display values from databse.

Please help. Thank you

It says "The name count does not exists in the current context"

I tried using is null but isnt working

If there is no data in the database then these web forms should display some default values and let user insert new values.

i am not able to do this....

I have posted my code. Thanks

HOW TO MARK AS SOLVE ... I CANT FIND ANYTHING

Thanks its working now

Its working Thanks!

i have to add triggers to the add button isnt.

no i didnt , i will add now. thanks

sorry its not updating still

ok let me try thanks

Thanks

Thanks

hi can you please help me with an example...

1.when i select a value in the dropdownlist , it should show in a list box.(This i have done)
2. These data(multiple values ) from list box should get stored into the database(here i am having trouble).

Please can someone help!!

thanks

protected void usersavebtn_Click(object sender, EventArgs e)
{

string connectionString = ConfigurationManager.AppSettings["ApplicationServices"];
SqlConnection myconnection = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand("sp_InsertAdmin_User", myconnection);
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@Userid", Convert.ToInt32(usersddl.SelectedValue));
cmd.Parameters.AddWithValue("@TierCode", Convert.ToInt32(userbranchgrplistbox.Text));
cmd.Parameters.AddWithValue("@BranchCode", Convert.ToInt32(branchddl.SelectedValue));
cmd.CommandType = CommandType.StoredProcedure;
myconnection.Open();
cmd.Connection = myconnection;
cmd.ExecuteNonQuery();
myconnection.Close();

}

Can you please give me a small example as I am very new to this. Thanks

But can I have 2 update statements for one gridview control?
When I tried It says i cant have 2 update statements .

Yes i am using multiline for my text box.

Sorry its still not working... its displaying now as sum,add

its saving into the database but in the same row.ex: aaabbb

Hi Raji

Its giving me this error:


String cannot be of zero length.
Parameter name: oldValue


Thanks

Hi Raji

sorry to be a pain. But I replaced space instead of comma then its not saving in another row.In the text box I have user is going to enter the data line by line. Please help

Thank you so much Raje...

Hi Prashant
I have tried with your code as well and its working. Thank you so much

Thanks alot as I was trying this since two days ....Now finally its done

Thanks alot its working! But if the user doesnt use comma its not inserting the data row by row

ok let me try thank you

Hi Raji

Your example is working fine but still the values are saving in the same row like
id value
2 sk sd ss

I want them to be saved like

id value
2 ss
2 sd
2 sk


Thanks. Please help

thanks alot Raje

Thanks alot. Its on every button click there will be a different id .

sorry i think i didnt ask the question properly. If example in a text box if i enter mango,bananna,apple then on save button click these values should be entered row by row with id=1 and then next time if a user enters other vaues then they should get saved as id=2 .
Hope now i have explained the question in a clear way. Please can you help me to do this. Thanks

Thank you

thanks

protected void newsubgrpddl_SelectedIndexChanged(object sender, EventArgs e)
{

getData(newsubgrpddl.SelectedItem.Text);


}

private void getData(string grades)
{
DataTable dt = new DataTable();
string connectionString = ConfigurationManager.AppSettings["ApplicationServices"];
SqlConnection myconnection = new SqlConnection(connectionString);
myconnection.Open();
SqlCommand sqlCmd = new SqlCommand("SELECT * from Admin_SubjectGroups WHERE SubjectGroupName = @SubjectGroupName", myconnection);
SqlDataAdapter sqlDa = new SqlDataAdapter(sqlCmd);
sqlCmd.Parameters.AddWithValue("@SubjectGroupName", subgrptxtbox.Text);
sqlDa.Fill(dt);
if (dt.Rows.Count > 0)
{
subprefixtxtbox.Text = dt.Rows[0]["subprefixtxtbox"].ToString();
}
myconnection.Close();
}

my tables:

Admin_SubjectGroups:

AuthorityCode int not null
SubjectGroupid int not null
SubjectGroupName nvarchar(50)


Admin_Subjects

SubjectGroupid not null
subjectprefix nvarchar(50)


Please can you help.. I have just tried the above code but its not displaying anything in the text boxwhen i select a value from dropdown list. Thanks

sorry i think i didnt ask the question properly.

If example in a text box if i enter mango,bananna,apple then on save button click these values should be entered row by row with id=1 and then next time if a user enters other vaues then they should get saved as id=2 .

Hope now i have explained the question in a clear way.


Please can you help me to do this.

Thanks

ok thanks I will try ...

Hi Jagadesh

Thanks but I am not very experienced . If possible can you please give me a small example. Thanks

ok thanks i will try

Thank you so much for your help

I already tried the single querty and its working fine.
But problem is i am placing this update command in Gridview for updating rows
and i cant keep two update commands together .
so i wanted to join these two tables and update

i did run on sql server the errror is on update a,b . Thanks

Thanks a lot but I am getting this error. Please help

System.Data.SqlClient.SqlException: Incorrect syntax near ','.

Thanks

yes ,there is TierCode common in both

Thanks.Its working for 1 column but it isnt working for the other.
UPDATE Admin_Tier set TierName=@TierName where TierCode=@TierCode .
Is it possible to join these two update statements?